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

DB2 - table JBM_CLUSTER can't be created when new failover mode used

    XMLWordPrintable

Details

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

    Description

      It seems that table JBM_CLUSTER cannot be created when new failover mode is used and db2 97 db is used.

      Could you please look at it?

      Thank you,

      Mirek

      Log:

      02:36:41,398 TRACE @RMI TCP Connection(2)-10.16.89.224 [JDBCSupport] Executing: CREATE TABLE JBM_CLUSTER (NODE_ID SMALLINT, PING_TIMESTAMP DATETIME, STATE SMALLINT, PRIMARY KEY(NODE_ID))
      02:36:41,398 DEBUG @RMI TCP Connection(2)-10.16.89.224 [logger] TransactionImple.getStatus
      02:36:41,398 DEBUG @RMI TCP Connection(2)-10.16.89.224 [logger] TransactionImple.getStatus
      02:36:41,435 DEBUG @RMI TCP Connection(2)-10.16.89.224 [JDBCSupport] Failed to execute: CREATE TABLE JBM_CLUSTER (NODE_ID SMALLINT, PING_TIMESTAMP DATETIME, STATE SMALLINT, PRIMARY KEY(NODE_ID))
      com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DATETIME, DRIVER=4.11.77
      at com.ibm.db2.jcc.am.gd.a(gd.java:676)
      at com.ibm.db2.jcc.am.gd.a(gd.java:60)
      at com.ibm.db2.jcc.am.gd.a(gd.java:127)
      at com.ibm.db2.jcc.am.jn.c(jn.java:2561)
      at com.ibm.db2.jcc.am.jn.d(jn.java:2549)
      at com.ibm.db2.jcc.am.jn.b(jn.java:1965)
      at com.ibm.db2.jcc.t4.cb.h(cb.java:224)
      at com.ibm.db2.jcc.t4.cb.b(cb.java:47)
      at com.ibm.db2.jcc.t4.q.b(q.java:38)
      at com.ibm.db2.jcc.t4.rb.h(rb.java:114)
      at com.ibm.db2.jcc.am.jn.hb(jn.java:1960)
      at com.ibm.db2.jcc.am.jn.a(jn.java:3066)
      at com.ibm.db2.jcc.am.jn.c(jn.java:719)
      at com.ibm.db2.jcc.am.jn.executeUpdate(jn.java:703)
      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.startService(MessagingPostOfficeService.java:516)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:597)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
      at org.jboss.test.messaging.tools.container.ServiceContainer.invoke(ServiceContainer.java:715)

      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: