Upgrading HSQLDB to MySQL problems

I'm having quite a bit of trouble doing the full HSQLDB to MySQL upgrade. I think I finally got a good conversion to complete and now TC won't run, I get a 404 error when I try to connect to the main page.

Now I'm not sure I have the DB conversion fully done:
- Do I have to delete any of the old hsqldb files? The docs don't say.
- Do I have to delete anything in the config or system folders? The docs don't say.

stdout_.log file:
TeamCity data path directory: D:/.BuildServer
ERROR - work.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'buildServer' defined in ServletContext resource : Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class : Constructor threw exception; nested exception is java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertException: Failed
org.springframework.beans.BeanInstantiationException: Could not instantiate bean class : Constructor threw exception; nested exception is java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertException: Failed
java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertException: Failed
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.]]>(BuildServerImpl.java:904)

4 comments

dhoffer wrote:

I'm having quite a bit of trouble doing the full HSQLDB to MySQL upgrade. I think I finally got a good conversion to complete and now TC won't run, I get a 404 error when I try to connect to the main page.

Now I'm not sure I have the DB conversion fully done:
- Do I have to delete any of the old hsqldb files? The docs don't say.
- Do I have to delete anything in the config or system folders? The docs don't say.

stdout_.log file:
TeamCity data path directory: D:/.BuildServer
ERROR - work.web.context.ContextLoader - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'buildServer' defined in ServletContext resource : Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class : Constructor threw exception; nested exception is java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertException: Failed
org.springframework.beans.BeanInstantiationException: Could not instantiate bean class : Constructor threw exception; nested exception is java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertException: Failed
java.lang.RuntimeException: jetbrains.buildServer.serverSide.versioning.ConvertException: Failed
at jetbrains.buildServer.serverSide.impl.BuildServerImpl.<init>(BuildServerImpl.java:904)


Can you please list contents of .BuildServer\system\version.dat file?
Have you tried using mysql before making full upgrade?

--
Alexey Gopachenko
JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

0

Here is my version.dat file contents:
#Wed Apr 11 14:47:29 EDT 2007
version=73
version.org.hsqldb.jdbcDriver=117

This doesn't seem right, the docs don't say how this file gets configured.

As for using MySQL before full upgrade, I think I did do this once in the process of getting things setup. (However I think I did copy over my prior .BuildServer folder after this because I wanted to be sure I had all the 'stuff' that the HSQLDB2MySQL conversion process requires. I had trouble getting this to work properly. Maybe I shouldn't have copied this file? The docs don't say.) Also the docs say to delete the teamcity tables in MySQL before doing the conversion so I did this.

0

dhoffer wrote:

Here is my version.dat file contents:
#Wed Apr 11 14:47:29 EDT 2007
version=73
version.org.hsqldb.jdbcDriver=117

This doesn't seem right, the docs don't say how this file gets configured.

As for using MySQL before full upgrade, I think I did do this once in the process of getting things setup. (However I think I did copy over my prior .BuildServer folder after this because I wanted to be sure I had all the 'stuff' that the HSQLDB2MySQL conversion process requires. I had trouble getting this to work properly. Maybe I shouldn't have copied this file? The docs don't say.) Also the docs say to delete the teamcity tables in MySQL before doing the conversion so I did this.


Please shutdown server, delete
> version=73
line and start server again.

Although we are not sure how this line is still left there, we will try
to either improve instructions or upgrade tool to cover this case. Thank
you for your feedback!

--
Alexey Gopachenko
JetBrains Inc.
http://www.intellij.com
"Develop with pleasure!"

0

I had removed the version.dat file because I didn't find your reply and I restarted the TC service. It now seems to have all my data so I assume that it is properly connected to MySQL now (MySQL shows additional connections now).

Thanks much!

0

Please sign in to leave a comment.