Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
107
questions with no upvoted or accepted answers
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 ...
- 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 ...
- 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 ...
- 171
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 ...
- 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 ...
- 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 ...
- 73
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.
...
- 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:
...
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 ...
- 31
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 ...
- 201
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 (...
- 31
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 ...
- 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 (...
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, ...
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 ...
- 4,448
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 ...
user141074
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 ...
- 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....
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 ...
- 21
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:
...
- 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 ...
- 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 ...
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 ...
- 11
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 ...
- 11
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 ...
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 ...
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 ...
- 31
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 ...
- 11
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 ...
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' ...
- 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 ...
- 111
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 ...
- 11
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, ...
- 186
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(...
- 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 ...
- 15.6k
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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," +
...
- 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 ...
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 ...
- 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
...
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?
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 6,299
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 ...
- 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}/${...
- 111