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)
