-
Bug
-
Resolution: Done
-
Critical
-
EAP_EWP 5.1.1 ER2
-
None
-
NEW
Hi,
there are not delivered messages in this test scenario(DistributedQueueTest.testSuckFailureHandling):
send 1000 messages to node 0, receive on node 1 and
1. when receiving, kill node1
2. restart node1 and continue receive
3. repeat step 1 and 2 for 5 times
Logs attached. I didn't have time to investigate deeper. But it seems to be problem in SQL commands for Sybase. For example i found following error message in server1 logs:
14:06:51,050 DEBUG @RMI TCP Connection(2)-10.16.64.56 [JDBCSupport] Failed to execute: CREATE TABLE JBM_CLUSTER (NODE_ID SMALLINT, PING_TIMESTAMP DATETIME, STATE SMALLINT, PRIMARY KEY(NODE_ID))
com.sybase.jdbc4.jdbc.SybSQLException: Column 'NODE_ID' is part of a primary key constraint and cannot be null.
at com.sybase.jdbc4.tds.Tds.a(Unknown Source)
at com.sybase.jdbc4.tds.Tds.nextResult(Unknown Source)
at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.nextResult(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.updateLoop(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(Unknown Source)
at com.sybase.jdbc4.jdbc.SybStatement.executeUpdate(Unknown Source)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)
at org.jboss.messaging.core.impl.JDBCSupport.createSchema(JDBCSupport.java:340)
at org.jboss.messaging.core.impl.JDBCSupport.start(JDBCSupport.java:207)
at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:413)
at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startS
Could you look at it please?
Thank you,
Mirek