The errors tag has no wiki summary.
0
votes
1answer
26 views
Error: “Storage Engine for the Table Doesn't Support Nullable Columns” (SequelPro)
I'm trying to load a very normal .csv file (that was created from Excel 2011 for Mac) into SequelPro (using MySQL) with my Mac -- and I've recently started getting this error consistently. Can anybody ...
0
votes
0answers
14 views
Oracle AVDF Database Firewall - Status check error
We are using Oracle Audit Vault & Database Firewall 12.1.0. After checking the status of the database Firewall, in the diagnostic report, we keep getting the following errors:
Checking bridges: ...
1
vote
1answer
31 views
Whay makes this rare error: “Can't connect to local MySQL server through socket '/tmp/mysql.sock' (146)”
This is a rare error that occurs on Solaris, have seen it from Perl looking like this.
DBI->connect(...) or die "Unable to connect: $DBI::errstr"
Outputs
Unable to connect: Can't connect to ...
2
votes
2answers
58 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` ...
2
votes
1answer
73 views
MySQL error 2006 MySQL server has gone away after upgrade to 5.6.10 using homebrew on Max OS X 10.8.3
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 ...
-1
votes
1answer
57 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
221 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
29 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 ...
3
votes
3answers
128 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
131 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
92 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
86 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
100 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
113 views
PostgreSQL server log connection message [closed]
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
206 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 ...
0
votes
2answers
273 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
2k 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
128 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
416 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
177 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
102 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
137 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
63 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
163 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
129 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
795 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
804 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 ...
