EAP: Table 'teamcity.build_parameters' doesn't exist

I just updated to the latest EAP and I see this when I try to run a build

org.springframework.jdbc.UncategorizedSQLException: Error executing update with params:[4646]; uncategorized SQLException for SQL ; SQL state ; error code ; Table 'teamcity.build_parameters' doesn't exist; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'teamcity.build_parameters' doesn't exist

I can provide the trace if that's helpful.

7 comments
Comment actions Permalink

From what server version did you upgrade and what is the content of .BuildServer/system/version.dat file?

--
Pavel Sher

0
Comment actions Permalink

we were on build 7388

here is the new version.dat and the previous one.

build@build /opt/TCWork/system $ cat version.dat
#Wed Nov 19 16:32:25 EST 2008
version.com.mysql.jdbc.Driver=264
build@build /opt/TCWork/system $ cat version.dat.bak
#Tue Aug 05 19:18:48 EDT 2008
version.org.hsqldb.jdbcDriver=251

that old driver is wrong... we were on mysql before the update

Edited by: chowda on Nov 20, 2008 9:56 AM

Edited by: chowda on Nov 20, 2008 9:58 AM

0
Comment actions Permalink

Well if you were on mysql then version.dat must have record about it. Right now it looks like no conversion was done during your last upgrade and this is the cause of the error. Did you do database migration before or after the upgrade?

--
Pavel Sher

0
Comment actions Permalink

I migrated to mysql after the update to 7388 but before this update that I am now having problems with.

if I go to my backup dir of that working dir, I see this:

build@build ~/backup-TCWork-2008-11-19/system $ cat version.dat

  1. generated by TC database migration tool @Tue Aug 05 19:42:49 EDT 2008

version.com.mysql.jdbc.Driver=251

but the version.dat.bak i posted earlier is in there as well with the same contents... so that's just a red herring.. sorry.

0
Comment actions Permalink

Could you please restore your system from the backup and try to upgrade once again. If you'll see the same problem again please send the logs (teamcity-server.log) after the upgrade to teamcity-feedback jetbrains.com

--
Pavel Sher

0
Comment actions Permalink

I emailed the full log... here is the meaty bit


jetbrains.buildServer.serverSide.versioning.ConvertException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Duplicate column name 'IS_PERSONAL'
at jetbrains.buildServer.serverSide.versioning.converters.AddCanceledAndPersonalToBuildStateConverter.convert(AddCanceledAndPersonalToBuildStateConverter.java:9)

0
Comment actions Permalink

peter helped me out.. I'm up and running on the new EAP... lost some historic stuff, but that's no big deal in my situation. I didn't have to reconfigure anything important, and that's all I care about.

"If you do not need history and user accounts you can drop your
database and remove .BuildServer/system folder. Then start server. The
new database will be created but configuration of your projects will be
preserved."

0

Please sign in to leave a comment.