)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":5948,"name":"Oleg Bondarev","email":"obondarev@mirantis.com","username":"obondarev"},"change_message_id":"16c8d9b4f1ea08ce0bbc09e6120e8c9ef8bc0c46","unresolved":true,"context_lines":[{"line_number":7,"context_line":"Group execution of SQL functional tests"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Functional SQL tests (MySQL and PostgreSQL) use the DB installed"},{"line_number":10,"context_line":"backend. To avoid overloading the DB engine, the test cases are"},{"line_number":11,"context_line":"grouped [1] together and executed by the same worker process. That"},{"line_number":12,"context_line":"will ensure those tests are not executed in parallel, interfering"},{"line_number":13,"context_line":"each other."}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"1bba5804_d953b815","line":10,"range":{"start_line":10,"start_character":9,"end_line":10,"end_character":43},"updated":"2021-04-12 07:24:09.000000000","message":"Can mysql and postgre tests use same DB engine at the same time? I thought each worker has it\u0027s own one..","commit_id":"7326fd622f2c3cb36681136d79e39e4efdda5411"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"a66fe838c13e032716693f8f8a275532411c43af","unresolved":true,"context_lines":[{"line_number":7,"context_line":"Group execution of SQL functional tests"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Functional SQL tests (MySQL and PostgreSQL) use the DB installed"},{"line_number":10,"context_line":"backend. To avoid overloading the DB engine, the test cases are"},{"line_number":11,"context_line":"grouped [1] together and executed by the same worker process. That"},{"line_number":12,"context_line":"will ensure those tests are not executed in parallel, interfering"},{"line_number":13,"context_line":"each other."}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"f7bd161c_d84c8b86","line":10,"range":{"start_line":10,"start_character":9,"end_line":10,"end_character":43},"in_reply_to":"1bba5804_d953b815","updated":"2021-04-12 08:50:08.000000000","message":"Right, each one has its own DB engine. Initially it tested using two \"group_regex\" inputs but I tested using only one (PS2) and each class has its own separate worker. Please, take a look at.\n- TestModelsMigrationsMysql: worker 7\n- TestModelsMigrationsPsql: worker 3\n\nWith this new input parameter we group each DB engine class tests in one worker.\n\n[1]https://zuul.opendev.org/t/openstack/build/2af941954ceb491c8ec393080856b6b3/log/job-output.txt","commit_id":"7326fd622f2c3cb36681136d79e39e4efdda5411"},{"author":{"_account_id":16688,"name":"Rodolfo Alonso","email":"ralonsoh@redhat.com","username":"rodolfo-alonso-hernandez"},"change_message_id":"f65dd6bd9224beba8db11bec8c161cc6dbce4f4f","unresolved":true,"context_lines":[{"line_number":7,"context_line":"Group execution of SQL functional tests"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Functional SQL tests (MySQL and PostgreSQL) use the DB installed"},{"line_number":10,"context_line":"backend. To avoid overloading the DB engine, the test cases are"},{"line_number":11,"context_line":"grouped [1] together and executed by the same worker process. That"},{"line_number":12,"context_line":"will ensure those tests are not executed in parallel, interfering"},{"line_number":13,"context_line":"each other."}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"be015fc8_1a7ab04d","line":10,"range":{"start_line":10,"start_character":9,"end_line":10,"end_character":43},"in_reply_to":"918359aa_caa17545","updated":"2021-04-12 16:37:10.000000000","message":"The point is that without the input \"--group_regex\", any test from \"TestModelsMigrationsPsq\" or \"TestModelsMigrationsMysql\" is executed randomly by any worker. This could lead to a situation where two or more tests using the same DB engine (MySQL, Postgree) are being executed at the same time. That overloads the DB engine an slows down the test execution.\n\nWith this group we ensure all tests using the same backend are executed by the same worker, that implies none of those tests are going to be executed in parallel. This is the goal of this patch.","commit_id":"7326fd622f2c3cb36681136d79e39e4efdda5411"},{"author":{"_account_id":5948,"name":"Oleg Bondarev","email":"obondarev@mirantis.com","username":"obondarev"},"change_message_id":"60581df557f59c4a1c7f8e63281da2b4ed87a0d2","unresolved":true,"context_lines":[{"line_number":7,"context_line":"Group execution of SQL functional tests"},{"line_number":8,"context_line":""},{"line_number":9,"context_line":"Functional SQL tests (MySQL and PostgreSQL) use the DB installed"},{"line_number":10,"context_line":"backend. To avoid overloading the DB engine, the test cases are"},{"line_number":11,"context_line":"grouped [1] together and executed by the same worker process. That"},{"line_number":12,"context_line":"will ensure those tests are not executed in parallel, interfering"},{"line_number":13,"context_line":"each other."}],"source_content_type":"text/x-gerrit-commit-message","patch_set":2,"id":"918359aa_caa17545","line":10,"range":{"start_line":10,"start_character":9,"end_line":10,"end_character":43},"in_reply_to":"f7bd161c_d84c8b86","updated":"2021-04-12 09:00:36.000000000","message":"Sorry, still can\u0027t understand this sentence \"To avoid overloading the DB engine\" - which DB engine is at the risk of being overloaded given that tests are executed by different workers with different DB engines?","commit_id":"7326fd622f2c3cb36681136d79e39e4efdda5411"}]}