java.sql.SQLTransactionRollbackException

A lock could not be obtained within the time requested

Solutions on the web74

  • via JFrog JIRA by Frederic Simon, 10 months ago
    A lock could not be obtained within the time requested
  • via JFrog JIRA by Eran Blumental, 10 months ago
    A lock could not be obtained within the time requested
  • via symmetricds by psi_teck
    , 1 year ago
    A lock could not be obtained within the time requested
  • Stack trace

    • java.sql.SQLTransactionRollbackException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)[commons-dbcp-1.2.2.jar:1.2.2] at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)[commons-dbcp-1.2.2.jar:1.2.2] at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:450)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:371)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:348)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:344)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:488)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:344)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.util.db.ArtifactoryConnectionHelper.select(ArtifactoryConnectionHelper.java:64)[artifactory-jcr-storage-2.5.1.1.jar:2.2.8b] at org.artifactory.jcr.jackrabbit.ArtifactoryDataStore.insertRecordInDb(ArtifactoryDataStore.java:266)[artifactory-jcr-storage-2.5.1.1.jar:na] at org.artifactory.jcr.jackrabbit.ArtifactoryDataStore.addRecord(ArtifactoryDataStore.java:232)[artifactory-jcr-storage-2.5.1.1.jar:na] at org.apache.jackrabbit.core.value.BLOBInDataStore.getInstance(BLOBInDataStore.java:124)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.value.InternalValue.getBLOBFileValue(InternalValue.java:619)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.value.InternalValue.create(InternalValue.java:369)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.value.InternalValueFactory.create(InternalValueFactory.java:94)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.apache.jackrabbit.core.value.ValueFactoryImpl.createBinary(ValueFactoryImpl.java:74)[jackrabbit-core-jfrog-2.2.8b.jar:2.2.8b] at org.artifactory.jcr.fs.JcrFile.fillJcrData(JcrFile.java:584)[artifactory-jcr-storage-2.5.1.1.jar:na] at org.artifactory.jcr.fs.JcrFile.setResourceNode(JcrFile.java:516)[artifactory-jcr-storage-2.5.1.1.jar:na] at org.artifactory.jcr.fs.JcrFile.fillData(JcrFile.java:144)[artifactory-jcr-storage-2.5.1.1.jar:na] at org.artifactory.repo.jcr.StoringRepoMixin.fillJcrFileData(StoringRepoMixin.java:770)[artifactory-core-2.5.1.1.jar:na] at org.artifactory.repo.jcr.StoringRepoMixin.saveResource(StoringRepoMixin.java:613)[artifactory-core-2.5.1.1.jar:na] at org.artifactory.repo.jcr.JcrRepoBase.saveResource(JcrRepoBase.java:409)[artifactory-core-2.5.1.1.jar:na] at org.artifactory.engine.UploadServiceImpl.doProcess(UploadServiceImpl.java:298)[artifactory-core-2.5.1.1.jar:na] at sun.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:1.7.0_04] at java.lang.reflect.Method.invoke(Unknown Source)[na:1.7.0_04] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.artifactory.request.aop.RequestAdvice.invoke(RequestAdvice.java:68)[artifactory-core-2.5.1.1.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)[spring-tx-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:121)[artifactory-jcr-storage-2.5.1.1.jar:na] at org.artifactory.jcr.lock.aop.LockingAdvice.invoke(LockingAdvice.java:49)[artifactory-jcr-storage-2.5.1.1.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at $Proxy38.doProcess(Unknown Source)[na:na] at org.artifactory.engine.UploadServiceImpl.process(UploadServiceImpl.java:178)[artifactory-core-2.5.1.1.jar:na] at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source)[na:na] at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)[na:1.7.0_04] at java.lang.reflect.Method.invoke(Unknown Source)[na:1.7.0_04] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)[spring-aop-3.0.6.RELEASE.jar:3.0.6.RELEASE] at $Proxy38.process(Unknown Source)[na:na] at org.artifactory.webapp.servlet.RepoFilter.doUpload(RepoFilter.java:182)[artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:133)[artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:85)[artifactory-web-application-2.5.1.1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190)[jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:276)[artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:197)[artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:179)[artifactory-web-application-2.5.1.1.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:147)[artifactory-web-application-2.5.1.1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190)[jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:55)[artifactory-web-application-2.5.1.1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190)[jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:68)[artifactory-web-application-2.5.1.1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190)[jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:424)[jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:494)[jetty-security-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:229)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:931)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:361)[jetty-servlet-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:245)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.Server.handle(Server.java:337)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1020)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:775)[jetty-http-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:222)[jetty-http-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:417)[jetty-server-7.0.2.v20100331.jar:7.0.2.v20100331] at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:474)[jetty-io-7.0.2.v20100331.jar:7.0.2.v20100331] at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)[na:1.7.0_04] at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)[na:1.7.0_04] at java.lang.Thread.run(Unknown Source)[na:1.7.0_04] Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: A lock could not be obtained within the time requested at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)[derby-10.8.2.2.jar:na] ... 88 more Caused by: org.apache.derby.iapi.error.StandardException: A lock could not be obtained within the time requested at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.raw.xact.RowLocking2.lockContainer(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.raw.data.BaseContainerHandle.useContainer(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.heap.Heap.open(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.RAMTransaction.openCompiledConglomerate(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.btree.index.B2IForwardScan.init(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.btree.index.B2I.openScan(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.RAMTransaction.openScan(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.store.access.RAMTransaction.openCompiledScan(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.sql.execute.TableScanResultSet.openScanController(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.sql.execute.TableScanResultSet.openCore(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.openCore(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.openCore(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.open(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)[derby-10.8.2.2.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)[derby-10.8.2.2.jar:na] ... 82 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    5 times, 3 months ago
    Once, 5 months ago
    Unknown user
    Once, 1 year ago