)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":782,"name":"John Garbutt","email":"john@johngarbutt.com","username":"johngarbutt"},"change_message_id":"f5ca9723e4144190aa4023a1d6e5dd48e37f77f2","unresolved":false,"context_lines":[{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Currently in nova/network/neutronv2/api.py in _get_instance_uuids_by_ip"},{"line_number":10,"context_line":"we are searching via GET /v2.0/ports.json?fixed_ips\u003dip_address%3D192.168.1.1"},{"line_number":11,"context_line":"when we need to search by GET /v2.0/ports.json?ip_address\u003d192.168.1.1"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"In our production environment the current search is having timeouts with"},{"line_number":14,"context_line":"Neutron with even 5 minute timeout settings when database has millions"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"7a016987_0309b695","line":11,"updated":"2015-05-14 13:02:48.000000000","message":"Sorry, it doesn\u0027t seem clear to me why the less specific search would be faster?\n\nIs there something we can point to as to why thats the case? like does this difference hold true with ML2","commit_id":"c641449b0473e8c933a5f980f3b775b848b349c6"},{"author":{"_account_id":7924,"name":"Jason Meridth","email":"jmeridth@gmail.com","username":"jmeridth"},"change_message_id":"68d6ba897ba04bfac70d34b05eecc5be909f03ad","unresolved":false,"context_lines":[{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Currently in nova/network/neutronv2/api.py in _get_instance_uuids_by_ip"},{"line_number":10,"context_line":"we are searching via GET /v2.0/ports.json?fixed_ips\u003dip_address%3D192.168.1.1"},{"line_number":11,"context_line":"when we need to search by GET /v2.0/ports.json?ip_address\u003d192.168.1.1"},{"line_number":12,"context_line":""},{"line_number":13,"context_line":"In our production environment the current search is having timeouts with"},{"line_number":14,"context_line":"Neutron with even 5 minute timeout settings when database has millions"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"7a016987_2e95b9e3","line":11,"in_reply_to":"7a016987_0309b695","updated":"2015-05-14 13:37:46.000000000","message":"Can definitely make this clearer and give better data to support the change.  We\u0027re not using ML2, so....  We use https://github.com/rackerlabs/quark (as you know).  Please don\u0027t make this about switching to ML2 (which we have had many issues with and so have others).  We\u0027re in production, hence the suggested change.\n\nJohn: Can you help me understand why we\u0027re passing a query as a value? (ip_address%3D192.168.1.1)","commit_id":"c641449b0473e8c933a5f980f3b775b848b349c6"},{"author":{"_account_id":782,"name":"John Garbutt","email":"john@johngarbutt.com","username":"johngarbutt"},"change_message_id":"f5ca9723e4144190aa4023a1d6e5dd48e37f77f2","unresolved":false,"context_lines":[{"line_number":13,"context_line":"In our production environment the current search is having timeouts with"},{"line_number":14,"context_line":"Neutron with even 5 minute timeout settings when database has millions"},{"line_number":15,"context_line":"of rows of ip addresses."},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"Change-Id: Iea0cc613ee27cda6cde91d4fa49a40fae4cfd66b"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"7a016987_83f5a684","line":16,"updated":"2015-05-14 13:02:48.000000000","message":"You should get more eyes on this patch if you raise a bug that can track this patch.","commit_id":"c641449b0473e8c933a5f980f3b775b848b349c6"},{"author":{"_account_id":7924,"name":"Jason Meridth","email":"jmeridth@gmail.com","username":"jmeridth"},"change_message_id":"68d6ba897ba04bfac70d34b05eecc5be909f03ad","unresolved":false,"context_lines":[{"line_number":13,"context_line":"In our production environment the current search is having timeouts with"},{"line_number":14,"context_line":"Neutron with even 5 minute timeout settings when database has millions"},{"line_number":15,"context_line":"of rows of ip addresses."},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"Change-Id: Iea0cc613ee27cda6cde91d4fa49a40fae4cfd66b"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"7a016987_8e86edb7","line":16,"in_reply_to":"7a016987_83f5a684","updated":"2015-05-14 13:37:46.000000000","message":"That\u0027s like creating an issue on github so I can PR.  Very silly.  I\u0027ll do it though.","commit_id":"c641449b0473e8c933a5f980f3b775b848b349c6"},{"author":{"_account_id":7924,"name":"Jason Meridth","email":"jmeridth@gmail.com","username":"jmeridth"},"change_message_id":"60b6912b16f5800b595593c61f176fa206fdb96e","unresolved":false,"context_lines":[{"line_number":13,"context_line":"In our production environment the current search is having timeouts with"},{"line_number":14,"context_line":"Neutron with even 5 minute timeout settings when database has millions"},{"line_number":15,"context_line":"of rows of ip addresses."},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"Change-Id: Iea0cc613ee27cda6cde91d4fa49a40fae4cfd66b"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":3,"id":"7a016987_e91f9b59","line":16,"in_reply_to":"7a016987_8e86edb7","updated":"2015-05-14 13:42:14.000000000","message":"John explained off-line it helps with not getting lost in the backlog.  Fair enough.","commit_id":"c641449b0473e8c933a5f980f3b775b848b349c6"}]}