Yasin Koyuncu created ARTEMIS-2628:
--------------------------------------
Summary: Persistence issue: column "recordType" not found
Key: ARTEMIS-2628
URL: https://issues.apache.org/jira/browse/ARTEMIS-2628
Project: ActiveMQ Artemis
Issue Type: Bug
Components: Broker
Affects Versions: 2.11.0
Reporter: Yasin Koyuncu
Hi,
I am trying to setup an environment with database as persistent storage.
However when the server starts I get the following error:
2020-02-16 15:31:55,014 WARN
[org.apache.activemq.artemis.jdbc.store.journal.JDBCJournalImpl] Unknown column
'recordType' in 'field list': java.sql.SQLSyntaxErrorException: Unknown column
'recordType' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
[mysql-connector-java-8.0.19.jar:8.0.19]
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
[mysql-connector-java-8.0.19.jar:8.0.19]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
[mysql-connector-java-8.0.19.jar:8.0.19]
at
com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
[mysql-connector-java-8.0.19.jar:8.0.19]
at
org.apache.activemq.artemis.jdbc.store.logging.LoggingPreparedStatement.executeQuery(LoggingPreparedStatement.java:55)
[artemis-jdbc-store-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.jdbc.store.journal.JDBCJournalImpl.load(JDBCJournalImpl.java:832)
[artemis-jdbc-store-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.jdbc.store.journal.JDBCJournalImpl.load(JDBCJournalImpl.java:904)
[artemis-jdbc-store-2.11.0.jar:2.11.0]
at org.apache.activemq.artemis.core.journal.Journal.load(Journal.java:200)
[artemis-journal-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.core.persistence.impl.journal.AbstractJournalStorageManager.loadBindingJournal(AbstractJournalStorageManager.java:1491)
[artemis-server-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.loadJournals(ActiveMQServerImpl.java:3194)
[artemis-server-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.initialisePart2(ActiveMQServerImpl.java:2890)
[artemis-server-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation.run(LiveOnlyActivation.java:76)
[artemis-server-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.internalStart(ActiveMQServerImpl.java:601)
[artemis-server-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.start(ActiveMQServerImpl.java:528)
[artemis-server-2.11.0.jar:2.11.0]
at
org.apache.activemq.artemis.integration.FileBroker.start(FileBroker.java:70)
[artemis-cli-2.11.0.jar:2.11.0]
at org.apache.activemq.artemis.cli.commands.Run.execute(Run.java:84)
[artemis-cli-2.11.0.jar:2.11.0]
at org.apache.activemq.artemis.cli.Artemis.internalExecute(Artemis.java:150)
[artemis-cli-2.11.0.jar:2.11.0]
at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:98)
[artemis-cli-2.11.0.jar:2.11.0]
at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:125)
[artemis-cli-2.11.0.jar:2.11.0]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[rt.jar:1.8.0_232]
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
[rt.jar:1.8.0_232]
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[rt.jar:1.8.0_232]
at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_232]
at org.apache.activemq.artemis.boot.Artemis.execute(Artemis.java:129)
[artemis-boot.jar:2.11.0]
at org.apache.activemq.artemis.boot.Artemis.main(Artemis.java:49)
[artemis-boot.jar:2.11.0]
2020-02-16 15:31:55,042 WARN [org.apache.activemq.artemis.core.server]
AMQ222010: Critical IO Error, shutting down the server. file=NULL,
message=Critical IO Error. Failed to process JDBC Record statements:
java.sql.SQLSyntaxErrorException: Unknown column 'recordType' in 'field list'
This is weird since the bindings table is setup properly on the database and
it's still complaining. I've tried it Postgresql and Mysql and both have the
same issue. I was wondering if it ever worked?
My configuration:
<store>
<database-store>
<jdbc-connection-url>jdbc:mysql://user:[email protected]:3306/artemis</jdbc-connection-url>
<bindings-table-name>BINDINGS</bindings-table-name>
<message-table-name>MESSAGES</message-table-name>
<page-store-table-name>PAGE_STORE</page-store-table-name>
<large-message-table-name>LARGE_MESSAGES</large-message-table-name>
<node-manager-store-table-name>NODE_MANAGER</node-manager-store-table-name>
<jdbc-driver-class-name>com.mysql.cj.jdbc.Driver</jdbc-driver-class-name>
</database-store>
</store>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
