jetbrains.buildServer.serverSide.db.UnexpectedDBException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • Error persisting queue
    via by Unknown author,
    • jetbrains.buildServer.serverSide.db.UnexpectedDBException: Error executing batch: Batch entry 0 insert into build_artifact_dependency (build_state_id, source_build_type_id, src_paths, revision_rule, branch, artif_dep_id) values (17815, 'bt21', 'lapis-download-url.sh', '17745.tcbuildid', NULL, 'ARTIFACT_DEPENDENCY_5') was aborted. Call getNextException to see the cause. ERROR: prepared statement "S_302" does not exist SQL query: insert into build_artifact_dependency (build_state_id, source_build_type_id, src_paths, revision_rule, branch, artif_dep_id) values (?, ?, ?, ?, ?, ?) SQL exception: Batch entry 0 insert into build_artifact_dependency (build_state_id, source_build_type_id, src_paths, revision_rule, branch, artif_dep_id) values (17815, 'bt21', 'lapis-download-url.sh', '17745.tcbuildid', NULL, 'ARTIFACT_DEPENDENCY_5') was aborted. Call getNextException to see the cause. at jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeBatchPortion(GenericQuery.java:297) at jetbrains.buildServer.serverSide.db.queries.GenericQuery.access$300(GenericQuery.java:27) at jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:247) at jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:245) at jetbrains.buildServer.serverSide.db.queries.GenericQuery.underPreparedStatement(GenericQuery.java:407) at jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeBatch(GenericQuery.java:245) at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl$26.run(BuildPromotionImpl.java:4) at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$4.run(TeamCityDatabaseManager.java:908) at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$4.run(TeamCityDatabaseManager.java:905) at jetbrains.buildServer.serverSide.db.InternalDBUtil.runAndRetry(InternalDBUtil.java:25) at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.runAndRetry(TeamCityDatabaseManager.java:931) at jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.runAndRetry(TeamCityDatabaseManager.java:905) at jetbrains.buildServer.serverSide.db.DBFacade.runAndRetry(DBFacade.java:273) at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.persistArtifactDependencies(BuildPromotionImpl.java:1242) at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.persist(BuildPromotionImpl.java:839) at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.persist(BuildPromotionImpl.java:1432) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$16.run(BuildQueueImpl.java:20) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl$2.run(SecurityContextImpl.java:1) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:3) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:27) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:10) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.lambda$persistQueue$0(BuildQueueImpl.java:387) at jetbrains.buildServer.util.NamedThreadFactory.executeWithNewThreadName(NamedThreadFactory.java:74) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.persistQueue(BuildQueueImpl.java:356) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.access$1400(BuildQueueImpl.java:39) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$4$1.run(BuildQueueImpl.java:3) at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupState.runUnderLock(ServerCleanupState.java:52) at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupState.runReadAction(ServerCleanupState.java:19) at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl.executeWithInactiveCleanup(ServerCleanupManagerImpl.java:232) at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$$FastClassBySpringCGLIB$$ba2c8525.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at jetbrains.buildServer.serverSide.impl.auth.TeamCityMethodSecurityInterceptor.invoke(TeamCityMethodSecurityInterceptor.java:3) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.CglibAopProxy$FixedChainStaticTargetInterceptor.intercept(CglibAopProxy.java:604) at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$$EnhancerBySpringCGLIB$$204bbfa7.executeWithInactiveCleanup(<generated>) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$4.run(BuildQueueImpl.java:4) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl$7.run(BuildQueueImpl.java:3) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl$2.run(SecurityContextImpl.java:1) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:3) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:27) at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:10) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.runAsSystem(BuildQueueImpl.java:279) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.addToQueue(BuildQueueImpl.java:498) at jetbrains.buildServer.serverSide.impl.BuildQueueImpl.processTasks(BuildQueueImpl.java:492) at jetbrains.buildServer.serverSide.impl.auth.SecuredBuildQueue.processTasks(SecuredBuildQueue.java:101) at jetbrains.buildServer.controllers.actions.AddToQueueProcessor.processRequest(AddToQueueProcessor.java:93) at jetbrains.buildServer.controllers.RunCustomBuildController.doPost(RunCustomBuildController.java:71) at jetbrains.buildServer.controllers.BaseFormXmlController$1.handleRequest(BaseFormXmlController.java:53) at jetbrains.buildServer.controllers.AjaxRequestProcessor.processRequest(AjaxRequestProcessor.java:45) at jetbrains.buildServer.controllers.BaseFormXmlController.doHandle(BaseFormXmlController.java:51) at jetbrains.buildServer.controllers.BaseController.handleRequestInternal(BaseController.java:75) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:147) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869) at javax.servlet.http.HttpServlet.service(HttpServlet.java:650) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843) at javax.servlet.http.HttpServlet.service(HttpServlet.java:731) at jetbrains.buildServer.maintenance.TeamCityDispatcherServlet.service(TeamCityDispatcherServlet.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at jetbrains.buildServer.web.DisableSessionIdFromUrlFilter.doFilter(DisableSessionIdFromUrlFilter.java:8) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:107) at jetbrains.buildServer.diagnostic.web.DiagnosticFilter.doFilter(DiagnosticFilter.java:44) at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:112) at jetbrains.buildServer.web.DependencyParametersCalculationContextFilter.doFilter(DependencyParametersCalculationContextFilter.java:2) at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:112) at org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:73) at jetbrains.buildServer.web.DelegatingFilter.doFilter(DelegatingFilter.java:7) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at jetbrains.buildServer.web.ResponseFragmentFilter.doFilter(ResponseFragmentFilter.java:20) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1757) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1716) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.BatchUpdateException: Batch entry 0 insert into build_artifact_dependency (build_state_id, source_build_type_id, src_paths, revision_rule, branch, artif_dep_id) values (17815, 'bt21', 'lapis-download-url.sh', '17745.tcbuildid', NULL, 'ARTIFACT_DEPENDENCY_5') was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2778) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2959) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331) at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331) at jetbrains.buildServer.serverSide.db.queries.GenericQuery$6.run(GenericQuery.java:290) at jetbrains.buildServer.serverSide.db.queries.GenericQuery$6.run(GenericQuery.java:287) at jetbrains.buildServer.serverSide.db.DBInternalUtils.rawOperation(DBInternalUtils.java:72) at jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeBatchPortion(GenericQuery.java:287) ... 96 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    6 more bugmates