[ https://issues.apache.org/jira/browse/ARTEMIS-2647?focusedWorklogId=400748&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-400748 ]
ASF GitHub Bot logged work on ARTEMIS-2647: ------------------------------------------- Author: ASF GitHub Bot Created on: 10/Mar/20 14:33 Start Date: 10/Mar/20 14:33 Worklog Time Spent: 10m Work Description: asfgit commented on pull request #3008: ARTEMIS-2647: Fix append-to-file for mysql URL: https://github.com/apache/activemq-artemis/pull/3008 ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 400748) Time Spent: 0.5h (was: 20m) > 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: 0.5h > 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)