TC 7.1 (build 23907) - .Net Duplicates finder error

Hi,

I am trying to get the duplicates finder running but its failing with this error:

[07:14:11][Step 2/2] Processing data

[07:14:11][Step 2/2] Error occurred while processing duplicate runner messages

[07:14:11][Step 2/2] jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Executing update with parameters: [48795123449856, 5, line:195,216, 195] caused SQL error:  SQL query: insert into duplicate_fragments(id, file_id, offset_info, line) values (?, ?, ?, ?) SQL exception: Attempt to insert null into a non-nullable column: column: FRAGMENT_ID table: DUPLICATE_FRAGMENTS in statement [insert into duplicate_fragments(id, file_id, offset_info, line) values (?, ?, ?, ?)]      at org.hsqldb.jdbc.Util.throwError(Util.java:58)      at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:441)      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)

Is there some setup needed or DB requirements for this option?


Thanks,
Chris
5 comments

FWIW - I also get a similar error when running it against a Java project, using the Java Duplicates Finder.

[14:07:28]Step 2/2: Dupe Finder (Duplicates finder (Java)) (4m:09s)

[14:07:29][Step 2/2] JDK path for '1.7' :%env.JDK_17% doesn't exist.

[14:07:44][Step 2/2] [  12611]  ERROR - .impl.MessageBusConnectionImpl - Cannot load module file '/appl/ion/anvil/teamcity-buildagent/work/trunk/idea/ArtsTree.iml':

[14:07:44][Step 2/2] File /appl/ion/anvil/teamcity-buildagent/work/trunk/idea/ArtsTree.iml does not exist

[14:07:44][Step 2/2] java.lang.RuntimeException: Cannot load module file '/appl/ion/anvil/teamcity-buildagent/work/trunk/idea/ArtsTree.iml':

[14:07:44][Step 2/2] File /appl/ion/anvil/teamcity-buildagent/work/trunk/idea/ArtsTree.iml does not exist

[14:07:44][Step 2/2] at com.intellij.openapi.module.impl.ModuleManagerImpl.a(ModuleManagerImpl.java:328)

[14:07:44][Step 2/2] at com.intellij.openapi.module.impl.ModuleManagerImpl.access$800(ModuleManagerImpl.java:75)

[14:07:44][Step 2/2] at com.intellij.openapi.module.impl.ModuleManagerImpl$3.run(ModuleManagerImpl.java:274)

[14:07:44][Step 2/2] at com.intellij.openapi.module.impl.ModuleManagerImpl.a(ModuleManagerImpl.java:303)

[14:07:44][Step 2/2] at com.intellij.openapi.module.impl.ModuleManagerImpl.access$200(ModuleManagerImpl.java:75)

[14:07:44][Step 2/2] at com.intellij.openapi.module.impl.ModuleManagerImpl$2.projectComponentsInitialized(ModuleManagerImpl.java:120)

[14:07:44][Step 2/2] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

[14:07:44][Step 2/2] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

[14:07:44][Step 2/2] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

[14:07:44][Step 2/2] at java.lang.reflect.Method.invoke(Method.java:597)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusConnectionImpl.deliverMessage(MessageBusConnectionImpl.java:110)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusImpl.doPumpMessages(MessageBusImpl.java:220)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusImpl.doPumpMessages(MessageBusImpl.java:226)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusImpl.pumpMessages(MessageBusImpl.java:212)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusImpl.pumpMessages(MessageBusImpl.java:209)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusImpl.sendMessage(MessageBusImpl.java:202)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusImpl.access$000(MessageBusImpl.java:42)

[14:07:44][Step 2/2] at com.intellij.util.messages.impl.MessageBusImpl$2.invoke(MessageBusImpl.java:128)

[14:07:44][Step 2/2] at com.sun.proxy.$Proxy31.projectComponentsInitialized(Unknown Source)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectImpl.init(ProjectImpl.java:297)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl.a(ProjectManagerImpl.java:277)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl.a(ProjectManagerImpl.java:330)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl.access$400(ProjectManagerImpl.java:80)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl$9.compute(ProjectManagerImpl.java:549)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl$9.compute(ProjectManagerImpl.java:545)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl$4.run(ProgressManagerImpl.java:256)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl$TaskRunnable.run(ProgressManagerImpl.java:469)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl$6.run(ProgressManagerImpl.java:288)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl$2.run(ProgressManagerImpl.java:178)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:218)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl.runProcess(ProgressManagerImpl.java:169)

[14:07:44][Step 2/2] at com.intellij.openapi.application.impl.ApplicationImpl.runProcessWithProgressSynchronously(ApplicationImpl.java:611)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl.a(ProgressManagerImpl.java:285)

[14:07:44][Step 2/2] at com.intellij.openapi.progress.impl.ProgressManagerImpl.runProcessWithProgressSynchronously(ProgressManagerImpl.java:264)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl.d(ProjectManagerImpl.java:545)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl.convertAndLoadProject(ProjectManagerImpl.java:519)

