http://stackoverflow.com/questions/23466283/got-error-157-un known-error-code-from-ndbcluster

[rahul Goel]

Intermittently got the above error on application nodes while using following configuration.

1. MySQL Cluster (mysql-5.6.11 ndb 7.3.2)
2. quartz 1.6.6.
3. mysql-connector-java:5.1.20

Confirmed there was no network issue when the error happens, although error pertains to network issue of Cluster not available.

Already went through the mysql bugs http://bugs.mysql.com/bug.php?id=44817, which states error is not descriptive and
MySQL Cluster ERROR 1296 (HY000): Got error 157 'Unknown error code' from NDBCLUSTER

Tried upgrading to mysql-connector-java:5.1.28, as suggested here http://forums.terracotta.org/forums/posts/list/8339.page but still issue persist.

Here is complete stack trace

[QuartzScheduler_org.springframework.scheduling.quartz.SchedulerFactoryBean#0-chelgptcat002.karmalab.net1399008756111_ClusterManager]
ERROR quartz.LocalDataSourceJobStore :manage - ClusterManager: Error managing cluster: Failure identifying failed instances when checking-in:
Got error 157 'Unknown error code' from NDBCLUSTER
org.quartz.JobPersistenceException: Failure identifying failed instances when checking-in: Got error 157 'Unknown error code' from NDBCLUSTER
[See nested exception: java.sql.SQLException: Got error 157 'Unknown error code' from NDBCLUSTER]
at org.quartz.impl.jdbcjobstore.JobStoreSupport.findFailedInstances(JobStoreSupport.java:3266)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.clusterCheckIn(JobStoreSupport.java:3319)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.doCheckin(JobStoreSupport.java:3175)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.manage(JobStoreSupport.java:3798)
at org.quartz.impl.jdbcjobstore.JobStoreSupport$ClusterManager.run(JobStoreSupport.java:3834)

Caused by: java.sql.SQLException: Got error 157 'Unknown error code' from NDBCLUSTER
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1086)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4237)
at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2190)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:2046)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3543)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:491)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:3245)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2413)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2836)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2825)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2156)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2313)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectSchedulerStateRecords(StdJDBCDelegate.java:3276)
at org.quartz.impl.jdbcjobstore.JobStoreSupport.findFailedInstances(JobStoreSupport.java:3229)

Thanks