junit.framework.ComparisonFailure: isolation levels: 4 4 expected:<[23505]> but was:<[40XL1]>

db-derby-dev | Myrna van Lunteren (JIRA) | 3 years ago
  1. 0

    [jira] [Commented] (DERBY-6437) testLockingWithRollback failing on trunk with AssertionFailedError - isolation levels: 4 2

    db-derby-dev | 3 years ago | Myrna van Lunteren (JIRA)
    junit.framework.ComparisonFailure: isolation levels: 4 4 expected:<[23505]> but was:<[40XL1]>
  2. 0

    [jira] [Created] (DERBY-5563) UniqueConstraintMultiThreadedTest fails intermittently to due to lock timeout

    db-derby-dev | 5 years ago | Dag H. Wanvik (Created) (JIRA)
    junit.framework.ComparisonFailure: isolation levels: 1 2 expected:<[23505]> but was:<[40XL1]>
  3. 0

    [jira] [Commented] (DERBY-5563) UniqueConstraintMultiThreadedTest fails intermittently to due to lock timeout

    db-derby-dev | 5 years ago | Dag H. Wanvik (Commented) (JIRA)
    junit.framework.ComparisonFailure: isolation levels: 1 2 expected:<[23505]> but was:<[40XL1]>
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    After a period of usage, Fedora 3.2.1 becomes sluggish and unpredictable. Ordinary requests such as http://127.0.0.1:8080/fedora/objects/new?label=test&ownerID=fedoraAdmin&state=A Cause a StorageDeviceException, deriving from derby returning "ERROR 40XL1: A lock could not be obtained within the time requested". See stack trace below. There is still storage space on the device. The errors only occur after I've used the image for a while (usually when I get to around 550 objects). I am mostly running the test suites for active-fedora and ruby-fedora against it. Fedora Spits out this error (after Fedora hangs for about a minute): Jul 16, 2009 11:31:18 AM com.sun.jersey.server.impl.application.WebApplicationImpl onException SEVERE: Internal server error javax.ws.rs.WebApplicationException: fedora.server.errors.StorageDeviceException: Error attempting FieldSearch update of changeme:525 at fedora.server.rest.BaseRestResource.handleException(BaseRestResource.java:122) at fedora.server.rest.FedoraObjectResource.createObject(FedoraObjectResource.java:416) at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.jersey.server.impl.model.method.dispatch.EntityParamDispatchProvider$ResponseOutInvoker._dispatch(EntityParamDispatchProvider.java:157) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:67) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:124) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:71) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:111) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:63) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:555) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:514) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:505) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:359) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterRestApiFlash.doFilter(FilterRestApiFlash.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:613) Caused by: fedora.server.errors.StorageDeviceException: Error attempting FieldSearch update of changeme:525 at fedora.server.search.FieldSearchSQLImpl.update(FieldSearchSQLImpl.java:256) at fedora.server.search.FieldSearchSQLModule.update(FieldSearchSQLModule.java:151) at fedora.server.storage.DefaultDOManager.doCommit(DefaultDOManager.java:1413) at fedora.server.storage.SimpleDOWriter.commit(SimpleDOWriter.java:443) at fedora.server.management.DefaultManagement.ingest(DefaultManagement.java:152) at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at fedora.server.messaging.NotificationInvocationHandler.invoke(NotificationInvocationHandler.java:70) at $Proxy0.ingest(Unknown Source) at fedora.server.management.ManagementModule.ingest(ManagementModule.java:338) at fedora.server.rest.FedoraObjectResource.createObject(FedoraObjectResource.java:411) ... 44 more Caused by: java.sql.SQLException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at fedora.server.utilities.SQLUtilityImpl.i_addRow(SQLUtilityImpl.java:264) at fedora.server.utilities.SQLUtilityImpl.i_replaceInto(SQLUtilityImpl.java:144) at fedora.server.utilities.SQLUtility.replaceInto(SQLUtility.java:91) at fedora.server.search.FieldSearchSQLImpl.update(FieldSearchSQLImpl.java:240) ... 55 more Caused by: ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source) at org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(Unknown Source) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(Unknown Source) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockScan(Unknown Source) at org.apache.derby.impl.store.access.btree.LeafControlRow.growRoot(Unknown Source) at org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(Unknown Source) at org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(Unknown Source) at org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown Source) at org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source) at org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 63 more

    Sakai JIRA | 8 years ago | Matt Zumwalt
    javax.ws.rs.WebApplicationException: fedora.server.errors.StorageDeviceException: Error attempting FieldSearch update of changeme:525
  6. 0

    After a period of usage, Fedora 3.2.1 becomes sluggish and unpredictable. Ordinary requests such as http://127.0.0.1:8080/fedora/objects/new?label=test&ownerID=fedoraAdmin&state=A Cause a StorageDeviceException, deriving from derby returning "ERROR 40XL1: A lock could not be obtained within the time requested". See stack trace below. There is still storage space on the device. The errors only occur after I've used the image for a while (usually when I get to around 550 objects). I am mostly running the test suites for active-fedora and ruby-fedora against it. Fedora Spits out this error (after Fedora hangs for about a minute): Jul 16, 2009 11:31:18 AM com.sun.jersey.server.impl.application.WebApplicationImpl onException SEVERE: Internal server error javax.ws.rs.WebApplicationException: fedora.server.errors.StorageDeviceException: Error attempting FieldSearch update of changeme:525 at fedora.server.rest.BaseRestResource.handleException(BaseRestResource.java:122) at fedora.server.rest.FedoraObjectResource.createObject(FedoraObjectResource.java:416) at sun.reflect.GeneratedMethodAccessor75.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at com.sun.jersey.server.impl.model.method.dispatch.EntityParamDispatchProvider$ResponseOutInvoker._dispatch(EntityParamDispatchProvider.java:157) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:67) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:124) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:71) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:111) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:63) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:555) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:514) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:505) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:359) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterRestApiFlash.doFilter(FilterRestApiFlash.java:78) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at fedora.server.security.servletfilters.FilterSetup.doFilter(FilterSetup.java:234) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:613) Caused by: fedora.server.errors.StorageDeviceException: Error attempting FieldSearch update of changeme:525 at fedora.server.search.FieldSearchSQLImpl.update(FieldSearchSQLImpl.java:256) at fedora.server.search.FieldSearchSQLModule.update(FieldSearchSQLModule.java:151) at fedora.server.storage.DefaultDOManager.doCommit(DefaultDOManager.java:1413) at fedora.server.storage.SimpleDOWriter.commit(SimpleDOWriter.java:443) at fedora.server.management.DefaultManagement.ingest(DefaultManagement.java:152) at sun.reflect.GeneratedMethodAccessor78.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at fedora.server.messaging.NotificationInvocationHandler.invoke(NotificationInvocationHandler.java:70) at $Proxy0.ingest(Unknown Source) at fedora.server.management.ManagementModule.ingest(ManagementModule.java:338) at fedora.server.rest.FedoraObjectResource.createObject(FedoraObjectResource.java:411) ... 44 more Caused by: java.sql.SQLException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:101) at fedora.server.utilities.SQLUtilityImpl.i_addRow(SQLUtilityImpl.java:264) at fedora.server.utilities.SQLUtilityImpl.i_replaceInto(SQLUtilityImpl.java:144) at fedora.server.utilities.SQLUtility.replaceInto(SQLUtility.java:91) at fedora.server.search.FieldSearchSQLImpl.update(FieldSearchSQLImpl.java:240) ... 55 more Caused by: ERROR 40XL1: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source) at org.apache.derby.impl.store.raw.xact.RowLocking3.lockRecordForWrite(Unknown Source) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(Unknown Source) at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockScan(Unknown Source) at org.apache.derby.impl.store.access.btree.LeafControlRow.growRoot(Unknown Source) at org.apache.derby.impl.store.access.btree.LeafControlRow.splitFor(Unknown Source) at org.apache.derby.impl.store.access.btree.BTreeController.start_xact_and_dosplit(Unknown Source) at org.apache.derby.impl.store.access.btree.BTreeController.doIns(Unknown Source) at org.apache.derby.impl.store.access.btree.BTreeController.insert(Unknown Source) at org.apache.derby.impl.store.access.btree.index.B2IController.insert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source) at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) ... 63 more

    Sakai JIRA | 8 years ago | Matt Zumwalt
    javax.ws.rs.WebApplicationException: fedora.server.errors.StorageDeviceException: Error attempting FieldSearch update of changeme:525

    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

      A lock could not be obtained within the time requested

      at org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA()
    2. Derby
      EmbedStatement.executeUpdate
      1. org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(Unknown Source)
      2. org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
      3. org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
      4. org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
      5. org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
      6. org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
      7. org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
      8. org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
      9. org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
      10. org.apache.derby.impl.jdbc.EmbedStatement.executeLargeUpdate(Unknown Source)
      11. org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
      11 frames
    3. org.apache.derbyTesting
      DBOperations.run
      1. org.apache.derbyTesting.functionTests.tests.lang.DBOperations.insert(DBOperations.java:61)
      2. org.apache.derbyTesting.functionTests.tests.lang.DBOperations.run(DBOperations.java:103)
      2 frames
    4. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:761)
      1 frame