Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-6637

Not delivered messages - DistributedQueueTest.testSuckFailureHandling is failling on Sybase 15.0

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • EAP_EWP 5.1.1 ER3
    • EAP_EWP 5.1.1 ER2
    • Messaging
    • None
    • NEW

    Description

      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

      Attachments

        Activity

          People

            gaohoward Howard Gao
            mnovak1@redhat.com Miroslav Novak
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: