Questions tagged [errors]

For questions about specific error codes or messages, including troubleshooting.

107 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
1 answer
2k views

How do I identify the source of the 17886 errors ("server will drop the connection") in my SQL errorlog?

I have a SQL 2012 server that is throwing the following error every 5 minutes or so: Error: 17886, Severity: 20, State: 1. The server will drop the connection, because the client driver has sent ...
BradC's user avatar
  • 9,752
5 votes
0 answers
4k views

Very Sporadic Cannot initialize the data source object of OLE DB provider "SQLNCLI11" for linked server

OLE DB provider "SQLNCLI11" for linked server "001" returned message "Unable to complete login process due to delay in opening server connection". Msg 7303, Level 16, State 1, Line 19 Cannot ...
Drew's user avatar
  • 115
5 votes
0 answers
5k views

PgBouncer cannot connect to server

I have configured PgBouncer with PostgreSQL 9.6 on windows 7 machine. Here are the pgbouncer configuration settings; [databases] test = host=127.0.0.1 port=5432 dbname=master_db user=postgres ...
Shahzad Bacha's user avatar
4 votes
0 answers
3k views

Getting: Possible index corruption detected. Run DBCC CHECKDB

When I connect to the database and run a command on some catalogs, I get Msg 9100, Level 23 1> SELECT * FROM sys.databases; 2> GO Msg 9100, Level 23, State 2, Server x230, Line 1 Possible index ...
Evan Carroll's user avatar
  • 60.4k
4 votes
0 answers
3k views

"Server local connection provider has stopped listening" errors in SQL Server error log

We have started seeing the following errors appearing intermittently (between 1 and 5 a day on average) in the error logs on one of our SQL 2016 servers: Error: 26050, Severity: 17, State: 1. Server ...
JamesLean's user avatar
  • 391
3 votes
2 answers
837 views

DBCC consistency error in SQL Server

I ran DBCC CheckDB in our Production SQL Server 2014. It reported back with one consistency error: Failed:(-1073548784) Executing the query "DBCC CHECKDB(N'MYDB') WITH NO_INF..." failed ...
sqllover2020's user avatar
3 votes
0 answers
2k views

The prelogin packet used to open the connection is structurally invalid

I'm getting the below error across multiple servers (SQL Server 2005, 2008, 2008r2, 2012). The SQL Servers are up to date with service packs as is the OS. These are all SQL Server Standard edition. ...
donna's user avatar
  • 31
3 votes
0 answers
446 views

Cannot add standby database to the data broker configuration in oracle 11g

I have duplicated the primary database to standby database and then I added the primary database in data broker configuration. But when I'm trying to add standby database I'm getting following error: ...
Enthusiastic learner's user avatar
3 votes
0 answers
323 views

How do I change a processor count on a stopped SQL Server instance?

I have restored an image of a production SQL Server 2008 R2 to a Virtual Machine to test out some changes. When I try to start SQL Server to recreate tempdb (in partition that was not restored), it ...
Torsten S.'s user avatar
3 votes
1 answer
1k views

MySQL: Skip INSERT / UPDATE statement that triggers error but show them in output

I have a million of rows of customers to be imported via SQL dump. Customer data will be inserted into main table customer and child table customer_address The dump contains the following SQL ...
MagePsycho's user avatar
3 votes
1 answer
2k views

MySQL: error 1118 (42000) row size too large

storage_engine = MyISAM table_type = MyISAM version = 5.1.25-rc database_name.sql dump size is 3.3G: mysqldump -u user -p database_name > database_name.sql When I try to restore the database (...
user122761's user avatar
3 votes
0 answers
2k views

SSMS Client Error: Internal connection fatal error

I am running SSMS 11.0.5646.0 on a Windows 7.0 Pro desktop connected by UTP directly to same network switch as my development server (Windows 2008R2 Standard, SQL 2008R2 SE with SP3). All within the ...
Ray's user avatar
  • 31
3 votes
0 answers
309 views

Unable to Update on SQL Server 2008 R2

This is a bit strange so bear with me please. After installing a new SQL Server 2008 R2 on a new server (Windows 2012 Standard) just like the production one, I tried to connect my web aplication (...
Piero van Oordt's user avatar
3 votes
4 answers
4k views

I don't know how to fix ORA-04091 mutating trigger error

I'm learning Oracle SQL, but when dealing with triggers I'm finding an error, that prevents me from updating values in that table. The error is: error ORA-04091: table USUARIO.LINEAS is mutating, ...
Daniel Hernández's user avatar
2 votes
0 answers
31 views

DAC silently swallows tokenization errors in sp_msforeachdb

This morning I hopped on the DAC to check something out. Oops, I made a typo! 1> exec sp_msforeachdb N' 2~ use [?] 3~ select N'?', count(*) from sys.sysrscols; 4~ ' 5> go 1> Can you spot ...
Peter Vandivier's user avatar
2 votes
1 answer
2k views

Determine cause of "MySQL server has gone away"

I've got a long running process on a headless server. It is a C program that monitors a modem for Caller Id and hangs up on telemarketers. On startup the program opens a connection to a MariaDB 10.3 ...
user avatar
2 votes
0 answers
2k views

ERROR InnoDB: Trying to access page number .. in space .., space name..., which is outside the tablespace bounds

I am running a mysql database server (5.7) on a virtual ubuntu 16.04 host. This host collects syslog messages from my other network hosts, adds the values to a pipe and creates mysql records for each ...
dufte's user avatar
  • 81
2 votes
0 answers
426 views

understanding mysqlslap concurrency

I have a RDS instance running in AWS. By default max_connections=45 so I used mysqlslap to see how it works. I ran: mysqlslap --concurrency=20 --host=deleteme.ckn5fsf3nwqp.ca-central-1.rds....
Simon Ernesto Cardenas Zarate's user avatar
2 votes
1 answer
373 views

Cosmos DB ODBC driver installation problem

We are trying to install Cosmos DB ODBC Driver following the instructions provided in this Microsoft Azure resource and are running into the following error: The setup routines for Microsoft ...
Ben Saunders's user avatar
2 votes
0 answers
3k views

SQLServerAgent Error: The process cannot access the file because it is being used by another process

I have created the following as an automated job to run at midnight on every database server I manage: This job fails intermittently on some servers, but not others and I get the following error: ...
AKDiscer's user avatar
  • 1,365
2 votes
1 answer
692 views

Mysql 5.7 cannot start again

For the first time in my life, I have Ubuntu, so I do not know much how to manage and what should I be looking for; I'm using version 18.04. I installed MySQL 5.7, it worked great for a couple of days ...
Simon's user avatar
  • 81
1 vote
0 answers
49 views

Mariadb replication Master Slave fail with error code 1595

I've a strange problem. A Mariadb replication start failing since this morning. Until today everything works fine from month. This is my scenario: I've a server in a DC which is the master, and a ...
Paolo Daniele's user avatar
1 vote
1 answer
59 views

MySQL 1054 Error After Creating Trigger to Update on Insert

I am learning basic SQL and have gotten stuck with triggers. I have a database with two tables, customer and invoice. The table characteristics follow: CREATE TABLE customer ( CUST_NUM ...
Kegan Smith's user avatar
1 vote
0 answers
144 views

Azure SQL Error "Invalid object name '##{myTempTableName}'

I am getting an error in my stored procedure: "Invalid object name '##{myTempTableName}' for 3 global temporary tables. There are several temp tables used in the procedure, but I am getting this ...
One More Tea's user avatar
1 vote
1 answer
25 views

Syntax issues when uploading backup from mysql5.7 to percona xtradb 5.7

Greetings to those readying the thread and thank you for devoting your time to answering the question. I have encountered a problem when uploading a MySQL 5.7 backup database to a Percona xtradb 5.7 ...
michael peychev's user avatar
1 vote
0 answers
144 views

MySQL not throwing some errors in prepared statement

If I run the following query: DELETE FROM `table` where `id` = '123%7D'; Notice the gibberish at the end of the where clause I get the following error ERROR 1292 (22007): Truncated incorrect DOUBLE ...
Marlon de Oliveira dos Santos's user avatar
1 vote
1 answer
2k views

SQL Server is terminating this session. c0000005 EXCEPTION_ACCESS_VIOLATION

I Got Error: A user request from the session with SPID 183 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log ...
Ivan Bonanno's user avatar
1 vote
0 answers
391 views

Sql Server Agent Job - Unable to start execution of step 1 (reason: Error authenticating proxy "user", system error: The user's account has expired.)

My predecessor created several "Intergration Services Catalogs" dtsx packages which are scheduled / run via SQL Server Agent -> Jobs using an SSISFileProxy which is using ...
Wyvernstail's user avatar
1 vote
0 answers
138 views

Flags Cloud SQL for Postgresql

Context: I have a process that runs daily, with different amounts of data, if the process is on the weekday (process last 30 days), for weekends (process last year). The input is of 10 tables of ...
Diego Figueroa's user avatar
1 vote
0 answers
241 views

Oracle error 43914 in CASE WHEN expression: arguments have undefined collation

I want to know which is the difference between this query: SELECT * FROM TEST_TABLE WHERE CHAR_FIELD = CASE WHEN KEY_FIELD = 'Q' THEN 'M' ELSE CASE WHEN KEY_FIELD = 'T' THEN 'K' ...
Artm94's user avatar
  • 11
1 vote
0 answers
215 views

Unable to grant privileges with admin account

I'm running MariaDB version 10.4.8 on Amazon RDS. Once the server is up and running, I need to create some databases, users and grant privileges to those users. Creating the databases and users works ...
Prdufresne's user avatar
1 vote
0 answers
4k views

Persistent problems importing CSV files via pgAdmin 4 to PostgreSQL 12 on Mac OS - Failing with Exit Code -6

I've been trying for several days to import CSV files into a PostgreSQL 12 database hosted on Mac OS 10.15.5, using the Import/Export tool in pgAdmin 4. I am consistently getting an error message ...
DB_Newbie's user avatar
1 vote
0 answers
309 views

Error 17807, Severity: 020 - error source identification

I have setup an alert to notify me on high severity errors. Irregularly, from time to time an error occurs: "Error 17807, Severity: 020, Description: Event '31', which was received from the client, ...
Martin Karouš's user avatar
1 vote
0 answers
2k views

Troubleshoot MS DTC error

I've been getting these two errors on SQL Server log: Error 1: DESCRIPTION: Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(...
Ronaldo's user avatar
  • 4,964
1 vote
0 answers
1k views

database mirror - A connection attempt failed because the connected party did not properly respond after a period of time

I have database mirror set up in one of my servers and all seems to be fine, however, from time to time I get this error message in the logs: --Execute it on Primary/Secondary server EXEC ...
Marcello Miorelli's user avatar
1 vote
0 answers
64 views

SSMS Connect to remote SQL instance with Windows Authentication

I have a remote SQL instance (Microsoft SQL Server 2016 (SP2-CU3) (KB4458871) - 13.0.5216.0 (X64) I can connect to the instance fine locally on the box through SSMS using both Windows and SQL ...
medina's user avatar
  • 197
1 vote
0 answers
391 views

How to recover from a segmentation fault

Postgresql 11 running on a Centros RHEL 7. Suddenly BD crashed and service went down. service postgresql-11.service status Redirecting to /bin/systemctl status postgresql-11.service Segmentation ...
Imanol Y.'s user avatar
  • 775
1 vote
0 answers
4k views

Slave I/O for channel error connecting to master Error_code: 2003

i am trying a master master replication mysql with phpmyadmin using wamp server. everything seems to be fine, the configuration was well done, so the server is slave and master at the same time , but ...
Nina's user avatar
  • 11
1 vote
0 answers
263 views

Mongodb throwing an error when I run the query to record last position from oplog

I am getting an error when I run the query in the secondary member to record the last position from the oplog. below is the query. db.oplog.rs.find().sort({$natural:-1}).limit(1).next().ts and the ...
moong's user avatar
  • 11
1 vote
2 answers
982 views

java.sql.SQLException: ORA-01410: invalid ROWID

I am getting java.sql.SQLException: ORA-01410: invalid ROWID for some of the rows. Here is my query. "select OP.PLU_LONG PROD_ID," + "OP.NEW_PRICE PRICE," + ...
Ashok's user avatar
  • 11
1 vote
1 answer
1k views

Error: 9245, Severity: 16, State: 1. / "During the last time interval X query notification errors were suppressed"

We are receiving this notification several hundred times a day and while we're regularly checking notifications from Severity 16 errors, this isn't something we're really concerned about. I've read ...
MyDoggieJessie's user avatar
1 vote
0 answers
2k views

Incorrect syntax near 'BULK' for bulk INSERT in Azure Data Studio

I am trying to bulk insert a large CSV file delimited by tabs. I am on a Mac, and executing queries on Azure Data Studio (formerly SQL Operations Studio), since SSMS is not available for Macs. Here is ...
ITried's user avatar
  • 111
1 vote
0 answers
706 views

MySQL shutting down automatically

I have a LEMP server in a Ubuntu instance and my MySQL are shutting down automatically... I have no idea what's happening. I had to manually restart it to keep the site online Here is my mysql log ...
Renalcio Carlos Junior's user avatar
1 vote
0 answers
32 views

Selective error logging (based on error code) in PostgreSQL

I want to log all PostgreSQL errors except unique_violation (error code 23505), which I would like suppressed. How do I achieve that?
Bass's user avatar
  • 123
1 vote
0 answers
664 views

InnoDB: Cannot open table

Copied to file from (XAMPP) /Applications/XAMPP/xamppfiles/var/mysql to /Applications/AMPPS/var (AMPPS) But I having this error. 2017-01-25 18:01:55 1860 [Warning] InnoDB: Cannot open table ...
Kenan's user avatar
  • 11
1 vote
1 answer
504 views

MongoDB 3.2.10 Index rebuilding did not complete: 11000 E11000 duplicate key error collection

MongoDB 3.2.10 Getting the following error when adding a replica set as WiredTiger. This is sharded cluster ( 3 shards nodes ). 2 Shards replica sets created using wiredTiger storage so only 1 shard ...
Sanjay's user avatar
  • 81
1 vote
0 answers
2k views

Can I at least get MySQL errors to give line numbers in the correct query?

We all know MySQL errors are pretty unhelpful. I understand that due to query optimisation it would be in-principle very difficult to unwind errors to their exact location in the source text and that ...
spraff's user avatar
  • 213
1 vote
0 answers
575 views

Unable to insert explicit value in table due to IDENTITY_INSERT is ON Error

I am trying to insert explicit values in one of my Real time Audit Production database. There are more than 80 columns, I have just taken here 5 columns. I am writing syntax is as below: use ...
Md Haidar Ali Khan's user avatar
1 vote
2 answers
593 views

RDS Replication Error (Apply Error 1406 / Truncation)

I have a MySQL RDS instance as a master, created a Read Replica from it, and ran some schema change operations on it. To be specific, I changed the charset and collation of all the tables and columns ...
dylst's user avatar
  • 13
1 vote
0 answers
521 views

Does psql print command results to standard error?

I am running COPY command through psql 9.1.15 as a cronjob to append data in csv file to table1: psql -q -h $DB_HOST -d $DB_NAME -p $DB_PORT -U $DB_USER <<EOF copy table1 from '${BUCKET}/${...
Dmitrii I.'s user avatar