shared_zones table is missing mysql_charset and mysql_engine
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Designate |
New
|
Undecided
|
Unassigned |
Bug Description
The table shared_zones is missing the options `mysql_engine` and `mysql_charset`, this leads to an error when the database default's charset defined differs from the charset defined in other tables.
The error:
sqlalchemy.
[SQL:
CREATE TABLE shared_zones (
id CHAR(32) NOT NULL,
created_at DATETIME,
updated_at DATETIME,
zone_id CHAR(32) NOT NULL,
project_id VARCHAR(36) NOT NULL,
target_project_id VARCHAR(36) NOT NULL,
PRIMARY KEY (id),
CONSTRAINT unique_shared_zone UNIQUE (zone_id, project_id, target_project_id),
FOREIGN KEY(zone_id) REFERENCES zones (id) ON DELETE CASCADE
)
]
That should be the system wide default[1], but I am guessing you are in some kind of upgrade situation? /github. com/openstack/ designate/ blob/master/ designate/ storage/ sqlalchemy/ alembic/ versions/ 15b34ff3ecb8_ fix_service_ charset. py#L48
[1] https:/
Or are you using a non-mysql database?