The errors tag has no wiki summary.
-1
votes
1answer
49 views
Why is this mysql query wrong? [closed]
I try to run the following sql query in mysql
SET @rank:=0;
WITH TEMP
(
SELECT @rank := @rank + 1 AS ROW_ID , UUID() as RANDOM_VALUE,D.*
FROM house_information_new D
ORDER BY ...
0
votes
1answer
48 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 ...
0
votes
0answers
19 views
What is the quickest way to recover from an “Incorrect key file for table” replication error?
I'm trying to figure out the quickest way to recover from a replication error.
The production site replicates to a DR site. There are two databases at each site. So prod_master replicates to ...
2
votes
2answers
82 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 ...
4
votes
1answer
85 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 ...
0
votes
1answer
65 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.
2
votes
0answers
56 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 ...
-1
votes
1answer
82 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()) ...
0
votes
1answer
66 views
PostgreSQL server log connection message
I'm seeing the following message in PostgreSQL server log:
LOG: could not receive data from client: No connection could be made because the target machine actively refused it.
There are ...
4
votes
0answers
152 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 subsequently
...
0
votes
2answers
183 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
101 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 ...
4
votes
1answer
243 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
157 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 ...
2
votes
2answers
87 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 ...
4
votes
1answer
2k 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 ...
0
votes
1answer
110 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
...
1
vote
1answer
62 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:
...
3
votes
1answer
150 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 ...
2
votes
1answer
93 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 ...
2
votes
1answer
665 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
1answer
700 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 ...
