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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2016-02-08
    • Component/s: Admin
    • Labels:
      None

      Description

      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
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                2016-02-08