Skip to content

Instantly share code, notes, and snippets.

@lithix-src

lithix-src/gist:4218616

Created December 5, 2012 19:13
Show Gist options
  • Save lithix-src/4218616 to your computer and use it in GitHub Desktop.
Save lithix-src/4218616 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
[Dec 5, 2012 11:12:32 AM] [WARN] [com.dbshards.config.DbsConfigParser] [main] Ignoring client invalid element transaction-isolation-level
Connected OK
SQLConsole> update publisher.publisher_publisher set id=0 where company="MASKED";
[Dec 5, 2012 11:12:58 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:1:1: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:1:1; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:1; statementCount=1; hopCount=1; language=1; targetShard=1; targetShardNot=-1; hopCount=1; primaryAgentId=1; primaryShardId=1 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.46.228:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:1:1; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:1; statementCount=1; hopCount=1; language=1; targetShard=1; targetShardNot=-1; hopCount=1; primaryAgentId=1; primaryShardId=1 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.46.228:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.46.228:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:12:59 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:2:2: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:2:2; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:2; statementCount=1; hopCount=1; language=1; targetShard=2; targetShardNot=-1; hopCount=1; primaryAgentId=2; primaryShardId=2 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.247.35:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:2:2; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:2; statementCount=1; hopCount=1; language=1; targetShard=2; targetShardNot=-1; hopCount=1; primaryAgentId=2; primaryShardId=2 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.247.35:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.247.35:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:12:59 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:3:3: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:3:3; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:3; statementCount=1; hopCount=1; language=1; targetShard=3; targetShardNot=-1; hopCount=1; primaryAgentId=3; primaryShardId=3 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.123.242:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:3:3; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:3; statementCount=1; hopCount=1; language=1; targetShard=3; targetShardNot=-1; hopCount=1; primaryAgentId=3; primaryShardId=3 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.123.242:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.123.242:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:12:59 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:4:4: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:4:4; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:4; statementCount=1; hopCount=1; language=1; targetShard=4; targetShardNot=-1; hopCount=1; primaryAgentId=4; primaryShardId=4 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.226.99.207:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:4:4; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:4; statementCount=1; hopCount=1; language=1; targetShard=4; targetShardNot=-1; hopCount=1; primaryAgentId=4; primaryShardId=4 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.226.99.207:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.226.99.207:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:00 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:5:5: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:5:5; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:5; statementCount=1; hopCount=1; language=1; targetShard=5; targetShardNot=-1; hopCount=1; primaryAgentId=5; primaryShardId=5 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.12.134.139:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:5:5; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:5; statementCount=1; hopCount=1; language=1; targetShard=5; targetShardNot=-1; hopCount=1; primaryAgentId=5; primaryShardId=5 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.12.134.139:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.12.134.139:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:00 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:6:6: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:6:6; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:6; statementCount=1; hopCount=1; language=1; targetShard=6; targetShardNot=-1; hopCount=1; primaryAgentId=6; primaryShardId=6 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.10.166.19:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:6:6; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:6; statementCount=1; hopCount=1; language=1; targetShard=6; targetShardNot=-1; hopCount=1; primaryAgentId=6; primaryShardId=6 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.10.166.19:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.10.166.19:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:00 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:7:7: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:7:7; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:7; statementCount=1; hopCount=1; language=1; targetShard=7; targetShardNot=-1; hopCount=1; primaryAgentId=7; primaryShardId=7 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.81.29:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:7:7; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:7; statementCount=1; hopCount=1; language=1; targetShard=7; targetShardNot=-1; hopCount=1; primaryAgentId=7; primaryShardId=7 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.81.29:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.38.81.29:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:00 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:8:8: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:8:8; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:8; statementCount=1; hopCount=1; language=1; targetShard=8; targetShardNot=-1; hopCount=1; primaryAgentId=8; primaryShardId=8 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.217.33:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:8:8; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:8; statementCount=1; hopCount=1; language=1; targetShard=8; targetShardNot=-1; hopCount=1; primaryAgentId=8; primaryShardId=8 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.217.33:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.217.33:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:01 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:9:9: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:9:9; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:9; statementCount=1; hopCount=1; language=1; targetShard=9; targetShardNot=-1; hopCount=1; primaryAgentId=9; primaryShardId=9 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.60.90.176:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:9:9; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:9; statementCount=1; hopCount=1; language=1; targetShard=9; targetShardNot=-1; hopCount=1; primaryAgentId=9; primaryShardId=9 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.60.90.176:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.60.90.176:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:01 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:10:10: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:10:10; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:10; statementCount=1; hopCount=1; language=1; targetShard=10; targetShardNot=-1; hopCount=1; primaryAgentId=10; primaryShardId=10 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.144.10.231:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:10:10; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:10; statementCount=1; hopCount=1; language=1; targetShard=10; targetShardNot=-1; hopCount=1; primaryAgentId=10; primaryShardId=10 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.144.10.231:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.144.10.231:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:01 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:11:11: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:11:11; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:11; statementCount=1; hopCount=1; language=1; targetShard=11; targetShardNot=-1; hopCount=1; primaryAgentId=11; primaryShardId=11 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.62.145.230:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:11:11; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:11; statementCount=1; hopCount=1; language=1; targetShard=11; targetShardNot=-1; hopCount=1; primaryAgentId=11; primaryShardId=11 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.62.145.230:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.62.145.230:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:01 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:12:12: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:12:12; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:12; statementCount=1; hopCount=1; language=1; targetShard=12; targetShardNot=-1; hopCount=1; primaryAgentId=12; primaryShardId=12 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.10.161.138:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:12:12; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:12; statementCount=1; hopCount=1; language=1; targetShard=12; targetShardNot=-1; hopCount=1; primaryAgentId=12; primaryShardId=12 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.10.161.138:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.10.161.138:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:02 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:13:13: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:13:13; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:13; statementCount=1; hopCount=1; language=1; targetShard=13; targetShardNot=-1; hopCount=1; primaryAgentId=13; primaryShardId=13 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.77.177:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:13:13; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:13; statementCount=1; hopCount=1; language=1; targetShard=13; targetShardNot=-1; hopCount=1; primaryAgentId=13; primaryShardId=13 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.77.177:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.40.77.177:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:02 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:14:14: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:14:14; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:14; statementCount=1; hopCount=1; language=1; targetShard=14; targetShardNot=-1; hopCount=1; primaryAgentId=14; primaryShardId=14 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.62.13.75:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:14:14; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:14; statementCount=1; hopCount=1; language=1; targetShard=14; targetShardNot=-1; hopCount=1; primaryAgentId=14; primaryShardId=14 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.62.13.75:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.62.13.75:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:02 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:15:15: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:15:15; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:15; statementCount=1; hopCount=1; language=1; targetShard=15; targetShardNot=-1; hopCount=1; primaryAgentId=15; primaryShardId=15 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.32.214.99:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:15:15; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:15; statementCount=1; hopCount=1; language=1; targetShard=15; targetShardNot=-1; hopCount=1; primaryAgentId=15; primaryShardId=15 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.32.214.99:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.32.214.99:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:02 AM] [ERROR] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] PRE_COMMIT FAILED: java.sql.SQLException: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:16:16: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:16:16; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:16; statementCount=1; hopCount=1; language=1; targetShard=16; targetShardNot=-1; hopCount=1; primaryAgentId=16; primaryShardId=16 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.12.54.38:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:448)
at com.dbshards.jdbc.sharding.DbsShardedConnection.commit(DbsShardedConnection.java:280)
at com.dbshards.jdbc.sharding.DbsShardedConnection.setAutoCommit(DbsShardedConnection.java:195)
at com.dbshards.jdbc.sharding.DbsShardedStatement.executeUpdate(DbsShardedStatement.java:1206)
at com.dbshards.jdbc.sharding.DbsShardedStatement.execute(DbsShardedStatement.java:418)
at com.dbshards.sqlconsole.SQLConsole.execute(SQLConsole.java:259)
at com.dbshards.sqlconsole.SQLConsole.run(SQLConsole.java:242)
at com.dbshards.sqlconsole.SQLConsole.main(SQLConsole.java:89)
Caused by: java.sql.SQLException: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:16:16; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:16; statementCount=1; hopCount=1; language=1; targetShard=16; targetShardNot=-1; hopCount=1; primaryAgentId=16; primaryShardId=16 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.12.54.38:4010)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendMessage(DbsReplicateConnection.java:627)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.sendCommit(DbsReplicateConnection.java:528)
at com.dbshards.jdbc.replicate.DbsReplicateConnection.commit(DbsReplicateConnection.java:419)
... 7 more
Caused by: com.codefutures.common.messaging.server.FailAckException: FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.12.54.38:4010)
at com.dbshards.messaging.nio.NioAsyncConnection.read(NioAsyncConnection.java:283)
at com.dbshards.messaging.nio.NioAsyncConnection.access$000(NioAsyncConnection.java:19)
at com.dbshards.messaging.nio.NioAsyncConnection$1.run(NioAsyncConnection.java:85)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
[Dec 5, 2012 11:13:02 AM] [WARN] [com.dbshards.jdbc.sharding.DbsShardedConnection] [main] [c1345464-4a6f-4382-bbc6-7ad7f0174a77:1] Commit took 4136 ms. PRE=4135 ms; POST=1 ms.
SQL Exception: PRE_COMMIT failed for TX c1345464-4a6f-4382-bbc6-7ad7f0174a77:16:16: Failed to send message: Commit: mode=MODE_PRE_COMMIT; agentAssignedId=-1; txId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:16:16; connId=c1345464-4a6f-4382-bbc6-7ad7f0174a77:16; statementCount=1; hopCount=1; language=1; targetShard=16; targetShardNot=-1; hopCount=1; primaryAgentId=16; primaryShardId=16 due to FAIL_ACK_PRE_COMMIT_FAILED: FAIL_ACK (10.12.54.38:4010)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment