Migrating to MySQL fails with migrateDBProgressAjax error message

Symptoms

Migrating from HSQL to MySQL using the administration panel fails, and the following appears in the atlassian-fisheye.log:

This is seen in the web browser:

Cause

The cause is unknown.

Resolution

1. Create a backup using the admin interface;

2. Create the MySQL database;

3. Shutdown Fisheye;

4. Using a command line client, go to FISHEYE_HOME/bin and restore only the database from the backup using the database command line options:

   Example (Linux / Mac):

   1 ./fisheyectl.sh restore --sql --file /path/to/fecru/backup_2013-20-12_0915.zip --dbtype mysql --jdbcurl jdbc:mysql://hostname:3306/fisheye --username dbuser --password dbuserpwd

   Example (Windows):

   1 ./fisheyectl.bat restore --sql --file /path/to/fecru/backup_2013-20-12_0915.zip --dbtype mysql --jdbcurl jdbc:mysql://hostname:3306/fisheye --username dbuser --password dbuserpwd

5. When the restore process is finished, backup the config.xml and edit the original one this way:

   1. Search for the <check-for-updates/> element. Right after this element, insert this:

      1 2 3 4 5 6 7 8 9 10 11 12 13 14 <database type="mysql"> <connection dialect="org.hibernate.dialect.MySQL5InnoDBDialect" driver="com.mysql.jdbc.Driver" jdbcurl="jdbc:mysql://host_name_here:3306/fisheye_database_name_here" username="db_username_here" password="db_user_password_here" maxPoolSize="20" minPoolSize="5" driverSource="bundled"/> <parameters>useUnicode=true characterEncoding=UTF8 connectionCollation=UTF8_bin </parameters> </database>

      Please remember to edit jdbcurl, username and password parameters accordingly.

   2. Save and close the file;

6. Start Fisheye.