ansible-mariadb-galera-cluster icon indicating copy to clipboard operation
ansible-mariadb-galera-cluster copied to clipboard

Can't find any matching row in the user table

Open eRadical opened this issue 2 years ago • 0 comments

Describe the bug With new version of ansible and community mysql I started getting the following error:

failed: [services-mariadb-cluster-01.staging.example.com] (item=ip-172-21-1-53) => {"ansible_loop_var": "item", "changed": false, "item": "ip-172-21-1-53", "msg": "(1133, \"Can't find any matching row in the user table\")"}
ok: [services-mariadb-cluster-01.staging.example.com] => (item=127.0.0.1)
ok: [services-mariadb-cluster-01.staging.example.com] => (item=::1)
ok: [services-mariadb-cluster-01.staging.example.com] => (item=localhost)

To Reproduce community.mysql 3.5.1

Expected behavior Either ignore or cleanup root accounts and keep only the localhost one.

Additional context To get past my reconfiguration I added:

ignore_errors: true

but I not sure if we can keep this or came up w/ a better solution.

eRadical avatar Sep 19 '22 16:09 eRadical