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