MariaDB database backup and restore in kolla-ansible
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
kolla-ansible |
Invalid
|
Undecided
|
Unassigned |
Bug Description
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/
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:/
- IRC: 'openstack' channel on Freenode
-------
Release: 12.2.1.dev57 on 2021-01-18 23:14:14
SHA: 1cce0d531343589
Source: https:/
URL: https:/
Hmm, it seems wrong version of Kolla Ansible must have been used as "BINLOG MONITOR" is only present in Xena+.