Questions tagged [errors]

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

Filter by
Sorted by
Tagged with
23
votes
8answers
91k 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 ...
1
vote
1answer
3k 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 ...
16
votes
4answers
73k 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 ...
16
votes
5answers
72k 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 ...
17
votes
2answers
43k 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 ...
13
votes
2answers
64k 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 ...
8
votes
7answers
57k 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 ...
3
votes
1answer
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 ...
11
votes
2answers
2k 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 ...
5
votes
3answers
6k 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 ...
3
votes
1answer
181 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 ...
1
vote
1answer
1k 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 ...
14
votes
2answers
23k 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'
17
votes
1answer
38k 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?
1
vote
1answer
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 ...
11
votes
4answers
2k 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 ...
1
vote
2answers
1k 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 ...
1
vote
1answer
2k 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.
3
votes
1answer
163 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 ...
3
votes
2answers
907 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 ...
2
votes
1answer
2k 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 ...
2
votes
3answers
2k 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' ...
2
votes
5answers
14k 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 ...
2
votes
1answer
117 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 ...
2
votes
2answers
12k 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)') ); ...
1
vote
1answer
43 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]...
1
vote
1answer
429 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
1answer
413 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 ...
1
vote
1answer
294 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 (...
-1
votes
1answer
280 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 ...