[ 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)