Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
27 votes
4 answers
73k views

The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values

One of INSERT INTO script is written as following. INSERT INTO tableName (Column1, Column2,....) VALUES (value1, Value2,...), (value1, Value2,...),.... Following is the error we are facing on ...
user avatar
25 votes
9 answers
117k views

Login failed for user - Error 18456 - Severity 14, State 38

Message that SQL Server Log File Viewer shows: Login failed for user [User] Error: 18456, Severity: 14, State 38 What it actually means: Failed to open the explicitly specified database My ...
user avatar
24 votes
3 answers
46k views

How do I resolve this error, "ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'"?

When I run the following command I get an error, however one of my scripts requires it. SET time_zone = 'UTC'; ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'
user avatar
  • 56.3k
23 votes
4 answers
36k views

Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade

In mysqld.log I have thousands of lines like: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade So, according to virtually every post on the ...
user avatar
21 votes
2 answers
97k views

Postgres incomplete startup packet error

I am attempting to install Postgres 9.3 on Ubuntu 14.04 and I am getting an irksome error on startup. Here's what I'm seeing: $ sudo service postgresql restart * Restarting PostgreSQL 9.3 database ...
user avatar
19 votes
5 answers
93k views

MySQL import csv file ERROR 13 (HY000): Can't get stat of /path/file.csv (Errcode: 2)

