TC Web portal unusable after upgrade
I just upgraded to 9.1.3 and did the data conversion on the internal database. The web portal is now unusable. Several minutes to display the login page unusable. The process of loading the project list can take > 5 mins.
Has anyone else run into this? I had no issues on the previous version (8.0.?) and don't see any unusual system resource spikes.
Please sign in to leave a comment.
Hi David,
Please attach teamcity-server.log and also several thread dumps collected while server is in hanging state.
Here are the logs and thread dumps. I noticed several "long request" dumps were auto generated.
Attachment(s):
2015-09-25_09.44.16-manual.txt.zip
2015-09-25_09.43.51-longRequest-16.txt.zip
2015-09-25_09.43.37-manual.txt.zip
2015-09-25_09.43.11-longRequest-16.txt.zip
teamcity-server.log.zip
Hi David,
Sorry for delay. According to thread dumps the problem is with the internal HSQL database. We strongly recommend using an external database as a back-end TeamCity database in a production environment. An external database is usually more reliable and provides better performance: the internal database may crash and lose all your data. Also, the internal database may become extremely slow on large data sets (say, database storage files over 200Mb).
Please migrate to external database: https://confluence.jetbrains.com/display/TCD9/Migrating+to+an+External+Database.
What changed so drastically between this version and version 8?
The previous version worked just fine with no issues, and then after the upgrade it all fell apart. It just seems odd that the version change would so drasticaly decrease performance on the same database as before.