Using SQL 2008
I realise that SQL 2008 is not supported but I have seen posts from people who say it works.
Also our company uses SQL 2000 or 2008 - we don't have 2005!
I have migrated our db from mysql to 2008 and now when starting up I get the following error after it has started, plugins loaded and agents have been detected.
Any ideas how to fix this?
[2009-10-28 10:22:20,093] ERROR - jetbrains.buildServer.SERVER - Error occurred while starting build
java.lang.RuntimeException: Failed to associate build with promotion, promotion was not persisted
at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.setAssociatedBuild(BuildPromotionImpl.java:445)
at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.initialize(RunningBuildImpl.java:202)
at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.<init>(RunningBuildImpl.java:190)
at jetbrains.buildServer.serverSide.impl.BuildFactoryImpl.createRunningBuild(BuildFactoryImpl.java:19)
at jetbrains.buildServer.serverSide.impl.auth.SecuredBuildFactory.createRunningBuild(SecuredBuildFactory.java:11)
at jetbrains.buildServer.serverSide.impl.BuildTypeImpl.newRunningBuild(BuildTypeImpl.java:803)
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:33)
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$$d5b93646.newRunningBuild(<generated>)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.startBuild(BuildServerImpl.java:533)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.access$700(BuildServerImpl.java:551)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl$5.run(BuildServerImpl.java:4)
at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl.executeWithInactiveCleanup(ServerCleanupManagerImpl.java:24)
at jetbrains.buildServer.serverSide.impl.cleanup.ServerCleanupManagerImpl$$FastClassByCGLIB$$ba2c8525.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:33)
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.cleanup.ServerCleanupManagerImpl$$EnhancerByCGLIB$$78f6a408.executeWithInactiveCleanup(<generated>)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.flushQueue(BuildServerImpl.java:153)
at jetbrains.buildServer.serverSide.impl.BuildServerRunner$2.doSomething(BuildServerRunner.java:2)
at jetbrains.buildServer.serverSide.impl.BuildServerRunner$BuildServerWorker.run(BuildServerRunner.java:9)
at java.lang.Thread.run(Thread.java:595)
Please sign in to leave a comment.
Please attach full teamcity-server.log file.
[2009-10-28 10:21:41,859] INFO - jetbrains.buildServer.SERVER - Starting TeamCity server
[2009-10-28 10:21:44,140] INFO - dServer.serverSide.ServerPaths - TeamCity data path was read from teamcity.data.path
[2009-10-28 10:21:44,156] INFO - dServer.serverSide.ServerPaths - TeamCity data directory:d:/.BuildServer
[2009-10-28 10:21:44,421] INFO - erver.serverSide.impl.DBFacade - Connection pool configured (net.sourceforge.jtds.jdbc.Driver, maximum number of connections: 50)
[2009-10-28 10:21:44,421] INFO - erver.serverSide.impl.DBFacade - Connection pool URL: jdbc:jtds:sqlserver://WWLDBMS7006:1433/teamcity
[2009-10-28 10:21:45,390] INFO - jetbrains.buildServer.SERVER - Loading roles from the configuration file: D:\.BuildServer\config\roles-config.xml
[2009-10-28 10:21:45,968] INFO - jetbrains.buildServer.SERVER - Start initializing build durations cache...
[2009-10-28 10:21:46,906] INFO - jetbrains.buildServer.SERVER - Finished initializing build durations cache
[2009-10-28 10:21:50,093] INFO - n.email.EMailNotificatorConfig - Loading configuration file: D:\.BuildServer\config\email-config.xml
[2009-10-28 10:21:50,156] INFO - ion.template.NotificatorConfig - Loading configuration file: D:\.BuildServer\config\ide-notificator-config.xml
[2009-10-28 10:21:50,171] INFO - jabber.JabberNotificatorConfig - Loading configuration file: D:\.BuildServer\config\jabber-config.xml
[2009-10-28 10:21:50,484] INFO - ion.template.NotificatorConfig - Loading configuration file: D:\.BuildServer\config\win32-config.xml
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginManagerImpl - ===========================================================
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginManagerImpl - Scanning plugin folder: D:\TeamCity\webapps\ROOT\WEB-INF\plugins
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginsCollection - Found plugin buildDurationStatisticsPlugin
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginsCollection - Found plugin changeViewers
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginsCollection - Found plugin clearcase
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginsCollection - Found plugin cvs
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginsCollection - Found plugin feed
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginsCollection - Found plugin ldap
[2009-10-28 10:21:51,031] INFO - rver.plugins.PluginsCollection - Found plugin perforce
[2009-10-28 10:21:51,046] INFO - rver.plugins.PluginsCollection - Found plugin remoteAccess
[2009-10-28 10:21:51,046] INFO - rver.plugins.PluginsCollection - Found plugin stacktraces
[2009-10-28 10:21:51,046] INFO - rver.plugins.PluginsCollection - Found plugin starteam
[2009-10-28 10:21:51,046] INFO - rver.plugins.PluginsCollection - Found plugin svn
[2009-10-28 10:21:51,046] INFO - rver.plugins.PluginsCollection - Found plugin TeamCityArtifactsSizeStatisticsPlugin
[2009-10-28 10:21:51,046] INFO - rver.plugins.PluginsCollection - Found plugin tfs
[2009-10-28 10:21:51,046] INFO - rver.plugins.PluginsCollection - Found plugin vss
[2009-10-28 10:21:51,077] INFO - rver.plugins.PluginsCollection - Found plugin FxCop
[2009-10-28 10:21:51,077] INFO - rver.plugins.PluginsCollection - Found plugin rake-runner
[2009-10-28 10:21:51,077] INFO - rver.plugins.PluginsCollection - Found plugin xml-report-plugin
[2009-10-28 10:21:51,077] INFO - rver.plugins.PluginManagerImpl - Scanning plugin folder: D:\.BuildServer\plugins
[2009-10-28 10:21:51,077] INFO - rver.plugins.PluginManagerImpl - Found 17 plugins: [buildDurationStatisticsPlugin, changeViewers, clearcase, cvs, feed, FxCop, ldap, perforce, rake-runner, remoteAccess, stacktraces, starteam, svn, TeamCityArtifactsSizeStatisticsPlugin, tfs, vss, xml-report-plugin]
[2009-10-28 10:21:51,077] INFO - rver.plugins.PluginManagerImpl - Start intializing plugins...
[2009-10-28 10:21:51,077] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\cvs\agent\cvsAgent.zip for cvs
[2009-10-28 10:21:51,093] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\remoteAccess\agent\remoteAccess.zip for remoteAccess
[2009-10-28 10:21:51,093] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\stacktraces\agent\stacktracesAgent.zip for stacktraces
[2009-10-28 10:21:51,109] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\svn\agent\svnAgent.zip for svn
[2009-10-28 10:21:51,109] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\tfs\agent\tfs-agent.zip for tfs
[2009-10-28 10:21:51,109] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\.unpacked\fxcop-plugin\agent\fxcop-agent.zip for FxCop
[2009-10-28 10:21:51,109] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\.unpacked\rake-runner-plugin\agent\rake-runner-agent.zip for rake-runner
[2009-10-28 10:21:51,109] INFO - ns.agent.AgentPluginsPublisher - Registering agent plugin D:\TeamCity\webapps\ROOT\WEB-INF\plugins\.unpacked\xml-report-plugin\agent\xml-report-plugin.zip for xml-report-plugin
[2009-10-28 10:21:51,109] INFO - rver.plugins.PluginsCollection - No plugins were loaded with standalone classloaders
[2009-10-28 10:21:51,109] INFO - rver.plugins.PluginsCollection - Load shared classloader for 17 plugins [buildDurationStatisticsPlugin, changeViewers, clearcase, cvs, feed, FxCop, ldap, perforce, rake-runner, remoteAccess, stacktraces, starteam, svn, TeamCityArtifactsSizeStatisticsPlugin, tfs, vss, xml-report-plugin]
[2009-10-28 10:21:51,702] INFO - jetbrains.buildServer.LDAP - ------ LdapManager Start ------
[2009-10-28 10:21:52,421] INFO - rver.plugins.PluginManagerImpl - Loaded 17 plugins: [buildDurationStatisticsPlugin, changeViewers, clearcase, cvs, feed, FxCop, ldap, perforce, rake-runner, remoteAccess, stacktraces, starteam, svn, TeamCityArtifactsSizeStatisticsPlugin, tfs, vss, xml-report-plugin]
[2009-10-28 10:21:52,421] INFO - rver.plugins.PluginManagerImpl - ===========================================================
[2009-10-28 10:21:52,437] INFO - jetbrains.buildServer.CLEANUP - DB compact time has been set to 03:00:00 daily
[2009-10-28 10:21:52,531] INFO - jetbrains.buildServer.SERVER - Loading history of VCS changes...
[2009-10-28 10:21:55,515] INFO - jetbrains.buildServer.SERVER - Done loading VCS history: 32754 changes loaded
[2009-10-28 10:22:05,343] INFO - jetbrains.buildServer.SERVER - Server configuration reloaded.
[2009-10-28 10:22:07,390] INFO - jetbrains.buildServer.SERVER - Start prefetching changes for 200 build configurations...
[2009-10-28 10:22:08,155] INFO - jetbrains.buildServer.SERVER - Done prefetching changes
[2009-10-28 10:22:08,171] INFO - jetbrains.buildServer.SERVER - Start loading cache of build committers...
[2009-10-28 10:22:09,890] INFO - jetbrains.buildServer.SERVER - Done loading cache of build committers
[2009-10-28 10:22:09,984] WARN - jetbrains.buildServer.SERVER - Unable to load running build instance: 95873 due to error: Failed to associate build with promotion, promotion was not persisted
[2009-10-28 10:22:09,984] INFO - jetbrains.buildServer.SERVER - Unable to load running build instance
java.lang.RuntimeException: Failed to associate build with promotion, promotion was not persisted
at jetbrains.buildServer.serverSide.impl.BuildPromotionImpl.setAssociatedBuild(BuildPromotionImpl.java:445)
at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.initialize(RunningBuildImpl.java:202)
at jetbrains.buildServer.serverSide.impl.RunningBuildImpl.<init>(RunningBuildImpl.java:54)
at jetbrains.buildServer.serverSide.impl.BuildFactoryImpl.createRunningBuild(BuildFactoryImpl.java:8)
at jetbrains.buildServer.serverSide.impl.auth.SecuredBuildFactory.createRunningBuild(SecuredBuildFactory.java:7)
at jetbrains.buildServer.serverSide.impl.history.DBBuildHistory.loadRunningBuild(DBBuildHistory.java:150)
at jetbrains.buildServer.serverSide.impl.history.DBBuildHistory.loadRunningBuild(DBBuildHistory.java:79)
at jetbrains.buildServer.serverSide.impl.history.DBBuildHistory$9.process(DBBuildHistory.java:4)
at jetbrains.buildServer.serverSide.impl.history.DBBuildHistory$9.process(DBBuildHistory.java:2)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.processResultSet(GenericQuery.java:102)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.doExecuteQuery(GenericQuery.java:0)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.access$100(GenericQuery.java:48)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery$2.run(GenericQuery.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$3.doInConnection(DBFacade.java)
at jetbrains.buildServer.serverSide.impl.DBFacade$4.doInConnection(DBFacade.java:1)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:341)
at jetbrains.buildServer.serverSide.impl.DBFacade._runSql(DBFacade.java:199)
at jetbrains.buildServer.serverSide.impl.DBFacade.runSql(DBFacade.java:160)
at jetbrains.buildServer.serverSide.impl.query.GenericQuery.execute(GenericQuery.java:9)
at jetbrains.buildServer.serverSide.impl.history.DBBuildHistory.fetchAllRunningBuilds(DBBuildHistory.java:185)
at jetbrains.buildServer.serverSide.impl.auth.SecuredBuildHistory.fetchAllRunningBuilds(SecuredBuildHistory.java:43)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.loadRunningBuilds(BuildServerImpl.java:387)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.access$000(BuildServerImpl.java:20)
at jetbrains.buildServer.serverSide.impl.BuildServerImpl$3.serverStartup(BuildServerImpl.java:4)
at sun.reflect.GeneratedMethodAccessor40.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at jetbrains.buildServer.util.EventDispatcher.dispatch(EventDispatcher.java:83)
at jetbrains.buildServer.serverSide.ServerSideEventDispatcher.access$000(ServerSideEventDispatcher.java:6)
at jetbrains.buildServer.serverSide.ServerSideEventDispatcher$1$1.run(ServerSideEventDispatcher.java:2)
at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl$2.run(SecurityContextImpl.java)
at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:20)
at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAs(SecurityContextImpl.java:28)
at jetbrains.buildServer.serverSide.impl.auth.SecurityContextImpl.runAsSystem(SecurityContextImpl.java:32)
at jetbrains.buildServer.serverSide.ServerSideEventDispatcher$1.invoke(ServerSideEventDispatcher.java:2)
at $Proxy0.serverStartup(Unknown Source)
at jetbrains.buildServer.web.impl.BuildServerConfigurator.loadConfiguration(BuildServerConfigurator.java:30)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1412)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1373)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1333)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:471)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:217)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381)
at org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:354)
at org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:292)
at org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:262)
at org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:126)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at jetbrains.spring.web.TeamCityDispatcherServlet.init(TeamCityDispatcherServlet.java:6)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1172)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:992)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4058)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4371)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:516)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:578)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)
Is it possible to obtain the full log? If it contains sensitive data you can send it to teamcity-feedback[at]jetbrains.com.
Please find it attached.
Attachment(s):
teamcity-server.log.zip
It looks like server was incorrectly shutdown (killed?). To fix this issue run the following SQL command:
delete from running where build_id = 95873
We will fix this issue at our side too.
Hi,
I ran that script but it is still failing.
Attached is the log
Attachment(s):
new_log.txt.zip
Could you please enable debug logging (http://www.jetbrains.net/confluence/display/TCD5/Reporting+Issues#ReportingIssues-LoggingEvents) and attach here log with debug messages?
Hi,
Attached is the debug log file.
Attachment(s):
teamcity-server-debug.log.zip
Could you please stop the server again then remove all running builds and all builds from the queue by executing this SQL commands:
delete from build_queue;
delete from running;
Then try to start server again.
Hi,
Have run those commands and here is the result.
Thanks
Attachment(s):
teamcity-server-debug2.log.zip
I do not quite understand what happens in your case. Could you please check our updated documentation on setup of TeamCity server with MSSQL 2008:
http://www.jetbrains.net/confluence/display/TCD5/Setting+up+an+External+Database#SettingupanExternalDatabase-MicrosoftSQLServer
Please setup TeamCity & database accordingly. Pay especial attention at collation used for the database, probably this is the cause of your problems.