Comment 28 for bug 1824435

Just wanted to add a note on here, if you have already begun an upgrade (and run nova-manage db online_data_migrations) on a version prior to this fix landing and hit the error, there is a manual step you need to take in order for the upgrade (i.e. nova-manage db online_data_migrations) to work after you have applied the fix.

If you have a duplicate security_groups record with NULL user_id and project_id, you need to delete one of them. In this case, you would delete the record with id = 3.

> select id,name,description,user_id,project_id,deleted from security_groups;
+----+---------+-------------+----------------------------------+----------------------------------+---------+
| id | name | description | user_id | project_id | deleted |
+----+---------+-------------+----------------------------------+----------------------------------+---------+
| 1 | default | default | da452be8c38f42fe9527646f7da1683e | 5e9830de3b6b40b6b1269b6bd9659502 | 0 |
| 2 | default | default | NULL | NULL | 0 |
| 3 | default | default | NULL | NULL | 0 |
+----+---------+-------------+----------------------------------+----------------------------------+---------+

After you have deleted the duplicate security_groups record, try again and the nova-manage db online_data_migrations command should succeed.