[14:07:44][Step 2/2] at com.intellij.openapi.project.impl.ProjectManagerImpl.loadAndOpenProject(ProjectManagerImpl.java:478)

[14:07:44][Step 2/2] at com.intellij.ide.impl.ProjectUtil.openProject(ProjectUtil.java:175)

[14:07:44][Step 2/2] at com.intellij.ide.impl.ProjectUtil.openOrImport(ProjectUtil.java:106)

[14:07:44][Step 2/2] at com.intellij.dupLocator.util.DuplocateMain$1.run(DuplocateMain.java:136)

[14:07:44][Step 2/2] at com.intellij.openapi.application.impl.ApplicationImpl.runReadAction(ApplicationImpl.java:864)

[14:07:44][Step 2/2] at com.intellij.dupLocator.util.DuplocateMain.main(DuplocateMain.java:116)

[14:07:44][Step 2/2] at com.intellij.idea.IdeaApplication.run(IdeaApplication.java:215)

[14:07:44][Step 2/2] at com.intellij.idea.MainImpl$3.run(MainImpl.java:194)

[14:07:44][Step 2/2] at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

[14:07:44][Step 2/2] at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:672)

[14:07:44][Step 2/2] at java.awt.EventQueue.access$400(EventQueue.java:81)

[14:07:44][Step 2/2] at java.awt.EventQueue$2.run(EventQueue.java:633)

[14:07:44][Step 2/2] at java.awt.EventQueue$2.run(EventQueue.java:631)

[14:07:44][Step 2/2] at java.security.AccessController.doPrivileged(Native Method)

[14:07:44][Step 2/2] at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)

[14:07:44][Step 2/2] at java.awt.EventQueue.dispatchEvent(EventQueue.java:642)

[14:07:44][Step 2/2] at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)

[14:07:44][Step 2/2] at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

[14:07:44][Step 2/2] at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)

[14:07:44][Step 2/2] at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)

[14:07:44][Step 2/2] at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)

[14:07:44][Step 2/2] at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

[14:07:44][Step 2/2] [  12613]  ERROR - .impl.MessageBusConnectionImpl - IntelliJ IDEA 11.1.3  Build #IU-117.840

[14:07:44][Step 2/2] [  12613]  ERROR - .impl.MessageBusConnectionImpl - JDK: 1.6.0_45

[14:07:44][Step 2/2] [  12613]  ERROR - .impl.MessageBusConnectionImpl - VM: Java HotSpot(TM) 64-Bit Server VM

[14:07:44][Step 2/2] [  12613]  ERROR - .impl.MessageBusConnectionImpl - Vendor: Sun Microsystems Inc.

[14:07:44][Step 2/2] [  12613]  ERROR - .impl.MessageBusConnectionImpl - OS: Linux

[14:07:44][Step 2/2] [  12613]  ERROR - .impl.MessageBusConnectionImpl - Last Action:

[14:08:29][Step 2/2] Upload duplicates

[14:11:34][Upload duplicates] Error occurred while processing duplicate runner messages

