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