[ARTEMIS-2628] Persistence issue: column "recordType" not found

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 2.11.0
• Component/s: Broker
• Assignee: Unassigned
• Reporter: Yasin Koyuncu
• Created: 21/Feb/20 11:17
• Updated: 16/Mar/20 16:58
• Resolved: 16/Mar/20 16:58

Description

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:[e-mail]: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>