)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"change_message_id":"d6e515be3da893c464dded99b8996146965f0224","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":10,"id":"5971426b_c3ca749e","updated":"2022-05-11 22:34:17.000000000","message":"have not checked the full code but generated data lgtm - https://storage.bhs.cloud.ovh.net/v1/AUTH_dcaab5e32b234d56b626f72581e3644c/zuul_opendev_logs_ca6/839820/10/check/tempest-full-py3/ca64a13/controller/logs/performance.json","commit_id":"883365dbae32fa6c7939db3410c94edd43045299"},{"author":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"change_message_id":"57136fcf806b980fe95f3325cde19e84240d8255","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":11,"id":"d6ac455e_2c5b6a3a","updated":"2022-05-12 16:10:27.000000000","message":"recheck volume failure on cs9","commit_id":"fe52d7f0a88de2dc330923cf6cf52c83ccb92bd6"},{"author":{"_account_id":8556,"name":"Ghanshyam Maan","display_name":"Ghanshyam Maan","email":"gmaan.os14@gmail.com","username":"ghanshyam"},"change_message_id":"1e310ae007d1581069098e70c1af403d424b68c8","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":11,"id":"4543690b_0272ceb7","updated":"2022-05-17 22:23:28.000000000","message":"thanks. lgtm","commit_id":"fe52d7f0a88de2dc330923cf6cf52c83ccb92bd6"}],"lib/databases/mysql":[{"author":{"_account_id":13861,"name":"yatin","email":"ykarel@redhat.com","username":"yatinkarel"},"change_message_id":"507395bff0c11a58a29896572c3659bb6625af31","unresolved":true,"context_lines":[{"line_number":154,"context_line":"        echo \"enabling MySQL performance counting\""},{"line_number":155,"context_line":""},{"line_number":156,"context_line":"        # Install our sqlalchemy plugin"},{"line_number":157,"context_line":"        pip_install ${TOP_DIR}/tools/dbcounter"},{"line_number":158,"context_line":""},{"line_number":159,"context_line":"        # Create our stats database for accounting"},{"line_number":160,"context_line":"        recreate_database stats"}],"source_content_type":"application/x-shellscript","patch_set":11,"id":"9557ba66_34b24e5c","line":157,"updated":"2022-05-19 10:43:44.000000000","message":"this not working with ubuntu jammy 2022-05-19 08:47:55.185446 | controller |   × Getting requirements to build wheel did not run successfully.\n2022-05-19 08:47:55.185467 | controller |   │ exit code: 1\n2022-05-19 08:47:55.185479 | controller |   ╰─\u003e [4 lines of output]\n2022-05-19 08:47:55.185490 | controller |       Traceback (most recent call last):\n2022-05-19 08:47:55.185502 | controller |         File \"/usr/lib/python3/dist-packages/pip/_vendor/pep517/in_process/_in_process.py\", line 15, in \u003cmodule\u003e\n2022-05-19 08:47:55.185513 | controller |           from glob import glob\n2022-05-19 08:47:55.185524 | controller |       ModuleNotFoundError: No module named \u0027glob\u0027\n2022-05-19 08:47:55.185534 | controller |       [end of output]\n\n\nhttps://a85d35cbc0c739182972-b6afd4e7a056a6cd7e33e9056366401b.ssl.cf1.rackcdn.com/842127/3/check/devstack-platform-ubuntu-jammy/f9bb125/job-output.txt","commit_id":"fe52d7f0a88de2dc330923cf6cf52c83ccb92bd6"}],"stack.sh":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"ed85f7639316e3a2d3bf96f08994fe647f91a241","unresolved":true,"context_lines":[{"line_number":1518,"context_line":"        echo \"\""},{"line_number":1519,"context_line":"        echo \"Post-stack database query stats:\""},{"line_number":1520,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1521,"context_line":"              \u0027SELECT * FROM queries\u0027 -t 2\u003e/dev/null"},{"line_number":1522,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1523,"context_line":"              \u0027DELETE FROM queries\u0027 2\u003e/dev/null"},{"line_number":1524,"context_line":"    fi"}],"source_content_type":"text/x-sh","patch_set":11,"id":"0f975cc7_e566976f","line":1521,"updated":"2022-05-13 16:00:40.000000000","message":"Do we need to trigger a flush in the sqlalchemy plugin before dumping the stats or maybe wait for 30 seconds? I guess the simple thing here is probably good enough and avoid a lot of extra complexity or waiting.","commit_id":"fe52d7f0a88de2dc330923cf6cf52c83ccb92bd6"},{"author":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"change_message_id":"6dfba0dbc6fb6631d9610d4f7de311305a7716ea","unresolved":true,"context_lines":[{"line_number":1518,"context_line":"        echo \"\""},{"line_number":1519,"context_line":"        echo \"Post-stack database query stats:\""},{"line_number":1520,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1521,"context_line":"              \u0027SELECT * FROM queries\u0027 -t 2\u003e/dev/null"},{"line_number":1522,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1523,"context_line":"              \u0027DELETE FROM queries\u0027 2\u003e/dev/null"},{"line_number":1524,"context_line":"    fi"}],"source_content_type":"text/x-sh","patch_set":11,"id":"d4551946_a05ab053","line":1521,"in_reply_to":"0f975cc7_e566976f","updated":"2022-05-13 16:43:49.000000000","message":"I put limits into the plugin for time and number of queries so that we know the maximum amount of \"error\" we could be absorbing by doing this too quickly. So I think that we\u0027re okay not being too concerned. Dumping this table was really just for informational purposes before I wiped the slate before starting tempest. It doesn\u0027t even *need* to stay here, although it was highly informational regarding the keystone behavior. I could also collapse it by query type to keep it smaller.\n\nIn the tempest case, which is what I think we really care about, the post-run matter seems plenty long and slow to have all of the stuff flushed out by the plugin before we go and collect the stats, so I think we\u0027re good there.","commit_id":"fe52d7f0a88de2dc330923cf6cf52c83ccb92bd6"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"ed85f7639316e3a2d3bf96f08994fe647f91a241","unresolved":true,"context_lines":[{"line_number":1520,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1521,"context_line":"              \u0027SELECT * FROM queries\u0027 -t 2\u003e/dev/null"},{"line_number":1522,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1523,"context_line":"              \u0027DELETE FROM queries\u0027 2\u003e/dev/null"},{"line_number":1524,"context_line":"    fi"},{"line_number":1525,"context_line":"fi"},{"line_number":1526,"context_line":""}],"source_content_type":"text/x-sh","patch_set":11,"id":"e9e31ea6_d25c335a","line":1523,"updated":"2022-05-13 16:00:40.000000000","message":"I guess we do this so that the tempest triggered queries are counted in a separate set and we don\u0027t have to subtract the devstack queries from the tempest queries?","commit_id":"fe52d7f0a88de2dc330923cf6cf52c83ccb92bd6"},{"author":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"change_message_id":"6dfba0dbc6fb6631d9610d4f7de311305a7716ea","unresolved":true,"context_lines":[{"line_number":1520,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1521,"context_line":"              \u0027SELECT * FROM queries\u0027 -t 2\u003e/dev/null"},{"line_number":1522,"context_line":"        mysql -u $DATABASE_USER -p$DATABASE_PASSWORD -h $MYSQL_HOST stats -e \\"},{"line_number":1523,"context_line":"              \u0027DELETE FROM queries\u0027 2\u003e/dev/null"},{"line_number":1524,"context_line":"    fi"},{"line_number":1525,"context_line":"fi"},{"line_number":1526,"context_line":""}],"source_content_type":"text/x-sh","patch_set":11,"id":"45b6cffd_29ce2794","line":1523,"in_reply_to":"e9e31ea6_d25c335a","updated":"2022-05-13 16:43:49.000000000","message":"Yep, exactly. It avoids changes in devstack setup procedures from altering the numbers we\u0027re really trying to collect from the tempest run.","commit_id":"fe52d7f0a88de2dc330923cf6cf52c83ccb92bd6"}]}