Uploaded image for project: 'Confluence Server and Data Center'
  1. Confluence Server and Data Center
  2. CONFSERVER-5149

Unable to restore a backuped version (foreign key errors)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Highest
    • Resolution: Support Request
    • Affects Version/s: 2.1.1
    • Fix Version/s: None
    • Component/s: None
    • Environment:

      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

        1. confluence-2.1.2-debug.log
          928 kB
        2. fresh-setup-db-orders.log
          24 kB
        3. restore-on-fresh-setup-db-orders.sql
          61 kB
        4. stacktrace.txt
          21 kB
        5. stacktrace-standalone.txt
          11 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              17b12069583b Stephane Nicoll
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: