Bug #119126 Debug server crash at crash,Diagnostics_area::set_ok_status while run pstress & random-shutdown tests.

• Submitted: 10 Oct 2025 7:18
• Reporter: Ceit Zhang
• Status: Open
• Category: MySQL Server
• Severity: S6 (Debug Builds)
• Version: 8.0.43
• OS: Any
• CPU Architecture: Any

[10 Oct 2025 7:18] Ceit Zhang

Description:
Server (in debug verson only)crash with the following stack:
/data/engine/mysql/bin/mysqld(print_fatal_signal(int)+0x38a) [0x5636e5f48f99]
/data/engine/mysql/bin/mysqld(handle_fatal_signal+0x69) [0x5636e5f49195]
/usr/lib64/libpthread.so.0(+0x13280) [0x7f47ea7c8280]
/usr/lib64/libc.so.6(gsignal+0x10b) [0x7f47e820577b]
/usr/lib64/libc.so.6(abort+0x151) [0x7f47e8206aa1]
/usr/lib64/libc.so.6(+0x3203a) [0x7f47e81fe03a]
/usr/lib64/libc.so.6(+0x320b2) [0x7f47e81fe0b2]
/data/engine/mysql/bin/mysqld(Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)+0x79) [0x5636e5c3cda7]
/data/engine/mysql/bin/mysqld(my_ok(THD*, unsigned long long, unsigned long long, char const*)+0x53) [0x5636e5bc861f]
/data/engine/mysql/bin/mysqld(mysql_alter_table(THD*, char const*, char const*, HA_CREATE_INFO*, Table_ref*, Alter_info*)+0x64e6) [0x5636e5dde10a]
/data/engine/mysql/bin/mysqld(Sql_cmd_alter_table::execute(THD*)+0x5e0) [0x5636e64833dc]
/data/engine/mysql/bin/mysqld(mysql_execute_command(THD*, bool)+0x6139) [0x5636e5cd43d1]
/data/engine/mysql/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x7ae) [0x5636e5cd688a]
/data/engine/mysql/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x18b0) [0x5636e5ccb4e3]
/data/engine/mysql/bin/mysqld(do_command(THD*)+0x5e5) [0x5636e5cc91fc]

How to repeat:
Run the following two test scripts simultaneously:
1、A normal pstress tests with following command:
./pstress-ms_prepare --user root --address 127.0.0.1 --database=pstress --port 3306  --password *** --threads 128  --tables 300 --logdir=./log_tmg1 --records 3000  --seconds 80000 --infile=./pquery.sql --log-failed-queries --no-tbs --engine=innodb --no-partition-tables --no-blob --modify-column=67 --rename-column=22 --no-desc-index --no-shuffle --no-delete --no-select --no-update --no-auto-inc --no-column-compression --no-insert --no-table-compression --only-cl-sql --only-cl-ddl --insert-row=124 --delete-with-cond=89 --delete-all-row=79 --update-with-cond=86  
2、A random time shutdown with following script:
#!/bin/bash
while [ True ]
do
        echo "==========================`date`=====================${i}======================"
        mysql -uroot -p*** -h127.0.0.1 -P3306 -e "shutdown"
        sleep 30
        手动拉取进程
        sleep_time=$(( ($RANDOM % 21 + 40) * 60 ))
        echo $sleep_time
        sleep $sleep_time;
done

Suggested fix:
don't know