)]}'
{"/PATCHSET_LEVEL":[{"author":{"_account_id":20634,"name":"Chris MacNaughton","email":"chris.macnaughton@canonical.com","username":"Chris.MacNaughton"},"change_message_id":"a5bb87b88ee657db6d9e60dc59b9e50bb7bac0df","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"2eec5131_166c8f17","updated":"2022-05-04 14:20:02.000000000","message":"I am also able to successfully use mysql-router in a test deploy with this patch","commit_id":"9563b204ad838529c17a155274f5815de595f6dc"},{"author":{"_account_id":2424,"name":"Felipe Reyes","email":"felipe.reyes@canonical.com","username":"freyes"},"change_message_id":"046863cb8f86c6da808ce7e514df2cb3dd431bc2","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"1bd48e2e_3005947c","updated":"2022-05-04 13:58:32.000000000","message":"In a running system with a broken state I was able to upgrade to the charm built with this patch successfully\n\n```\nubuntu@freyes-bastion:~$ juju status nova-cloud-controller\nModel    Controller   Cloud/Region         Version  SLA          Timestamp\ndefault  icarus-maas  icarus-maas/default  2.9.29   unsupported  13:49:00Z\n\nApp                    Version  Status   Scale  Charm                  Channel  Rev  Exposed  Message\nnova-cloud-controller  24.0.0   waiting      1  nova-cloud-controller  stable   361  no       Incomplete relations: identity, messaging\nnova-mysql-router      8.0.29   blocked      1  mysql-router           stable    15  no       Failed to connect to MySQL\n\nUnit                      Workload  Agent  Machine  Public address  Ports              Message\nnova-cloud-controller/0*  waiting   idle   0/lxd/4  10.246.114.74   8774/tcp,8775/tcp  Incomplete relations: identity, messaging\n  nova-mysql-router/0*    blocked   idle            10.246.114.74                      Failed to connect to MySQL\n\nMachine  State    DNS            Inst id              Series  AZ       Message\n0        started  10.246.114.55  virt-node-04         focal   default  Deployed\n0/lxd/4  started  10.246.114.74  juju-b70e35-0-lxd-4  focal   default  Container started\n\nubuntu@freyes-bastion:~$ wget https://openstack-ci-reports.ubuntu.com/artifacts/e8f/840454/1/check/charm-build/e8f981e/mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm\n--2022-05-04 13:49:09--  https://openstack-ci-reports.ubuntu.com/artifacts/e8f/840454/1/check/charm-build/e8f981e/mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm                                        Resolving openstack-ci-reports.ubuntu.com (openstack-ci-reports.ubuntu.com)... 185.125.188.134\nConnecting to openstack-ci-reports.ubuntu.com (openstack-ci-reports.ubuntu.com)|185.125.188.134|:443... connected.\nHTTP request sent, awaiting response... 200 OK\nLength: 14714610 (14M) [text/plain]\nSaving to: ‘mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm’\n\nmysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm 100%[\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003e]  14.03M  13.8MB/s    in 1.0s\n\n2022-05-04 13:49:11 (13.8 MB/s) - ‘mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm’ saved [14714610/14714610]\n\nubuntu@freyes-bastion:~$ juju upgrade-charm --force-units --path ./mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm nova-mysql-router\nERROR zip: not a valid zip file\n1 ubuntu@freyes-bastion:~$ file mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm\nmysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm: gzip compressed data, last modified: Wed May  4 13:35:08 2022, max compression\nubuntu@freyes-bastion:~$ gunzip mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm\ngzip: mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm: unknown suffix -- ignored\n2 ubuntu@freyes-bastion:~$ mv mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm.gz\nubuntu@freyes-bastion:~$ gunzip mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm.gz\nubuntu@freyes-bastion:~$ juju upgrade-charm --force-units --path ./mysql-router-bcc911b8b0e945a0968bbdc445e47d1b.charm nova-mysql-router\nAdded local charm \"mysql-router\", revision 3, to the model\nLeaving endpoints in \"public-space\": certificates, db-router, juju-info, shared-db\nubuntu@freyes-bastion:~$ juju debug-log -i nova-mysql-router/0\n...\nunit-nova-mysql-router-0: 13:53:55 INFO unit.nova-mysql-router/0.juju-log Writing /var/lib/mysql/nova-mysql-router/mysqlrouter.conf\nunit-nova-mysql-router-0: 13:53:55 DEBUG unit.nova-mysql-router/0.juju-log Proactively resetting ssl_ca\nunit-nova-mysql-router-0: 13:53:55 DEBUG unit.nova-mysql-router/0.juju-log Proactively resetting ssl_ca\nunit-nova-mysql-router-0: 13:53:55 DEBUG unit.nova-mysql-router/0.juju-log Proactively resetting ssl_ca\nunit-nova-mysql-router-0: 13:53:55 DEBUG unit.nova-mysql-router/0.juju-log Running _assess_status()\nunit-nova-mysql-router-0: 13:53:55 DEBUG unit.nova-mysql-router/0.juju-log Opening db connection for mysqlrouteruser@127.0.0.1\nunit-nova-mysql-router-0: 13:53:56 INFO unit.nova-mysql-router/0.juju-log DEPRECATION WARNING: Function _ows_check_services_running is being removed on/around 2022-05 : use ows_check_services_running() instead\nunit-nova-mysql-router-0: 13:53:56 DEBUG unit.nova-mysql-router/0.config-changed active\nubuntu@freyes-bastion:~$ juju status nova-cloud-controller\nModel    Controller   Cloud/Region         Version  SLA          Timestamp\ndefault  icarus-maas  icarus-maas/default  2.9.29   unsupported  13:54:12Z\n\nApp                    Version  Status   Scale  Charm                  Channel  Rev  Exposed  Message\nnova-cloud-controller  24.0.0   waiting      1  nova-cloud-controller  stable   361  no       Incomplete relations: identity, messaging\nnova-mysql-router      8.0.29   active       1  mysql-router           stable     3  no       Unit is ready\n\nUnit                      Workload  Agent  Machine  Public address  Ports              Message\nnova-cloud-controller/0*  waiting   idle   0/lxd/4  10.246.114.74   8774/tcp,8775/tcp  Incomplete relations: identity, messaging\n  nova-mysql-router/0*    active    idle            10.246.114.74                      Unit is ready\n\nMachine  State    DNS            Inst id              Series  AZ       Message\n0        started  10.246.114.55  virt-node-04         focal   default  Deployed\n0/lxd/4  started  10.246.114.74  juju-b70e35-0-lxd-4  focal   default  Container started\n\nubuntu@freyes-bastion:~$ juju ssh 0/lxd/4 sudo pastebinit /var/lib/mysql/nova-mysql-router/mysqlrouter.conf\nhttps://paste.ubuntu.com/p/zKSPYWHgbz/\nConnection to 10.246.114.74 closed.\n```","commit_id":"9563b204ad838529c17a155274f5815de595f6dc"},{"author":{"_account_id":2424,"name":"Felipe Reyes","email":"felipe.reyes@canonical.com","username":"freyes"},"change_message_id":"37b64314bd89dc2aa3ad87d196fa212bf98c68e2","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"3ad45c21_8bc5f5af","updated":"2022-05-04 18:52:35.000000000","message":"charm-recheck\n\n\u003e - focal https://openstack-ci-reports.ubuntu.com/artifacts/be4/840454/1/check/focal/be40fc6/ : FAILURE in 47m 36s\n\n\nkeystone/0*                 error     idle   0        172.16.0.76     5000/tcp  hook failed: \"shared-db-relation-changed\"\n  keystone-mysql-router/0*  blocked   idle            172.16.0.76               Failed to connect to MySQL\nvault/0*                    blocked   idle   4        172.16.0.160    8200/tcp  Vault needs to be initialized\n  vault-mysql-router/0*     active    idle            172.16.0.160              Unit is ready\n\none mysql-router failed, while the other didn\u0027t, but juju-crashdump failed to capture the logs\n\n\n2022-05-04 17:37:48.272665 | focal-medium | 2022-05-04 17:37:48,271 - Command \"scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@172.16.0.76:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 266bb7fa-a90c-4f76-873d-b029b34e96b5.tar\" failed\n2022-05-04 17:37:48.273133 | focal-medium | 2022-05-04 17:37:48,272 - Command \u0027scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@172.16.0.76:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 266bb7fa-a90c-4f76-873d-b029b34e96b5.tar\u0027 returned non-zero exit status 1.\n2022-05-04 17:37:48.319568 | focal-medium | 2022-05-04 17:37:48,318 - Command \"scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@172.16.0.200:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 7178b6d8-9ad8-4577-95a5-0e1617fdae64.tar\" failed\n2022-05-04 17:37:48.319655 | focal-medium | 2022-05-04 17:37:48,319 - Command \u0027scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@172.16.0.200:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 7178b6d8-9ad8-4577-95a5-0e1617fdae64.tar\u0027 returned non-zero exit status 1.\n2022-05-04 17:39:58.291649 | focal-medium | 2022-05-04 17:39:58,289 - Command \"scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@252.0.200.1:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 7178b6d8-9ad8-4577-95a5-0e1617fdae64.tar\" failed\n2022-05-04 17:39:58.292117 | focal-medium | 2022-05-04 17:39:58,289 - Command \"scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@252.0.76.1:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 266bb7fa-a90c-4f76-873d-b029b34e96b5.tar\" failed\n2022-05-04 17:39:58.292191 | focal-medium | 2022-05-04 17:39:58,290 - Command \u0027scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@252.0.200.1:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 7178b6d8-9ad8-4577-95a5-0e1617fdae64.tar\u0027 returned non-zero exit status 1.\n2022-05-04 17:39:58.292511 | focal-medium | 2022-05-04 17:39:58,292 - Command \u0027scp -o StrictHostKeyChecking\u003dno -i ~/.local/share/juju/ssh/juju_id_rsa ubuntu@252.0.76.1:/tmp/1a17f72c-702f-4a70-bbd0-707426c13643/juju-dump-1a17f72c-702f-4a70-bbd0-707426c13643.tar 266bb7fa-a90c-4f76-873d-b029b34e96b5.tar\u0027 returned non-zero exit status 1.\n2022-05-04 17:39:58.304555 | focal-medium | 2022-05-04 17:39:58,302 - Command \"tar -pxf 7178b6d8-9ad8-4577-95a5-0e1617fdae64.tar -C 1/baremetal\" failed\n2022-05-04 17:39:58.304616 | focal-medium | 2022-05-04 17:39:58,303 - Command \u0027tar -pxf 7178b6d8-9ad8-4577-95a5-0e1617fdae64.tar -C 1/baremetal\u0027 returned non-zero exit status 2.\n2022-05-04 17:39:58.304642 | focal-medium | 2022-05-04 17:39:58,303 - Command \"tar -pxf 266bb7fa-a90c-4f76-873d-b029b34e96b5.tar -C 0/baremetal\" failed\n2022-05-04 17:39:58.304650 | focal-medium | 2022-05-04 17:39:58,303 - Command \u0027tar -pxf 266bb7fa-a90c-4f76-873d-b029b34e96b5.tar -C 0/baremetal\u0027 returned non-zero exit status 2.","commit_id":"9563b204ad838529c17a155274f5815de595f6dc"},{"author":{"_account_id":2424,"name":"Felipe Reyes","email":"felipe.reyes@canonical.com","username":"freyes"},"change_message_id":"d392a8346150aa0f51940b25cf92aa986b71eaa3","unresolved":false,"context_lines":[],"source_content_type":"","patch_set":1,"id":"63a68477_bd23085b","updated":"2022-05-04 16:31:41.000000000","message":"charm-recheck\n\n\u003e - full_model_ha-focal-full-ha https://openstack-ci-reports.ubuntu.com/artifacts/005/840454/1/check/full_model_ha-focal-full-ha/0056daf/ : FAILURE in 1h 44m 44s\n\n  keystone-mysql-router/2    blocked   idle            172.16.0.59                         Failed to connect to MySQL\n\nunit-keystone-mysql-router-2: 2022-05-04 15:26:21 DEBUG unit.keystone-mysql-router/2.juju-log Updating configuration parameters\nunit-keystone-mysql-router-2: 2022-05-04 15:26:21 INFO unit.keystone-mysql-router/2.juju-log Writing /var/lib/mysql/keystone-mysql-router/mysqlrouter.conf\nunit-keystone-mysql-router-2: 2022-05-04 15:26:21 DEBUG unit.keystone-mysql-router/2.juju-log Proactively resetting ssl_ca\nunit-keystone-mysql-router-2: 2022-05-04 15:26:21 DEBUG unit.keystone-mysql-router/2.juju-log Running _assess_status()\nunit-keystone-mysql-router-2: 2022-05-04 15:26:22 DEBUG unit.keystone-mysql-router/2.juju-log Opening db connection for mysqlrouteruser@127.0.0.1\nunit-keystone-mysql-router-2: 2022-05-04 15:26:22 ERROR unit.keystone-mysql-router/2.juju-log Failed to connect to database due to \u0027(2003, \"Can\u0027t connect to MySQL server on \u0027127.0.0.1:3306\u0027 (111)\")\u0027\nunit-keystone-mysql-router-2: 2022-05-04 15:26:22 DEBUG unit.keystone-mysql-router/2.juju-log Could not connect to db\n\n\nThere is no more information in the crashdump, the directory for this unit is empty.","commit_id":"9563b204ad838529c17a155274f5815de595f6dc"}]}