[
https://issues.apache.org/jira/browse/ARTEMIS-2296?focusedWorklogId=231857&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-231857
]
ASF GitHub Bot logged work on ARTEMIS-2296:
-------------------------------------------
Author: ASF GitHub Bot
Created on: 24/Apr/19 03:25
Start Date: 24/Apr/19 03:25
Worklog Time Spent: 10m
Work Description: michaelandrepearce commented on issue #2636:
ARTEMIS-2296 PgResultSet.updateBlob not implemented
URL: https://github.com/apache/activemq-artemis/pull/2636#issuecomment-486052740
Have you looked at
https://github.com/opentable/otj-pg-embedded
Or
https://www.testcontainers.org/modules/databases/postgres/
As a way to run postgres for unit testing
----------------------------------------------------------------
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: 231857)
Time Spent: 20m (was: 10m)
> 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: 20m
> 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)