[14:11:37][Upload duplicates] jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Executing update with parameters: [50379966382080, 422, normalizedLE:2873,3164, 87] caused SQL error:  SQL query: insert into duplicate_fragments(id, file_id, offset_info, line) values (?, ?, ?, ?) SQL exception: Attempt to insert null into a non-nullable column: column: FRAGMENT_ID table: DUPLICATE_FRAGMENTS in statement [insert into duplicate_fragments(id, file_id, offset_info, line) values (?, ?, ?, ?)]      at org.hsqldb.jdbc.Util.throwError(Util.java:58)      at org.hsqldb.jdbc.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:441)      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery$4.action(GenericQuery.java:189)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery$4.action(GenericQuery.java:186)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery.underPreparedStatement(GenericQuery.java:476)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery.access$700(GenericQuery.java:28)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery$10.apply(GenericQuery.java:464)      at jetbrains.buildServer.serverSide.db.DBFunctions.withDB(DBFunctions.java:2252)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery.underPreparedStatement(GenericQuery.java:461)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeUpdate(GenericQuery.java:186)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery$3.run(GenericQuery.java:171)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery$3.run(GenericQuery.java:169)      at jetbrains.buildServer.serverSide.db.DBFacade$5.doInConnection(DBFacade.java:384)      at jetbrains.buildServer.serverSide.db.DBFacade$6.doInConnection(DBFacade.java:408)      at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)      at jetbrains.buildServer.serverSide.db.DBFacade._runSql(DBFacade.java:404)      at jetbrains.buildServer.serverSide.db.DBFacade.runSql(DBFacade.java:382)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery.executeUpdate(GenericQuery.java:169)      at jetbrains.buildServer.duplicator.queries.InsertDuplicatesQuery.execute(InsertDuplicatesQuery.java:27)      at jetbrains.buildServer.duplicator.DuplicatesMessageProcessor.doProcessMessageInternal(DuplicatesMessageProcessor.java:91)      at jetbrains.buildServer.duplicator.DuplicatesMessageProcessor.doProcessMessage(DuplicatesMessageProcessor.java:70)      at jetbrains.buildServer.serverSide.stat.StatisticsMessageProcessor.processMessage(StatisticsMessageProcessor.java:21)      at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.doProcessMessage(RunningBuildImpl.java:396)      at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.processMessage(RunningBuildImpl.java:152)      at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.addBuildMessages(RunningBuildImpl.java:174)      at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.addAgentBuildMessages(RunningBuildImpl.java:102)      at jetbrains.buildServer.serverSide.impl.XmlRpcBasedServer$1.doInTransactionWithoutResult(XmlRpcBasedServer.java:247)      at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)      at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)      at jetbrains.buildServer.serverSide.impl.XmlRpcBasedServer.doAddMessages(XmlRpcBasedServer.java:244)      at jetbrains.buildServer.serverSide.impl.XmlRpcBasedServer.log(XmlRpcBasedServer.java:203)      at sun.reflect.GeneratedMethodAccessor557.invoke(Unknown Source)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)      at java.lang.reflect.Method.invoke(Unknown Source)      at jetbrains.buildServer.serverSide.impl.ExceptionCollectorWrapper.execute(ExceptionCollectorWrapper.java:14)      at jetbrains.buildServer.controllers.XmlRpcController$1.execute(XmlRpcController.java:2)      at org.apache.xmlrpc.XmlRpcWorker.invokeHandler(XmlRpcWorker.java:84)      at org.apache.xmlrpc.XmlRpcWorker.execute(XmlRpcWorker.java:146)      at org.apache.xmlrpc.TCXmlRpcServer$TCXmlRpcWorker.execute(TCXmlRpcServer.java:32)      at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:139)      at org.apache.xmlrpc.XmlRpcServer.execute(XmlRpcServer.java:114)      at jetbrains.buildServer.controllers.XmlRpcController$2.apply(XmlRpcController.java:5)      at jetbrains.buildServer.controllers.XmlRpcController$2.apply(XmlRpcController.java:4)      at jetbrains.buildServer.serverSide.impl.XmlRpcSessionManager.executeRequest(XmlRpcSessionManager.java:183)      at jetbrains.buildServer.controllers.XmlRpcController.handleRequestInternal(XmlRpcController.java:13)      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:790)      at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)      at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)      at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)      at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)      at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)      at jetbrains.buildServer.maintenance.TeamCityDispatcherServlet.service(TeamCityDispatcherServlet.java:5)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)      at jetbrains.buildServer.web.ParametersProviderCalculationContextFilter.doFilter(ParametersProviderCalculationContextFilter.java:10)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)      at jetbrains.buildServer.web.DisableSessionIdFromUrlFilter.doFilter(DisableSessionIdFromUrlFilter.java:3)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)      at jetbrains.buildServer.web.DiagnosticFilter.doFilter(DiagnosticFilter.java:5)      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)      at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:300)      at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)      at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Attempt to insert null into a non-nullable column: column: FRAGMENT_ID table: DUPLICATE_FRAGMENTS in statement [insert into duplicate_fragments(id, file_id, offset_info, line) values (?, ?, ?, ?)]      ... 80 more


Still using same TC7 version as before.
0

We have upgraded to TC8.0.5 and it is still failing:

[13:52:59][Step 2/3] Upload duplicates
[13:53:01][Upload duplicates] Error occurred while processing duplicate runner messages
[13:53:01][Upload duplicates] jetbrains.buildServer.serverSide.db.UnexpectedDBException: Unexpected exception SQLException: SQL error when doing: Executing update with parameters: [50491635531776, 360, normalizedLE:24790,25262, 540] caused SQL error:  SQL query: insert into duplicate_fragments(id, file_id, offset_info, line) values (?, ?, ?, ?) SQL exception: Attempt to insert null into a non-nullable column: column: FRAGMENT_ID table: DUPLICATE_FRAGMENTS in statement [insert into duplicate_fragments(id, file_id, offset_info, line) values (?, ?, ?, ?)]      at org.hsqldb1.jdbc.Util.throwError(Util.java:58)      at org.hsqldb1.jdbc.jdbcPreparedStatement.executeUpdate(jdbcPreparedStatement.java:439)      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:261)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery$5.action(GenericQuery.java:258)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery.underPreparedStatement(GenericQuery.java:536)      at jetbrains.buildServer.serverSide.db.queries.GenericQuery.access$700(GenericQuery.java:28)

Note this build ran on a linux agent, whereas the TC server is a windows box.
0

Wonder if the error relates to the use of the default internal DB (hsqldb) - looking to switch to mysql to see if that fixes the issue...

0

Using MySQL fixed the issue :) ...

0

We are using MSSQL and are getting the same error on TC 9.0.1 (build 32116)

0

Please sign in to leave a comment.