)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"change_message_id":"8947005c1b0c0b6108eb56d4f06421e0510c5963","unresolved":false,"context_lines":[{"line_number":18,"context_line":"a postgres database. The change that causes this to be necessary"},{"line_number":19,"context_line":"must be relatively recent as this wasn\u0027t happening last week."},{"line_number":20,"context_line":""},{"line_number":21,"context_line":"The problem can show up when the outer join to the root_rp and"},{"line_number":22,"context_line":"parent_rp copies the resource_providers table can only produce"},{"line_number":23,"context_line":"a single row."},{"line_number":24,"context_line":""},{"line_number":25,"context_line":"[1] https://hub.docker.com/r/cdent/placedock/"},{"line_number":26,"context_line":""}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"9f6a8fd7_93ef4baf","line":23,"range":{"start_line":21,"start_character":0,"end_line":23,"end_character":13},"updated":"2018-04-19 12:53:02.000000000","message":"Sorry, I\u0027ve read this four times now and I can\u0027t parse it.  Brain goes off the rails starting at \"can only produce\".","commit_id":"be0ab23840c901e005a7e213d503be02a0da7362"},{"author":{"_account_id":14070,"name":"Eric Fried","email":"openstack@fried.cc","username":"efried"},"change_message_id":"c64b90233573f09cbc0284206de71bd3458bfe78","unresolved":false,"context_lines":[{"line_number":18,"context_line":"a postgres database. The change that causes this to be necessary"},{"line_number":19,"context_line":"must be relatively recent as this wasn\u0027t happening last week."},{"line_number":20,"context_line":""},{"line_number":21,"context_line":"The problem can show up when the outer join to the root_rp and"},{"line_number":22,"context_line":"parent_rp copies the resource_providers table can only produce"},{"line_number":23,"context_line":"a single row."},{"line_number":24,"context_line":""},{"line_number":25,"context_line":"[1] https://hub.docker.com/r/cdent/placedock/"},{"line_number":26,"context_line":""}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"9f6a8fd7_6e508e5e","line":23,"range":{"start_line":21,"start_character":0,"end_line":23,"end_character":13},"in_reply_to":"9f6a8fd7_2e9cd6be","updated":"2018-04-19 13:29:25.000000000","message":"Thanks.","commit_id":"be0ab23840c901e005a7e213d503be02a0da7362"},{"author":{"_account_id":11564,"name":"Chris Dent","email":"cdent@anticdent.org","username":"chdent"},"change_message_id":"921a75e6b70a26625ac12e55f69274fccd24de5a","unresolved":false,"context_lines":[{"line_number":18,"context_line":"a postgres database. The change that causes this to be necessary"},{"line_number":19,"context_line":"must be relatively recent as this wasn\u0027t happening last week."},{"line_number":20,"context_line":""},{"line_number":21,"context_line":"The problem can show up when the outer join to the root_rp and"},{"line_number":22,"context_line":"parent_rp copies the resource_providers table can only produce"},{"line_number":23,"context_line":"a single row."},{"line_number":24,"context_line":""},{"line_number":25,"context_line":"[1] https://hub.docker.com/r/cdent/placedock/"},{"line_number":26,"context_line":""}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"9f6a8fd7_2e9cd6be","line":23,"range":{"start_line":21,"start_character":0,"end_line":23,"end_character":13},"in_reply_to":"9f6a8fd7_93ef4baf","updated":"2018-04-19 13:06:43.000000000","message":"I copied from what jay said earlier and then made a slight adjustment that left out what is perhaps a critical word, can tune it up if you care enough: \"copies _of_ the\"\n\nThat is, there are two aliases of the rp table, one for root and one for parent. These joins are the things that are upsetting postgres, but not mysql, but only under particular conditions (which is why the parent patch doesn\u0027t fail).","commit_id":"be0ab23840c901e005a7e213d503be02a0da7362"}],"nova/api/openstack/placement/objects/resource_provider.py":[{"author":{"_account_id":7,"name":"Jay Pipes","email":"jaypipes@gmail.com","username":"jaypipes"},"change_message_id":"89acec52809860b24f02f1827ceede440fb00ffd","unresolved":false,"context_lines":[{"line_number":1603,"context_line":"            for (r_idx, amount) in resources.items()]"},{"line_number":1604,"context_line":"        query \u003d query.select_from(usage_join)"},{"line_number":1605,"context_line":"        query \u003d query.where(sa.or_(*where_clauses))"},{"line_number":1606,"context_line":"        query \u003d query.group_by(rp.c.id, root_rp.c.uuid, parent_rp.c.uuid)"},{"line_number":1607,"context_line":"        # NOTE(sbauza): Only RPs having all the asked resources can be provided"},{"line_number":1608,"context_line":"        query \u003d query.having(sql.func.count("},{"line_number":1609,"context_line":"            sa.distinct(_INV_TBL.c.resource_class_id)) \u003d\u003d len(resources))"}],"source_content_type":"text/x-python","patch_set":5,"id":"9f6a8fd7_843715b1","line":1606,"updated":"2018-04-18 22:10:23.000000000","message":"yeah, PostgreSQL doesn\u0027t know that the outer join to the root_rp copy of the resource_providers table can only produce a single row apparently. Same for the parent_rp copy of the resource_providers table.","commit_id":"d1ef1665204ee816ba111b9dcad7f4ee7716fe60"}]}