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 | 3 months ago
  1. 0

    Error persisting queue

    YouTrack | 3 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