[
https://issues.apache.org/jira/browse/ARTEMIS-2296?focusedWorklogId=231729&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-231729
]
ASF GitHub Bot logged work on ARTEMIS-2296:
-------------------------------------------
Author: ASF GitHub Bot
Created on: 23/Apr/19 22:07
Start Date: 23/Apr/19 22:07
Worklog Time Spent: 10m
Work Description: jbertram commented on pull request #2636: ARTEMIS-2296
PgResultSet.updateBlob not implemented
URL: https://github.com/apache/activemq-artemis/pull/2636
There is no test for this as we don't have a way to embed/test Postgres.
It will need to be verified externally. However, given the exception the
fix looks solid.
----------------------------------------------------------------
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:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 231729)
Time Spent: 10m
Remaining Estimate: 0h
> 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
> Attachments: ARTEMIS-2296.patch
>
> Time Spent: 10m
> 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)
