Uploaded image for project: 'Openfire'
  1. Openfire
  2. OF-1229

[HSQL] PubSubPersistenceManager - statement is not in batch mode

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.1.0
    • Component/s: Database
    • Labels:
      None

      Description

      Using current master build, we are getting this with HSQL

      2016.11.28 10:18:05 ERROR [TaskEngine-pool-3]: org.jivesoftware.openfire.pubsub.PubSubPersistenceManager - statement is not in batch mode
      java.sql.SQLException: statement is not in batch mode
      	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      	at org.hsqldb.jdbc.JDBCUtil.sqlExceptionSQL(Unknown Source)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)
      	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      	at java.lang.reflect.Method.invoke(Method.java:498)
      	at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)
      	at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)
      	at $java.sql.Statement$$EnhancerByProxool$$6838ad71.executeBatch(<generated>)
      	at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager.purgeItems(PubSubPersistenceManager.java:1893)
      	at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager.access$000(PubSubPersistenceManager.java:62)
      	at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager$2.run(PubSubPersistenceManager.java:288)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: org.hsqldb.HsqlException: statement is not in batch mode
      	at org.hsqldb.error.Error.error(Unknown Source)
      	at org.hsqldb.error.Error.error(Unknown Source)
      	... 17 more
      

      OF-955 update likely to blame here...

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              akrherz Daryl Herzmann
              Reporter:
              akrherz Daryl Herzmann
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: