)]}'
{"playbooks/roles/mariadb/templates/docker-compose.yaml.j2":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"3a58b45ebf23c6ae57bb1693ae077225f41dc42d","unresolved":true,"context_lines":[{"line_number":1,"context_line":"version: \u00272\u0027"},{"line_number":2,"context_line":"services:"},{"line_number":3,"context_line":"  mariadb:"},{"line_number":4,"context_line":"    image: docker.io/library/mariadb:10.6"},{"line_number":5,"context_line":"    network_mode: host"},{"line_number":6,"context_line":"    environment:"},{"line_number":7,"context_line":"      MYSQL_ROOT_PASSWORD: \"{{ mariadb_root_password }}\""}],"source_content_type":"text/x-jinja2","patch_set":1,"id":"287326ca_dc20b693","line":4,"range":{"start_line":4,"start_character":37,"end_line":4,"end_character":41},"updated":"2024-04-04 16:17:49.000000000","message":"Can we make this 10.11 and we should probably go ahead and set the flag to allow auto upgrades from the start. That way we\u0027ll be able to do upgrades in the future more easily.\n\nhttps://opendev.org/opendev/system-config/src/branch/master/playbooks/roles/lodgeit/templates/docker-compose.yaml.j2#L4-L13 is an example where we\u0027ve already converted (and I\u0027m slowly working through the other mariadbs we have to do the same).","commit_id":"a2936874e9dd201dad6c96e47c7dcf02c41d4e11"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"c31ea0ef38f0d5566eda7b48d8b31c0122977f42","unresolved":false,"context_lines":[{"line_number":1,"context_line":"version: \u00272\u0027"},{"line_number":2,"context_line":"services:"},{"line_number":3,"context_line":"  mariadb:"},{"line_number":4,"context_line":"    image: docker.io/library/mariadb:10.6"},{"line_number":5,"context_line":"    network_mode: host"},{"line_number":6,"context_line":"    environment:"},{"line_number":7,"context_line":"      MYSQL_ROOT_PASSWORD: \"{{ mariadb_root_password }}\""}],"source_content_type":"text/x-jinja2","patch_set":1,"id":"0fa044da_3235bffe","line":4,"range":{"start_line":4,"start_character":37,"end_line":4,"end_character":41},"in_reply_to":"287326ca_dc20b693","updated":"2024-04-04 16:49:12.000000000","message":"Done","commit_id":"a2936874e9dd201dad6c96e47c7dcf02c41d4e11"}],"playbooks/zuul/templates/group_vars/zuul-db.yaml.j2":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"3a58b45ebf23c6ae57bb1693ae077225f41dc42d","unresolved":true,"context_lines":[{"line_number":1,"context_line":"mariadb_password: testuserpassword"},{"line_number":2,"context_line":"mariadb_root_password: testrootpassword"},{"line_number":3,"context_line":""}],"source_content_type":"text/x-jinja2","patch_set":1,"id":"e50636cb_dae07c54","line":3,"updated":"2024-04-04 16:17:49.000000000","message":"Do you also need to set the flag to up the service here? Otherwise in testing we won\u0027t up mariadb and our testinfra tests should fail.","commit_id":"a2936874e9dd201dad6c96e47c7dcf02c41d4e11"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"c31ea0ef38f0d5566eda7b48d8b31c0122977f42","unresolved":false,"context_lines":[{"line_number":1,"context_line":"mariadb_password: testuserpassword"},{"line_number":2,"context_line":"mariadb_root_password: testrootpassword"},{"line_number":3,"context_line":""}],"source_content_type":"text/x-jinja2","patch_set":1,"id":"462ce01e_25365659","line":3,"in_reply_to":"e50636cb_dae07c54","updated":"2024-04-04 16:49:12.000000000","message":"Done","commit_id":"a2936874e9dd201dad6c96e47c7dcf02c41d4e11"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"c31ea0ef38f0d5566eda7b48d8b31c0122977f42","unresolved":true,"context_lines":[{"line_number":1,"context_line":"mariadb_password: testuserpassword"},{"line_number":2,"context_line":"mariadb_root_password: testrootpassword"},{"line_number":3,"context_line":"mariadb_run_compose_up: true"},{"line_number":4,"context_line":""}],"source_content_type":"text/x-jinja2","patch_set":2,"id":"ca872b6a_833a8e6d","line":3,"updated":"2024-04-04 16:49:12.000000000","message":"We will need to add this file to the list at https://opendev.org/opendev/system-config/src/branch/master/playbooks/zuul/run-base.yaml#L115 in order for it to get installed on the test bridge node.","commit_id":"0181e4b05fd19c04b21540cdb1515c134f5ead46"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"a74351645418e7b8f31aad0a8a54fa735408831b","unresolved":false,"context_lines":[{"line_number":1,"context_line":"mariadb_password: testuserpassword"},{"line_number":2,"context_line":"mariadb_root_password: testrootpassword"},{"line_number":3,"context_line":"mariadb_run_compose_up: true"},{"line_number":4,"context_line":""}],"source_content_type":"text/x-jinja2","patch_set":2,"id":"eeb4cf49_257c770d","line":3,"in_reply_to":"ca872b6a_833a8e6d","updated":"2024-04-04 16:50:24.000000000","message":"Done","commit_id":"0181e4b05fd19c04b21540cdb1515c134f5ead46"}],"testinfra/test_zuul_db.py":[{"author":{"_account_id":5263,"name":"Jeremy Stanley","display_name":"fungi","email":"fungi@yuggoth.org","username":"fungi","status":"missing, presumed fed"},"change_message_id":"c5ba7fcf814a6060d4df4082825c743cef66075b","unresolved":false,"context_lines":[{"line_number":20,"context_line":"def test_mariadb_logs(host):"},{"line_number":21,"context_line":"    mariadb_log_file \u003d host.file(\u0027/var/log/containers/docker-mariadb.log\u0027)"},{"line_number":22,"context_line":"    assert mariadb_log_file.exists"},{"line_number":23,"context_line":"    assert mariadb_log_file.contains(\u0027mysqld: ready for connections\u0027)"}],"source_content_type":"text/x-python","patch_set":3,"id":"679a111f_18cf8e9a","line":23,"updated":"2024-04-04 17:11:30.000000000","message":"This works for now. Later we can stick the test bridge into the zuul group and test a TCP socket connection, or even do a minimal `show databases` query or something. In the meantime, just manually testing that the deployed production server is reachable from the schedulers before we switch over should suffice.","commit_id":"f6094f8d178febf6a64dd8fd378e7cfa4216a48c"}],"zuul.d/project.yaml":[{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"3a58b45ebf23c6ae57bb1693ae077225f41dc42d","unresolved":true,"context_lines":[{"line_number":654,"context_line":"        - infra-prod-service-tracing: *infra-prod-service-tracing"},{"line_number":655,"context_line":"        - infra-prod-service-zookeeper: *infra-prod-service-zookeeper"},{"line_number":656,"context_line":"        - infra-prod-service-zuul: *infra-prod-service-zuul"},{"line_number":657,"context_line":"        - infra-prod-service-zuul-db"},{"line_number":658,"context_line":"        - infra-prod-service-zuul-lb: *infra-prod-service-zuul-lb"},{"line_number":659,"context_line":"        - infra-prod-service-zuul-preview: *infra-prod-service-zuul-preview"},{"line_number":660,"context_line":"        - infra-prod-run-accessbot: *infra-prod-run-accessbot"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"1a52f6b9_278c56e3","line":657,"updated":"2024-04-04 16:17:49.000000000","message":"If anyone else is wondering the extra service-zuul bits set things like letsencrypt dependency ordering and backup related stuff. None of which we\u0027ll be doing for the new db service (at least to start).","commit_id":"a2936874e9dd201dad6c96e47c7dcf02c41d4e11"},{"author":{"_account_id":4146,"name":"Clark Boylan","email":"cboylan@sapwetik.org","username":"cboylan"},"change_message_id":"c31ea0ef38f0d5566eda7b48d8b31c0122977f42","unresolved":false,"context_lines":[{"line_number":654,"context_line":"        - infra-prod-service-tracing: *infra-prod-service-tracing"},{"line_number":655,"context_line":"        - infra-prod-service-zookeeper: *infra-prod-service-zookeeper"},{"line_number":656,"context_line":"        - infra-prod-service-zuul: *infra-prod-service-zuul"},{"line_number":657,"context_line":"        - infra-prod-service-zuul-db"},{"line_number":658,"context_line":"        - infra-prod-service-zuul-lb: *infra-prod-service-zuul-lb"},{"line_number":659,"context_line":"        - infra-prod-service-zuul-preview: *infra-prod-service-zuul-preview"},{"line_number":660,"context_line":"        - infra-prod-run-accessbot: *infra-prod-run-accessbot"}],"source_content_type":"text/x-yaml","patch_set":1,"id":"7f28618b_f8506362","line":657,"in_reply_to":"1a52f6b9_278c56e3","updated":"2024-04-04 16:49:12.000000000","message":"Done","commit_id":"a2936874e9dd201dad6c96e47c7dcf02c41d4e11"}]}