Questions tagged [errors]

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

79 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
458 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 ...
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
2answers
1k views

This installation of MySQL is already upgraded to 5.7.25?

I used sudo apt upgrade and got this: E: dpkg was interrupted, you must manually run 'sudo dpkg --configure -a' to correct the problem. So I did it and I see this for more than an hour. Setting up ...
3
votes
0answers
1k 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

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 ...
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
310 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
173 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
764 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
494 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
910 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
194 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
261 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
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
12 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
122 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
37 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
619 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
66 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
397 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
1answer
476 views

SQL Server crash with Reason 0x00000006 after a while on linux

Environment OS Ubuntu 16.04 x86_64 (also happening on Windows) DB SQL Server 2017 with FullText Search module (mssql-server and mssql-server-fts packages) Problem The issue that I'm facing is ...
1
vote
0answers
760 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
452 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
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: ...
1
vote
1answer
741 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
443 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
340 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
982 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
539 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
397 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
406 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
677 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
324 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
682 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
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
157 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
35 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
829 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
43 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
45 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
45 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
197 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 ...
0
votes
0answers
1k views

Unable to open BCP host data-file

Having an issue with exporting files to a network drive via the BCP host data file. There is no problem in exporting a file to the C drive of the machine that the SQL Server is installed on, however ...
0
votes
0answers
1k views

ERROR 3680 (HY000): Failed to create schema directory 'wwww' (errno: 2 - No such file or directory)

I'm trying to create a database using MySQL but getting an error message as follows: mysql> create database XXX -> ; ERROR 3680 (HY000): failed to create schema directory 'XXX' (errno: 2 - ...