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

Openfire Openfire Support
1

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()

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?

2

Which version of Openfire?

3

4.1.1

4

So it is this issue [OF-1229] [HSQL] PubSubPersistenceManager - statement is not in batch mode - IgniteRealtime JIRA , but impacts the Archive plugin.

The good news is that it is harmless (I believe), the bad news is that it clutters up the log files greatly. I have filed it here:

[OF-1266] [HSQL] Archive Plugin - Statement is not in batch mode - IgniteRealtime JIRA