[ARTEMIS-2296] AMQ222010: Critical IO Error, shutting down the server, Method org.postgresql.jdbc.PgResultSet.updateBlob(int,Blob) is not yet implemented.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.6.3, 2.6.4, 2.7.0
• Fix Version/s: 2.8.0
• Assignee: Unassigned
• Reporter: Ravi Soni
• Created: 06/Apr/19 17:07
• Updated: 24/Apr/19 19:09
• Resolved: 24/Apr/19 19:09

Description

Steps to reproduce

1. Set Artemis on PostgreSQL JDBC Store
2. Add many messages to a server, We have around 6G database store in PostgreSQL.
3. 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

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]

Issue Links

• links to: GitHub Pull Request #2636