Build history removed but not the artifacts after upgrade to 9.1.3

Hello,after upgrading TeamCity Enterprise from 8.1.5 to 9.1.3 the history of all builds has been removed. Nothing is shown in the UI but the build artifacts still exist on the server. Can the history be restored?Cleanup was running for 12h with progress of 0%. (Current stage: Executing global cleaner (1 of 20): BackgroundBuildDataCleaner) No error shown in the log.What is the recommended way to delete artifacts of the deleted history builds?Also all users have been removed.And all VCS roots have been somehow changed and now the generated checkout folder name changed. We have many large repositories which will have to do a clean checkout now.Regards,Helios
9 comments
Comment actions Permalink

Hi Helios,


It seems like there are some problems with database. The build history, users and their data are stoed in database. What type of database do you use? Did you configured correctly the databse.properties file? Did the upgrade go smoothly?
Could you please attach teamcity-server.log file?

0
Comment actions Permalink
Hello Alina,We are using MySQL Server 5.1.58 and the database.properties remained unchanged after the upgrade. (according to the file modified date)Upgrade went smoothly. The teamcity-server.log files (log, log.1, log.2, log.3) are all full of buildLogMigration warnings like:[2015-10-04 15:07:18,067]WARN - erver.SERVER.buildLogMigration -Found build log file without related build in database 'D:\.BuildServer\system\messages\CH87\904587.msg5'[2784956 bytes].Please check if you need the file and consider removing it manually., will try to repeat migration on the next startupThanks,Helios
0
Comment actions Permalink

Could you please attach zipped full teamcity-server.log.* files?

0
Comment actions Permalink
Attached zipped log files with some obfuscation and some project related lines removed.

Attachment(s):
teamcity-server.log.zip
0
Comment actions Permalink

Unfortunately the upgrade log is rotated out. Could you please restore from the backup and try to perform the upgrade again? Before upgrade please increase the value of maxBackupIndex property.

0
Comment actions Permalink
Unfortunately this is only possible during weekends which will be too late with all the new builds and changes. We need to find another solution.
0
Comment actions Permalink

Could you please describe how did you perform the upgrade step by step? Also please go to Administration > General Settings page and check that Data Directory on this page is correct and it is the same as the directory where previously created artifacts are stored.

0
Comment actions Permalink
From our upgrade doc (like with all previous upgrades): check current TC doc about upgrade; disable all agents (wait for running/queued builds to finish); logon to server and stop TC server service; run installer (install only server not agent, don't let the installer start the service); verify database.properties;verify/update plugins; start TC server service; upgrade with key from log; Data Directory is still the same and new artifacts are written to the same folders.(somehow the formatting of the message  is always lost)edit: And just looked at the new backup, the zipped backup size decreased from 550MB (8.1.5) to 230MB (9.1.3). Mainly the (unzipped) size of the table test_info changed from 700MB to 10MB.
0
Comment actions Permalink

If you are not able to restore the production server and perform the upgrade again, then could you please create a copy of TeamCity server from backup, upgrade this server and send us the resulted logs? Alternatively you can send us the backup and we will try to run upgrade on our side.

0

Please sign in to leave a comment.