Database constraint violation on upgrading to 4.5.3.

Upon upgrading from 4.0 (build 8080) to 4.5.3 (build 9035), I get:

Constructor threw exception; nested exception is jetbrains.buildServer.serverSide.versioning.ConvertException: Converter jetbrains.buildServer.serverSide.versioning.VersionManager$27 failed with error: Violation of unique index SYS_IDX_59: duplicate value(s) for column(s) ID in statement [ALTER TABLE agent ADD COLUMN STATUS_TO_RESTORE  INTEGER]

I'm using the internal database engine.

Any suggestions?

-c

2 comments
Comment actions Permalink

I was able to resolve this (actually back on version 4.0 still) by

java -jar webapps/ROOT/WEB-INF/lib/hsqldb.jar --inlineRc URL=jdbc:hsqldb:file:../.BuildServer/system/buildserver,USER=sa
<empty password>
delete from agent;

-c

0
Comment actions Permalink

It looks like a bug in db engine. Do you have full exception? If so please submit a bug report to our tracker with exception attached: http://jetbrains.net/tracker

0

Please sign in to leave a comment.