I am currently migrating our database from HSQLDB to PostreSQL, using the maintainDB script. We should have done this a long time ago, before the database grew so large, so we know this is going to take a while. Now the script has been running for 14 hours, but there is no progress indication. (I know this is a problem you are aware of, this is not what I'm asking here.) The whole time it has been saying "Starting backup"
My question is if there is any other way to get a hint of whether the script is working or not. I tried attaching strace to it in Cygwin, but that crashed maintainDB when I exited strace, so I don't want to do that again.
In pgAdmin, I see there are still no tables in the teamcity database.
I then scrolled up a bit in the command line window, and saw several messages of the type "java.io.FileNotFoundException: C:\TeamCity\bin\..\logs\teamcity-maintenance.log (Access is denied)" I had not noticed these before, as the command line window had filled up with other messages about connecting to the database successfully, and that it was starting the backup.
Has the script failed? Should I quit, fix the access problems, and start it again? Or is it actually working now and I should let it sit there in order to not lose 14 hours of work?
Edit: The java process is using 32M of RAM, and 4% CPU, and has been doing so since last night. This is another reason why I suspect the script is actually not doing anything.
Edit2: Another clue: The command line window says "Intermediate backup file: F:\TeamCityData\backup\TeamCity_Backup_20130504_094550.zip", but that file does still not exist.