java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is closed.

Pentaho BI Platform Tracking | David Fombella | 3 years ago
  1. 0
  2. 0
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Customer reports seeing the following in the log: 2012-01-03 11:25:53,578 DEBUG [mondrian.server.Execution] mondrian.olap.MondrianException: Mondrian Error:An exception was encountered while trying to cleanup an execution context. A statement failed to cancel gracefully. Locus was : "Error while loading segment". java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is closed. at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136) at org.apache.commons.dbcp.DelegatingStatement.cancel(DelegatingStatement.java:249) at mondrian.server.Execution.cleanStatements(Execution.java:147) at mondrian.server.Execution.end(Execution.java:168) at mondrian.server.StatementImpl.end(StatementImpl.java:98) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:644) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Note that "A statement failed to cancel gracefully" occurs when an MDX statement times out, and Mondrian tries to cancel the running SQL statements. In this case, it looks as if the statements have already finished, but Mondrian still tries to cancel them. I think this bug is harmless, but it points to problems in the SQL statement lifecycle management.

    Pentaho BI Platform Tracking | 5 years ago | Julian Hyde
    java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is closed.
  5. 0

    Customer reports seeing the following in the log: 2012-01-03 11:25:53,578 DEBUG [mondrian.server.Execution] mondrian.olap.MondrianException: Mondrian Error:An exception was encountered while trying to cleanup an execution context. A statement failed to cancel gracefully. Locus was : "Error while loading segment". java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is closed. at org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136) at org.apache.commons.dbcp.DelegatingStatement.cancel(DelegatingStatement.java:249) at mondrian.server.Execution.cleanStatements(Execution.java:147) at mondrian.server.Execution.end(Execution.java:168) at mondrian.server.StatementImpl.end(StatementImpl.java:98) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:644) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Note that "A statement failed to cancel gracefully" occurs when an MDX statement times out, and Mondrian tries to cancel the running SQL statements. In this case, it looks as if the statements have already finished, but Mondrian still tries to cancel them. I think this bug is harmless, but it points to problems in the SQL statement lifecycle management.

    Pentaho BI Platform Tracking | 5 years ago | Julian Hyde
    java.sql.SQLException: org.apache.commons.dbcp.DelegatingStatement is closed.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      org.apache.commons.dbcp.DelegatingStatement is closed.

      at org.apache.commons.dbcp.DelegatingStatement.checkOpen()
    2. Commons DBCP
      DelegatingStatement.cancel
      1. org.apache.commons.dbcp.DelegatingStatement.checkOpen(DelegatingStatement.java:136)
      2. org.apache.commons.dbcp.DelegatingStatement.cancel(DelegatingStatement.java:249)
      2 frames
    3. mondrian.server
      StatementImpl.end
      1. mondrian.server.Execution.cleanStatements(Execution.java:147)
      2. mondrian.server.Execution.end(Execution.java:168)
      3. mondrian.server.StatementImpl.end(StatementImpl.java:98)
      3 frames
    4. mondrian.rolap
      RolapConnection$1.call
      1. mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:644)
      2. mondrian.rolap.RolapConnection.access$000(RolapConnection.java:52)
      3. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:586)
      4. mondrian.rolap.RolapConnection$1.call(RolapConnection.java:585)
      4 frames
    5. Java RT
      Thread.run
      1. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
      2. java.util.concurrent.FutureTask.run(Unknown Source)
      3. java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      5. java.lang.Thread.run(Unknown Source)
      5 frames