net.sf.hibernate.exception.GenericJDBCException: Could not execute query

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • We have a few issues with this re-indexing ... CONF-3977 (http://support.atlassian.com/browse/CSP-1450) and now this. Basically, when we re-index, we end up running out of cursors - get loads of the errors below: We had to set the number of open cursors limit (limit per connection) to the rather ridiculous value of 2000 before we could get a successful re-index completion. And when the re-index was completed, we had 5518 open cursors remaining... which kinda suggests some kind of leakage... So, I am not sure if the two are related... but I get the feeling they are... ======================================================= INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,561 ERROR [core.persistence.hibernate.AnyTypeHibernateObjectDao] Unable to get objects: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | net.sf.hibernate.exception.GenericJDBCException: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getObjects(HibernateEntityObjectQueue.java:84) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getNextObjects(HibernateEntityObjectQueue.java:54) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.getNextObject(BatchIndexingThread.java:150) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.run(BatchIndexingThread.java:40) INFO | jvm 1 | 2005/10/01 16:22:53 | at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source) INFO | jvm 1 | 2005/10/01 16:22:53 | at java.lang.Thread.run(Thread.java:534) INFO | jvm 1 | 2005/10/01 16:22:53 | Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:815) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.getLength(T4C8TTILob.java:260) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CConnection.length(T4CConnection.java:1896) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.sql.CLOB.length(CLOB.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at org.springframework.jdbc.support.lob.OracleLobHandler.getClobAsString(OracleLobHandler.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.util.BucketClobStringType.nullSafeGet(BucketClobStringType.java:120) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.CustomType.nullSafeGet(CustomType.java:92) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.hydrate(Loader.java:690) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRow(Loader.java:505) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQuery(Loader.java:285) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.list(Loader.java:1054) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) INFO | jvm 1 | 2005/10/01 16:22:53 | ... 8 more
    via by Nick Minutello,
  • We have a few issues with this re-indexing ... CONF-3977 (http://support.atlassian.com/browse/CSP-1450) and now this. Basically, when we re-index, we end up running out of cursors - get loads of the errors below: We had to set the number of open cursors limit (limit per connection) to the rather ridiculous value of 2000 before we could get a successful re-index completion. And when the re-index was completed, we had 5518 open cursors remaining... which kinda suggests some kind of leakage... So, I am not sure if the two are related... but I get the feeling they are... ======================================================= INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,560 ERROR [sf.hibernate.util.JDBCExceptionReporter] ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | 2005-10-01 16:22:53,561 ERROR [core.persistence.hibernate.AnyTypeHibernateObjectDao] Unable to get objects: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | net.sf.hibernate.exception.GenericJDBCException: Could not execute query INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getObjects(HibernateEntityObjectQueue.java:84) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getNextObjects(HibernateEntityObjectQueue.java:54) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.getNextObject(BatchIndexingThread.java:150) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.search.lucene.BatchIndexingThread.run(BatchIndexingThread.java:40) INFO | jvm 1 | 2005/10/01 16:22:53 | at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source) INFO | jvm 1 | 2005/10/01 16:22:53 | at java.lang.Thread.run(Thread.java:534) INFO | jvm 1 | 2005/10/01 16:22:53 | Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | ORA-01000: maximum open cursors exceeded INFO | jvm 1 | 2005/10/01 16:22:53 | INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:815) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4C8TTILob.getLength(T4C8TTILob.java:260) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.jdbc.driver.T4CConnection.length(T4CConnection.java:1896) INFO | jvm 1 | 2005/10/01 16:22:53 | at oracle.sql.CLOB.length(CLOB.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at org.springframework.jdbc.support.lob.OracleLobHandler.getClobAsString(OracleLobHandler.java:184) INFO | jvm 1 | 2005/10/01 16:22:53 | at bucket.util.BucketClobStringType.nullSafeGet(BucketClobStringType.java:120) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.CustomType.nullSafeGet(CustomType.java:92) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.hydrate(Loader.java:690) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRow(Loader.java:505) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQuery(Loader.java:285) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.loader.Loader.list(Loader.java:1054) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) INFO | jvm 1 | 2005/10/01 16:22:53 | at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) INFO | jvm 1 | 2005/10/01 16:22:53 | ... 8 more
    via by Nick Minutello,
  • Openbravo won't run.
    via openbravo by kchopein
    ,
  • amount field with decimals in hibernate
    via Stack Overflow by JNPW
    ,
  • Query bind parameter in Trees
    via by 475070,
    • net.sf.hibernate.exception.GenericJDBCException: Could not execute query at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) at net.sf.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:79) at net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1531) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1523) at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getObjects(HibernateEntityObjectQueue.java:84) at bucket.core.persistence.hibernate.HibernateEntityObjectQueue.getNextObjects(HibernateEntityObjectQueue.java:54) at bucket.search.lucene.BatchIndexingThread.getNextObject(BatchIndexingThread.java:150) at bucket.search.lucene.BatchIndexingThread.run(BatchIndexingThread.java:40) at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Thread.java:534) Caused by: java.sql.SQLException: ORA-01000: maximum open cursors exceeded ORA-01000: maximum open cursors exceeded at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272) at oracle.jdbc.driver.T4C8TTILob.receiveReply(T4C8TTILob.java:815) at oracle.jdbc.driver.T4C8TTILob.getLength(T4C8TTILob.java:260) at oracle.jdbc.driver.T4CConnection.length(T4CConnection.java:1896) at oracle.sql.CLOB.length(CLOB.java:184) at org.springframework.jdbc.support.lob.OracleLobHandler.getClobAsString(OracleLobHandler.java:184) at bucket.util.BucketClobStringType.nullSafeGet(BucketClobStringType.java:120) at net.sf.hibernate.type.CustomType.nullSafeGet(CustomType.java:92) at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:67) at net.sf.hibernate.loader.Loader.hydrate(Loader.java:690) at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:631) at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:590) at net.sf.hibernate.loader.Loader.getRow(Loader.java:505) at net.sf.hibernate.loader.Loader.getRowFromResultSet(Loader.java:218) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:285) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1054) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554) ... 8 more

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    76 more bugmates