On 01/10/2017 05:57 PM, Mátyás Selmeci wrote:
I'm trying to upgrade a koji installation from 1.6 to 1.11. The database
boggling at 1.6, that's.... six years ago
migrate scripts work all the way up to 1.10, but
schema-upgrade-1.10-1.11.sql errors out when trying to add the
"container_sane" constraint to the "buildroot" table.
I think what's going on is:
- the constraint is to make sure container_type and container_arch are
either both NULL or neither NULL
- the container_type column is new in 1.11, so when the migration script
adds it, all the values are NULL
- the container_arch column is a renaming of the arch column, where arch
(for us) is either "i386" or "x86_64", never NULL
What do you suggest I do?