B5433: converting from hsqldb to mysql problems:

Following the instructions given for converting from using HSQLDB to MySQL,
I'm getting the following errors:

1. server-openapi.jar is not specified as a required jar although it seems to be required since it defines a VersionSuppport class;
2. the import process fails with an error : there's a missing SERVER.BUILD_TYPE_ID
column.

Has this been tested ? Am I doing something wrong?

Cheers,

Bonny

5 comments

Bonny Rais wrote:

Following the instructions given for converting from using HSQLDB to MySQL,
I'm getting the following errors:

1. server-openapi.jar is not specified as a required jar although it seems to be required since it defines a VersionSuppport class;
2. the import process fails with an error : there's a missing SERVER.BUILD_TYPE_ID
column.

Has this been tested ? Am I doing something wrong?

Yes, this feature was tested and is already used by many of our users.
Thank you for valuable feedback, documentation was updated.

To help you with conversion we need following details:
-exact version of server and database software.
-contents of .BuildServer\system\version.dat (before conversion, not the
generated one)
-full conversion log

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

0

Alexey,

Bonny Rais wrote:

Following the instructions given for converting

from using HSQLDB to MySQL,

I'm getting the following errors:

1. server-openapi.jar is not specified as a

required jar although it seems to be required since
it defines a VersionSuppport class;

2. the import process fails with an error : there's

a missing SERVER.BUILD_TYPE_ID

column.

Has this been tested ? Am I doing something wrong?

Yes, this feature was tested and is already used by
many of our users.


I appologise if my question came across as a critisism - I had no
intention of doing this, of course. I just wanted to convert the database over.

Thank you for valuable feedback, documentation was
updated.

To help you with conversion we need following
details:
-exact version of server and database software.
-contents of .BuildServer\system\version.dat (before
conversion, not the
generated one)
-full conversion log


By the server version, I assume you mean TC? if so, then it's build 5433.
MySQL Server version is 5.0.45
MySQL Connector/J is mysql-connector-java-5.0.7-bin.jar
Version.dat includes the following lines:
version.com.mysql.jdbc.Driver=145
version.org.hsqldb.jdbcDriver=145
OS is RHEL3

Following is the log (?) from the conversion - could not find an actual log file:
Tue Sep 11 15:15:49 EST 2007 Connecting to the source database jdbc:hsqldb:file:/home/teamcity/.BuildServer/system/buildserver
Tue Sep 11 15:15:50 EST 2007 Connecting to the target database jdbc:mysql://localhost/tc3
Tue Sep 11 15:15:50 EST 2007 Initializing schema...
TABLES to be converted: (36) [[agent, agent_build_type_access, agent_sources_version, build_checkout_rules, build_queue, build_type_vcs_change, canceled_info, compiler_output, deleted_build_types, downloaded_artifacts, failed_tests_output, granted_license, history, ignored_tests, paused_build_types, personal_vcs_changes, personal_vcs_history, remember_me, remote_run_build_types, run_configuration_policy, running, server, server_property, statistics, test_info, test_names, user_blocks, user_notification_events, user_projects_order, user_projects_visibility, user_property, user_watch_type, users, vcs_changes, vcs_history, vcs_root_versions]]
Tue Sep 11 15:15:51 EST 2007 Exporting data to TC-export-1189487751848
Tue Sep 11 15:15:52 EST 2007 Importing data from TC-export-1189487751848
Exception in thread "main" org.dbunit.dataset.NoSuchColumnException: SERVER.BUILD_TYPE_ID
at org.dbunit.operation.AbstractOperation.getOperationMetaData(AbstractOperation.java:71)
at org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:130)
at jetbrains.buildServer.serverSide.HSQL2MySQL.doImport(HSQL2MySQL.java:33)
at jetbrains.buildServer.serverSide.HSQL2MySQL.main(HSQL2MySQL.java:87)


Cheers,

Bonny

0

Bonny Rais wrote:

Alexey,

>

Bonny Rais wrote:

>> Following the instructions given for converting

from using HSQLDB to MySQL,

>> I'm getting the following errors:
>>
>> 1. server-openapi.jar is not specified as a

required jar although it seems to be required since
it defines a VersionSuppport class;

>> 2. the import process fails with an error : there's

a missing SERVER.BUILD_TYPE_ID

>> column.
>>
>> Has this been tested ? Am I doing something wrong?

Yes, this feature was tested and is already used by
many of our users.

>

I appologise if my question came across as a critisism - I had no
intention of doing this, of course. I just wanted to convert the
database over.

>

Thank you for valuable feedback, documentation was
updated.

>

To help you with conversion we need following
details:
-exact version of server and database software.
-contents of .BuildServer\system\version.dat (before
conversion, not the
generated one)
-full conversion log

