)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},"change_message_id":"8b6e1784d8afd56a53653310e0aaced08362b312","unresolved":true,"context_lines":[{"line_number":27,"context_line":"May result in the database going through thousand of records (all"},{"line_number":28,"context_line":"deleted records and all records for other projects), as demonstrated by"},{"line_number":29,"context_line":"the following SQL queries where 10435 rows existed in the database and"},{"line_number":30,"context_line":"had to be checked just to return a single on."},{"line_number":31,"context_line":""},{"line_number":32,"context_line":"This is the SQL equivalent of the earlier cinder list command:"},{"line_number":33,"context_line":""}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"12580ed3_a02f8c32","line":30,"updated":"2023-02-08 04:48:03.000000000","message":"one","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"0da1ed17686141c517e6503674761b96f260666c","unresolved":false,"context_lines":[{"line_number":27,"context_line":"May result in the database going through thousand of records (all"},{"line_number":28,"context_line":"deleted records and all records for other projects), as demonstrated by"},{"line_number":29,"context_line":"the following SQL queries where 10435 rows existed in the database and"},{"line_number":30,"context_line":"had to be checked just to return a single on."},{"line_number":31,"context_line":""},{"line_number":32,"context_line":"This is the SQL equivalent of the earlier cinder list command:"},{"line_number":33,"context_line":""}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"2ab3be23_0394a8f8","line":30,"in_reply_to":"12580ed3_a02f8c32","updated":"2023-02-08 11:14:00.000000000","message":"Done","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"},{"author":{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},"change_message_id":"8b6e1784d8afd56a53653310e0aaced08362b312","unresolved":true,"context_lines":[{"line_number":52,"context_line":"snapshots, groups, group_snapshots, and backups tables, which will allow"},{"line_number":53,"context_line":"the database to do efficient retrieval of records for listings."},{"line_number":54,"context_line":""},{"line_number":55,"context_line":"The reason why we order first deleted and the project_id is because when"},{"line_number":56,"context_line":"an admin does a listing with `--all-tenants` that query will be able to"},{"line_number":57,"context_line":"use the deleted table of the new compound index."},{"line_number":58,"context_line":""}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"4d511ece_e503aa87","line":55,"range":{"start_line":55,"start_character":0,"end_line":55,"end_character":67},"updated":"2023-02-08 04:48:03.000000000","message":"I do not understand. This phrase makes no sense. Did you mean \"why we order by deleted and the project_id\" or ...?","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"0da1ed17686141c517e6503674761b96f260666c","unresolved":false,"context_lines":[{"line_number":52,"context_line":"snapshots, groups, group_snapshots, and backups tables, which will allow"},{"line_number":53,"context_line":"the database to do efficient retrieval of records for listings."},{"line_number":54,"context_line":""},{"line_number":55,"context_line":"The reason why we order first deleted and the project_id is because when"},{"line_number":56,"context_line":"an admin does a listing with `--all-tenants` that query will be able to"},{"line_number":57,"context_line":"use the deleted table of the new compound index."},{"line_number":58,"context_line":""}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"91ea38b1_6880174f","line":55,"range":{"start_line":55,"start_character":0,"end_line":55,"end_character":67},"in_reply_to":"4d511ece_e503aa87","updated":"2023-02-08 11:14:00.000000000","message":"I meant \"why we order by deleted and then project_id\", will fix it.","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"},{"author":{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},"change_message_id":"8b6e1784d8afd56a53653310e0aaced08362b312","unresolved":true,"context_lines":[{"line_number":71,"context_line":"| volumes |          1 | volumes_deleted_project_id_idx |            1 | deleted             | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |"},{"line_number":72,"context_line":"| volumes |          1 | volumes_deleted_project_id_idx |            2 | project_id          | A         |           6 |     NULL | NULL   | YES  | BTREE      |         |               |"},{"line_number":73,"context_line":"+---------+------------+--------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"$ mysql cinder -e \u0027explain select id, display_name from volumes where not deleted and project_id\u003d\"a41464e54125407aab09e0236cce2c3c\"\u0027"},{"line_number":76,"context_line":"+------+-------------+---------+------+--------------------------------+--------------------------------+---------+-------------+------+-----------------------+"},{"line_number":77,"context_line":"| id   | select_type | table   | type | possible_keys                  | key                            | key_len | ref         | rows | Extra                 |"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"3aa09406_365271c9","line":74,"updated":"2023-02-08 04:48:03.000000000","message":"Is it just me, of the  table volumes has redundant indexes attached (same key, only cardinality is different)? Please be gentle and tell me \"no\", I don\u0027t know anything about databases.","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"0da1ed17686141c517e6503674761b96f260666c","unresolved":false,"context_lines":[{"line_number":71,"context_line":"| volumes |          1 | volumes_deleted_project_id_idx |            1 | deleted             | A         |           4 |     NULL | NULL   | YES  | BTREE      |         |               |"},{"line_number":72,"context_line":"| volumes |          1 | volumes_deleted_project_id_idx |            2 | project_id          | A         |           6 |     NULL | NULL   | YES  | BTREE      |         |               |"},{"line_number":73,"context_line":"+---------+------------+--------------------------------+--------------+---------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+"},{"line_number":74,"context_line":""},{"line_number":75,"context_line":"$ mysql cinder -e \u0027explain select id, display_name from volumes where not deleted and project_id\u003d\"a41464e54125407aab09e0236cce2c3c\"\u0027"},{"line_number":76,"context_line":"+------+-------------+---------+------+--------------------------------+--------------------------------+---------+-------------+------+-----------------------+"},{"line_number":77,"context_line":"| id   | select_type | table   | type | possible_keys                  | key                            | key_len | ref         | rows | Extra                 |"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":6,"id":"21eb7a85_71b05569","line":74,"in_reply_to":"3aa09406_365271c9","updated":"2023-02-08 11:14:00.000000000","message":"I\u0027m no expert either.  ;-)\n\nIf you look even if the key is the same the key_name is also different.\n\nSo here we see column name \"deleted\" for the volumes table for both the \"volumes_service_uuid_idx\" and the \"volumes_deleted_project_id_idx\" indexes.\n\nThat\u0027s because these are composite indexes and not just single indexes, so one index uses (\u0027service_uuid\u0027, deleted\u0027) and the other (\u0027deleted\u0027, \u0027project_id\u0027).  Both have the deleted column, but they are different btrees, and the old index we had didn\u0027t even help queries using deleted in the filter (which are most of them) because it was the second field...\n\nIf you \n\nNote: I forgot to update this table with the latest output, so I\u0027ll update it.","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"}],"/PATCHSET_LEVEL":[{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"5e9ff960bd782d3afb55fab5fbc18c1b3a926e40","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":5,"id":"ca57623b_6283803a","updated":"2023-02-07 15:47:30.000000000","message":"I\u0027ll be adding some more indexes","commit_id":"3e3b3c6fd62cc2542956a1b14f74c0fca93a3477"},{"author":{"_account_id":597,"name":"Pete Zaitcev","email":"zaitcev@kotori.zaitcev.us","username":"zaitcev"},"change_message_id":"8b6e1784d8afd56a53653310e0aaced08362b312","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":6,"id":"cb818003_6a48887b","updated":"2023-02-08 04:48:03.000000000","message":"What do you think the impact of new indexes is going to be for insertions? Or do we list volumes much more often than create them?","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"0da1ed17686141c517e6503674761b96f260666c","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":6,"id":"5d670fc8_c7b82484","in_reply_to":"cb818003_6a48887b","updated":"2023-02-08 11:14:00.000000000","message":"I think the number of times we create/delete resources is usually significantly lower than the times these are queried in the different operations, and if we add the fact that we currently have to go through all the deleted rows and rows for other projects that means that Cinder has a scaling problem.\n\nI think these indexes are useful, but I\u0027m open to discussing them on a per-index basis if you think some may not be that useful.","commit_id":"6ed98cb0cf89c54e03aa8d0ef93b903f675d64b2"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"ac32c1ea798b590be82c948f6cc1afb811074202","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":7,"id":"27f13c75_815574e3","updated":"2023-03-03 12:47:34.000000000","message":"one issue noted in document which could be problematic for users in older releases since they would execute a repeated command (volume, project_id) and the (volume, host) index won\u0027t be created.","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"fdce18187bfa12816a0a59744dcfcb62baf49d7b","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":7,"id":"a7fd3fc2_66907eb2","in_reply_to":"27f13c75_815574e3","updated":"2023-03-03 12:49:31.000000000","message":"correction: (deleted, project_id) and (deleted, host)","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"},{"author":{"_account_id":5314,"name":"Brian Rosmaita","email":"rosmaita.fossdev@gmail.com","username":"brian-rosmaita"},"change_message_id":"0c663a30c2ea94a686bbbf121070b9063af18a30","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":9,"id":"64bd6463_b3b5d8e0","updated":"2023-03-06 13:50:05.000000000","message":"Thanks for fixing this.  Documentation will be helpful for operators using older releases; commit message will be helpful for anyone facing a similar issue with db performance.  Release note is excellent (except for the typo!). Docs and releasenote render nicely in HTML.\n\nUnfortunately, the typo is bad enough that we need to fix it now, I think.","commit_id":"2f74ccbbaa05fe8588f4a6a39eef2d55f99cf5a6"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"6f5bb27beb4dc8369d30f758c2de61ba8725f744","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":9,"id":"b6ccc518_acf608e1","updated":"2023-03-03 14:49:13.000000000","message":"my comments are addressed. LGTM.","commit_id":"2f74ccbbaa05fe8588f4a6a39eef2d55f99cf5a6"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"f1f61e10dd8f284a926bb2780698c994f213cc7d","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":9,"id":"b2a465d0_a33cc824","updated":"2023-03-04 14:46:33.000000000","message":"recheck multiple jobs failed, failing to find packages","commit_id":"2f74ccbbaa05fe8588f4a6a39eef2d55f99cf5a6"},{"author":{"_account_id":5314,"name":"Brian Rosmaita","email":"rosmaita.fossdev@gmail.com","username":"brian-rosmaita"},"change_message_id":"d2901a3875586f44b9766c7cb3382a78b6927a65","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"ac7cc42f_da700239","updated":"2023-03-06 13:54:25.000000000","message":"Only change is to the URL in a release note.","commit_id":"2b1a38499c0a5d4f0c49236b285878978027f3d0"},{"author":{"_account_id":5314,"name":"Brian Rosmaita","email":"rosmaita.fossdev@gmail.com","username":"brian-rosmaita"},"change_message_id":"a94e6de348056a71bcdefff6737708368459371c","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":11,"id":"b0de3b34_370260a1","updated":"2023-03-06 14:08:18.000000000","message":"Only change is to an http ref in a release note, so still +2 from me.","commit_id":"bbe42df26ca9df9ee09e6885d9b777259a888dcd"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"e306831158787c6451e2df1a6e724f5ec9d7d510","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":11,"id":"4fce930f_c72d9457","updated":"2023-03-06 14:08:57.000000000","message":"only releasenote change, still LGTM.","commit_id":"bbe42df26ca9df9ee09e6885d9b777259a888dcd"}],"cinder/db/migrations/versions/daa98075b90d_add_resource_indexes.py":[{"author":{"_account_id":11655,"name":"Julia Kreger","email":"juliaashleykreger@gmail.com","username":"jkreger","status":"Flying to the moon with a Jetpack!"},"change_message_id":"eaf477cb3929161f6bad48d615880ff93cb72f2b","unresolved":true,"context_lines":[{"line_number":29,"context_line":""},{"line_number":30,"context_line":"def upgrade():"},{"line_number":31,"context_line":"    for table in (\u0027groups\u0027, \u0027volumes\u0027, \u0027snapshots\u0027, \u0027backups\u0027):"},{"line_number":32,"context_line":"        op.create_index(f\u0027{table}_project_id_deleted_idx\u0027,"},{"line_number":33,"context_line":"                        table,"},{"line_number":34,"context_line":"                        (\u0027project_id\u0027, \u0027deleted\u0027)),"}],"source_content_type":"text/x-python","patch_set":3,"id":"c90bbed8_5d6ad6fe","line":32,"updated":"2023-02-03 15:24:42.000000000","message":"One thought here, we had to do something similar in ironic, and one thing which sort of helped us experience wise was toa lso check if the index exists. That doesn\u0027t work with non-mysql databases, but if the name matches then it can skip.\n\nhttps://github.com/openstack/ironic/blob/master/ironic/db/sqlalchemy/alembic/versions/ac00b586ab95_node_indexes.py#L42-L48\n\nWe explicitly did this because we documented the missing indexes and how to add them, since we realized... they were kind of a big performance impact that operators of older versions might want/need.","commit_id":"88abe91a2cd74feea63d182b4b7097702a450947"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"0da1ed17686141c517e6503674761b96f260666c","unresolved":false,"context_lines":[{"line_number":29,"context_line":""},{"line_number":30,"context_line":"def upgrade():"},{"line_number":31,"context_line":"    for table in (\u0027groups\u0027, \u0027volumes\u0027, \u0027snapshots\u0027, \u0027backups\u0027):"},{"line_number":32,"context_line":"        op.create_index(f\u0027{table}_project_id_deleted_idx\u0027,"},{"line_number":33,"context_line":"                        table,"},{"line_number":34,"context_line":"                        (\u0027project_id\u0027, \u0027deleted\u0027)),"}],"source_content_type":"text/x-python","patch_set":3,"id":"a80d7e94_9a4c109c","line":32,"in_reply_to":"c90bbed8_5d6ad6fe","updated":"2023-02-08 11:14:00.000000000","message":"Thanks for the suggestion. I have followed it in my latest patch.","commit_id":"88abe91a2cd74feea63d182b4b7097702a450947"}],"doc/source/admin/ts-db-cpu-spikes.rst":[{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"ac32c1ea798b590be82c948f6cc1afb811074202","unresolved":true,"context_lines":[{"line_number":14,"context_line":"Adding indexes"},{"line_number":15,"context_line":"--------------"},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"In older releases, before Antelope, there were some tables that performed"},{"line_number":18,"context_line":"poorly in the presence of a large number of deleted resources (volumes,"},{"line_number":19,"context_line":"snapshots, backups, etc) which resulted in high CPU loads on the DB servers not"},{"line_number":20,"context_line":"only when listing those resources, but also when doing some operations on them."}],"source_content_type":"text/x-rst","patch_set":7,"id":"8aee019b_316ee4af","line":17,"range":{"start_line":17,"start_character":26,"end_line":17,"end_character":34},"updated":"2023-03-03 12:47:34.000000000","message":"nit: better to mention the official name along with the name used for \"marketing\" purposes like, 2023.1 (Antelope)","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"f0376be0b00ef26aff75f627d177c3b332ca4e64","unresolved":false,"context_lines":[{"line_number":14,"context_line":"Adding indexes"},{"line_number":15,"context_line":"--------------"},{"line_number":16,"context_line":""},{"line_number":17,"context_line":"In older releases, before Antelope, there were some tables that performed"},{"line_number":18,"context_line":"poorly in the presence of a large number of deleted resources (volumes,"},{"line_number":19,"context_line":"snapshots, backups, etc) which resulted in high CPU loads on the DB servers not"},{"line_number":20,"context_line":"only when listing those resources, but also when doing some operations on them."}],"source_content_type":"text/x-rst","patch_set":7,"id":"99a2b4b0_0bcdfd6e","line":17,"range":{"start_line":17,"start_character":26,"end_line":17,"end_character":34},"in_reply_to":"8aee019b_316ee4af","updated":"2023-03-03 13:29:49.000000000","message":"Done","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"ac32c1ea798b590be82c948f6cc1afb811074202","unresolved":true,"context_lines":[{"line_number":23,"context_line":"This example below is specific to MariaDB/MySQL, but the syntax should be easy"},{"line_number":24,"context_line":"to modify for operators using PostgreSQL, and it represents the changes that"},{"line_number":25,"context_line":"older releases could add to resolve these DB server CPU spikes in such a way"},{"line_number":26,"context_line":"that they would not conflict with the ones that Cinder introduced in Antelope."},{"line_number":27,"context_line":""},{"line_number":28,"context_line":".. code-block:: sql"},{"line_number":29,"context_line":""}],"source_content_type":"text/x-rst","patch_set":7,"id":"eda85a48_ab57f83e","line":26,"range":{"start_line":26,"start_character":69,"end_line":26,"end_character":77},"updated":"2023-03-03 12:47:34.000000000","message":"same","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"f0376be0b00ef26aff75f627d177c3b332ca4e64","unresolved":false,"context_lines":[{"line_number":23,"context_line":"This example below is specific to MariaDB/MySQL, but the syntax should be easy"},{"line_number":24,"context_line":"to modify for operators using PostgreSQL, and it represents the changes that"},{"line_number":25,"context_line":"older releases could add to resolve these DB server CPU spikes in such a way"},{"line_number":26,"context_line":"that they would not conflict with the ones that Cinder introduced in Antelope."},{"line_number":27,"context_line":""},{"line_number":28,"context_line":".. code-block:: sql"},{"line_number":29,"context_line":""}],"source_content_type":"text/x-rst","patch_set":7,"id":"303f772e_8f96d009","line":26,"range":{"start_line":26,"start_character":69,"end_line":26,"end_character":77},"in_reply_to":"eda85a48_ab57f83e","updated":"2023-03-03 13:29:49.000000000","message":"Done","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"ac32c1ea798b590be82c948f6cc1afb811074202","unresolved":true,"context_lines":[{"line_number":31,"context_line":"   create index groups_deleted_project_id_idx on groups (deleted, project_id);"},{"line_number":32,"context_line":"   create index group_snapshots_deleted_project_id_idx on groups (deleted, project_id);"},{"line_number":33,"context_line":"   create index volumes_deleted_project_id_idx on volumes (deleted, project_id);"},{"line_number":34,"context_line":"   create index volumes_deleted_host_idx on volumes (deleted, project_id);"},{"line_number":35,"context_line":"   create index snapshots_deleted_project_id_idx on snapshots (deleted, project_id);"},{"line_number":36,"context_line":"   create index backups_deleted_project_id_idx on backups (deleted, project_id);"}],"source_content_type":"text/x-rst","patch_set":7,"id":"c3e548ec_27008e8f","line":34,"range":{"start_line":34,"start_character":62,"end_line":34,"end_character":72},"updated":"2023-03-03 12:47:34.000000000","message":"shouldn\u0027t this be host?","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"},{"author":{"_account_id":9535,"name":"Gorka Eguileor","email":"geguileo@redhat.com","username":"Gorka"},"change_message_id":"f0376be0b00ef26aff75f627d177c3b332ca4e64","unresolved":false,"context_lines":[{"line_number":31,"context_line":"   create index groups_deleted_project_id_idx on groups (deleted, project_id);"},{"line_number":32,"context_line":"   create index group_snapshots_deleted_project_id_idx on groups (deleted, project_id);"},{"line_number":33,"context_line":"   create index volumes_deleted_project_id_idx on volumes (deleted, project_id);"},{"line_number":34,"context_line":"   create index volumes_deleted_host_idx on volumes (deleted, project_id);"},{"line_number":35,"context_line":"   create index snapshots_deleted_project_id_idx on snapshots (deleted, project_id);"},{"line_number":36,"context_line":"   create index backups_deleted_project_id_idx on backups (deleted, project_id);"}],"source_content_type":"text/x-rst","patch_set":7,"id":"3a2c5de0_fb193686","line":34,"range":{"start_line":34,"start_character":62,"end_line":34,"end_character":72},"in_reply_to":"c3e548ec_27008e8f","updated":"2023-03-03 13:29:49.000000000","message":"YES!!","commit_id":"2623a0567f1931e68b43ac9b242c1c113f650e3b"}],"releasenotes/notes/db-resource-indexes-8010c9a881277503.yaml":[{"author":{"_account_id":5314,"name":"Brian Rosmaita","email":"rosmaita.fossdev@gmail.com","username":"brian-rosmaita"},"change_message_id":"0c663a30c2ea94a686bbbf121070b9063af18a30","unresolved":true,"context_lines":[{"line_number":16,"context_line":""},{"line_number":17,"context_line":"    An example of the SQL commands to generate these indexes can be found"},{"line_number":18,"context_line":"    in the `specific troubleshooting guide"},{"line_number":19,"context_line":"    \u003chtts://docs.openstack.org/ironic/latest/admin/ts-db-spikes.html\u003e`_."},{"line_number":20,"context_line":"fixes:"},{"line_number":21,"context_line":"  - |"},{"line_number":22,"context_line":"    `Bug #1952443 \u003chttps://bugs.launchpad.net/cinder/+bug/1952443\u003e`_: Improve"}],"source_content_type":"text/x-yaml","patch_set":9,"id":"4b85b803_586a0a0d","line":19,"range":{"start_line":19,"start_character":31,"end_line":19,"end_character":37},"updated":"2023-03-06 13:50:05.000000000","message":"ummm ... cinder?","commit_id":"2f74ccbbaa05fe8588f4a6a39eef2d55f99cf5a6"},{"author":{"_account_id":5314,"name":"Brian Rosmaita","email":"rosmaita.fossdev@gmail.com","username":"brian-rosmaita"},"change_message_id":"a94e6de348056a71bcdefff6737708368459371c","unresolved":false,"context_lines":[{"line_number":16,"context_line":""},{"line_number":17,"context_line":"    An example of the SQL commands to generate these indexes can be found"},{"line_number":18,"context_line":"    in the `specific troubleshooting guide"},{"line_number":19,"context_line":"    \u003chtts://docs.openstack.org/ironic/latest/admin/ts-db-spikes.html\u003e`_."},{"line_number":20,"context_line":"fixes:"},{"line_number":21,"context_line":"  - |"},{"line_number":22,"context_line":"    `Bug #1952443 \u003chttps://bugs.launchpad.net/cinder/+bug/1952443\u003e`_: Improve"}],"source_content_type":"text/x-yaml","patch_set":9,"id":"13e705de_00845b88","line":19,"range":{"start_line":19,"start_character":31,"end_line":19,"end_character":37},"in_reply_to":"4b85b803_586a0a0d","updated":"2023-03-06 14:08:18.000000000","message":"Done","commit_id":"2f74ccbbaa05fe8588f4a6a39eef2d55f99cf5a6"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"925911e92ed2d9a58ab7f08521f6e57bae43bb54","unresolved":true,"context_lines":[{"line_number":16,"context_line":""},{"line_number":17,"context_line":"    An example of the SQL commands to generate these indexes can be found"},{"line_number":18,"context_line":"    in the `specific troubleshooting guide"},{"line_number":19,"context_line":"    \u003chtts://docs.openstack.org/cinder/latest/admin/ts-db-spikes.html\u003e`_."},{"line_number":20,"context_line":"fixes:"},{"line_number":21,"context_line":"  - |"},{"line_number":22,"context_line":"    `Bug #1952443 \u003chttps://bugs.launchpad.net/cinder/+bug/1952443\u003e`_: Improve"}],"source_content_type":"text/x-yaml","patch_set":10,"id":"7296a539_d8e3827b","line":19,"range":{"start_line":19,"start_character":51,"end_line":19,"end_character":63},"updated":"2023-03-06 14:02:02.000000000","message":"I think this will be ts-db-cpu-spikes\n\nhttps://review.opendev.org/c/openstack/cinder/+/819669/10/doc/source/admin/ts-db-cpu-spikes.rst","commit_id":"2b1a38499c0a5d4f0c49236b285878978027f3d0"},{"author":{"_account_id":27615,"name":"Rajat Dhasmana","email":"rajatdhasmana@gmail.com","username":"whoami-rajat"},"change_message_id":"b62e83026596042be4f5a6b8e71170600cb1102c","unresolved":false,"context_lines":[{"line_number":16,"context_line":""},{"line_number":17,"context_line":"    An example of the SQL commands to generate these indexes can be found"},{"line_number":18,"context_line":"    in the `specific troubleshooting guide"},{"line_number":19,"context_line":"    \u003chtts://docs.openstack.org/cinder/latest/admin/ts-db-spikes.html\u003e`_."},{"line_number":20,"context_line":"fixes:"},{"line_number":21,"context_line":"  - |"},{"line_number":22,"context_line":"    `Bug #1952443 \u003chttps://bugs.launchpad.net/cinder/+bug/1952443\u003e`_: Improve"}],"source_content_type":"text/x-yaml","patch_set":10,"id":"eb47ab8f_f6913302","line":19,"range":{"start_line":19,"start_character":51,"end_line":19,"end_character":63},"in_reply_to":"7296a539_d8e3827b","updated":"2023-03-06 14:05:41.000000000","message":"Done\n\nhttps://5e58f4bf6e2b5a73e23d-7dcadb3b825be6bd9a7713f5f71202a8.ssl.cf1.rackcdn.com/819669/9/check/openstack-tox-docs/5b6ed94/docs/admin/ts-db-cpu-spikes.html","commit_id":"2b1a38499c0a5d4f0c49236b285878978027f3d0"}]}