Details
-
Bug
-
Resolution: Won't Fix
-
Major
-
None
-
2.6
-
software platform
-
SQLException PoolablePreparedStatement xwikiproperties xwikiobjects NOT SPECIFIED
-
Unknown
-
N/A
-
N/A
-
Description
Update (May 26, 2011):
Ok, this issue is becoming a problem. I can't look through my tomcat logs because they are filled with this exception over and over again. With a clean log file, Tomcat startup, and accessing one page generates a 1MB log file. I've tried modifying my log4j.properties file to log the exception somewhere else, but I'm unable to do so. I have searched and searched for a reason for this and come up with nothing. Please help.
Original:
I have just recently installed xwiki 2.6, so this is essentially about a fresh install. I'm running Tomcat 5.5 and MySQL Server 5.1. I'm getting exceptions attempting to update xwikiproperties and xwikiobjects being thrown over and over showing up in Tomcat's log, but I'm not seeing any errors being shown to the user while using the wiki. In other words, these exceptions are being thrown, but the wiki appears to be working correctly from the users standpoint. The following are a couple of the exceptions.
Example 1:
java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement with address: "com.mysql.jdbc.PreparedStatement@19bc376: update xwikiobjects set XWO_NUMBER=** NOT SPECIFIED *, XWO_NAME=* NOT SPECIFIED *, XWO_CLASSNAME=* NOT SPECIFIED *, XWO_GUID=* NOT SPECIFIED ** where XWO_ID=** NOT SPECIFIED **" is closed.
at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
at org.apache.commons.dbcp.DelegatingStatement.clearBatch(DelegatingStatement.java:294)
at org.apache.commons.dbcp.PoolablePreparedStatement.clearBatch(PoolablePreparedStatement.java:86)
at org.apache.commons.dbcp.PoolablePreparedStatement.passivate(PoolablePreparedStatement.java:134)
at org.apache.commons.dbcp.PoolingConnection.passivateObject(PoolingConnection.java:350)
at org.apache.commons.pool.impl.GenericKeyedObjectPool.addObjectToPool(GenericKeyedObjectPool.java:1570)
at org.apache.commons.pool.impl.GenericKeyedObjectPool.returnObject(GenericKeyedObjectPool.java:1526)
at org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2359)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:853)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:824)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:643)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:181)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:175)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1431)
at com.xpn.xwiki.plugin.watchlist.WatchListJob.setPreviousFireTime(WatchListJob.java:170)
at com.xpn.xwiki.plugin.watchlist.WatchListJob.executeJob(WatchListJob.java:240)
at com.xpn.xwiki.plugin.scheduler.AbstractJob.execute(AbstractJob.java:75)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)
Example 2:
java.sql.SQLException: org.apache.commons.dbcp.PoolablePreparedStatement with address: "com.mysql.jdbc.PreparedStatement@12407f7: update xwikiproperties set XWP_CLASSTYPE=** NOT SPECIFIED ** where XWP_ID=** NOT SPECIFIED ** and XWP_NAME=** NOT SPECIFIED **" is closed.
at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:137)
at org.apache.commons.dbcp.DelegatingStatement.clearBatch(DelegatingStatement.java:294)
at org.apache.commons.dbcp.PoolablePreparedStatement.clearBatch(PoolablePreparedStatement.java:86)
at org.apache.commons.dbcp.PoolablePreparedStatement.passivate(PoolablePreparedStatement.java:134)
at org.apache.commons.dbcp.PoolingConnection.passivateObject(PoolingConnection.java:350)
at org.apache.commons.pool.impl.GenericKeyedObjectPool.addObjectToPool(GenericKeyedObjectPool.java:1570)
at org.apache.commons.pool.impl.GenericKeyedObjectPool.returnObject(GenericKeyedObjectPool.java:1526)
at org.apache.commons.dbcp.PoolablePreparedStatement.close(PoolablePreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
at org.apache.commons.dbcp.DelegatingStatement.close(DelegatingStatement.java:168)
at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:269)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:249)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2367)
at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312)
at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612)
at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:853)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:824)
at com.xpn.xwiki.store.XWikiHibernateStore.saveXWikiDoc(XWikiHibernateStore.java:643)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:181)
at com.xpn.xwiki.store.XWikiCacheStore.saveXWikiDoc(XWikiCacheStore.java:175)
at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1431)
at com.xpn.xwiki.plugin.watchlist.WatchListJ