org.artifactory.storage.StorageException

Could not insert build org.jfrog.build.api.Build@5ccf3b3d

Solutions on the web22

  • via JFrog JIRA by Michal Reuven, 1 year ago
    Could not insert build org.jfrog.build.api.Build@5ccf3b3d
  • via JFrog JIRA by Michal Reuven, 10 months ago
    Could not insert build org.jfrog.build.api.Build@5ccf3b3d
  • via JFrog JIRA by David Slater, 1 year ago
    Could not insert build org.jfrog.build.api.Build@336ab41c
  • Stack trace

    • org.artifactory.storage.StorageException: Could not insert build org.jfrog.build.api.Build@5ccf3b3d at org.artifactory.storage.db.build.service.BuildStoreServiceImpl.addBuild(BuildStoreServiceImpl.java:135)[artifactory-storage-db-3.4.2.jar:na] at org.artifactory.build.BuildServiceImpl.addBuild(BuildServiceImpl.java:175)[artifactory-core-3.4.2.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_51] at java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_51] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)[spring-aop-4.0.5.RELEASE.jar:4.0.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)[spring-aop-4.0.5.RELEASE.jar:4.0.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.0.5.RELEASE.jar:4.0.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)[spring-tx-4.0.5.RELEASE.jar:4.0.5.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)[spring-tx-4.0.5.RELEASE.jar:4.0.5.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)[spring-tx-4.0.5.RELEASE.jar:4.0.5.RELEASE] at org.artifactory.storage.fs.lock.aop.LockingAdvice.invoke(LockingAdvice.java:64)[artifactory-storage-common-3.4.2.jar:na] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.0.5.RELEASE.jar:4.0.5.RELEASE] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)[spring-aop-4.0.5.RELEASE.jar:4.0.5.RELEASE] at com.sun.proxy.$Proxy62.addBuild(Unknown Source)[na:na] at org.artifactory.rest.resource.ci.BuildResource.addBuild(BuildResource.java:295)[artifactory-rest-3.4.2.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_51] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_51] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_51] at java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_51] at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$VoidOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:167)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:288)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1483)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1414)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1363)[jersey-server-1.12.jar:1.12] at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1353)[jersey-server-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:414)[jersey-servlet-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:537)[jersey-servlet-1.12.jar:1.12] at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:708)[jersey-servlet-1.12.jar:1.12] at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)[servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)[catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.39] at org.artifactory.webapp.servlet.RepoFilter.execute(RepoFilter.java:173)[artifactory-web-application-3.4.2.jar:na] at org.artifactory.webapp.servlet.RepoFilter.doFilter(RepoFilter.java:85)[artifactory-web-application-3.4.2.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.39] at org.artifactory.webapp.servlet.AccessFilter.useAuthentication(AccessFilter.java:314)[artifactory-web-application-3.4.2.jar:na] at org.artifactory.webapp.servlet.AccessFilter.authenticateAndExecute(AccessFilter.java:218)[artifactory-web-application-3.4.2.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilterInternal(AccessFilter.java:184)[artifactory-web-application-3.4.2.jar:na] at org.artifactory.webapp.servlet.AccessFilter.doFilter(AccessFilter.java:152)[artifactory-web-application-3.4.2.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.39] at org.artifactory.webapp.servlet.RequestFilter.doFilter(RequestFilter.java:62)[artifactory-web-application-3.4.2.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.39] at org.artifactory.webapp.servlet.ArtifactoryFilter.doFilter(ArtifactoryFilter.java:92)[artifactory-web-application-3.4.2.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.39] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)[catalina.jar:7.0.39] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)[catalina.jar:7.0.39] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)[catalina.jar:7.0.39] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)[catalina.jar:7.0.39] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1009)[tomcat-coyote.jar:7.0.39] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)[tomcat-coyote.jar:7.0.39] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)[tomcat-coyote.jar:7.0.39] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)[na:1.7.0_51] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)[na:1.7.0_51] at java.lang.Thread.run(Thread.java:744)[na:1.7.0_51] Caused by: java.sql.SQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'BUILDS_NAME_NUMBER_DATE_IDX' defined on 'BUILDS'. at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeUpdate(Unknown Source)[derby-10.9.1.0.jar:na] at org.artifactory.storage.db.util.JdbcHelper.executeUpdate(JdbcHelper.java:131)[artifactory-storage-db-3.4.2.jar:na] at org.artifactory.storage.db.build.dao.BuildsDao.createBuild(BuildsDao.java:67)[artifactory-storage-db-3.4.2.jar:na] at org.artifactory.storage.db.build.service.BuildStoreServiceImpl.addBuild(BuildStoreServiceImpl.java:132)[artifactory-storage-db-3.4.2.jar:na] ... 65 more Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'BUILDS_NAME_NUMBER_DATE_IDX' defined on 'BUILDS'. at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source)[derby-10.9.1.0.jar:na] ... 77 more Caused by: org.apache.derby.iapi.error.StandardException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'BUILDS_NAME_NUMBER_DATE_IDX' defined on 'BUILDS'. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)[derby-10.9.1.0.jar:na] at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)[derby-10.9.1.0.jar:na] ... 71 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

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