patchwork.ozlabs.org offline for upgrade - Mon 13 April

[Jeremy Kerr]

Hi all,

> I see that there are a couple of large migrations in the 2.2.0 release,
> but hopefully they won't take too long. I'll send an update when we're
> done.

OK, we're back up and running on v2.2.0. Let me know if you see
anything odd post-upgrade.

A couple of notes:

 - by far the longest migration task was executing these queries:

    https://github.com/getpatchwork/patchwork/blob/v2.2.0/patchwork/migrations/0032_migrate_data_from_series_patch_to_patch.py#L18

   looks like that would be a good contender for an UPDATE .. FROM, 
   rather than the ~2 million subqueries

 - the database disk usage has increased by about 14%; I assume this is
   the new indexes.

That said, all went pretty smoothly, given the python & django upgrades
required too. Thanks patchworkers, and thanks to sfr for the help!

Cheers,


Jeremy