Details
-
Bug
-
Resolution: Won't Fix
-
Low
-
None
-
None
-
None
-
None
-
Severity 3 - Minor
-
Description
Upgrading FeCru from 2.6.3 to 2.7.1
MySQL 5.0.32-Debian_7etch12-log
2011-09-20 08:05:27,708 ERROR [ThreadPool1 ] fisheye.app DBEditHelper-doGet - Database migration failed: com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script /opt/fecru-2.7.3/sql/MYSQL/schema/constraints_75.sql com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script /opt/fecru-2.7.3/sql/MYSQL/schema/constraints_75.sql at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:317) at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:159) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:91) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:73) at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) at java.util.concurrent.FutureTask.run(FutureTask.java:138) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:98) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:206) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:662) Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 103: "alter table cru_review add index FK6288A3D17492E860 (cru_parent_review), add constraint FK6288A3D17492E860 foreign key (cru_parent_review) references cru_review (cru_review_id);" (Can't create table './fecru27/#sql-7e4e_3f7e3a.frm' (errno: 150)), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:483) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:414) at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:311) ... 10 more Caused by: java.sql.SQLException: Can't create table './fecru27/#sql-7e4e_3f7e3a.frm' (errno: 150) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647) at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:455) ... 12 more
Upgrading while using MySQL 5.1.41-3ubuntu12.10 or 5.1.58 apple-darwin10.3.0 works fine.