Skip to main content

Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
25 votes
9 answers
131k 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 ...
Pete Oakey's user avatar
3 votes
2 answers
1k views

Execution plan flips Filter and Execute Scalar when using the PK, causes cast to fail

I have some data tables that where imported in from a flat file source so everything is varchar(max) except FileRecordID which is a int that hold the row number the data came from in the flat file ...
Scott Chamberlain's user avatar
1 vote
1 answer
5k views

What is wrong with this statement? 'Unknown column'? [duplicate]

I'm not used to the 'as' keyword and I thought it would be a nice idea to use it. So why do I get an 'unknown column' (eid) error? I use mysql... select t1.index as eid, t1.col1 as col1, t1.col2 as ...
pzogr's user avatar
  • 125
22 votes
2 answers
107k 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 ...
andrewniesen's user avatar
20 votes
6 answers
106k 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 ...
Guillermo's user avatar
  • 203
18 votes
5 answers
118k 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 ...
alexus's user avatar
  • 625
16 votes
5 answers
79k 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 ...
user43965's user avatar
  • 169
15 votes
12 answers
187k 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 ...
Racer SQL's user avatar
  • 7,386
11 votes
4 answers
7k 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 ...
Solomon Rutzky's user avatar
9 votes
5 answers
6k 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 ...
J.D.'s user avatar
  • 38.1k
9 votes
1 answer
8k 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 ...
Mikko Rantalainen's user avatar
7 votes
5 answers
4k views

Microsoft SQL Server 2019 Developer Edition suddenly throwing Internal Connection Fatal Errors

I have Microsoft SQL Server 2019 Developer edition installed on my computer for local development work with .NET. Everything was working well as of two months ago, when I was last working on a ...
Andy S.'s user avatar
  • 73
5 votes
3 answers
10k 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 ...
John Stone's user avatar
4 votes
1 answer
880 views

Challenges with Key with Gaps?

I had a mistake with a trigger which resulted in errors in PostgreSQL 9.4.3 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit. Each time during the error, the primary key ...
Léo Léopold Hertz 준영's user avatar
3 votes
1 answer
245 views

UPDATE statement processing records that should be eliminated by WHERE clause

I am getting a very odd error. Consider the table below: CREATE TABLE #MyTable ( Key1 INT , Key2 INT , x SMALLINT , y INT , z INT , a FLOAT , b FLOAT , c SMALLINT , s FLOAT ) -- insert ...
James's user avatar
  • 33
3 votes
1 answer
2k views

Rare error lasts only a second "Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146)" 146=ECONNREFUSED

This is a rare error that occurs on Solaris 10, have seen it from Perl, where this line DBI->connect(...) or die "Whoops! $DBI::errstr" outputs Whoops! Can't connect to local MySQL server through ...
700 Software's user avatar
1 vote
1 answer
2k views

Restore from copy of SQL Server backup file produces invalid data error

We have an instance of SQL Server 2008 R2 SP2 sitting in a DMZ. When I back up one of its databases to a drive local to that server, then run a RESTORE VERIFYONLY against the backup file, it declares ...
Bob C's user avatar
  • 179
33 votes
5 answers
100k 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 ...
Aasim Abdullah's user avatar
26 votes
3 answers
58k 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'
Evan Carroll's user avatar
  • 63.7k
23 votes
7 answers
85k 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 ...
Max's user avatar
  • 471
18 votes
1 answer
44k 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?
aron's user avatar
  • 595
16 votes
3 answers
16k 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 ...
Alex's user avatar
  • 339
11 votes
4 answers
4k 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 ...
Bogdan Bogdanov's user avatar
6 votes
1 answer
22k 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 ...
Evan Carroll's user avatar
  • 63.7k
4 votes
1 answer
421 views

Implicit conversion causing error part of the time

I have been scratching my head about this one for the last day or so - I just can't see why a procedure works in one environment, but then fails in another due to a conversion error (same data, same ...
George.Palacios's user avatar
3 votes
2 answers
32k views

Cannot get geometry object from data you send to the GEOMETRY field

The following simple test returns an error CREATE TABLE track ( position point NOT NULL ); INSERT INTO track VALUES ( position=ST_PointFromText('POINT(-45.62390335574153 -3.9551761173743847)') ); ...
Aubin's user avatar
  • 185
