Michal Toth created ARTEMIS-1683: ------------------------------------ Summary: DB2 is not working with artemis 2.4.0 SQL Syntax error Key: ARTEMIS-1683 URL: https://issues.apache.org/jira/browse/ARTEMIS-1683 Project: ActiveMQ Artemis Issue Type: Bug Components: Broker Affects Versions: 2.4.0 Reporter: Michal Toth
I have set up DB2 10.5 according docs and broker is unable to create tables on start. Seems like my connector is doing well (properly set up and JDBC url is fine as well). Here's the output of running on rhel7 {noformat} [root@dell-pem630-02 clients]# /opt/artemis-7-i0/bin/artemis run 11:20:16.670 INFO [org.eclipse.jetty.util.log] Logging initialized @642ms to org.eclipse.jetty.util.log.Slf4jLog 11:20:16.855 WARN [org.apache.activemq.artemis.core.server] AMQ222269: Please use a fixed value for "journal-pool-files". Default changed per https://issues.apache.org/jira/browse/ARTEMIS-1628 11:20:16.879 INFO [org.apache.activemq.artemis.integration.bootstrap] AMQ101000: Starting ActiveMQ Artemis Server 11:20:18.467 INFO [org.apache.activemq.artemis.core.server] AMQ221000: live Message Broker is starting with configuration Broker Configuration (clustered=false,journalDirectory=./data/journal,bindingsDirectory=./data/bindings,largeMessagesDirectory=./data/large-messages,pagingDirectory=./data/paging) 11:20:18.502 ERROR [org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver] SQL STATEMENTS: CREATE TABLE LARGE_MESSAGES_TABLE(ID BIGINT AUTO_INCREMENT, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID)) SQL EXCEPTIONS: SQLState: 42601 ErrorCode: -104 Message: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=,;IGINT AUTO_INCREMENT;<references_spec>, DRIVER=4.21.29 11:20:18.502 WARN [org.apache.activemq.artemis.core.server] 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=-104, SQLSTATE=42601, SQLERRMC=,;IGINT AUTO_INCREMENT;<references_spec>, DRIVER=4.21.29 at com.ibm.db2.jcc.am.kd.a(kd.java:810) [db2jcc4.jar:] at com.ibm.db2.jcc.am.kd.a(kd.java:66) [db2jcc4.jar:] at com.ibm.db2.jcc.am.kd.a(kd.java:140) [db2jcc4.jar:] at com.ibm.db2.jcc.am.sp.c(sp.java:2796) [db2jcc4.jar:] at com.ibm.db2.jcc.am.sp.d(sp.java:2784) [db2jcc4.jar:] at com.ibm.db2.jcc.am.sp.b(sp.java:2146) [db2jcc4.jar:] at com.ibm.db2.jcc.t4.bb.j(bb.java:233) [db2jcc4.jar:] at com.ibm.db2.jcc.t4.bb.c(bb.java:48) [db2jcc4.jar:] at com.ibm.db2.jcc.t4.p.b(p.java:38) [db2jcc4.jar:] at com.ibm.db2.jcc.t4.vb.h(vb.java:124) [db2jcc4.jar:] at com.ibm.db2.jcc.am.sp.jb(sp.java:2141) [db2jcc4.jar:] at com.ibm.db2.jcc.am.sp.a(sp.java:3336) [db2jcc4.jar:] at com.ibm.db2.jcc.am.sp.c(sp.java:768) [db2jcc4.jar:] at com.ibm.db2.jcc.am.sp.executeUpdate(sp.java:747) [db2jcc4.jar:] at org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver.createTableIfNotExists(AbstractJDBCDriver.java:194) [artemis-jdbc-store-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver.createTable(AbstractJDBCDriver.java:112) [artemis-jdbc-store-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactoryDriver.createSchema(JDBCSequentialFileFactoryDriver.java:69) [artemis-jdbc-store-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver.start(AbstractJDBCDriver.java:82) [artemis-jdbc-store-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactory.start(JDBCSequentialFileFactory.java:132) [artemis-jdbc-store-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.persistence.impl.journal.JDBCJournalStorageManager.init(JDBCJournalStorageManager.java:92) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.persistence.impl.journal.AbstractJournalStorageManager.<init>(AbstractJournalStorageManager.java:226) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.persistence.impl.journal.JournalStorageManager.<init>(JournalStorageManager.java:106) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.persistence.impl.journal.JDBCJournalStorageManager.<init>(JDBCJournalStorageManager.java:55) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.createStorageManager(ActiveMQServerImpl.java:2114) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.initialisePart1(ActiveMQServerImpl.java:2255) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation.run(LiveOnlyActivation.java:63) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.internalStart(ActiveMQServerImpl.java:521) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.start(ActiveMQServerImpl.java:460) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.integration.FileBroker.start(FileBroker.java:111) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.commands.Run.execute(Run.java:82) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.Artemis.internalExecute(Artemis.java:149) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:96) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:123) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_161] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_161] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_161] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_161] at org.apache.activemq.artemis.boot.Artemis.execute(Artemis.java:129) [artemis-boot.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.boot.Artemis.main(Artemis.java:49) [artemis-boot.jar:2.4.0.amq-710004-redhat-1] 11:20:18.522 ERROR [org.apache.activemq.artemis.jdbc.store.drivers.AbstractJDBCDriver] SQL STATEMENTS: CREATE TABLE PG_STR_TBL(ID BIGINT AUTO_INCREMENT, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID)) SQL EXCEPTIONS: SQLState: 42601 ErrorCode: -104 Message: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=,;IGINT AUTO_INCREMENT;<references_spec>, DRIVER=4.21.29 11:20:18.541 INFO [org.apache.activemq.artemis.core.server] AMQ221043: Protocol module found: [artemis-server]. Adding protocol support for: CORE 11:20:18.542 INFO [org.apache.activemq.artemis.core.server] AMQ221043: Protocol module found: [artemis-amqp-protocol]. Adding protocol support for: AMQP 11:20:18.542 INFO [org.apache.activemq.artemis.core.server] AMQ221043: Protocol module found: [artemis-hornetq-protocol]. Adding protocol support for: HORNETQ 11:20:18.542 INFO [org.apache.activemq.artemis.core.server] AMQ221043: Protocol module found: [artemis-mqtt-protocol]. Adding protocol support for: MQTT 11:20:18.543 INFO [org.apache.activemq.artemis.core.server] AMQ221043: Protocol module found: [artemis-openwire-protocol]. Adding protocol support for: OPENWIRE 11:20:18.543 INFO [org.apache.activemq.artemis.core.server] AMQ221043: Protocol module found: [artemis-stomp-protocol]. Adding protocol support for: STOMP 11:20:18.582 ERROR [org.apache.activemq.artemis.core.server] AMQ224000: Failure in initialisation: java.lang.NullPointerException at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactoryDriver.listFiles(JDBCSequentialFileFactoryDriver.java:89) [artemis-jdbc-store-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactory.listFiles(JDBCSequentialFileFactory.java:180) [artemis-jdbc-store-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.persistence.impl.journal.JournalStorageManager.cleanupIncompleteFiles(JournalStorageManager.java:212) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.persistence.impl.journal.JournalStorageManager.beforeStart(JournalStorageManager.java:191) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.persistence.impl.journal.AbstractJournalStorageManager.start(AbstractJournalStorageManager.java:1517) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.initialisePart1(ActiveMQServerImpl.java:2287) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation.run(LiveOnlyActivation.java:63) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.internalStart(ActiveMQServerImpl.java:521) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.start(ActiveMQServerImpl.java:460) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.integration.FileBroker.start(FileBroker.java:111) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.commands.Run.execute(Run.java:82) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.Artemis.internalExecute(Artemis.java:149) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:96) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:123) [artemis-cli-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_161] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_161] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_161] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_161] at org.apache.activemq.artemis.boot.Artemis.execute(Artemis.java:129) [artemis-boot.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.boot.Artemis.main(Artemis.java:49) [artemis-boot.jar:2.4.0.amq-710004-redhat-1] 11:20:18.583 INFO [org.apache.activemq.artemis.core.server] AMQ221001: Apache ActiveMQ Artemis Message Broker version 2.4.0.amq-710004-redhat-1 [amq, nodeID=e6c04193-126b-11e8-acee-5cf9dd9b2c46] 11:20:18.589 ERROR [org.apache.activemq.artemis.core.server] AMQ224068: Unable to stop component: org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation: java.lang.IllegalStateException: live lock can't be renewed at org.apache.activemq.artemis.core.server.impl.jdbc.JdbcNodeManager.pauseLiveServer(JdbcNodeManager.java:332) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation.close(LiveOnlyActivation.java:99) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.stop(ActiveMQServerImpl.java:1105) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.stop(ActiveMQServerImpl.java:939) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl$4.run(ActiveMQServerImpl.java:774) [artemis-server-2.4.0.amq-710004-redhat-1.jar:2.4.0.amq-710004-redhat-1] 11:20:18.590 INFO [org.apache.activemq.artemis.core.server] AMQ221002: Apache ActiveMQ Artemis Message Broker version 2.4.0.amq-710004-redhat-1 [e6c04193-126b-11e8-acee-5cf9dd9b2c46] stopped, uptime 1.705 seconds 11:20:18.677 INFO [org.eclipse.jetty.server.Server] jetty-9.4.z-SNAPSHOT 11:20:18.753 INFO [org.eclipse.jetty.webapp.StandardDescriptorProcessor] NO JSP Support for /redhat-branding, did not find org.eclipse.jetty.jsp.JettyJspServlet 11:20:18.762 INFO [org.eclipse.jetty.server.session] DefaultSessionIdManager workerName=node0 11:20:18.762 INFO [org.eclipse.jetty.server.session] No SessionScavenger set, using defaults 11:20:18.763 INFO [org.eclipse.jetty.server.session] Scavenging every 600000ms 11:20:18.773 INFO [io.hawt.branding.plugin.PluginContextListener] Initialized hawtio-redhat-fuse-branding plugin 11:20:18.783 INFO [org.eclipse.jetty.server.handler.ContextHandler] Started o.e.j.w.WebAppContext@5b367418{/redhat-branding,file:///opt/jboss-amq-7-i0/tmp/jetty-0.0.0.0-8161-redhat-branding.war-_redhat-branding-any-7850249989896071083.dir/webapp/,AVAILABLE}{/opt/amq-broker-7.1.0/web/redhat-branding.war} 11:20:18.806 INFO [org.eclipse.jetty.webapp.StandardDescriptorProcessor] NO JSP Support for /artemis-plugin, did not find org.eclipse.jetty.jsp.JettyJspServlet 11:20:18.811 INFO [org.apache.activemq.hawtio.plugin.PluginContextListener] Initialized artemis-plugin plugin 11:20:18.812 INFO [org.eclipse.jetty.server.handler.ContextHandler] Started o.e.j.w.WebAppContext@19c65cdc{/artemis-plugin,file:///opt/jboss-amq-7-i0/tmp/jetty-0.0.0.0-8161-artemis-plugin.war-_artemis-plugin-any-5894197120335880672.dir/webapp/,AVAILABLE}{/opt/amq-broker-7.1.0/web/artemis-plugin.war} 11:20:18.844 INFO [org.eclipse.jetty.webapp.StandardDescriptorProcessor] NO JSP Support for /dispatch-hawtio-console, did not find org.eclipse.jetty.jsp.JettyJspServlet SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/opt/jboss-amq-7-i0/tmp/jetty-0.0.0.0-8161-dispatch-hawtio-console.war-_dispatch-hawtio-console-any-6616845924589921461.dir/webapp/WEB-INF/lib/slf4j-log4j12-1.7.22.redhat-1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/opt/amq-broker-7.1.0/lib/slf4j-jboss-logmanager-1.0.3.GA-redhat-2.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]{noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)