MySQL Cluster ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER

mysql database-administration mysql-cluster
Jacob R picture Jacob R · Aug 30, 2013 · Viewed 11.6k times · Source

Today my datacenter had a breaker fail which resulted in my servers losing power. I'm running a 4 node MySQL cluster. I restarted the cluster, first the management nodes, then the data nodes, then after the data nodes were running I started the SQL nodes. I then checked the cluster with ndb_mgm -e SHOW. Everything seemed fine until I tried running a query. I got this error,

ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER

I check the MySQL logs and could not find any errors. I then tried a full shutdown and restart of the MySQL cluster and checked config between the shutdown and start. Everything seemed to check out. I then ran a query on another database using the NDBCLUSTER engine. The query was successful. I've tried searching google but no one seems to have any answers that help. I've checked the config, I've made sure ndbd is running on the data nodes, ect. The other databases seem to be working fine except this one. I have a backup of the database but I would much preferably recover the database if possible.

If anyone has any suggestion or ideas, it would be greatly appreciated.

Thanks in advance.

Answer

Bill Karwin picture Bill Karwin · Aug 30, 2013

Error 157 is actually 'could not connect to storage engine' and the fact that MySQL fails to report that error correctly is a bug: http://bugs.mysql.com/bug.php?id=44817

The case described in that bug mentions that you get the error when you try to query a table in NDB when the cluster is still down.

So I'm just guessing, but I would conclude that your cluster is not started. Either you missed starting one of the nodes, or else something went wrong starting one of the nodes.

Related questions

how to drop database

i used the following sytanx drop database filmo; and got the following error: ERROR 1010 (HY000): Error dropping database (can't rmdir './filmo/', errno: 17) any ideas..

Read More
improve speed of mysql import

I have large database of 22GB. I used to take backup with mysqldump command in a gzip format. When i extract the gz file it produces the .sql file of 16.2GB When I try to import the database in my …

Read More
mysql_secure_installation "Can't connect to local MySQL server through socket"

When I am invoking the file mysql_secure_installation I get an error like [mysqk123@InstallZeMo bin]$ ./mysql_secure_installation NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP …

Read More