powered by Jive Software

What do these Java-Errors mean?

Hello everybody,

I’m running a Windows based Openfire v3.8.1 XMPP Server with the following plugins and system data:

Plugins:

Jingle Nodes Plugin

Registration

STUN server plugin

Search

Subscription

User Service

System:

Java Version:
1.6.0_18 Sun Microsystems Inc. – Java HotSpot™ Client VM
Appserver:
jetty/7.x.y-SNAPSHOT
OS / Hardware:
Windows Server 2008 R2 / x86
Database
MySQL v5.6.10 (using piped connection)

It does its’ job quite nice, but on a daily basis I find these recurring errors and warnings in the log (red markings as in the log files):

Warn

org.jivesoftware.openfire.pubsub.PubSubPersistenceManager - Affiliations found for a non-existent node: urn:xmpp:inbox

org.jivesoftware.openfire.pubsub.PubSubPersistenceManager - Subscription found for a non-existent node: urn:xmpp:inbox

org.jivesoftware.util.log.util.CommonsLogFactory - Going to buffer response body of large or unknown size. Using getResponseBodyAsStream instead is recommended.

Error

at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3206)

at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1447)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.logicalcobwebs.proxool.ProxyStatement.invoke(ProxyStatement.java:100)

at org.logicalcobwebs.proxool.ProxyStatement.intercept(ProxyStatement.java:57)

at $java.sql.Wrapper$$EnhancerByProxool$$a5cc137b.executeQuery()

at org.jivesoftware.openfire.pubsub.PubSubPersistenceManager.getLastPublishedItem( PubSubPersistenceManager.java:1544)

at org.jivesoftware.openfire.pubsub.LeafNode.getLastPublishedItem(LeafNode.java:36 3)

at org.jivesoftware.openfire.pep.PEPService.sendLastPublishedItems(PEPService.java :468)

at org.jivesoftware.openfire.pep.IQPEPHandler$GetNotificationsOnInitialPresence.ru n(IQPEPHandler.java:658)

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301 (Unknown Source)

at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknow n Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

org.jivesoftware.database.DbConnectionManager - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=DEFAULT’ at line 1

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=DEFAULT’ at line 1

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)

at com.mysql.jdbc.Connection.execSQL(Connection.java:3277)

at com.mysql.jdbc.Connection.unsetMaxRows(Connection.java:5867)

at com.mysql.jdbc.Statement.realClose(Statement.java:2070)

at com.mysql.jdbc.PreparedStatement.realClose(PreparedStatement.java:2204)

at com.mysql.jdbc.PreparedStatement.close(PreparedStatement.java:695)

at org.logicalcobwebs.proxool.AbstractProxyStatement.close(AbstractProxyStatement. java:115)

What do these errors and warnings mean and how to avoid them?

Thanks a lot in advance,

Regards

Tom

**
**