Uploaded image for project: 'FishEye'
  1. FishEye
  2. FE-3736

MySQL 5.0 Upgrade fails when upgrading from 2.6.3 to 2.7.1

    Details

    • Type: Bug
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Symptom Severity:
      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.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Last commented:
                5 years, 39 weeks ago