You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@activemq.apache.org by "Justin Bertram (Jira)" <ji...@apache.org> on 2020/01/13 18:04:00 UTC
[jira] [Resolved] (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 ]
Justin Bertram resolved ARTEMIS-1683.
-------------------------------------
Resolution: Abandoned
I'm optimistically assuming this isn't a problem on the latest release (i.e. 2.10.1) so I'm closing. Re-open if the issue still exists.
> 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}
> {{db2jcc4.jar & sqlj4.zip}} are in place {{broker-home/lib/}}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)