>

>

By the server version, I assume you mean TC? if so, then it's build 5433.
MySQL Server version is 5.0.45
MySQL Connector/J is mysql-connector-java-5.0.7-bin.jar
Version.dat includes the following lines:
version.com.mysql.jdbc.Driver=145
version.org.hsqldb.jdbcDriver=145
OS is RHEL3

>

Following is the log (?) from the conversion - could not find an
actual log file:
Tue Sep 11 15:15:49 EST 2007 Connecting to the source database
jdbc:hsqldb:file:/home/teamcity/.BuildServer/system/buildserver
Tue Sep 11 15:15:50 EST 2007 Connecting to the target database
jdbc:mysql://localhost/tc3
Tue Sep 11 15:15:50 EST 2007 Initializing schema...
TABLES to be converted: (36) [[agent, agent_build_type_access,
agent_sources_version, build_checkout_rules, build_queue,
build_type_vcs_change, canceled_info, compiler_output,
deleted_build_types, downloaded_artifacts, failed_tests_output,
granted_license, history, ignored_tests, paused_build_types,
personal_vcs_changes, personal_vcs_history, remember_me,
remote_run_build_types, run_configuration_policy, running, server,
server_property, statistics, test_info, test_names, user_blocks,
user_notification_events, user_projects_order,
user_projects_visibility, user_property, user_watch_type, users,
vcs_changes, vcs_history, vcs_root_versions]]
Tue Sep 11 15:15:51 EST 2007 Exporting data to TC-export-1189487751848
Tue Sep 11 15:15:52 EST 2007 Importing data from TC-export-1189487751848
Exception in thread "main" org.dbunit.dataset.NoSuchColumnException:
SERVER.BUILD_TYPE_ID
at
org.dbunit.operation.AbstractOperation.getOperationMetaData(AbstractOperation.java:71)
at
org.dbunit.operation.AbstractBatchOperation.execute(AbstractBatchOperation.java:130)
at
jetbrains.buildServer.serverSide.HSQL2MySQL.doImport(HSQL2MySQL.java:33)
at
jetbrains.buildServer.serverSide.HSQL2MySQL.main(HSQL2MySQL.java:87)

>
>

Cheers,

>

Bonny

There indeed should not be column BUILD_TYPE_ID in table SERVER.
Have you ever encountered problems when installing any EAP version?
May be at some point you installed previous EAP server version w/o
restoring corresponding database backup?

Anyway, I need some additional data to help you with conversion.
Can you please send me directory listing (with file sizes visible) of
folder with exported data and full contents of exported SERVER table data?

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

0

Bonny

There indeed should not be column BUILD_TYPE_ID in
table SERVER.
Have you ever encountered problems when installing
any EAP version?
May be at some point you installed previous EAP
server version w/o
restoring corresponding database backup?


I cannot recall now, but the installation process went along the lines
of, roughtly, installing TC2.1, having issues with CVS modules defined
in the modules file, then installing EAP 5433 and starting from scratch
(at least as far as I know), and now, attempting to migrate the database to mysql.
However, the BUILD_TYPE_ID column seems to be required from the import
code?? do I have the wrong jar version somehow? How do I check?


Anyway, I need some additional data to help you with
conversion.
Can you please send me directory listing (with file
sizes visible) of
folder with exported data and full contents of
exported SERVER table data?


I no longer have access to this directory - I have gone down the semi
manual way and imported the remaining exported data by using direct
sql. TC seems to work fine now (although we're not using all it's features,
so I could be wrong).



Cheers,

Bonny

0

Bonny Rais wrote:
>>> Bonny
>> There indeed should not be column BUILD_TYPE_ID in
>> table SERVER.
>> Have you ever encountered problems when installing
>> any EAP version?
>> May be at some point you installed previous EAP
>> server version w/o
>> restoring corresponding database backup?


I cannot recall now, but the installation process went along the lines
of, roughtly, installing TC2.1, having issues with CVS modules defined
in the modules file, then installing EAP 5433 and starting from scratch
(at least as far as I know), and now, attempting to migrate the database to mysql.
However, the BUILD_TYPE_ID column seems to be required from the import
code?? do I have the wrong jar version somehow? How do I check?

No, the error message means that exported data contains this column
while newly generated schema don't.

>> Anyway, I need some additional data to help you with
>> conversion.
>> Can you please send me directory listing (with file
>> sizes visible) of
>> folder with exported data and full contents of
>> exported SERVER table data?


I no longer have access to this directory - I have gone down the semi
manual way and imported the remaining exported data by using direct
sql. TC seems to work fine now (although we're not using all it's features,
so I could be wrong).

OK.


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

0

Please sign in to leave a comment.