Another error while migrating from internal HSQLDB to MySQL

Avatar
Permanently deleted user
Created

Hi,

I have a problem migration my TC hsqldb to MySQL (5.0.x). The migration scripts stops with the following exception:

Caused by: error in script file line: 106 S1000 General error java.lang.NullPointerException in statement

The statement "SET TABLE USERS INDEX'244 244 0'" is contained in the file "~/.BuildServer/system/buildsystem.script". Removing all these statement does not help; it ends with a successful migration with 0 migrated records.

Any hints?
is there a fallback solution to retrieve the users+passwords from the hsqldb?

--Alex

Votes

0

Share

3 comments
Avatar
Permanently deleted user
Created

BTW, I as suggested in the migration guide I upgraded my TC instance from 3.1.1 to 3.1.2 before the db migration.

A test with a fresh TC 3.1.2 db works find, so I assume the upgrade left the hsqldb in a state which is not suitable for the db migration script.

0
Avatar
Permanently deleted user
Created

ok, if found the problem: You may not copy the 'buildsystem.data' without the other hsqldb files. They all together are forming the db, not only the data file.

With the correct input the migrartion works fine.

--a.

0
Avatar
Permanently deleted user
Created

Alex Schwartz wrote:

ok, if found the problem: You may not copy the 'buildsystem.data' without the other hsqldb files. They all together are forming the db, not only the data file.

With the correct input the migrartion works fine.

--a.


Glad that you've sorted it out.

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

0

Please sign in to leave a comment.