Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-8765

instrument_annotation should not be backed up in mbdump.tar.bz2

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 2016-02-08
    • None
    • Admin
    • None

      The table `instrument_annotation`, which is a derived one, has been added into @group_core in admin/ExportAllTables.

      Now that the instrument_annotation is packed into mbdump.tar.bz2, whereas the table `annotation` is not, on restoring a dump file into a new server, this breaks the foreign key constraint on `instrument_annotation` as nothing exists in `annotation` (CreateFKConstraints.sql), and fails the InitDb.pl.

      diff --git a/admin/ExportAllTables b/admin/ExportAllTables
index 9c056b7..f036c2c 100755
--- a/admin/ExportAllTables
+++ b/admin/ExportAllTables
@@ -76,7 +76,6 @@ my @group_core = qw(
     instrument
     instrument_alias
     instrument_alias_type
-    instrument_annotation
     instrument_gid_redirect
     instrument_type
     isrc
@@ -239,6 +238,7 @@ my @group_derived = qw(
     event_meta
     event_tag
     instrument_tag
+    instrument_annotation
     label_annotation
     label_meta
     label_tag

            bitmap Michael Wiencek
            ttflee ttflee
            Votes:
            1 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved:

                Version Package
                2016-02-08