sampledata is corrupt

Bug #344324 reported by Stuart Bishop
2
Affects Status Importance Assigned to Milestone
Launchpad itself
Fix Released
High
Stuart Bishop

Bug Description

When restoring sampledata, we:
 - Turn off database constraints
 - Restore the data
 - Turn on database constraints

That final doesn't detect corrupt data, such as the teamparticipation and teammembership entries referencing the non-existant person 243624.

This happens when people edit the sample data by hand.

We can protect against the corruption by doing a pg_dump and pg_restore of the database. If this fails, the database is corrupt. This can be part of the test suite.

Stuart Bishop (stub)
Changed in launchpad-foundations:
assignee: nobody → stub
importance: Undecided → High
milestone: none → 2.2.3
status: New → Triaged
Revision history for this message
Francis J. Lacoste (flacoste) wrote :

There is a branch in review for this one.

Changed in launchpad-foundations:
milestone: 2.2.3 → 2.2.4
status: Triaged → In Progress
Stuart Bishop (stub)
Changed in launchpad-foundations:
status: In Progress → Fix Committed
Stuart Bishop (stub)
Changed in launchpad-foundations:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.