MySQL Forums
Forum List  »  NDB clusters

UPDATE error on 5.0.22
Posted by: Luigi Bai
Date: November 15, 2006 04:27PM

I'm trying to update a cluster table but I'm getting the following error:

mysql> update cache set data='blah' where cid='menu:0:en' ;
ERROR 1296 (HY000): Got error 1 'Unknown error code' from ndbcluster

This is the table description:
mysql> desc cache;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| cid | varchar(255) | NO | PRI | NULL | |
| data | text | YES | | NULL | |
| expire | int(11) | NO | MUL | 0 | |
| created | int(11) | NO | | 0 | |
| headers | text | YES | | NULL | |
+---------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> show warnings;
+-------+------+--------------------------------------------------+
| Level | Code | Message |
+-------+------+--------------------------------------------------+
| Error | 1296 | Got error 1 'Unknown error code' from ndbcluster |
| Error | 1180 | Got error 1 during COMMIT |
+-------+------+--------------------------------------------------+
2 rows in set (0.00 sec)

And the table definition:
CREATE TABLE `cache` (
`cid` varchar(255) NOT NULL default '',
`data` text,
`expire` int(11) NOT NULL default '0',
`created` int(11) NOT NULL default '0',
`headers` text,
PRIMARY KEY (`cid`),
KEY `expire` (`expire`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1;


Any ideas on what's going wrong? I'm able to update other tables in the db, I have the right permissions, etc. I was able to INSERT 8 rows into it, but I'm unable to UPDATE it?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
UPDATE error on 5.0.22
1502
November 15, 2006 04:27PM
1133
November 26, 2006 11:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.