com.cenqua.crucible.hibernate.CruDBException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

MySQL doesn't support some types of characters (such as emojis) with the utf8 encoding. You need to be on MySQL 5.5+ and force utf8mb4 (everywhere, client and server). You can do this sending the query "SET NAMES utf8mb4". Check this https://goo.gl/3E2qzg

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • 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.
    via by Rene Verschoor [Atlassian],
  • 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.
    via by Rene Verschoor [Atlassian],
  • How to disable --skip-grant-tables in MySQL?
    via Stack Overflow by Jade
    ,
  • 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.
    via by Andrew Myers [Atlassian],
  • 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.
    via by Andrew Myers [Atlassian],
  • How to export a table from mysql using java
    via Stack Overflow by Dhinakar
    ,
  • Problems with MySQL…
    via GitHub by alfista-sk
    ,
  • mvn cat:install 权限问题
    via GitHub by dozer47528
    ,
  • Inserting values from JTable to MySQL
    via Stack Overflow by ridhi
    ,
    • 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

    Users with the same issue

    AxeloAxelo
    5 times, last one,
    jshakiljshakil
    3 times, last one,
    Unknown visitor
    Unknown visitor2 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    145 more bugmates