Details
-
Bug
-
Resolution: Fixed
-
Highest
-
1.4.4
-
None
Description
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