You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@activemq.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2020/03/10 14:34:00 UTC
[jira] [Commented] (ARTEMIS-2647) JDBC store query append-to-file
not correct for mysql
[ https://issues.apache.org/jira/browse/ARTEMIS-2647?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17056008#comment-17056008 ]
ASF subversion and git services commented on ARTEMIS-2647:
----------------------------------------------------------
Commit 127173b5d9a3fd8d42c82dcd6577700d81cb1e39 in activemq-artemis's branch refs/heads/master from Benjamin Graf
[ https://gitbox.apache.org/repos/asf?p=activemq-artemis.git;h=127173b ]
ARTEMIS-2647: Fix append-to-file for mysql
> JDBC store query append-to-file not correct for mysql
> -----------------------------------------------------
>
> Key: ARTEMIS-2647
> URL: https://issues.apache.org/jira/browse/ARTEMIS-2647
> Project: ActiveMQ Artemis
> Issue Type: Bug
> Components: Broker
> Affects Versions: 2.11.0
> Reporter: Benjamin Graf
> Priority: Major
> Time Spent: 20m
> Remaining Estimate: 0h
>
> Running artemis with mysql database as store throws exception if paging:
> {noformat}
> 09:25:34.555 WARN [Thread-1 (ActiveMQ-IO-server-org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl$7@29527d0b)] AMQ222010: Critical IO Error, shutting down the server. file=org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile@4850c957, message=Error writing to JDBC file.
> com.mysql.cj.jdbc.exceptions.NotUpdatable: Result Set not updatable (references no primary keys).This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from that table. See the JDBC 2.1 API Specification, section 5.6 for more details.
> at com.mysql.cj.jdbc.result.UpdatableResultSet.generateStatements(UpdatableResultSet.java:569) ~[?:?]
> at com.mysql.cj.jdbc.result.UpdatableResultSet.syncUpdate(UpdatableResultSet.java:1124) ~[?:?]
> at com.mysql.cj.jdbc.result.UpdatableResultSet.updateBlob(UpdatableResultSet.java:1267) ~[?:?]
> at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactoryDriver.writeToFile(JDBCSequentialFileFactoryDriver.java:279) ~[!/:?]
> at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile.internalWrite(JDBCSequentialFile.java:162) [!/:?]
> at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile.internalWrite(JDBCSequentialFile.java:186) [!/:?]
> at org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile.lambda$scheduleWrite$0(JDBCSequentialFile.java:195) [!/:?]
> at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:42) [!/:?]
> at org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:31) [!/:?]
> at org.apache.activemq.artemis.utils.actors.ProcessorBase.executePendingTasks(ProcessorBase.java:66) [!/:?]
> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
> at org.apache.activemq.artemis.utils.ActiveMQThreadFactory$1.run(ActiveMQThreadFactory.java:118) [!/:?]
> {noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)