Trying to setup a vanilla Crucible

Question

Hi all,

Our company has been running Crucible for a bit and we're trying to upgrade it now (from 2.7.15 - 3.7). Before doing all that, I was planning on testing the upgrade on a vanilla setup. The MySQL is set up on a separate host from Crucible. However, when attempting to change the database to MySQL, I'm getting the following error:

Problem with create tables script /../crucible/fecru-2.7.15/sql/MYSQL/schema/tables_76.sql
Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with create tables script /.../crucible/fecru-2.7.15/sql/MYSQL/schema/tables_76.sql

I've searched around and most answers are saying permission. However, I'm able to create databases/tables without issues. Any ideas guys?

Many thanks.

JW · Answer

I found the cause - it was due to the database engine being MyISAM vs InnoDB!

Thanks!

lpater · Answer

Hi JW,

You might want to raise a support issue with the exact error messages you're getting.

What I think might be happening is you're trying to set up an old version of FishEye, on a MySQL version that wasn't fully supported by that version - see https://confluence.atlassian.com/display/FISHKB/FishEye+Fails+to+Startup+with+MySQL+5.6.x and https://jira.atlassian.com/browse/FE-4507.

Depending on the scope of your testing, you might be able to workaround the issue by modifying the creation script manually, at the problematic line.