Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-6128

PoolablePreparedStatement exception

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Fix
    • Major
    • None
    • 2.6
    • Storage
    • 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

      Attachments

        Activity

          People

            softec Denis Gervalle
            lscardin Leonard Scardino
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: