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.

YouTrack | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error persisting queue

    YouTrack | 8 months ago
    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.
  2. 0

    Exception when saving logs: feature/253_pgSQLSupport

    GitHub | 2 years ago | n0ha
    java.sql.BatchUpdateException: Batch entry 0 INSERT INTO logging (log_level, timestmp, logger, message, dpu, execution, stack_trace, relative_id) VALUES (20000, 1419000760106, 'cz.cuni.mff.xrg.odcs.backend.pipeline.event.PipelineInfo' ,'Starting execution number: 4 pipeline: ocr-test-2', NULL, 4, NULL, 1) was aborted. Call getNextException to see the cause.
  3. 0

    boolean value converting into integer by Hibernate with postgres

    Stack Overflow | 3 years ago | user3595144
    java.sql.BatchUpdateException: Batch entry 0 insert into prwss_main.t_ccdu_iec_progress (activity_date, block_id, expenditure, activity_id, is_complete, location_id, auth_by, auth _date, ent_by, ent_date, freeze_by, freeze_date, status, no_of_participants, notes, outcome, venue, village_id, iec_progress_id) values (2014-05-02 -07:00:00, D09B02, 0.01, ACT18, 0, DIV27, 0, NULL, 0, 2014-05-02 10:36:58.557000 -07:00:00, 0, NULL, U, 34, df, '', fvfg, 16983, 16802) was aborted. Call getNextException to see the cause.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using Hibernate, Spring Data, and Postgres sequence generation throws exception

    Stack Overflow | 5 years ago | Oggie
    java.sql.BatchUpdateException: Batch entry 0 insert into blah.config_type (config_type_description, config_type_name, insert_by, insert_time, update_by, update_time, config_type_id) values ('config type description', 'test', NULL, NULL, NULL, NULL, '71') was aborted. Call getNextException to see the cause.
  6. 0

    Internal server error on first page of study creation wizard

    GitHub | 2 years ago | mhmoed
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update

    10 unregistered visitors
    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.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()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Statement.executeBatch
      1. org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2778)
      2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912)
      3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338)
      4. org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2959)
      4 frames
    3. Commons DBCP
      DelegatingStatement.executeBatch
      1. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331)
      2. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331)
      3. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331)
      4. org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:331)
      4 frames
    4. TeamCity Build Server
      GenericQuery.executeBatch
      1. jetbrains.buildServer.serverSide.db.queries.GenericQuery$6.run(GenericQuery.java:290)
      2. jetbrains.buildServer.serverSide.db.queries.GenericQuery$6.run(GenericQuery.java:287)
      3. jetbrains.buildServer.serverSide.db.DBInternalUtils.rawOperation(DBInternalUtils.java:72)
      4. jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeBatchPortion(GenericQuery.java:287)
      5. jetbrains.buildServer.serverSide.db.queries.GenericQuery.access$300(GenericQuery.java:27)
      6. jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:247)
      7. jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:245)
      8. jetbrains.buildServer.serverSide.db.queries.GenericQuery.underPreparedStatement(GenericQuery.java:407)
      9. jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeBatch(GenericQuery.java:245)
      9 frames
    5. jetbrains.buildServer.serverSide
      BuildPromotionImpl$26.run
      1. jetbrains.buildServer.serverSide.impl.BuildPromotionImpl$26.run(BuildPromotionImpl.java:4)
      1 frame
    6. TeamCity Build Server
      DBFacade.runAndRetry
      1. jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$4.run(TeamCityDatabaseManager.java:908)
      2. jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager$4.run(TeamCityDatabaseManager.java:905)
      3. jetbrains.buildServer.serverSide.db.InternalDBUtil.runAndRetry(InternalDBUtil.java:25)
      4. jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.runAndRetry(TeamCityDatabaseManager.java:931)
      5. jetbrains.buildServer.serverSide.db.TeamCityDatabaseManager.runAndRetry(TeamCityDatabaseManager.java:905)
      6. jetbrains.buildServer.serverSide.db.DBFacade.runAndRetry(DBFacade.java:273)
      6 frames
    7. jetbrains.buildServer.serverSide
      BuildQueueImpl$16.run
      1. jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.persistArtifactDependencies(BuildPromotionImpl.java:1242)
      2. jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.persist(BuildPromotionImpl.java:839)
      3. jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.persist(BuildPromotionImpl.java:1432)
      4. jetbrains.buildServer.serverSide.impl.BuildQueueImpl$16.run(BuildQueueImpl.java:20)
      4 frames
    8. TeamCity Build Server
      SecurityContextImpl.runAsSystem
      1. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl$2.run(SecurityContextImpl.java:1)
      2. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:3)
      3. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:27)
      4. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:10)
      4 frames
    9. jetbrains.buildServer.serverSide
      BuildQueueImpl.lambda$persistQueue$0
      1. jetbrains.buildServer.serverSide.impl.BuildQueueImpl.lambda$persistQueue$0(BuildQueueImpl.java:387)
      1 frame
    10. TeamCity Build Server
      NamedThreadFactory.executeWithNewThreadName
      1. jetbrains.buildServer.util.NamedThreadFactory.executeWithNewThreadName(NamedThreadFactory.java:74)
      1 frame
    11. jetbrains.buildServer.serverSide
      BuildQueueImpl$4$1.run
      1. jetbrains.buildServer.serverSide.impl.BuildQueueImpl.persistQueue(BuildQueueImpl.java:356)
      2. jetbrains.buildServer.serverSide.impl.BuildQueueImpl.access$1400(BuildQueueImpl.java:39)
      3. jetbrains.buildServer.serverSide.impl.BuildQueueImpl$4$1.run(BuildQueueImpl.java:3)
      3 frames
    12. TeamCity Build Server
      ServerCleanupManagerImpl$$FastClassBySpringCGLIB$$ba2c8525.invoke
      1. jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupState.runUnderLock(ServerCleanupState.java:52)
      2. jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupState.runReadAction(ServerCleanupState.java:19)
      3. jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl.executeWithInactiveCleanup(ServerCleanupManagerImpl.java:232)
      4. jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$$FastClassBySpringCGLIB$$ba2c8525.invoke(<generated>)
      4 frames
    13. Spring Core
      MethodProxy.invoke
      1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
      1 frame
    14. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
      2 frames
    15. TeamCity Build Server
      TeamCityMethodSecurityInterceptor.invoke
      1. jetbrains.buildServer.serverSide.impl.auth.TeamCityMethodSecurityInterceptor.invoke(TeamCityMethodSecurityInterceptor.java:3)
      1 frame
    16. Spring AOP
      CglibAopProxy$FixedChainStaticTargetInterceptor.intercept
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
      2. org.springframework.aop.framework.CglibAopProxy$FixedChainStaticTargetInterceptor.intercept(CglibAopProxy.java:604)
      2 frames
    17. TeamCity Build Server
      ServerCleanupManagerImpl$$EnhancerBySpringCGLIB$$204bbfa7.executeWithInactiveCleanup
      1. jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$$EnhancerBySpringCGLIB$$204bbfa7.executeWithInactiveCleanup(<generated>)
      1 frame
    18. jetbrains.buildServer.serverSide
      BuildQueueImpl$7.run
      1. jetbrains.buildServer.serverSide.impl.BuildQueueImpl$4.run(BuildQueueImpl.java:4)
      2. jetbrains.buildServer.serverSide.impl.BuildQueueImpl$7.run(BuildQueueImpl.java:3)
      2 frames
    19. TeamCity Build Server
      SecurityContextImpl.runAsSystem
      1. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl$2.run(SecurityContextImpl.java:1)
      2. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:3)
      3. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:27)
      4. jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:10)
      4 frames
    20. jetbrains.buildServer.serverSide
      BuildQueueImpl.processTasks
      1. jetbrains.buildServer.serverSide.impl.BuildQueueImpl.runAsSystem(BuildQueueImpl.java:279)
      2. jetbrains.buildServer.serverSide.impl.BuildQueueImpl.addToQueue(BuildQueueImpl.java:498)
      3. jetbrains.buildServer.serverSide.impl.BuildQueueImpl.processTasks(BuildQueueImpl.java:492)
      3 frames
    21. TeamCity Build Server
      SecuredBuildQueue.processTasks
      1. jetbrains.buildServer.serverSide.impl.auth.SecuredBuildQueue.processTasks(SecuredBuildQueue.java:101)
      1 frame
    22. jetbrains.buildServer.controllers
      AddToQueueProcessor.processRequest
      1. jetbrains.buildServer.controllers.actions.AddToQueueProcessor.processRequest(AddToQueueProcessor.java:93)
      1 frame
    23. TeamCity Build Server
      BaseController.handleRequestInternal
      1. jetbrains.buildServer.controllers.RunCustomBuildController.doPost(RunCustomBuildController.java:71)
      2. jetbrains.buildServer.controllers.BaseFormXmlController$1.handleRequest(BaseFormXmlController.java:53)
      3. jetbrains.buildServer.controllers.AjaxRequestProcessor.processRequest(AjaxRequestProcessor.java:45)
      4. jetbrains.buildServer.controllers.BaseFormXmlController.doHandle(BaseFormXmlController.java:51)
      5. jetbrains.buildServer.controllers.BaseController.handleRequestInternal(BaseController.java:75)
      5 frames
    24. Spring MVC
      FrameworkServlet.doPost
      1. org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:147)
      2. org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:50)
      3. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)
      4. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)
      5. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)
      6. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)
      6 frames
    25. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
      1 frame
    26. Spring MVC
      FrameworkServlet.service
      1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)
      1 frame
    27. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
      1 frame
    28. TeamCity Build Server
      TeamCityDispatcherServlet.service
      1. jetbrains.buildServer.maintenance.TeamCityDispatcherServlet.service(TeamCityDispatcherServlet.java:52)
      1 frame
    29. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    30. Tomcat WS
      WsFilter.doFilter
      1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      1 frame
    31. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    32. TeamCity Build Server
      DisableSessionIdFromUrlFilter.doFilter
      1. jetbrains.buildServer.web.DisableSessionIdFromUrlFilter.doFilter(DisableSessionIdFromUrlFilter.java:8)
      1 frame
    33. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    34. Spring
      CompositeFilter$VirtualFilterChain.doFilter
      1. org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:107)
      1 frame
    35. jetbrains.buildServer.diagnostic
      DiagnosticFilter.doFilter
      1. jetbrains.buildServer.diagnostic.web.DiagnosticFilter.doFilter(DiagnosticFilter.java:44)
      1 frame
    36. Spring
      CompositeFilter$VirtualFilterChain.doFilter
      1. org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:112)
      1 frame
    37. TeamCity Build Server
      DependencyParametersCalculationContextFilter.doFilter
      1. jetbrains.buildServer.web.DependencyParametersCalculationContextFilter.doFilter(DependencyParametersCalculationContextFilter.java:2)
      1 frame
    38. Spring
      CompositeFilter.doFilter
      1. org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:112)
      2. org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:73)
      2 frames
    39. TeamCity Build Server
      DelegatingFilter.doFilter
      1. jetbrains.buildServer.web.DelegatingFilter.doFilter(DelegatingFilter.java:7)
      1 frame
    40. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      2 frames
    41. TeamCity Build Server
      ResponseFragmentFilter.doFilter
      1. jetbrains.buildServer.web.ResponseFragmentFilter.doFilter(ResponseFragmentFilter.java:20)
      1 frame
    42. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:436)
      8 frames
    43. Grizzly HTTP
      NioEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1078)
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
      3. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1757)
      4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1716)
      4 frames
    44. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      2 frames
    45. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      1 frame
    46. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame