Details
-
Bug
-
Resolution: Support Request
-
Highest
-
None
-
2.1.1
-
None
-
Tomcat 4.1.31, Mysql 4.1.16 running with connector/J 3.0.17 (mysql-connector-java-3.0.17-ga-bin.jar)
Description
See CSP-2113 for an history of the issue on your support system.
We just started using confluence in production and I had once an annoying message regarding foreign key errors:
2005-12-28 17:45:55,735 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table os_user_group add constraint FK932472461E2E76DB foreign key (group_id) references os_group (id)
2005-12-28 17:45:55,735 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-a30_a.frm' (errno: 150)"
[...] others (see attachment)
I was using mysql 4.0 so I thought it was a DB problem. I have just installed 4.1.16 and created a few pages (20 with 2 attachments). I did not have any foreign key errors this time. I then backuped, cleaned everything and tried to restor from backup and I still have those foreing key errors.
It means that I cannot use confluence in production at the moment because I will be unable to restore from it if I have any problem.
Attachments
Issue Links
- duplicates
-
CONFSERVER-5153 Error restoring on MySQL
- Closed