Hi,
Some weeks ago someone seems to have the same problem, but there is no
resolution in the thread.
I'm running 5.0.22 here are the error and the query :
update sessions set expiry = '1152520424', value = 'ttttttt'
where sesskey = '21iec4f62v539nh4rhgp2uiai1';
1296 - Got error 1 'Unknown error code' from ndbcluster
This one work well :
update sessions set expiry = '1152520424'
where sesskey = '21iec4f62v539nh4rhgp2uiai1';
When I delete some rows (800 of 2000), it's ok again and all queries run
fine.
Note that 'value' is a blob. I added some memory to the cluster but it
does not solve the problem. Sometimes the queries fails when there are
only 300 rows in the table. Could it be a memory problem ?
CREATE TABLE sessions (
sesskey varchar(32) NOT NULL default '',
expiry int(11) unsigned NOT NULL default '0',
value text NOT NULL,
PRIMARY KEY (sesskey),
KEY `expiry` (expiry)
)
Regards,