MariaDB database backup and restore in kolla-ansible

[Ken Holden]

Wallaby deployment on Ubuntu 20.04.03. Added enable_mariabackup: "yes" to globals and ran kolla-ansible -i multihost reconfigure -t mariadb. The run failed with:

Command failed ansible-playbook -e @/etc/kolla/globals.yml -e @/etc/kolla/passwords.yml -e CONFIG_DIR=/etc/kolla --tags mariadb -e kolla_action=reconfigure -e kolla_serial=0 /usr/local/share/kolla-ansible/ansible/site.yml --inventory ./multinode

TASK [mariadb : Creating database backup user and setting permissions] *****************************************************************************************************************************************************************
skipping: [control02]
skipping: [control03]
fatal: [control01]: FAILED! => {"action": "mysql_user", "changed": false, "msg": "(1064, \"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'BINLOG MONITOR ON *.* TO 'backup'@'%'' at line 1\")"}

I just ran the same thing on my dev cluster (deployed with wallaby but updated to xena) and it worked fine.

This bug tracker is for errors with the documentation, use the following as a template and remove or add fields as you see fit. Convert [ ] into [x] to check boxes:

- [x] This doc is inaccurate in this way: Followed the instructions for Wallaby and failed with the above error
- [ ] This is a doc addition request.
- [ ] I have a fix to the document that I can paste below including example: input and output.

If you have a troubleshooting or support issue, use the following resources:

 - The mailing list: https://lists.openstack.org
 - IRC: 'openstack' channel on Freenode

-----------------------------------
Release: 12.2.1.dev57 on 2021-01-18 23:14:14
SHA: 1cce0d53134358999b5f385d51d28f7b09f87c6f
Source: https://opendev.org/openstack/kolla-ansible/src/doc/source/admin/mariadb-backup-and-restore.rst
URL: https://docs.openstack.org/kolla-ansible/wallaby/admin/mariadb-backup-and-restore.html

[Radosław Piliszek (yoctozepto)]

Hmm, it seems wrong version of Kolla Ansible must have been used as "BINLOG MONITOR" is only present in Xena+.

[Ken Holden (kholden)]

yep that was it. Sorry for the false alarm. I updated openstack env to xena and it worked. i must have updated kolla-ansible beforehand. thank you for the quick response.