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

tracklist_index was not populated during NGS

    XMLWordPrintable

    Details

      Description

      The script that populates tracklist_index was not run during NGS. We will need to:

      On master:
      1. drop the table. (truncate, and repopulate while indexes are in place is going to be very slow, so drop it is)
      2. create the table again.
      3. run the population script: admin/sql/updates/ngs-cdlookup.sql
      4. dump the table data, move to FTP site.
      5. Create indexes, FKs and whatnot needed for this table.

      In slave:
      1. drop the table & re-create the table.
      2. ftp data dump from ftp site.
      3. import the data.
      4. create indexes, primary keys as appropriate.

      Finally, the toc is allowed to be NULL in the tracklist_index right now. That should be disallowed and we need to see why that is happening. (but that is less important right this second)

        Attachments

          Activity

            People

            • Assignee:
              acid2 Oliver Charles
              Reporter:
              rob Robert Kaye
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Packages

                Version Package
                Schema Change, 2011-07-11