com.cenqua.crucible.hibernate.CruDBException during restore of the backup
症状
atlassian-fisheye.log に次のメッセージが表示される。
java.io.IOException: Error talking to database: Problem running drop script (you may have to manually drop the DB) D:\Atlassian\fe
cru-3.4.3\sql\SQLSERVER2008\schema\drop_76.sql
at com.atlassian.crucible.migration.item.SQLBackup.restore(SQLBackup.java:208)
at com.atlassian.crucible.migration.item.SQLBackup$1.restore(SQLBackup.java:173)
at com.cenqua.fisheye.ctl.Restore.run(Restore.java:197)
at com.cenqua.fisheye.ctl.Restore.main(Restore.java:273)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.cenqua.fisheye.FishEyeCtl.mainImpl(FishEyeCtl.java:99)
at com.cenqua.fisheye.FishEyeCtl.main(FishEyeCtl.java:42)
Caused by: com.cenqua.crucible.hibernate.CruDBException: Problem running drop script (you may have to manually drop the DB) D:\Atl
assian\fecru-3.4.3\sql\SQLSERVER2008\schema\drop_76.sql
at com.cenqua.crucible.hibernate.DefaultDBControl.dropTables(DefaultDBControl.java:356)
at com.atlassian.crucible.migration.item.DBImporter.importData(DBImporter.java:105)
at com.atlassian.crucible.migration.item.SQLBackup.restore(SQLBackup.java:192)
... 9 more
Caused by: com.cenqua.crucible.hibernate.CruDBException: SQL script error on line 1: "alter table cru_changeset_comment drop const
raint FK1C588BB9A697BC70;"
('FK1C588BB9A697BC70' is not a constraint.), 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.dropTables(DefaultDBControl.java:352)原因
This was observed while trying to restore a backup with Fisheye/Crucible still running.
ソリューション
- Stop Fisheye/Crucibe.
- Ensure to go over the restore process again using a clean database (from Migrating to an external database you can go to the page of each DBMS in order to check yours is configured properly).
- Make sure Fisheye/Crucible is stopped during the restore process.
最終更新日 2018 年 7 月 31 日
Powered by Confluence and Scroll Viewport.