Uploaded image for project: 'ActiveMQ Artemis'
  1. ActiveMQ Artemis
  2. ARTEMIS-2296

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

    XMLWordPrintableJSON

    Details

    • 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
    • Component/s: None
    • Labels:
      None

      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]
      
      
      

        Attachments

        1. ARTEMIS-2296.patch
          2 kB
          Ravi Soni

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                ravi.soni Ravi Soni
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 50m
                  50m