Problem upgrading TC 4.5.4 to TC 5 with postgresql

I tried to upgrade from Teamcity 4.5.4 to the latest Teamcity 5.0.3 on Linux, and when I started the server back up I saw initialization errors.

It is set up for an external database in Postgresql v8.3.5 on a separate machine, which appeared to run fine under Teamcity 4.5.4. We use different port settings from the default, which I am pretty sure I also set in the new Teamcity installation folder.

Are there any steps during the upgrade process that I need to take for the external database? The upgrade instructions suggested the conversion is automatic.

Here is the beginning of the stack trace, let me know if I should post in full:

org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'standardBuildProblems' defined in URL [jar:file:/usr/local/TeamCity-5.0.3/webapps/ROOT/WEB-INF/lib/server.jar!/META-INF/buildServerSpring.xml]: Unsatisfied dependency expressed through constructor argument with index 0 of type [jetbrains.buildServer.ExtensionHolder]: : Error creating bean with name 'databaseConverter' defined in URL [jar:file:/usr/local/TeamCity-5.0.3/webapps/ROOT/WEB-INF/lib/server.jar!/META-INF/buildServerSpring.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Error executing  query with params: [300]; uncategorized SQLException for SQL [select count(*) from db_version where version_nr = ?]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'databaseConverter' defined in URL [jar:file:/usr/local/TeamCity-5.0.3/webapps/ROOT/WEB-INF/lib/server.jar!/META-INF/buildServerSpring.xml]: Invocation of init method failed; nested exception is org.springframework.jdbc.UncategorizedSQLException: Error executing  query with params: [300]; uncategorized SQLException for SQL [select count(*) from db_version where version_nr = ?]; SQL state [25P02]; error code [0]; ERROR: current transaction is aborted, commands ignored until end of transaction block; nested exception is org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
   at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:591)
   at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:193)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
   at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
   at java.security.AccessController.doPrivileged(Native Method)
   ...

5 comments

Hi,

could you please provide us with the 'teamcity-server.log'?

Thanks.

0

Hi,

thanks for the information. In this case, the automatic upgrade has finished unsuccessfully due to a problem with converting assigned responsibilities.

I've posted a bugreport http://youtrack.jetbrains.net/issue/TW-11383 - you can watch/vote for it.

The quick workaround is to remove the 'responsibles.xml' file from the system subdirectory (this file holds assigned responsibilities),
and then try to upgrade again. Or you can wait for the nearest 5.1 eap where this bug is expected to be fixed.

Best regards,
Leonid

0

Hi,
Thanks, I will try the workaround. Any guess how soon the 5.1 release might be available?

0

Hi,

> Any guess how soon the 5.1 release might be available?

I hope TC 5.1 release will be in April.
TC 5.1 EAP is expected this week.

Best regards,
Leonid

0

Please sign in to leave a comment.