Syntax error in TASK: mariadb : Change row format to DYNAMIC for legacy tables
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| kolla-ansible |
Invalid
|
Undecided
|
Unassigned | ||
| Train |
Fix Released
|
Medium
|
Radosław Piliszek | ||
Bug Description
I'm trying to upgrade from stein to train. I'm hitting an error in the task:
TASK: mariadb : Change row format to DYNAMIC for legacy tables. The error seems to be result of:
fatal: [sv-b16-u23]: FAILED! => {"changed": true, "cmd": ["docker", "exec", "mariadb", "mysql", "-uroot", "-redacted, "--silent", "--skip-
16:51:41.955571", "msg": "non-zero return code", "rc": 1, "start": "2020-06-11 16:51:41.865195", "stderr": "ERROR 1064 (42000) at line 1: 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 '@002dtemplate ROW_FORMAT=DYNAMIC' at line 1", "stderr_lines": ["ERROR 1064 (42000) at line 1: 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 '@002dtemplate ROW_FORMAT=DYNAMIC' at line 1"], "stdout": "", "stdout_lines": []
This is on centos 7 with centos base images.
| description: | updated |
| Will Szumski (willjs) wrote | #1 |
| Radosław Piliszek (yoctozepto) wrote | #2 |
| Changed in kolla-ansible: | |
| importance: | Undecided → Medium |
| status: | New → Invalid |
| importance: | Medium → Undecided |
| Will Szumski (willjs) wrote | #3 |
| Radosław Piliszek (yoctozepto) wrote | #4 |
| OpenStack Infra (hudson-openstack) wrote Fix proposed to kolla-ansible (stable/train) | #5 |
| OpenStack Infra (hudson-openstack) wrote Fix merged to kolla-ansible (stable/train) | #6 |
The workaround was to update this table manually, i.e:
MariaDB [murano]> ALTER TABLE murano.