Im getting this error from attempted inserts into a BDB table using
mysql-3.23.42 ( same error but more often in 3.23.38 ):
Could not insert new row into SESSION_DATA: Got error -30996 from table
handler
First - I have not been able to find what this error means in either the
source code, online, or with tools like perror ( doesnt like negative
numbers ). Does anyone have an idea what this is, or how to find out?
Info on the situation:
I've got X simultaneous connections inserting and updating rows, and this
error consistently pops up if X > 16. If X = 32, more than half of the
inserts are errors.
Here is the table:
CREATE TABLE SESSION_DATA (
SESSION_ID int(10) unsigned NOT NULL auto_increment,
SESSION_KEY varchar(32) default NULL,
TS_ACCESS timestamp(14) NOT NULL,
DATA text NOT NULL,
PRIMARY KEY (SESSION_ID),
UNIQUE KEY SESSION_DATA___SESSION_KEY (SESSION_KEY)
) TYPE=BerkeleyDB;
Here are the sql statements used:
## Create a Session
SET AUTOCOMMIT=0;
INSERT INTO SESSION_DATA (SESSION_KEY,TS_ACCESS,DATA) VALUES (NULL,NULL,'');
UPDATE SESSION_DATA SET SESSION_KEY='32bytesofblah',TS_ACCESS=NULL,DATA=''
WHERE SESSION_ID=###; ( ### was set to LAST_INSERT_ID() between sql
statements )
COMMIT;
SET AUTOCOMMIT=1;
## Update a Session ( AUTOCOMMIT=1 )
UPDATE SESSION_DATA SET SESSION_KEY='32bytes ofblah',TS_ACCESS=NOW(),DATA='a
load of text...' WHERE SESSION_ID=###;
thanks for any info,
dpk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
