Database consistency issues

Stephen Finucane stephen at that.guru
Wed Aug 29 20:41:58 AEST 2018


On Wed, 2018-08-08 at 12:27 -0400, Konstantin Ryabitsev wrote:
> On Thu, Aug 09, 2018 at 02:01:11AM +1000, Daniel Axtens wrote:
> > In the case of Patchwork 1.1.3, I am more confused - the Comment model
> > has a foreign key to Patch here. So if you try to delete Patch you
> > should have got a referential integrity error like I did with
> > e.g. Events. (Patchwork pre 2.0 is a pain to test as it uses Vagrant
> > VMs, which use VirtualBox by default, which breaks SecureBoot, so I'm
> > not going to try to get it going tonight.)
> > 
> > Was there anything you deleted after or during the migration?
> 
> Daniel:
> 
> Hmm... Well, the migration was a bit hairy, so it's possible something 
> did get missed. We migrated from 1.0, though, not from 1.1.3, so it's 
> possible something got missed? If it helps, I can send the database 
> schema that we currently have.

A copy of the schema, ideally before and after if you've a backup,
would be helpful. I don't know how much help I'll be but hopefully we
can have someone look at it.

Stephen



More information about the Patchwork mailing list