Issue Details (XML | Word | Printable)

Key: MBS-2986
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Oliver Charles
Reporter: Robert Kaye
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
MusicBrainz Server

tracklist_index was not populated during NGS

Created: 08/Jul/11 06:34 PM   Updated: 12/Jul/11 12:58 PM   Resolved: 12/Jul/11 12:58 PM
Component/s: CD support
Affects Version/s: None
Fix Version/s: Schema Change, 2011-07-11


 Description  « Hide

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)



Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.