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 |
Changed in kolla-ansible: | |
importance: | Undecided → Medium |
status: | New → Invalid |
importance: | Medium → Undecided |
The workaround was to update this table manually, i.e:
MariaDB [murano]> ALTER TABLE murano. `environment- template` ROW_FORMAT=DYNAMIC;