Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
80
questions with no upvoted or accepted answers
5
votes
0answers
589 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
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
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
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 ...
3
votes
0answers
2k 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 ...
3
votes
0answers
315 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
185 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
819 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
25 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
600 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
214 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
276 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
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 (...
1
vote
0answers
36 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
211 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
39 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
891 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
83 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
1answer
441 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
853 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
483 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
772 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
26 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
475 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
353 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
549 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
410 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
411 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
686 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
340 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
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
834 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
0answers
55 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 ...
0
votes
0answers
39 views
ORA-12560: TNS:protocol adapter error in Windows 10
Listener and service are up and running. In SQL Plus, if I connect with no login, and execute 'conn sys/pwd@host:port/sid as sysdba', connection is established successfully. But if I connect / as ...
0
votes
0answers
23 views
WAL Archival not working in PostgreSQL V9.4.9 DB server
Our DB servers are on VM, during planned server restart for system patch deployment our Master DB server crashed.
We have taken the clone of Primary Slave VM and restore the Master DB using last ...
0
votes
1answer
21 views
Trying to Count Multiple Columns SQL
I'm trying to count multiple columns in a select statement for a class I'm in.
Everything is coming from the same table. I want to know how many times that person paid something and how many times ...
0
votes
1answer
24 views
Everything is ok and x is not disappearing
Since some time ago, I've started with MySQL so I don't know Workbench very well.
That little red x next to the number of the line that indicates an error does not disappear, even though everything ...
0
votes
0answers
326 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(...
0
votes
0answers
60 views
Exit code 500 when importing a csv file in a table in pgAdmin4
I tried to import a CSV file with the method described here after creating my database with the method described there. However, it returned me a 500 Error.
The command is:
"C:\\Program Files (x86)\...
0
votes
0answers
1k views
SSRS 2016 : HTTP Error 503. The service is unavailable
We have SSRS 2016 on Windows Server 2016.
Reporting Server configured with virtual directories
http://ServerName:80/Reports
http://ServerName:80/ReportServer
While I'm trying to connect to reports ...
0
votes
0answers
44 views
Failing on queries with length of multiples of 32
tl;dr: Every SQL query of length 64 or higher that is a multiple of 32 results in the connection closing with a 2013 error when interacting with our remote MySQL server.
I am having the strangest ...
0
votes
1answer
57 views
Create View giving SQL7029
If relevant, I'm using IBM i V7R1M0.
I have some code in C#:
var generateSqlSql = $@"
CALL QSYS2.GENERATE_SQL(
'{obj.Name}',
'{obj.Library}',
'VIEW',
CREATE_OR_REPLACE_OPTION => '...
0
votes
0answers
50 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 ...
0
votes
0answers
246 views
One database on my MS SQL Server wont start OS error: 5(Access is denied.)
I am running MS-SQL server for Linux. There are several databases on this machine, but one of them refuses to start up. The error log shows:
2019-07-30 16:29:36.76 spid19s SQL Server is now ready ...
