Recreating users after server crash

I just had to reboot my TeamCity server and unfortunately the TeamCity
process wasn't shut down cleanly. Of course, this meant that I had to
re-create all the users, since
http://www.jetbrains.net/jira/browse/TW-574 isn't addressed.

Anyway, one good thing is that I didn't have to re-create all my build
configurations. Is there any way you could separate the users from the
build history (like you have with the build config), so that when the DB
gets corrupted I "only" lose the build history, and not the user
information?

R

4 comments
Comment actions Permalink

Hello Robert,

"Robert Gibson" <robbie_usenet@yahoo.co.uk> wrote in message
news:eichjg$77s$1@is.intellij.net...
>I just had to reboot my TeamCity server and unfortunately the TeamCity
>process wasn't shut down cleanly. Of course, this meant that I had to
>re-create all the users, since http://www.jetbrains.net/jira/browse/TW-574
>isn't addressed.

This is strange. In this case HSQLDB should recover it's database from the
backup. This should be done automatically.

Anyway, one good thing is that I didn't have to re-create all my build
configurations. Is there any way you could separate the users from the
build history (like you have with the build config), so that when the DB
gets corrupted I "only" lose the build history, and not the user
information?


It's not easy. I would suggest you to use MySQL instead of default TeamCity
database HSQLDB. MySQL is more reliable than HSQLDB, and you will be able to
backup TeamCity database without server shutdown.

--
Pavel Sher


0
Comment actions Permalink

Pavel Sher wrote:

Hello Robert,

"Robert Gibson" <robbie_usenet@yahoo.co.uk> wrote in message
news:eichjg$77s$1@is.intellij.net...

>>I just had to reboot my TeamCity server and unfortunately the TeamCity
>>process wasn't shut down cleanly. Of course, this meant that I had to
>>re-create all the users, since http://www.jetbrains.net/jira/browse/TW-574
>>isn't addressed.


This is strange. In this case HSQLDB should recover it's database from the
backup. This should be done automatically.

Maybe, but it doesn't seem to. I've also had similar problems simply
when upgrading the TC server.
Maybe I'll give MySQL a shot. Can I plug in other databases (like Sybase)?
Thanks,
R

0
Comment actions Permalink

Hello,

>> This is strange. In this case HSQLDB should recover it's database from
>> the backup. This should be done automatically.
>>

Maybe, but it doesn't seem to. I've also had similar problems simply when
upgrading the TC server.
Maybe I'll give MySQL a shot. Can I plug in other databases (like Sybase)?


No, for now it is impossible. For now list of supported databasese is
limited to HSQLDB and MySQL.

--
Pavel Sher


0

Please sign in to leave a comment.