com.cenqua.crucible.hibernate.CruDBException

Problem with constraints script /Users/foong/Desktop/CustomWare/fisheye/fecru-3.5.3/sql/MYSQL/schema/constraints_87.sql

Samebug tips1

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

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web50

  • via Atlassian JIRA by Kah Loun Foong [Atlassian], 10 months ago
    Problem with constraints script /Users/foong/Desktop/CustomWare/fisheye/fecru-3.5.3/sql/MYSQL/schema/constraints_87.sql
  • via Atlassian JIRA by Kah Loun Foong [Atlassian], 1 year ago
    Problem with constraints script /Users/foong/Desktop/CustomWare/fisheye/fecru-3.5.3/sql/MYSQL/schema/constraints_87.sql
  • via Atlassian JIRA by Gustavo Refosco [Atlassian], 1 year ago
    Problem with create tables script /Users/grefosco/Documents/Atlassian/FishEye/fecru-2.2.0/sql/MYSQL/schema/tables_63.sql
  • Stack trace

    • com.cenqua.crucible.hibernate.CruDBException: Problem with constraints script /Users/foong/Desktop/CustomWare/fisheye/fecru-3.5.3/sql/MYSQL/schema/constraints_87.sql at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:411) at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:145) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:93) at com.atlassian.crucible.actions.admin.database.DBEditHelper$ImportRunner.call(DBEditHelper.java:75) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:744) Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 19: "alter table cru_changeset_comment add index FK1C588BB9A697BC70 (cru_user_id), add constraint FK1C588BB9A697BC70 foreign key (cru_user_id) references cru_user (cru_user_id);" (Duplicate index 'FK1C588BB9A697BC70' defined on the table 'fecru353.cru_changeset_comment'. This is deprecated and will be disallowed in a future release.), please contact http://www.atlassian.com/support/ at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:593) at com.cenqua.crucible.hibernate.DefaultDBControl.executeScript(DefaultDBControl.java:524) at com.cenqua.crucible.hibernate.DefaultDBControl.addConstraints(DefaultDBControl.java:405) ... 9 more Caused by: java.sql.SQLException: Duplicate index 'FK1C588BB9A697BC70' defined on the table 'fecru353.cru_changeset_comment'. This is deprecated and will be disallowed in a future release. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

    Write tip

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

    Users with the same issue

    Unknown user
    Once, 2 years ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    149 more bugmates