)]}'
{"specs/victoria/remove-quota-usage-cache.rst":[{"author":{"_account_id":18058,"name":"Lucio Seki","email":"lseki@redhat.com","username":"lseki"},"change_message_id":"dbe25c5aa86e8e5cad15e225ad27cde991de9253","unresolved":false,"context_lines":[{"line_number":21,"context_line":""},{"line_number":22,"context_line":"Use Cases"},{"line_number":23,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":24,"context_line":"As a use I would like to create a volume and not get an error saying I\u0027m out"},{"line_number":25,"context_line":"of quota when I know that I\u0027m not based on my current usage."},{"line_number":26,"context_line":""},{"line_number":27,"context_line":"Proposed change"}],"source_content_type":"text/x-rst","patch_set":1,"id":"ff570b3c_3a40e407","line":24,"range":{"start_line":24,"start_character":5,"end_line":24,"end_character":8},"updated":"2020-05-26 17:48:38.000000000","message":"user","commit_id":"d72272622dbeac330ac7ebf048945e1ababc27b3"},{"author":{"_account_id":18058,"name":"Lucio Seki","email":"lseki@redhat.com","username":"lseki"},"change_message_id":"dbe25c5aa86e8e5cad15e225ad27cde991de9253","unresolved":false,"context_lines":[{"line_number":40,"context_line":""},{"line_number":41,"context_line":"Data model impact"},{"line_number":42,"context_line":"-----------------"},{"line_number":43,"context_line":"Removal of the quota_usages table. This is pretty independant so would be a minimal change."},{"line_number":44,"context_line":""},{"line_number":45,"context_line":"REST API impact"},{"line_number":46,"context_line":"---------------"}],"source_content_type":"text/x-rst","patch_set":1,"id":"ff570b3c_fa5e6ce7","line":43,"range":{"start_line":43,"start_character":50,"end_line":43,"end_character":61},"updated":"2020-05-26 17:48:38.000000000","message":"independent","commit_id":"d72272622dbeac330ac7ebf048945e1ababc27b3"},{"author":{"_account_id":1736,"name":"Ivan Kolodyazhny","email":"e0ne@e0ne.info","username":"e0ne"},"change_message_id":"6a91009ca73899650ee8c81d9867ad8d495232f5","unresolved":false,"context_lines":[{"line_number":58,"context_line":"---------------------"},{"line_number":59,"context_line":"None"},{"line_number":60,"context_line":""},{"line_number":61,"context_line":"Performance Impact"},{"line_number":62,"context_line":"------------------"},{"line_number":63,"context_line":"Because quota usage would be calculated on the fly there could be a slight increase in"},{"line_number":64,"context_line":"creating resources. But I expect this would be so small in the scheme of things."}],"source_content_type":"text/x-rst","patch_set":1,"id":"ff570b3c_b0ae69e4","line":61,"range":{"start_line":61,"start_character":0,"end_line":61,"end_character":18},"updated":"2020-06-02 12:47:50.000000000","message":"It would be good to have some performance tests results","commit_id":"d72272622dbeac330ac7ebf048945e1ababc27b3"},{"author":{"_account_id":18058,"name":"Lucio Seki","email":"lseki@redhat.com","username":"lseki"},"change_message_id":"b1ecfd2000e9ee5d31e1c7a3eceb5c3cebabac94","unresolved":false,"context_lines":[{"line_number":71,"context_line":""},{"line_number":72,"context_line":"Current system:"},{"line_number":73,"context_line":""},{"line_number":74,"context_line":"MariaDB [cinder]\u003e SELECT * FROM quota_usages WHERE project_id \u003d \u00277e479322bf754b2ca4945e18f28317ed\u0027;"},{"line_number":75,"context_line":"+---------------------+---------------------+------------+---------+-------+----------------------------------+---------------------+--------+----------+---------------+"},{"line_number":76,"context_line":"| created_at          | updated_at          | deleted_at | deleted | id    | project_id                       | resource            | in_use | reserved | until_refresh |"},{"line_number":77,"context_line":"+---------------------+---------------------+------------+---------+-------+----------------------------------+---------------------+--------+----------+---------------+"}],"source_content_type":"text/x-rst","patch_set":2,"id":"bf51134e_b508b72d","line":74,"updated":"2020-06-30 14:53:39.000000000","message":"You may want to use a code block markup [0] here, to have it rendered prettier than this [1].\n\n[0] https://www.sphinx-doc.org/en/1.5/markup/code.html\n[1] https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_f4d/730701/2/check/openstack-tox-docs/f4d4868/docs/specs/victoria/remove-quota-usage-cache.html","commit_id":"24f4f99151c0e060fe556c1ff333b2db49d01409"},{"author":{"_account_id":18058,"name":"Lucio Seki","email":"lseki@redhat.com","username":"lseki"},"change_message_id":"b1ecfd2000e9ee5d31e1c7a3eceb5c3cebabac94","unresolved":false,"context_lines":[{"line_number":87,"context_line":""},{"line_number":88,"context_line":"Calculating from volumes table:"},{"line_number":89,"context_line":""},{"line_number":90,"context_line":"MariaDB [cinder]\u003e SELECT SUM(size), COUNT(*) FROM volumes WHERE project_id \u003d \u00277e479322bf754b2ca4945e18f28317ed\u0027;"},{"line_number":91,"context_line":"+-----------+----------+"},{"line_number":92,"context_line":"| sum(size) | count(*) |"},{"line_number":93,"context_line":"+-----------+----------+"}],"source_content_type":"text/x-rst","patch_set":2,"id":"bf51134e_1506c321","line":90,"updated":"2020-06-30 14:53:39.000000000","message":"same as above","commit_id":"24f4f99151c0e060fe556c1ff333b2db49d01409"},{"author":{"_account_id":4523,"name":"Eric Harney","email":"eharney@redhat.com","username":"eharney"},"change_message_id":"0a499279949121a9d85ee910801c57f2a89f2650","unresolved":false,"context_lines":[{"line_number":95,"context_line":"+-----------+----------+"},{"line_number":96,"context_line":"1 row in set (0.04 sec)"},{"line_number":97,"context_line":""},{"line_number":98,"context_line":""},{"line_number":99,"context_line":"Other deployer impact"},{"line_number":100,"context_line":"---------------------"},{"line_number":101,"context_line":"None"}],"source_content_type":"text/x-rst","patch_set":2,"id":"bf51134e_80bf21cf","line":98,"updated":"2020-07-01 14:27:31.000000000","message":"We should review our database schema and see if we can optimize performance of these queries by adding indexes etc. to the DB.","commit_id":"24f4f99151c0e060fe556c1ff333b2db49d01409"},{"author":{"_account_id":28948,"name":"Liang Fang","email":"liang.a.fang@intel.com","username":"liang"},"change_message_id":"e17edd60f54e2e810c4bde1fbdbc171d239427d6","unresolved":false,"context_lines":[{"line_number":112,"context_line":""},{"line_number":113,"context_line":"Work Items"},{"line_number":114,"context_line":"----------"},{"line_number":115,"context_line":""},{"line_number":116,"context_line":"Dependencies"},{"line_number":117,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":118,"context_line":"None"}],"source_content_type":"text/x-rst","patch_set":2,"id":"bf51134e_dbb0eae0","line":115,"updated":"2020-07-01 15:30:43.000000000","message":"Should summarize the work items here?","commit_id":"24f4f99151c0e060fe556c1ff333b2db49d01409"},{"author":{"_account_id":28948,"name":"Liang Fang","email":"liang.a.fang@intel.com","username":"liang"},"change_message_id":"e17edd60f54e2e810c4bde1fbdbc171d239427d6","unresolved":false,"context_lines":[{"line_number":119,"context_line":""},{"line_number":120,"context_line":"Testing"},{"line_number":121,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":122,"context_line":"* Add related unit tests"},{"line_number":123,"context_line":""},{"line_number":124,"context_line":"Documentation Impact"},{"line_number":125,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":2,"id":"bf51134e_9b2952f4","line":122,"range":{"start_line":122,"start_character":14,"end_line":122,"end_character":24},"updated":"2020-07-01 15:30:43.000000000","message":"this impact all the DB calling to table quota_usages, not sure UT can handle DB change.","commit_id":"24f4f99151c0e060fe556c1ff333b2db49d01409"}]}