[MDEV-24419] Galera crash after ALTER TABLE convert to utf8mb4: Assertion failure in file data0type.cc line 67 Created: 2020-12-16  Updated: 2021-06-17  Resolved: 2021-01-14

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Galera
Affects Version/s: 10.4.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Deyvid Evaristo Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: 67, alter, character-set, crash, galera, need_feedback
Environment:

2 node MariaDB Galera cluster on 4GB RAM CentOS 7.*

Attachments: Text File mysql_error.log    
Issue Links:
Duplicate
duplicates MDEV-23245 Still getting assertion failure in fi... Closed
Relates
relates to MDEV-25951 MariaDB crash after ALTER TABLE conve... Closed

 Description   

After issuing a sequence of ALTER TABLE commands Galera crashed completely on both nodes:

SQL Commands:

alter table table1 convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table table2 convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table table3 convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table table4 convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table table5 convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table table6 convert to character set utf8mb4 collate utf8mb4_unicode_ci;
alter table table7 convert to character set utf8mb4 collate utf8mb4_unicode_ci;

mysql_error.log output/crash:

InnoDB: Assertion failure in file /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.4.12/storage/innobase/data/data0type.cc line 67

 Comments   
Comment by Marko Mäkelä [ 2020-12-16 ]

Can you repeat this with MariaDB 10.4.14 or later? This looks like a possible duplicate of MDEV-23245.

Comment by Deyvid Evaristo [ 2020-12-16 ]

Thanks Marko, good to know that. I will perform a new test.

Generated at Thu Feb 08 09:29:51 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.