[
https://issues.apache.org/jira/browse/ARTEMIS-2628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Justin Bertram closed ARTEMIS-2628.
-----------------------------------
Resolution: Cannot Reproduce
> 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
> Priority: Major
>
> I am trying to setup an environment with database as persistent storage.
> However when the server starts I get the following error:
>
> {noformat}
> 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'
> {noformat}
>
> 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:
> {code:xml}
> <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>
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
