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
9 comments
Comment actions Permalink

HI,

This is what we got

Thanks



Attachment(s):
trace.txt.zip
0
Comment actions Permalink

Please take more thread dumps. Unfortunately, having a single one is not enough.

0
Comment actions Permalink

Here you go, let me know if you need more



Attachment(s):
trace.txt.zip
0
Comment actions Permalink

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.

0
Comment actions Permalink

We've already tried rebooting numerous times with no success, should this be any different?

0
Comment actions Permalink

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?

0
Comment actions Permalink

Hello,

We stopped mySql and Teamcity, started mySql then started teamcity and got the attached stack trace

Thanks



Attachment(s):
trace.txt.zip
0
Comment actions Permalink

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?

0

Please sign in to leave a comment.