Description of problem: When upgrading a customer's db from 3.5 to 3.6, using the schema.sh script found in ovirt-engine repo, it fails in the last post upgrade script. The error is: 0030_set_default_cluster_for_registration.sql:4: ERROR: null value in column "option_value" violates not-null constraint The reason is that the following query return null into option_value, since the value in the name column is not 'Default': set option_value = (select vds_group_id from vds_groups where name ilike 'Default') How reproducible: run the schema.sh script on a db that returns null for the query: select vds_group_id from vds_groups where name ilike 'Default' Actual results: failure in upgrading the database Expected results: Additional info:
*** Bug 1226942 has been marked as a duplicate of this bug. ***
*** Bug 1221309 has been marked as a duplicate of this bug. ***
ovirt-3.6.0-3 release
Why does this bug depend on bug 1080542? 1080542 should not happen if you do not manually run one of the dbutils with user postgres.
Verified on: ovirt-engine-3.6.0-0.0.master.20150804111407.git122a3a0.el6.noarch Ran: ./schema.sh -v -s localhost -u engine -d engine -p 5432 -c apply Script execution completed successfully.