3 messages in com.mysql.lists.cluster1296 - Got error 1 'Unknown error code'
FromSent OnAttachments
Pierre Bastoul11 Jul 2006 01:55 
pek...@mysql.com11 Jul 2006 02:36 
Pierre Bastoul13 Jul 2006 09:31 
Subject:1296 - Got error 1 'Unknown error code'
From:Pierre Bastoul (pie@o10c.fr)
Date:07/11/2006 01:55:02 AM
List:com.mysql.lists.cluster

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,