Disable build configuration produced this error

Unexpected Error

Error message: Error executing query with params:[bt8]; uncategorized SQLException for SQL [INSERT INTO paused_build_types (BUILD_TYPE_ID) VALUES (?)]; SQL state [23000]; error code [-104]; Violation of unique constraint SYS_PK_82: duplicate value(s) for column(s) BUILD_TYPE_ID in statement [INSERT INTO paused_build_types (BUILD_TYPE_ID) VALUES (?)]; nested exception is java.sql.SQLException: Violation of unique constraint SYS_PK_82: duplicate value(s) for column(s) BUILD_TYPE_ID in statement [INSERT INTO paused_build_types (BUILD_TYPE_ID) VALUES (?)]

Show stacktrace
org.springframework.jdbc.UncategorizedSQLException: Error executing query with params:[bt8]; uncategorized SQLException for SQL [INSERT INTO paused_build_types (BUILD_TYPE_ID) VALUES (?)]; SQL state [23000]; error code [-104]; Violation of unique constraint SYS_PK_82: duplicate value(s) for column(s) BUILD_TYPE_ID in statement [INSERT INTO paused_build_types (BUILD_TYPE_ID) VALUES (?)]; nested exception is java.sql.SQLException: Violation of unique constraint SYS_PK_82: duplicate value(s) for column(s) BUILD_TYPE_ID in statement [INSERT INTO paused_build_types (BUILD_TYPE_ID) VALUES (?)] at jetbrains.buildServer.serverSide.impl.query.GenericQuery.doExecuteQuery(GenericQuery.java:31) at jetbrains.buildServer.serverSide.impl.query.GenericQuery.access$100(GenericQuery.java:13) at jetbrains.buildServer.serverSide.impl.query.GenericQuery$1.run(GenericQuery.java) at jetbrains.buildServer.serverSide.impl.DBFacade$4.doInConnection(DBFacade.java) at jetbrains.buildServer.serverSide.impl.DBFacade$5.doInConnection(DBFacade.java:3) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341) at jetbrains.buildServer.serverSide.impl.DBFacade._runSql(DBFacade.java:113) at jetbrains.buildServer.serverSide.impl.DBFacade.runSql(DBFacade.java:68) at jetbrains.buildServer.serverSide.impl.query.GenericQuery.execute(GenericQuery.java:83) at jetbrains.buildServer.serverSide.impl.BuildTypeImpl.doSetPaused(BuildTypeImpl.java:694) at jetbrains.buildServer.serverSide.impl.BuildTypeImpl.setPaused(BuildTypeImpl.java:390) at jetbrains.buildServer.serverSide.impl.BuildTypeImpl$$FastClassByCGLIB$$a84db719.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at jetbrains.buildServer.serverSide.impl.auth.TeamCityMethodSecurityInterceptor.invoke(TeamCityMethodSecurityInterceptor.java:20) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:582) at jetbrains.buildServer.serverSide.impl.BuildTypeImpl$$EnhancerByCGLIB$$4749bf4d.setPaused(<generated>) at jetbrains.buildServer.controllers.SimpleActionController.setPaused(SimpleActionController.java:12) at jetbrains.buildServer.controllers.SimpleActionController.access$000(SimpleActionController.java:7) at jetbrains.buildServer.controllers.SimpleActionController$1.doProcess(SimpleActionController.java:3) at jetbrains.buildServer.controllers.OneParamAction.process(OneParamAction.java:7) at jetbrains.buildServer.controllers.BaseActionController.doAction(BaseActionController.java:5) at jetbrains.buildServer.controllers.SimpleActionController.doHandle(SimpleActionController.java:10) at jetbrains.buildServer.controllers.BaseController.handleRequestInternal(BaseController.java:60) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:809) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:523) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:463) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at jetbrains.spring.web.TeamCityDispatcherServlet.service(TeamCityDispatcherServlet.java:14) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at jetbrains.buildServer.web.ResponseFragmentFilter.doFilter(ResponseFragmentFilter.java:3) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Violation of unique constraint SYS_PK_82: duplicate value(s) for column(s) BUILD_TYPE_ID in statement [INSERT INTO paused_build_types (BUILD_TYPE_ID) VALUES (?)] at org.hsqldb.jdbc.Util.throwError(Unknown Source) at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169) at jetbrains.buildServer.serverSide.impl.query.GenericQuery.doExecuteQuery(GenericQuery.java:39) ... 49 more
2 comments
Comment actions Permalink

Hi,

  Is this problem reproduceable?
 
  Could you please provide details to our tracker at http://jetbrains.net/tracker .

  Thanks!
  KIR

0
Comment actions Permalink

It only happened once when I tried to pause a build.

0

Please sign in to leave a comment.