Description:
Transactions failed to commit on following error:
Caused by: java.sql.SQLException: Got error 240 'Unknown error code' from NDBCLUSTER
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.26.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) ~[mysql-connector-java-5.1.26.jar:na]
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) ~[mysql-connector-java-5.1.26.jar:na]
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) ~[mysql-connector-java-5.1.26.jar:na]
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) ~[mysql-connector-java-5.1.26.jar:na]
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) ~[mysql-connector-java-5.1.26.jar:na]
at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1732) ~[mysql-connector-java-5.1.26.jar:na]
at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1284) ~[c3p0-0.9.2.1.jar:0.9.2.1]
at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112) ~[hibernate-core-4.2.6.Final.jar:4.2.6.Final]
No error to be found in the ndbmtdb log and or mysql sql nodes,
Here below status of the NDB cluster:
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=7 @10.99.24.16 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *)
id=8 @10.99.24.18 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0)
[ndb_mgmd(MGM)] 2 node(s)
id=15 @10.99.24.15 (mysql-5.6.17 ndb-7.3.5)
id=16 @10.99.24.19 (mysql-5.6.17 ndb-7.3.5)
[mysqld(API)] 4 node(s)
id=25 @10.99.24.15 (mysql-5.6.17 ndb-7.3.5)
id=26 @10.99.24.19 (mysql-5.6.17 ndb-7.3.5)
id=37 (not connected, accepting connect from jmbadb27)
id=38 (not connected, accepting connect from jmbadb28)
How to repeat:
not sure
Description: Transactions failed to commit on following error: Caused by: java.sql.SQLException: Got error 240 'Unknown error code' from NDBCLUSTER at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078) ~[mysql-connector-java-5.1.26.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4190) ~[mysql-connector-java-5.1.26.jar:na] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4122) ~[mysql-connector-java-5.1.26.jar:na] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2570) ~[mysql-connector-java-5.1.26.jar:na] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2731) ~[mysql-connector-java-5.1.26.jar:na] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2812) ~[mysql-connector-java-5.1.26.jar:na] at com.mysql.jdbc.ConnectionImpl.commit(ConnectionImpl.java:1732) ~[mysql-connector-java-5.1.26.jar:na] at com.mchange.v2.c3p0.impl.NewProxyConnection.commit(NewProxyConnection.java:1284) ~[c3p0-0.9.2.1.jar:0.9.2.1] at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doCommit(JdbcTransaction.java:112) ~[hibernate-core-4.2.6.Final.jar:4.2.6.Final] No error to be found in the ndbmtdb log and or mysql sql nodes, Here below status of the NDB cluster: ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration --------------------- [ndbd(NDB)] 2 node(s) id=7 @10.99.24.16 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0, *) id=8 @10.99.24.18 (mysql-5.6.17 ndb-7.3.5, Nodegroup: 0) [ndb_mgmd(MGM)] 2 node(s) id=15 @10.99.24.15 (mysql-5.6.17 ndb-7.3.5) id=16 @10.99.24.19 (mysql-5.6.17 ndb-7.3.5) [mysqld(API)] 4 node(s) id=25 @10.99.24.15 (mysql-5.6.17 ndb-7.3.5) id=26 @10.99.24.19 (mysql-5.6.17 ndb-7.3.5) id=37 (not connected, accepting connect from jmbadb27) id=38 (not connected, accepting connect from jmbadb28) How to repeat: not sure