Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-16093

HTTP error code 500 due to 'A lock could not be obtained due to a deadlock'

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: 5.5.1, 5.8.4, 6.0.1
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Environment:

      OS: CentOS Linux release 7.4.1708 (Core)
      Database Type : derby
      artifactory.running.mode: "PRO"
      artifactory.running.state: "Online"
      artifactory.version: "5.5.1"

      Description

      Artifactory sending HTTP error code 500 due to 'A lock could not be obtained due to a deadlock'

      System:
      OS: CentOS Linux release 7.4.1708 (Core)
      Database Type : derby
      artifactory.running.mode: "PRO"
      artifactory.running.state: "Online"
      artifactory.version: "5.5.1"

      Very often jenkins fails to deploy artifacts to artifactory with error code 500. We deploy ~10k artifacts a day (size of artifacts vary from kB to MB) and during rush hours usually fails.

      logs from artifactory.log:

      2018-03-09 21:56:02,099 [http-nio-8081-exec-140] [ERROR] (o.a.r.d.DbStoringRepoMixin:270) - Couldn't save resource, reason:
      java.lang.reflect.UndeclaredThrowableException: null
      at com.sun.proxy.$Proxy127.next(Unknown Source) ~[na:na]
      ...
      Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
      Lock : ROW, NODES, (5996,42)
      Waiting XID :

      {1851132700, S}

      , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132693, X}
      Lock : ROW, NODES, (5996,43)
      Waiting XID : {1851132693, S} , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132700, X}
      The selected victim is XID : 1851132700.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) ~[derby-10.11.1.1.jar:na]
      ... 111 common frames omitted
      Caused by: org.apache.derby.iapi.error.StandardException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
      Lock : ROW, NODES, (5996,42)
      Waiting XID : {1851132700, S}

      , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID :
      {1851132693, X}
      Lock : ROW, NODES, (5996,43)
      Waiting XID : {1851132693, S} , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132700, X}
      . The selected victim is XID : 1851132700.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      ... 113 common frames omitted

      2018-03-09 21:56:02,125 [http-nio-8081-exec-140] [ERROR] (o.a.w.s.RepoFilter :224) - Sending HTTP error code 500
      java.lang.reflect.UndeclaredThrowableException: null
      ...
      Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
      Lock : ROW, NODES, (5996,42)
      Waiting XID : {1851132700, S} , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132693, X}

      Lock : ROW, NODES, (5996,43)
      Waiting XID :
      {1851132693, S} , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132700, X}
      . The selected victim is XID : 1851132700.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) ~[derby-10.11.1.1.jar:na]
      ... 111 common frames omitted
      Caused by: org.apache.derby.iapi.error.StandardException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
      Lock : ROW, NODES, (5996,42)
      Waiting XID : {1851132700, S} , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132693, X}
      Lock : ROW, NODES, (5996,43)
      Waiting XID : {1851132693, S}

      , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID :
      {1851132700, X}
      . The selected victim is XID : 1851132700.
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.Deadlock.buildException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.ConcurrentLockSet.zeroDurationLockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.AbstractPool.zeroDurationlockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.services.locks.ConcurrentPool.zeroDurationlockObject(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.raw.xact.RowLocking2nohold.lockRecordForRead(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.heap.HeapController.lockRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3.lockRowOnPage(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScanRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.index.B2IRowLockingRR.lockScanRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source) ~[derby-10.11.1.1.jar:na]
      ... 113 common frames omitted

      logs from artifactory.log:
      2018-03-09 21:56:02,099 [http-nio-8081-exec-140] [ERROR] (o.a.r.d.DbStoringRepoMixin:270) - Couldn't save resource, reason
      2018-03-09 21:56:02,125 [http-nio-8081-exec-140] [ERROR] (o.a.w.s.RepoFilter :224) - Sending HTTP error code 500
      details below:

      2018-03-09 21:56:02,099 [http-nio-8081-exec-140] [ERROR] (o.a.r.d.DbStoringRepoMixin:270) - Couldn't save resource, reason:
      java.lang.reflect.UndeclaredThrowableException: null
      at com.sun.proxy.$Proxy127.next(Unknown Source) ~[na:na]
      at org.artifactory.storage.db.fs.dao.NodesDao.getChildren(NodesDao.java:227) ~[artifactory-storage-db-5.5.1.jar:na]
      at org.artifactory.storage.db.fs.service.FileServiceImpl.loadChildren(FileServiceImpl.java:263) ~[artifactory-storage-db-5.5.1.jar:na]
      at sun.reflect.GeneratedMethodAccessor237.invoke(Unknown Source) ~[na:na]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at com.sun.proxy.$Proxy161.loadChildren(Unknown Source) ~[na:na]
      at org.artifactory.storage.fs.tree.FolderNode.getChildrenItemNode(FolderNode.java:74) ~[artifactory-storage-common-5.5.1.jar:na]
      at org.artifactory.storage.fs.tree.FolderNode.getChildren(FolderNode.java:56) ~[artifactory-storage-common-5.5.1.jar:na]
      at org.artifactory.maven.MavenMetadataCalculator.folderContainsPoms(MavenMetadataCalculator.java:420) ~[artifactory-core-5.5.1.jar:na]
      at org.artifactory.maven.MavenMetadataCalculator.createSnapshotsMetadata(MavenMetadataCalculator.java:208) ~[artifactory-core-5.5.1.jar:na]
      at org.artifactory.maven.MavenMetadataCalculator.calculateAndSet(MavenMetadataCalculator.java:177) ~[artifactory-core-5.5.1.jar:na]
      at org.artifactory.maven.MavenMetadataCalculator.calculate(MavenMetadataCalculator.java:152) ~[artifactory-core-5.5.1.jar:na]
      at org.artifactory.maven.MavenMetadataServiceImpl.calculateMavenMetadata(MavenMetadataServiceImpl.java:81) ~[artifactory-core-5.5.1.jar:na]
      at sun.reflect.GeneratedMethodAccessor266.invoke(Unknown Source) ~[na:na]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at com.sun.proxy.$Proxy158.calculateMavenMetadata(Unknown Source) ~[na:na]
      at org.artifactory.repo.interceptor.MavenMetadataCalculationInterceptor.afterCreate(MavenMetadataCalculationInterceptor.java:72) ~[artifactory-core-5.5.1.jar:na]
      at org.artifactory.repo.interceptor.storage.StorageInterceptorsImpl.afterCreate(StorageInterceptorsImpl.java:65) ~[artifactory-core-5.5.1.jar:na]
      at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source) ~[na:na]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at com.sun.proxy.$Proxy180.afterCreate(Unknown Source) ~[na:na]
      at org.artifactory.repo.db.DbStoringRepoMixin.invokeAfterCreateInterceptors(DbStoringRepoMixin.java:391) ~[artifactory-core-5.5.1.jar:na]
      at org.artifactory.repo.db.DbStoringRepoMixin.saveResource(DbStoringRepoMixin.java:230) ~[artifactory-core-5.5.1.jar:na]
      at org.artifactory.repo.db.DbLocalRepo.saveResource(DbLocalRepo.java:158) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.repo.service.RepositoryServiceImpl.saveResourceInTransaction(RepositoryServiceImpl.java:1779) [artifactory-core-5.5.1.jar:na]
      at sun.reflect.GeneratedMethodAccessor177.invoke(Unknown Source) ~[na:na]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) [spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) [spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) [spring-tx-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at com.sun.proxy.$Proxy157.saveResourceInTransaction(Unknown Source) [na:na]
      at org.artifactory.repo.service.RepositoryServiceImpl.saveResource(RepositoryServiceImpl.java:1749) [artifactory-core-5.5.1.jar:na]
      at sun.reflect.GeneratedMethodAccessor203.invoke(Unknown Source) ~[na:na]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:201) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at com.sun.proxy.$Proxy157.saveResource(Unknown Source) [na:na]
      at org.artifactory.engine.UploadServiceImpl.uploadItemWithContent(UploadServiceImpl.java:499) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.engine.UploadServiceImpl.uploadItemWithProvidedContent(UploadServiceImpl.java:484) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.engine.UploadServiceImpl.uploadItem(UploadServiceImpl.java:387) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.engine.UploadServiceImpl.uploadFile(UploadServiceImpl.java:377) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.engine.UploadServiceImpl.uploadArtifact(UploadServiceImpl.java:358) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.engine.UploadServiceImpl.adjustResponseAndUpload(UploadServiceImpl.java:197) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.engine.UploadServiceImpl.validateRequestAndUpload(UploadServiceImpl.java:165) [artifactory-core-5.5.1.jar:na]
      at org.artifactory.engine.UploadServiceImpl.upload(UploadServiceImpl.java:128) [artifactory-core-5.5.1.jar:na]
      at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source) ~[na:na]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
      at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.artifactory.request.aop.RequestAdvice.invoke(RequestAdvice.java:67) [artifactory-core-5.5.1.jar:na]
      at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207) [spring-aop-4.1.5.RELEASE.jar:4.1.5.RELEASE]
      at com.sun.proxy.$Proxy177.upload(Unknown Source) [na:na]
      at org.artifactory.webapp.servlet.RepoFilter.doUpload(RepoFilter.java:215) [artifactory-web-application-5.5.1.jar:na]
      at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:164) [artifactory-web-application-5.5.1.jar:na]
      at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:93) [artifactory-web-application-5.5.1.jar:na]
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [catalina.jar:8.0.41]
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.41]
      at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:399) [artifactory-web-application-5.5.1.jar:na]
      at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:275) [artifactory-web-application-5.5.1.jar:na]
      at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:205) [artifactory-web-application-5.5.1.jar:na]
      at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:165) [artifactory-web-application-5.5.1.jar:na]
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [catalina.jar:8.0.41]
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.41]
      at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:67) [artifactory-web-application-5.5.1.jar:na]
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [catalina.jar:8.0.41]
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.41]
      at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164) [spring-session-1.2.2.RELEASE.jar:na]
      at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80) [spring-session-1.2.2.RELEASE.jar:na]
      at org.artifactory.webapp.servlet.SessionFilter.doFilter(SessionFilter.java:62) [artifactory-web-application-5.5.1.jar:na]
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [catalina.jar:8.0.41]
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.41]
      at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:116) [artifactory-web-application-5.5.1.jar:na]
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [catalina.jar:8.0.41]
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.41]
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) [catalina.jar:8.0.41]
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) [catalina.jar:8.0.41]
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) [catalina.jar:8.0.41]
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [catalina.jar:8.0.41]
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [catalina.jar:8.0.41]
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:509) [catalina.jar:8.0.41]
      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1104) [tomcat-coyote.jar:8.0.41]
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) [tomcat-coyote.jar:8.0.41]
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1524) [tomcat-coyote.jar:8.0.41]
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1480) [tomcat-coyote.jar:8.0.41]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_161]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_161]
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.0.41]
      at java.lang.Thread.run(Thread.java:748) [na:1.8.0_161]
      Caused by: java.lang.reflect.InvocationTargetException: null
      at sun.reflect.GeneratedMethodAccessor93.invoke(Unknown Source) ~[na:na]
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_161]
      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_161]
      at org.artifactory.storage.db.util.ResultSetWrapper.invoke(ResultSetWrapper.java:75) ~[artifactory-storage-db-5.5.1.jar:na]
      ... 107 common frames omitted
      Caused by: java.sql.SQLTransactionRollbackException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
      Lock : ROW, NODES, (5996,42)
      Waiting XID : {1851132700, S} , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132693, X}
      Lock : ROW, NODES, (5996,43)
      Waiting XID : {1851132693, S} , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID : {1851132700, X}

      The selected victim is XID : 1851132700.
      at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source) ~[derby-10.11.1.1.jar:na]
      at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source) ~[derby-10.11.1.1.jar:na]
      ... 111 common frames omitted
      Caused by: org.apache.derby.iapi.error.StandardException: A lock could not be obtained due to a deadlock, cycle of locks and waiters is:
      Lock : ROW, NODES, (5996,42)
      Waiting XID :
      {1851132700, S}

      , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID :

      {1851132693, X}

      Lock : ROW, NODES, (5996,43)
      Waiting XID :

      {1851132693, S}

      , APP, SELECT * FROM nodes WHERE repo = ? AND node_path = ? AND depth = ?
      Granted XID :

      {1851132700, X}

      . The selected victim is XID : 1851132700.
      ...

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            t3d Tomasz Długosz
            Votes:
            2 Vote for this issue
            Watchers:
            9 Start watching this issue

              Dates

              Created:
              Updated: