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.

4 comments
Comment actions Permalink

Hi David,

Please attach teamcity-server.log and also several thread dumps collected while server is in hanging state.

0
Comment actions Permalink

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.

0
Comment actions Permalink

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.

0

Please sign in to leave a comment.