3 Replies Latest reply on Jan 10, 2017 12:12 PM by Daryl Herzmann

    Every minute Error org.jivesoftware.openfire.archive.ConversationManager - stat java.sql.SQLException: statement is not in batch mode

    zwe

      Every minute error.log get a message:

       

      2017.01.09 13:10:18 org.jivesoftware.openfire.archive.ConversationManager - 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.GeneratedMethodAccessor73.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja va: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$$3cf0b48.executeBatch(<generated>)

              at org.jivesoftware.openfire.archive.ConversationManager$ArchivingTask.run(Convers ationManager.java:1015)

              at org.jivesoftware.openfire.archive.ConversationManager$1.run(ConversationManager .java:190)

              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)

              ... 15 more

       

      In my server "Archive Settings" is

      2432

      The maximum number of days to keep messages before purging them from the database.

       

      What wrong?