Questions tagged [errors]
For questions about specific error codes or messages, including troubleshooting.
373
questions
2
votes
2answers
654 views
MySQL #1064 error on line 2 [closed]
I'm quite new on learning SQL and I seem to be running into an issue with the following code:
CREATE TABLE `read`
(`order` NOT NULL UNIQUE AUTO_INCREMENT,
`title` VARCHAR(50) NOT NULL,
`url` ...
5
votes
2answers
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 ...
0
votes
1answer
7k views
Error “#1118 - row size too large” on the first row of the table only
I ran into a problem using a mySQL database. I have some columns as type text but when I try to enter data into the first row I get the error code "#1118 - Row size too large. The maximum row size for ...
4
votes
3answers
4k views
DBCC CHECKDB Notification
There are plenty of questions on DBA.SE regarding DBCC CHECKDB and how to resolve problems when errors are returned. My specific question is on actually getting notified that DBCC CHECKDB returned ...
5
votes
1answer
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 ...
1
vote
1answer
3k 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
2k views
How do I get more details on a full text catalog error?
I have an error that is repeatedly generated on a SQL Server 2005 instance running the databases for MS Team Foundation Server.
'Severity 16' occurred on INSTANCENAME
Looking in the SQL Server ...
0
votes
1answer
516 views
Undefined reference to my function [closed]
I'm working on a project on postgresql 8.4 server side. I'm adding some functionality in order to store some query informations.
I need to call two functions (start_create_profile() and check()) ...
5
votes
1answer
4k views
Receiving error Error: 18059, Severity: 20, State: 1 in the SQL Logs
I'm using SQL Server 2008 Sp3
Lately I'm having errors in the SQL Logs:
Error: 18059, Severity: 20, State: 1.
The connection has been dropped because the principal that opened it ...
1
vote
2answers
7k views
Postgresql - Segmentation fault (core dumped)
I'm working on postgresql code (server side).
I installed a version from source code following the official tutorial:
http://www.postgresql.org/docs/8.4/interactive/install-short.html
I did same ...
7
votes
2answers
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 ...
2
votes
1answer
2k views
Invalid File Name on login to SQLPLUS
The moment I log into SQLPLUS I get an SP2-0556 error. I recently moved OS but am connecting to the same database so I am not sure if it's because I'm using my old TNSNames or what. I can connect and ...
17
votes
1answer
41k 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?
2
votes
1answer
2k views
Error deleting more than 1 row
I have a stored procedure that is supposed to delete several rows from a table. It does not work and gives me the error:
The transaction ended in the trigger. The batch has been aborted
I tried ...
3
votes
2answers
991 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 ...
24
votes
8answers
105k 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 ...
2
votes
1answer
3k views
jdbc: does setAutoCommit(true) commits past executions?
I would like to execute some statements, and commit the entire batch at the end. I've tried the following approach:
connection.setAutoCommit(false); // Don't commit for each statement
int[]...
1
vote
1answer
157 views
MySQL 5 on Mac 10.5: “problem connecting to the database”
I have worked with MySQL for years but I am stuck on a seemingly trivial problem.
I installed MySQL 5.0.96 on Mac 10.5, created a database, created a user with privileges on everything, and problem:
...
4
votes
1answer
1k views
Named pipes connection closed when subjected to load
We're hosting a service where we have a messaging service. When a message arrives, it checks which subscribers it should be sent to by connecting to the database, and querying the subscriptions table....
9
votes
2answers
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 ...
4
votes
1answer
8k views
Atypical problem with ORA-01445
I have problem with following query Q1:
SELECT ADDRESS.STREET
FROM MYSALES.MYADDRESS ADDRESS
INNER JOIN MYSALES.MYCOUNTRY MCOUNTRY ON MCOUNTRY.MYCOUNTRY_ID = ADDRESS.MYCOUNTRY_ID
INNER JOIN ...
2
votes
3answers
9k views
DB2 LOAD data into table - Interpreting the error messages
I encountered some constraint issues when loading data from file into table
**
SQL3109N The utility is beginning to load data from file
"xag".
SQL3500W The utility is beginning the "LOAD" phase at ...
15
votes
3answers
18k 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 ...
