com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 12: "alter table cru_completed_frx drop foreign key FK927E9E9F1BD6EA47;" (Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152)), please contact http://www.atlassian.com/support/

Atlassian JIRA | Andrew Myers [Atlassian] | 7 years ago
  1. 0

    Changing to an improvement request because it turns out its not a bug, but the customer data was somehow missing certain constraints on the database. You get the following error. {noformat}Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 12: "alter table cru_completed_frx drop foreign key FK927E9E9F1BD6EA47;" (Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152)), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:395) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:347) at com.cenqua.crucible.hibernate.DefaultDBControl.doUpgrade(DefaultDBControl.java:332) at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:306) ... 93 more Caused by: java.sql.SQLException: Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152) 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:377) ... 96 more{noformat} If its possible, we should check to see if the constraint exists before trying to drop it. If it doesn't exist its no big deal in this case because we were dropping the table right afterwards.

    Atlassian JIRA | 7 years ago | Andrew Myers [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 12: "alter table cru_completed_frx drop foreign key FK927E9E9F1BD6EA47;" (Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152)), please contact http://www.atlassian.com/support/
  2. 0

    Changing to an improvement request because it turns out its not a bug, but the customer data was somehow missing certain constraints on the database. You get the following error. {noformat}Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 12: "alter table cru_completed_frx drop foreign key FK927E9E9F1BD6EA47;" (Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152)), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:395) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:347) at com.cenqua.crucible.hibernate.DefaultDBControl.doUpgrade(DefaultDBControl.java:332) at com.cenqua.crucible.hibernate.DefaultDBControl.upgrade(DefaultDBControl.java:306) ... 93 more Caused by: java.sql.SQLException: Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152) 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:377) ... 96 more{noformat} If its possible, we should check to see if the constraint exists before trying to drop it. If it doesn't exist its no big deal in this case because we were dropping the table right afterwards.

    Atlassian JIRA | 7 years ago | Andrew Myers [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 12: "alter table cru_completed_frx drop foreign key FK927E9E9F1BD6EA47;" (Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152)), please contact http://www.atlassian.com/support/
  3. 0

    How to disable --skip-grant-tables in MySQL?

    Stack Overflow | 4 years ago | Jade
    java.sql.SQLException: The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Upgrading FeCru from 2.6.3 to 2.7.1 MySQL 5.0.32-Debian_7etch12-log {noformat} 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 {noformat} Upgrading while using MySQL 5.1.41-3ubuntu12.10 or 5.1.58 apple-darwin10.3.0 works fine.

    Atlassian JIRA | 5 years ago | Rene Verschoor [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script /opt/fecru-2.7.3/sql/MYSQL/schema/constraints_75.sql
  6. 0

    Upgrading FeCru from 2.6.3 to 2.7.1 MySQL 5.0.32-Debian_7etch12-log {noformat} 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 {noformat} Upgrading while using MySQL 5.1.41-3ubuntu12.10 or 5.1.58 apple-darwin10.3.0 works fine.

    Atlassian JIRA | 5 years ago | Rene Verschoor [Atlassian]
    com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script /opt/fecru-2.7.3/sql/MYSQL/schema/constraints_75.sql

  1. jshakil 3 times, last 1 month ago
5 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Error on rename of './fisheye/cru_completed_frx' to './fisheye/#sql2-148e-586' (errno: 152)

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    StatementImpl.executeUpdate
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
    2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
    5. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
    6. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)
    7. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642)
    8. com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1647)
    9. com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1566)
    9 frames
  3. com.cenqua.crucible
    DefaultDBControl.executeScript
    1. com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:377)
    1 frame