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/03/16 15:42:00 UTC
[jira] [Updated] (ARTEMIS-2628) Persistence issue: column
"recordType" not found
[ https://issues.apache.org/jira/browse/ARTEMIS-2628?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Justin Bertram updated ARTEMIS-2628:
------------------------------------
Description:
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:pass@mysql.default.svc.cluster.local: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}
was:
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:pass@mysql.default.svc.cluster.local: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>
> 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:pass@mysql.default.svc.cluster.local: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)