Bug #110446 main.kill_myisam will assert when install group_replication

• Submitted: 21 Mar 2023 3:16
• Modified: 21 Mar 2023 8:33
• Reporter: phoenix Zhang (OCA)
• Status: Verified
• Category: MySQL Server: Group Replication
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Any
• CPU Architecture: Any

[21 Mar 2023 3:16] phoenix Zhang

Description:
In debug mode, when just install group_replication (no need start group_replication) in main.kill_myisam as below diff, it will assert.

How to repeat:
Here is the diff:
$ git diff
diff --git a/mysql-test/t/kill_myisam.test b/mysql-test/t/kill_myisam.test
index 25bec140e20..8f782f86f8c 100644
--- a/mysql-test/t/kill_myisam.test
+++ b/mysql-test/t/kill_myisam.test
@@ -14,6 +14,7 @@ connect (con2, localhost, root,,);
 #
 # Bug#27563: Stored functions and triggers wasn't throwing an error when killed.
 #
+install plugin group_replication soname 'group_replication.so';
 CREATE TABLE t1 (f1 INT);
 delimiter |;
 CREATE FUNCTION bug27563() RETURNS INT(11)

After run this testcase：mtr main.kill_myisam，it will assert as below.

Thread 1 (Thread 0x7f68042f1700 (LWP 50616)):
#7  in __GI___assert_fail (assertion=0x56537cdf9eaa "!flags.finalized",  "sql/binlog.cc", line=2112" int binlog_cache_data::finalize(THD*, Log_event*)") at assert.c:101
#8  in binlog_cache_data::finalize at sql/binlog.cc:2112
#9  in binlog_stmt_cache_data::finalize at sql/binlog.cc:1085
#10 in MYSQL_BIN_LOG::commit at sql/binlog.cc:8134
#11 in trans_commit_stmt at sql/transaction.cc:536
#12 in mysql_execute_command at sql/sql_parse.cc:4894
#13 in dispatch_sql_command at sql/sql_parse.cc:5322
#14 in dispatch_command at sql/sql_parse.cc:2036
#15 in do_command at sql/sql_parse.cc:1439

[21 Mar 2023 8:33] MySQL Verification Team

Hello phoenix Zhang!

Thank you for the report and feedback.

regards,
Umesh