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

Pentaho BI Platform Tracking | David Fombella | 4 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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.

    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