You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@activemq.apache.org by "Michal Toth (JIRA)" <ji...@apache.org> on 2018/02/15 16:30:00 UTC
[jira] [Updated] (ARTEMIS-1683) DB2 is not working with artemis
2.4.0 SQL Syntax error
[ https://issues.apache.org/jira/browse/ARTEMIS-1683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michal Toth updated ARTEMIS-1683:
---------------------------------
Description:
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}
broker.xml
{noformat}
<store>
<database-store>
<bindings-table-name>BINDINGS_TABLE</bindings-table-name>
<jdbc-connection-url>jdbc:db2://<myhost>:50000/dballo:user=adm;password=adm;</jdbc-connection-url>
<large-message-table-name>LARGE_MESSAGES_TABLE</large-message-table-name>
<page-store-table-name>PG_STR_TBL</page-store-table-name>
<jdbc-driver-class-name>com.ibm.db2.jcc.DB2Driver</jdbc-driver-class-name>
<message-table-name>MESSAGE_TABLE</message-table-name>
</database-store>
</store>
{noformat}
was:
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}
> 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
> Priority: Major
>
> 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}
>
> broker.xml
> {noformat}
> <store>
> <database-store>
> <bindings-table-name>BINDINGS_TABLE</bindings-table-name>
> <jdbc-connection-url>jdbc:db2://<myhost>:50000/dballo:user=adm;password=adm;</jdbc-connection-url>
> <large-message-table-name>LARGE_MESSAGES_TABLE</large-message-table-name>
> <page-store-table-name>PG_STR_TBL</page-store-table-name>
> <jdbc-driver-class-name>com.ibm.db2.jcc.DB2Driver</jdbc-driver-class-name>
> <message-table-name>MESSAGE_TABLE</message-table-name>
> </database-store>
> </store>
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)