I am an absolute beginner to MySQL (5.5.34) / Linux (Ubuntu 12.04 LTS)` I have created a simple database with one table. When trying to import data into it via a 'data_test.csv file an error message ...
user avatar
  • 193
17 votes
1 answer
42k views

Safe way to truncate SQL Server Error Log

We are running out of space. What is the safe way to clear the error log?
user avatar
  • 555
16 votes
6 answers
57k views

The operating system returned error 21 (The device is not ready.)

Every time I reboot Windows, for some databases I get this error: The operating system returned error 21(The device is not ready.) I checked the disk with chkdsk /r - no bad sectors. I executed ...
user avatar
  • 371
16 votes
5 answers
77k views

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes [closed]

I try installing SQL2008R2 - SQL2012 - sql2014 2014-07-17 16:31:16.00 spid14s Error: 17190, Severity: 16, State: 1. 2014-07-17 16:31:16.00 spid14s Initializing the FallBack certificate failed ...
user avatar
  • 169
15 votes
3 answers
19k views

What is a "heterogeneous query"?

I got the following error message regarding a SQL query I'm running in a program. SQL Server 2005 T-SQL. Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the ...
user avatar
  • 2,023
15 votes
4 answers
88k views

error 2013 (hy000) lost connection to mysql server during query while load of mysqldump

I'm trying to load mysqldump and I keep getting following error: ERROR 2013 (HY000) at line X: Lost connection to MySQL server during query /etc/my.cnf: [mysqld] max_allowed_packet = 16M ...
user avatar
  • 585
14 votes
7 answers
368k views

How to solve "Can't connect to local MySQL server through socket" error? [duplicate]

I kept getting this following error every time I tried to restart MySql. It was working fine before I changed the default data directory. ERROR 2002 (HY000): Can't connect to local MySQL server ...
user avatar
13 votes
3 answers
12k views

PostgreSQL 9.3.13, How do I refresh Materialised Views with different users?

[I think the root cause of this problem is me not understanding permissions and privileges...] So, to set the stage, the set up I have is a DB, call it MyDb. I have two users, spu1 and u1, spu1 is a ...
user avatar
  • 309
13 votes
2 answers
10k views

A possible infinite recompile was detected for SQLHANDLE

I have been finding strange error messages on the sql error log: Bocss: same deadlock taking place every hour – needs investigating Also lots of recompiles are listed in the error log for other ...
user avatar
12 votes
4 answers
48k views

Can't remote access MySQL server running on Mac OS X

I have a MySQL server running on my work computer, which runs Mac OS X Maverick. I want to access it from home computer, which also has Mac OS Maverick. From terminal, if in 1 tab, I ssh into my ...
user avatar
  • 221
12 votes
12 answers
140k views

Error: Cannot Generate SSPI context

When someone tries to connect to a SQL Server instance, the error shows up: It's not possible do generate SSPI context. Yesterday we had a blackout (don't know how to say this expression in ...
user avatar
  • 7,114
11 votes
4 answers
3k views

What is the maximum number of local variables that can participate in SET operation?

I have a stored procedure that contains business logic. Inside it I have around 1609 variables (don't ask me why, this is how the engine works). I try to SET a variable to the concatenated value of ...
user avatar
11 votes
4 answers
5k views

SQL Server on Linux hangs on initial startup, no errors, and no new / updated ErrorLog file

I'm using SQL Server 2017, Release Candidate 2 (RC2) on Linux (Ubuntu 16.04). When the server starts up, SQL Server usually starts as well. But for some reason, SQL Server won't start anymore. At ...
user avatar
10 votes
5 answers
2k views

string or binary data would be truncated in table '******', column '******'. Truncated value: '******'

One of our applications report on error message 2628: string or binary data would be truncated in table '******', column '******'. Truncated value: '******' instead of String or binary data would be ...
user avatar
10 votes
2 answers
122k views

Getting "ORA-00942: table or view does not exist" while table does exist

I'm fairly new to Oracle database. I have installed Oracle Database 11g R2 on Oracle Linux 6. I have successfully created a new database with dbca and connected to the database using: $ sqlplus "/ as ...
user avatar
10 votes
2 answers
39k views

Server requested authentication method unknown to the client [mysql_old_password]

Warning: PDO::__construct(): The server requested authentication method unknown to the client [mysql_old_password] SQLSTATE[HY000] [2054] The server requested authentication method unknown to the ...
user avatar
  • 265
9 votes
5 answers
3k views

Linked Server connection started failing with "Cannot generate SSPI context ... SQL Server Network Interfaces: The logon attempt failed" error?

The Issue I have two SQL Server 2016 Standard Edition servers on the same domain. ServerA has two linked server connections setup to ServerB. The first linked server connection is using a dedicated ...
user avatar
  • 24.8k
9 votes
1 answer
5k views

How to conditionally raise an error in MySQL without stored procedure

I need to conditionally raise an error, but I can only use a simple statement and no stored procedure. I'd like to do something like this: select case when foo = "bar" then 1 else SIGNAL SQLSTATE '...
user avatar
9 votes
2 answers
3k views

Getting SQLSTATE in psql error messages

I have the following problem. SELECT * FROM tgvbn(); ERROR: function tgvbn() does not exist LINE 1: SELECT * FROM tgvbn(); ^ HINT: No function matches the given name and ...
user avatar
  • 28.9k
9 votes
1 answer
2k views

AlwaysOn Availability Group error after Windows Update in environment without a failover cluster

Our SQL Server service was down this morning which brought down some of our websites. When I went to check the Windows Event Viewer I saw the following errors: Script level upgrade for database '...
user avatar
  • 291
8 votes
1 answer
31k views

MySQL Error: impossible to write to binary log

I have a system (inherited from another development company) and I don't know all its features yet. Construction: - web client/application (symfony 1.4) - DB - MySQL. Project is deployed on 2 servers:...
user avatar
8 votes
1 answer
6k views

How to restore everything (including "postgres" role) from pg_dumpall backup

I have a postgres 9.1 server running and I do backups with pg_dumpall -c -f /nfs/backup/fulldump.sql I'm testing restoring the backup to another server with psql -f /nfs/backup/fulldump.sql while ...
user avatar
7 votes
4 answers
2k views

What could cause SQL Server to deny execution of a SP at first, but allow it later with no privileges change?

A user (Windows login) just complained he was denied the execution of a procedure. I went to check and verified he had the privileges to execute it. I didn't change anything (and right now I'm the ...
user avatar
  • 4,404
7 votes
1 answer
79k views

"Invalid object name" error when executing query

I connect database with Visual Studio 2017. When I am trying to execute a query then it shows the following error: The connection string I am using is: SqlConnection con = new SqlConnection("Data ...
user avatar
7 votes
1 answer
74k views

No such column when column exists

I have a table (trackedinfo) inside my database that has the following columns (columns obtained by running PRAGMA table_info(trackedinfo);) The problem is that even though the column sendok exists, ...
user avatar
7 votes
1 answer
21k views

Error when creating a stored procedure in postgreSQL-10 [closed]

I couldn't get my first stored procedure to work, so I copied this example from the manual: CREATE PROCEDURE insert_data(a integer, b integer) LANGUAGE SQL AS $$ INSERT INTO tbl VALUES (a); INSERT ...
user avatar
7 votes
2 answers
2k views

A Difficult Case of "A transport-level error has occurred when receiving results from the server" SQL Server

We are building a new BizTalk cluster, with two BizTalk Application Servers and two SQL Servers. From SSMS on BizTalk AppServer #1 (and similarly from #2), we have two scenarios: Current - our ...
user avatar
6 votes
2 answers
19k views

ERROR 1054 (42S22): Unknown column 'plugin' in 'mysql.user'

I am trying to grant privileges for a user to a new database mysql> grant all on db_test.* to 'user_test'@'localhost' identified by 'usersexistingpassword'; I get the following error ERROR 1054 (...
user avatar
6 votes
1 answer
124k views

ERROR 1146 (42S02): Table 'db.tablename' doesn't exist [closed]

I have a two databases, when I prompt SHOW DATABASES I can see a list of the databases, including mysql, performance_schema and informations_schema. I can prompt 'SELECT DATABASE_NAME' on both of them,...
user avatar
  • 161
6 votes
2 answers
26k views

SQL Backup issues / Operating system error 995

Last night backups of some databases failed. Backups are being performed using CommVault. Below is error message in SQL Server logs 01/05/2016 23:03:58,spid58,Unknown,BackupVirtualDeviceFile::...
user avatar
6 votes
3 answers
169 views

Can't get access to other database

I am working on a project for my university. They gave me a login username and password for MySQL database they've setup on the server. With that username and password, I'm able to login to the ...
user avatar
6 votes
1 answer
9k views

SQL Timeout to Principle Server Error

I am seeing a timeout to the Pricincipel SQL server (2008 R2) The exact error I am seeing is this: Timeout expired. The timeout period elapsed prior to completion of the operation or the server ...
user avatar
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 ...
user avatar
  • 9,614
5 votes
3 answers
9k views

Arithmetic overflow error

If I run this code: select 99999 * 9999 result = 999890001 If I run this code: select 9999923 * 99999999 result: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting ...
user avatar
5 votes
2 answers
123 views

Does SQL Server 2008 R2 always fail with a severity level 20 error with certain large text manipulation?

When we run this on our SQL Server 2008 R2 instances, it causes a severity 20 error every time. It does not have that issue on our SQL Server 2016 instances. Query: DECLARE @v varchar(MAX) = REPLICATE(...
user avatar
  • 1,811
5 votes
3 answers
591 views

how to solve this warning in select

I have a problem with this query: SELECT * FROM Sales.SalesOrderDetail sod JOIN Sales.SalesOrderHeader soh ON sod.SalesOrderID = soh.SalesOrderID--- adventureworks db Warnings Type conversion ...
user avatar
5 votes
2 answers
4k views

raise an error in sql server severity higher than 18

I can easily raise user defined errors where severity is not higher than 18. When is higher, I get this error Error severity levels greater than 18 can only be specified by members of the ...
user avatar
5 votes
1 answer
1k views

SQL Server logs "blob data", viewable with journalctl

What does it mean when I run journalctl -u mssql-server.service and it says B blob data, Sep 06 17:34:44 x230 systemd[1]: Stopping Microsoft SQL Server Database Engine... Sep 06 17:34:44 x230 ...
user avatar
  • 56.3k
5 votes
2 answers
35k views

Insufficient disk space in Filegroup

One of my jobs is failing and it shows below message. Error: Could not allocate a new page for database 'Reporting' because of insufficient disk space in Filegroup ‘PRIMARY’. Create the necessary ...
user avatar
5 votes
2 answers
4k 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 ...
user avatar
  • 71
5 votes
1 answer
16k views

Incorrect definition of table mysql.event after migrating database to mariadb

I did a mysqldump to dump all databases into a .sql file, then installed a mariadb server. There are no errors after the installation. But after restoring the databases, I started to observe the ...
user avatar
5 votes
1 answer
16k views

What is the HY number (HY000) in MySQL Error messages?

When I get an error some of them have an HY code, ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") What is HY000 ...
user avatar
  • 56.3k
5 votes
2 answers
3k views

MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3 [closed]

I upgraded my installation of MySQL on my Mac OS X 10.8.3 using homebrew brew install mysql Everything seemed to go smoothly, but...not really, as it turns out. I cannot add a new user (neither ...
user avatar
  • 171
5 votes
5 answers
14k views

Bulk Insert - (0 row(s) affected)

I am trying to import a .CSV file into a mssql table using bulk insert (Although I am open to other methods). I have a bulk insert sql statement but it says (0 row(s) affected) when I execute the the ...
user avatar
5 votes
1 answer
2k views

Process attempted to unlock a resource it does not own

SQL Server 2005 SP4 32-Bit I have a DBCC CHECKDB job running nightly. Last night, soon after the job started, I got the errors below. The database is NOT in suspect mode, and CHECKDB comes back clean ...
user avatar
  • 1,933

1
2 3 4 5
9