Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
93
questions with no upvoted or accepted answers
5
votes
1answer
944 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 ...
4
votes
0answers
2k 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 ...
4
votes
0answers
2k 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 ...
4
votes
0answers
3k 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 ...
4
votes
0answers
2k 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 ...
3
votes
0answers
344 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
0answers
211 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 ...
3
votes
1answer
1k 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 (...
3
votes
1answer
951 views
Incorrect key file for table error. How can I change location of MySQL's temp folder to another part of drive with more disk space?
I am using MySQL with Sequel Pro on a Mac Pro OSX Mavericks and am trying to run the code for a stored procedure in order to add two new columns to a table. The procedure does math operations on ...
3
votes
0answers
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 ...
3
votes
0answers
306 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 (...
2
votes
0answers
26 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 ...
2
votes
0answers
877 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 ...
2
votes
0answers
1k 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.
...
2
votes
0answers
259 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
1answer
284 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 ...
2
votes
0answers
2k 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:
...
2
votes
1answer
380 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 ...
1
vote
0answers
19 views
Error run pgAdmin4 Fatal Error: The pgAdmin 4 server could not be contacted
I had installed PostgreSQL 10 and everythings perfect after i install but now i have this issue.
Fatal Error:
The pgAdmin 4 server could not be contacted
anyone know what could be the problem?
1
vote
0answers
33 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
0answers
31 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' ...
1
vote
0answers
2k 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 ...
1
vote
0answers
70 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, ...
1
vote
0answers
748 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(...
1
vote
0answers
384 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 ...
1
vote
0answers
40 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 ...
1
vote
0answers
2k 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 ...
1
vote
0answers
146 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 ...
1
vote
2answers
551 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," +
...
1
vote
0answers
1k 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 ...
1
vote
0answers
556 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
1answer
840 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 ...
1
vote
0answers
28 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?
1
vote
0answers
546 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 ...
1
vote
1answer
384 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 ...
1
vote
0answers
1k 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 ...
1
vote
0answers
558 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 ...
1
vote
2answers
459 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 ...
1
vote
0answers
415 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}/${...
1
vote
0answers
699 views
MySQL event scheduler doesn't work
I have the following MySQL event sheduler to udpate some values in RECETAS table's ESTADO column. I want to run it everyday at 10:05:00.
CREATE EVENT IF NOT EXISTS actualizar_prueba
ON SCHEDULE ...
1
vote
0answers
14k views
ORA-03137: TTC protocol internal error
I have 11g 2-node RAC.
My alert.log contains several ORA-03137 errors:
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/orcl2_ora_10679.trc (incident=149362):
ORA-03137: TTC protocol ...
1
vote
1answer
2k views
MySQL Cluster error on UPDATE: increase MaxNoOfConcurrentOperations
I had a table with ~0.5M rows and tried to execute a simple query, something like:
UPDATE table SET col1=-90 + RAND()*90, col2=-180+RAND()*360 WHERE col1=9999
but the result was
ERROR 1297 (HY000): ...
1
vote
1answer
967 views
XAMPP - Error: MySQL shutdown unexpectedly
Last night MySQL Service on my XAMPP local server was running fine. Today... it starts for 10 seconds and then give me following error:
10:14:28 AM [main] Initializing Modules
10:14:28 AM [main]...
0
votes
1answer
31 views
The pgAdmin 4 server could not be contacted
Whenever I install PostgreSQL, it stops working after about 6 months. This is the second time this happened! Last time this happened, I uninstalled and then installed version 4.29. How can I debug ...
0
votes
0answers
29 views
Linked server anonymous login error
I am trying to access a database in my UAT server through a windows login credential. When I try to access the database, I get the error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' This ...
0
votes
0answers
42 views
Failed (exit code: 1) when trying to restore DB from a .tar file in pgAdmin4
I'm been trying to restore my database and I'm getting an Exit error code 1. The database I'm trying to restore is SuperMart_DB.tar, but every time I get the same error message.
I have seen previous ...
0
votes
0answers
21 views
Full Text Index STOP POPULATION doesn't work, depending on Track Changes setting
I had a Full Text Index population going on for too much time and storage, so I decided to stop it, but the population didn't stop.
Notes:
Both index and catalog are created using the Full Text ...
0
votes
1answer
92 views
The connection is no longer usable because the server response for a previously executed statement was incorrectly formatted
One of our application AX2013 is connecting to our DB's in an Availability group spanning three SQL2016 nodes.
End users are getting some error in the application that always point to the same error ...
0
votes
1answer
31 views
SQL Server 2019: Rasing errors between 1 and 13000
I've been struggling with a task which requires me to raise a number of errors for testing purposes. Of course the time consuming errors are between 1 and 13000. I've managed to do them, but I need to ...
0
votes
1answer
101 views
Error using SQL Server 2019 Import and Export Data (64-bit)
I'm getting an error immediately upon starting the SQL Server 2019 Import and Export (64-bit) wizard, and I'm looking for ideas. The error is:
The SSIS Data Flow Task could not be created. Verify ...