[MDEV-25673] MariaDB fail to execute CONVERT TO CHARACTER Created: 2021-05-14  Updated: 2021-06-02  Resolved: 2021-06-02

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.5.10
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Dmitriy Rabotyagov Assignee: Aleksey Midenkov
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Ubuntu 20.04, Ubuntu 18.04, CentOS 8, Debian 10

Issue Links:
Duplicate
is duplicated by MDEV-25672 table alias from previous statement i... Closed
Problem/Incident
is caused by MDEV-25091 CREATE TABLE: field references qualif... Closed

 Description   

After switching our CI to mariadb 10.5.10 from 10.5.9 we started seing frequent but still interminent errors during execution of the service database alembic migrtations.
Migration always fail on the exact same query:

Error during database migration: (pymysql.err.OperationalError) (1054, "Unknown column '`cinder`.`consistencygroups_1`.`deleted`' in 'CHECK'")
 
[SQL: ALTER TABLE consistencygroups CONVERT TO CHARACTER SET utf8]
 
(Background on this error at: http://sqlalche.me/e/13/e3q8)

In mariadb-server journal I see only pretty much the same message:

[Warning] WSREP: Ignoring error 'Unknown column '`cinder`.`consistencygroups_1`.`deleted`' in 'CHECK'' on query. Default database: 'cinder'. Query: 'ALTER TABLE consistencygroups CONVERT TO CHARACTER SET utf8', Error_code: 1054

This stopped happening once we reverted MariaDB version back to 10.5.9 in CI.
Generated at Thu Feb 08 09:39:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.