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
**
**