3 votes
1 answer
9k views

Error Msg 10314, Level 16, State 11 with SAFE assembly after upgrade to SQL Server 2017

I have a pre-SQL Server 2017 database that I restored into / upgraded to SQL Server 2017. In this database I have a SQLCLR Assembly. The Assembly is marked as SAFE since it doesn't do anything ...
Solomon Rutzky's user avatar
3 votes
5 answers
21k views

MSSQLSERVER service does *not* start, port 1433 in use

Sorry to raise if this has been asked before. The SQL Server service is defined as manual, whenever I start it I get (event viewer): Server TCP provider failed to listen on [ 'any' 1433]. Tcp port ...
user36285's user avatar
3 votes
1 answer
235 views

Mysql same DB, same query, different users - different error messages

On my AWS RDS Mysql 8.0.16 server I have one DB (my-db) and 2 users: the master user (created automatically by RDS) and an app user created by me: create user if not exists `appuser`@`%` identified by ...
Andrey Agibalov's user avatar
3 votes
3 answers
3k views

MySQL 5.7 No Longer Returns Meaningful Error Messages

When I select from a table that doesn't exist: When I select a nonexistent column from an existing table: I used to receive meaningful error messages (ie 'Error Code: 1054. Unknown column 'column' ...
Ryan Foley's user avatar
2 votes
1 answer
2k views

What will happen with MySQL transaction if one of the queries fails?

I have 500 independent insert queries. I put them in a transaction to run faster. I am runing queries with PHP. What will happen if one of queries fails? Will the transaction be rolled back ...
Davit Huroyan's user avatar
2 votes
1 answer
188 views

SQL Server: Failed to monitor external signals

This program has encountered a fatal error and cannot continue running. The following diagnostic information is available: Reason: 0x00000007 Message: Failed to monitor external signals ...
Evan Carroll's user avatar
  • 63.7k
1 vote
1 answer
1k 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]...
Mohal's user avatar
  • 111
1 vote
1 answer
4k views

Getting error while importing large data through csv

I am new Postgres. I am getting constraint violation errors while importing a large CSV file. I want to disable all of the database constraints temporarily - I do not know how to do this.
sharad vishe's user avatar
1 vote
1 answer
2k views

Galera won`t start

MariaDB 10.1. I have 3 nodes: KVM-1 wsrep_on=ON binlog_format=ROW default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 innodb_locks_unsafe_for_binlog=1 query_cache_size=0 query_cache_type=0 ...
Roman Bogachev's user avatar
1 vote
1 answer
771 views

My MySQL Server Died

Approximately 1 time per week my MySQL server is shutting down. This is what the log looks like: 2016-03-18 13:46:25 13166 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (...
Philipp Klemeshov's user avatar
1 vote
2 answers
3k views

MySQL query INSERT INTO ... failed - The Table "x" is full

I apologize if my question is incomplete or noobish, I have extremely limited knowledge of SQL but the boss wants me to figure this one out. Environment: Webmin/Virtualmin | MySQL version 5.1.73 on ...
rainfly's user avatar
  • 11
1 vote
1 answer
940 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 ...
hbobenicio's user avatar
0 votes
2 answers
6k views

An error occurred while updating the entries. See the inner exception for details.; [INNER] Execution Timeout Expired

One of our production SQL Servers the database is performing poorly. On the application side, they are experiencing this error: An error occurred while updating the entries. See the inner exception ...
sqllover2020's user avatar
-1 votes
1 answer
690 views

'INTERVAL' is not a recognized ODBC date/time extension option

According to this docs on Interval Literals, this should be a valid INTERVAL, SELECT {INTERVAL '326' YEAR(4)}; But when I try that on dbfiddle, I get, Msg 155 Level 15 State 1 Line 1 'INTERVAL' is ...
Evan Carroll's user avatar
  • 63.7k
-1 votes
1 answer
5k views

Error Code: 1109. Unknown table 'revers' in field list

hello everyone this is a program to reverse a string the program works fine when values are given, but can't fetch the details from the table.If the method is wrong then please tell.thanking everyone ...
bhucho's user avatar
  • 105