Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.5.16
-
None
Description
We wanted to rolling upgrade a chat message table, so we took a first replica and change our table definition with the following SQL:
alter table chat_messages MODIFY COLUMN `text` text COMPRESSED COLLATE utf8mb4_unicode_ci DEFAULT NULL;
Once done the replication was broken with the following error message
Last_SQL_Error: Column 6 of table 'XXX.chat_messages' cannot be converted from type 'blob' to type 'text /!100301 COMPRESSED/'
|
*Note to reproduce replication settings *
- binlog_format : ROW
- Using_Gtid: Current_Pos
- Parallel_Mode: optimistic
*Note to reproduction table definition *
- The column origin column type COLUMN `text` text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
- The table is range partitioned by on timestamp created_at column
- The table is engine innodb