[
https://issues.apache.org/jira/browse/ARTEMIS-2296?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Justin Bertram resolved ARTEMIS-2296.
-------------------------------------
Resolution: Fixed
Fix Version/s: 2.8.0
> AMQ222010: Critical IO Error, shutting down the server, Method
> org.postgresql.jdbc.PgResultSet.updateBlob(int,Blob) is not yet implemented.
> -------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: ARTEMIS-2296
> URL: https://issues.apache.org/jira/browse/ARTEMIS-2296
> Project: ActiveMQ Artemis
> Issue Type: Bug
> Affects Versions: 2.6.3, 2.6.4, 2.7.0
> Reporter: Ravi Soni
> Priority: Major
> Fix For: 2.8.0
>
> Attachments: ARTEMIS-2296.patch
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> Steps to reproduce
> # Set Artemis on PostgreSQL JDBC Store
> # Add many messages to a server, We have around 6G database store in
> PostgreSQL.
> # Restart Artemis MQ Server, At some point on startup, it throws below error
> Reason for Error
> PostgresSequentialSequentialFileDriver class does not override
> public int writeToFile(JDBCSequentialFile file, byte[] data, boolean append)
> throws SQLException from JDBCSequentialFileFactoryDriver class
> {noformat}
> 2019-04-03 21:40:59,445 WARN [org.apache.activemq.artemis.journal]
> AMQ142021: Error on IO callback, Method
> org.postgresql.jdbc.PgResultSet.updateBlob(int,Blob) is not yet implemented.
> 2019-04-03 21:40:59,448 WARN [org.apache.activemq.artemis.journal]
> AMQ142021: Error on IO callback, Error writing to JDBC file.
> 2019-04-03 21:40:59,448 WARN [org.apache.activemq.artemis.core.server]
> AMQ222010: Critical IO Error, shutting down the server.
> file=org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile@3e134896,
> message=Error writing to JDBC file.:
> java.sql.SQLFeatureNotSupportedException: Method
> org.postgresql.jdbc.PgResultSet.updateBlob(int,Blob) is not yet implemented.
> at org.postgresql.Driver.notImplemented(Driver.java:688)
> [postgresql-42.2.5.jar:42.2.5]
> at org.postgresql.jdbc.PgResultSet.updateBlob(PgResultSet.java:3151)
> [postgresql-42.2.5.jar:42.2.5]
> at
> org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFileFactoryDriver.writeToFile(JDBCSequentialFileFactoryDriver.java:279)
> [artemis-jdbc-store-2.6.4.jar:2.6.4]
> at
> org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile.internalWrite(JDBCSequentialFile.java:162)
> [artemis-jdbc-store-2.6.4.jar:2.6.4]
> at
> org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile.internalWrite(JDBCSequentialFile.java:190)
> [artemis-jdbc-store-2.6.4.jar:2.6.4]
> at
> org.apache.activemq.artemis.jdbc.store.file.JDBCSequentialFile.lambda$scheduleWrite$1(JDBCSequentialFile.java:201)
> [artemis-jdbc-store-2.6.4.jar:2.6.4]
> at
> org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:42)
> [artemis-commons-2.6.4.jar:2.6.4]
> at
> org.apache.activemq.artemis.utils.actors.OrderedExecutor.doTask(OrderedExecutor.java:31)
> [artemis-commons-2.6.4.jar:2.6.4]
> at
> org.apache.activemq.artemis.utils.actors.ProcessorBase.executePendingTasks(ProcessorBase.java:66)
> [artemis-commons-2.6.4.jar:2.6.4]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
> [rt.jar:1.8.0_191]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
> [rt.jar:1.8.0_191]
> at
> org.apache.activemq.artemis.utils.ActiveMQThreadFactory$1.run(ActiveMQThreadFactory.java:118)
> [artemis-commons-2.6.4.jar:2.6.4]
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
