Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-15521

Maximum open cursors exceeded on Oracle

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.0-HF14, 7.3
    • Component/s: Core

      Description

      http://qa.nuxeo.org/jenkins/job/FT-nuxeo-master-cmis-dm-tomcat-multiosdb/Slave=MULTIDB_LINUX,dbprofile=oracle11g,jdk=openjdk-7-jdk/165/

      2014-10-06 15:13:44,711 WARN  [Nuxeo-Work-default-3] [org.apache.geronimo.connector.outbound.GeronimoConnectionEventListener] connectionErrorOccurred called with null
      java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
      ORA-01000: maximum open cursors exceeded
      ORA-01000: maximum open cursors exceeded
      
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
      	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:863)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1153)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1275)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576)
      	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3677)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
      	at org.tranql.connector.jdbc.PreparedStatementHandle.execute(PreparedStatementHandle.java:177)
      	at com.hp.hpl.jena.db.impl.SQLCache.executeSQL(SQLCache.java:720)
      	at com.hp.hpl.jena.db.impl.PSet_TripleStore_RDB.find(PSet_TripleStore_RDB.java:870)
      	at com.hp.hpl.jena.db.impl.SpecializedGraph_TripleStore.find(SpecializedGraph_TripleStore.java:142)
      	at com.hp.hpl.jena.db.impl.SpecializedGraphBase.find(SpecializedGraphBase.java:28)
      	at com.hp.hpl.jena.db.impl.DBPropGraph.findPropGraphByName(DBPropGraph.java:249)
      	at com.hp.hpl.jena.db.DBConnection.containsModel(DBConnection.java:198)
      	at org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:233)
      	at org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:176)
      	at org.nuxeo.ecm.platform.relations.jena.JenaGraph.query(JenaGraph.java:880)
      	at org.nuxeo.ecm.platform.annotations.service.AnnotationQuery.getAnnotationsForURIs(AnnotationQuery.java:68)
      	at org.nuxeo.ecm.platform.annotations.service.AnnotationsServiceImpl.queryAnnotations(AnnotationsServiceImpl.java:177)
      	at org.nuxeo.ecm.platform.annotations.proxy.AnnotationServiceProxy.queryAnnotations(AnnotationServiceProxy.java:190)
      	at org.nuxeo.ecm.platform.annotations.repository.service.DocumentVersionnedGraphManager.removeGraphFor(DocumentVersionnedGraphManager.java:143)
      	at org.nuxeo.ecm.platform.annotations.repository.service.DocumentVersionnedGraphManager.removeGraphFor(DocumentVersionnedGraphManager.java:132)
      	at org.nuxeo.ecm.platform.annotations.repository.service.DocumentVersionnedGraphManager.manage(DocumentVersionnedGraphManager.java:82)
      	at org.nuxeo.ecm.platform.annotations.repository.service.VersionEventListener.handleEvent(VersionEventListener.java:61)
      	at org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$ListenerWork.work(AsyncEventExecutor.java:172)
      	at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransaction(AbstractWork.java:351)
      	at org.nuxeo.ecm.core.work.AbstractWork.runWorkWithTransactionAndCheckExceptions(AbstractWork.java:312)
      	at org.nuxeo.ecm.core.work.AbstractWork.run(AbstractWork.java:280)
      	at org.nuxeo.ecm.core.work.WorkHolder.run(WorkHolder.java:52)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
      	at java.lang.Thread.run(Thread.java:745)
      

      http://qa.nuxeo.org/jenkins/job/FT-nuxeo-master-cmis-dm-tomcat-multiosdb/Slave=MULTIDB_LINUX,dbprofile=oracle11g,jdk=openjdk-7-jdk/165/
      http://qa.nuxeo.org/jenkins/job/FT-nuxeo-master-cmis-dm-tomcat-multiosdb/Slave=MULTIDB_LINUX,dbprofile=oracle11g,jdk=openjdk-7-jdk/165/artifact/nuxeo-distribution-dm/ftest/cmis/target/tomcat/log/server.log

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: