Uploaded image for project: 'AMQ Broker'
  1. AMQ Broker
  2. ENTMQBR-1807

As a EAP developer I want lower-case table names to be upper-case in all tests using DB2 11.1

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Blocker Blocker
    • None
    • None
    • None
    • None
    • AMQ Broker 1828

      Failing Test:
      org.jboss.qa.hornetq.test.soak.JdbcStoreSoakTestCase.soakTest

      LOG:

      03:30:45,263 INFO [org.apache.activemq.artemis.core.server] (ServerService Thread Pool – 78) AMQ221000: live Message Broker is starting with configuration Broker Configuration (clustered=true,jdbcDriverClassName=org.apache.derby.jdbc.EmbeddedDriver,jdbcConnectionUrl=null,messageTableName=mess_node_2,bindingsTableName=bind_node_2,largeMessageTableName=large_node_2,pageStoreTableName=p_node_2,)
      03:30:45,331 ERROR [org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver] (ServerService Thread Pool – 78)
      SQL STATEMENTS:
      CREATE TABLE large_node_2 (ID BIGINT GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1), FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB(2G), PRIMARY KEY(ID))
      SQL EXCEPTIONS:
      SQLState: 42710 ErrorCode: -601 Message: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=DBALLO08.LARGE_NODE_2;TABLE, DRIVER=4.24.92
      03:30:45,334 WARN [org.apache.activemq.artemis.core.server] (ServerService Thread Pool – 78) AMQ222010: Critical IO Error, shutting down the server. file=NULL, message=Unable to start database driver: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-601, SQLSTATE=42710, SQLERRMC=DBALLO08.LARGE_NODE_2;TABLE, DRIVER=4.24.92
      at com.ibm.db2.jcc.am.b6.a(b6.java:810)
      at com.ibm.db2.jcc.am.b6.a(b6.java:66)
      at com.ibm.db2.jcc.am.b6.a(b6.java:140)
      at com.ibm.db2.jcc.am.k3.c(k3.java:2817)
      at com.ibm.db2.jcc.am.k3.d(k3.java:2801)
      at com.ibm.db2.jcc.am.k3.b(k3.java:2161)
      at com.ibm.db2.jcc.t4.ab.k(ab.java:445)
      at com.ibm.db2.jcc.t4.ab.c(ab.java:104)
      at com.ibm.db2.jcc.t4.p.b(p.java:38)
      at com.ibm.db2.jcc.t4.av.h(av.java:124)
      at com.ibm.db2.jcc.am.k3.ak(k3.java:2156)
      at com.ibm.db2.jcc.am.k3.a(k3.java:3359)
      at com.ibm.db2.jcc.am.k3.c(k3.java:783)
      at com.ibm.db2.jcc.am.k3.executeUpdate(k3.java:762)
      at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:430)
      at org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver.createTableIfNotExists(AbstractJDBCDriver.java:243) [artemis-jdbc-store-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver.createTable(AbstractJDBCDriver.java:113) [artemis-jdbc-store-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactoryDriver.createSchema(JDBCSequentialFileFactoryDriver.java:69) [artemis-jdbc-store-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver.start(AbstractJDBCDriver.java:82) [artemis-jdbc-store-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactory.start(JDBCSequentialFileFactory.java:132) [artemis-jdbc-store-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.persistence.impl.journal.JDBCJournalStorageManager.init(JDBCJournalStorageManager.java:92) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.persistence.impl.journal.AbstractJournalStorageManager.<init>(AbstractJournalStorageManager.java:227) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.persistence.impl.journal.JournalStorageManager.<init>(JournalStorageManager.java:106) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.persistence.impl.journal.JDBCJournalStorageManager.<init>(JDBCJournalStorageManager.java:55) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.createStorageManager(ActiveMQServerImpl.java:2155) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.initialisePart1(ActiveMQServerImpl.java:2296) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation.run(LiveOnlyActivation.java:64) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.internalStart(ActiveMQServerImpl.java:536) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.start(ActiveMQServerImpl.java:475) [artemis-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.apache.activemq.artemis.jms.server.impl.JMSServerManagerImpl.start(JMSServerManagerImpl.java:376) [artemis-jms-server-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
      at org.wildfly.extension.messaging.activemq.jms.JMSService.doStart(JMSService.java:206) [wildfly-messaging-activemq-14.0.0.Beta1-SNAPSHOT.jar:14.0.0.Beta1-SNAPSHOT]
      at org.wildfly.extension.messaging.activemq.jms.JMSService.access$000(JMSService.java:65) [wildfly-messaging-activemq-14.0.0.Beta1-SNAPSHOT.jar:14.0.0.Beta1-SNAPSHOT]
      at org.wildfly.extension.messaging.activemq.jms.JMSService$1.run(JMSService.java:100) [wildfly-messaging-activemq-14.0.0.Beta1-SNAPSHOT.jar:14.0.0.Beta1-SNAPSHOT]
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [rt.jar:1.8.0_171]
      at java.util.concurrent.FutureTask.run(FutureTask.java:266) [rt.jar:1.8.0_171]
      at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35) [jboss-threads-2.3.2.Final.jar:2.3.2.Final]
      at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985) [jboss-threads-2.3.2.Final.jar:2.3.2.Final]
      at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487) [jboss-threads-2.3.2.Final.jar:2.3.2.Final]
      at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378) [jboss-threads-2.3.2.Final.jar:2.3.2.Final]
      at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_171]
      at org.jboss.threads.JBossThread.run(JBossThread.java:485) [jboss-threads-2.3.2.Final.jar:2.3.2.Final]

            fnigro Francesco Nigro
            fnigro Francesco Nigro
            Francesco Nigro
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - 2 days
                2d
                Remaining:
                Time Spent - 1 day, 4 hours Remaining Estimate - 4 hours
                4h
                Logged:
                Time Spent - 1 day, 4 hours Remaining Estimate - 4 hours
                1d 4h