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.

Solutions on the web80

  • via YouTrack by Unknown author, 9 months ago
    ) 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.
  • Error executing batch: data exception: string data, right truncation SQL query: insert into final_artifact_dependency (build_state_id, source_build_type_id, src_paths, revision_rule, branch) values (?, ?, ?, ?, ?) SQL exception: data exception: string data, right truncation
  • via YouTrack by Unknown author, 1 year ago
    Error executing batch: Duplicate entry '542530-2728-.teamcity.star' for key 'PRIMARY' SQL query: insert into build_state_private_tag (build_state_id, owner, tag) values (?, ?, ?) SQL exception: Duplicate entry '542530-2728-.teamcity.star' for key 'PRIMARY'
  • Stack trace

    • 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.BuildPromotionImpl.freezeInlinedSettings(BuildPromotionImpl.java:742) at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.freezeSettings(BuildPromotionImpl.java:324) at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.freezeSettings(BuildPromotionImpl.java:296) at jetbrains.buildServer.serverSide.impl.versionedSettings.VersionedSettingsFreezerImpl.lambda$null$0(VersionedSettingsFreezerImpl.java:188) at jetbrains.buildServer.serverSide.impl.versionedSettings.VersionedSettingsFreezerImpl.block(VersionedSettingsFreezerImpl.java:306) at jetbrains.buildServer.serverSide.impl.versionedSettings.VersionedSettingsFreezerImpl.lambda$freezeSettings$1(VersionedSettingsFreezerImpl.java:119) at jetbrains.buildServer.serverSide.impl.versionedSettings.VersionedSettingsFreezerImpl.block(VersionedSettingsFreezerImpl.java:306) at jetbrains.buildServer.serverSide.impl.versionedSettings.VersionedSettingsFreezerImpl.freezeSettings(VersionedSettingsFreezerImpl.java:98) at jetbrains.buildServer.serverSide.impl.QueuedBuildsSettingsFreezer.lambda$freezeSettings$0(QueuedBuildsSettingsFreezer.java:19) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) 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) ... 29 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, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    6 more bugmates