Unable to start team city after upgrade to 9.0
After upgrading to Teamcity 9 we can no longer login
the teamcity-server.log always hangs on this line
[2014-12-15 16:56:14,305] INFO - jetbrains.buildServer.SERVER - Loading history of VCS changes...
Attachment(s):
teamcity-server.log.zip
Please sign in to leave a comment.
Please take 2-3 thread dumps from the server process using jstack utility:
http://confluence.jetbrains.com/display/TCD9/Reporting+Issues#ReportingIssues-TakingThreadDump
HI,
This is what we got
Thanks
Attachment(s):
trace.txt.zip
Please take more thread dumps. Unfortunately, having a single one is not enough.
Here you go, let me know if you need more
Attachment(s):
trace.txt.zip
Please stop TeamCity server, then try killing all TeamCity specific queries in MySQL (queries started by TeamCity server user). If MySQL server is used by TeamCity only, you can also try restarting it. After that try starting server again.
We've already tried rebooting numerous times with no success, should this be any different?
So you already tried to kill all TeamCity related SQL queries running in MySQL and tried to restart MySQL server but it did not help?
Hello,
We stopped mySql and Teamcity, started mySql then started teamcity and got the attached stack trace
Thanks
Attachment(s):
trace.txt.zip
Ok, so far no clue. This part of code did not change since 8.1, and it is not clear why it takes minutes or even hours to execute this simple query:
select h.modification_id, h.user_name, h.description, h.change_date, h.vcs_root_id, h.version, h.display_version, h.changes_count, h.register_date from vcs_history h join vcs_root_instance v on (h.vcs_root_id = v.id) where h.modification_id >= 1 and h.modification_id < 50001 order by modification_id
Do you have an antivirus software installed?