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

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ARTEMIS-2296?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16825428#comment-16825428 ] 

ASF subversion and git services commented on ARTEMIS-2296:
----------------------------------------------------------

Commit b4ce3305bfc2b0a6ee88d0083aed5d7d6eaf586f in activemq-artemis's branch refs/heads/master from Justin Graham Bertram
[ https://gitbox.apache.org/repos/asf?p=activemq-artemis.git;h=b4ce330 ]

ARTEMIS-2296 PgResultSet.updateBlob not implemented

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.


> 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: 40m
>  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)