TC 5 update problem

Hello,

I tried to update(unpack new war file to application directory) to v5 and got following error message :

Error on step: Initializing...

Error creating bean with name 'standardBuildProblems' defined in URL [jar:file:/opt/teamcity/virtual/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:/opt/teamcity/virtual/WEB-INF/lib/server.jar!/META-INF/buildServerSpring.xml]: Invocation of init method failed; nested exception is jetbrains.buildServer.serverSide.versioning.ConvertException: Converter jetbrains.buildServer.serverSide.versioning.VersionManager$44 failed with error: SQL error when doing: Execute DDL
SQL query: alter table action_history add column additional_data  varchar(30)
SQL exception: Duplicate column name 'additional_data'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'databaseConverter' defined in URL [jar:file:/opt/teamcity/virtual/WEB-INF/lib/server.jar!/META-INF/buildServerSpring.xml]: Invocation of init method failed; nested exception is jetbrains.buildServer.serverSide.versioning.ConvertException: Converter jetbrains.buildServer.serverSide.versioning.VersionManager$44 failed with error: SQL error when doing: Execute DDL
SQL query: alter table action_history add column additional_data  varchar(30)
SQL exception: Duplicate column name 'additional_data'








Regards,

Alexey
2 comments
Comment actions Permalink

What database do you use? Internal or external? In case of external did you copy JDBC driver to WEB-INF/lib directory? Also it would be great to see the full teamcity-server.log.

0
Comment actions Permalink

Problem is resolved. The reason was that Teamcity Server 5.0 and our database had different collation, Teamcity uses utf8_general_ci, but database - utf8_unicode_ci.
So we set for teamcity connectionProperties.connectionCollation=utf8_unicode_ci in .BuildServer/config/database.properties, delete that column and restarted Teamcity.

0

Please sign in to leave a comment.