main.alter_table_online_debug fails sporadically

main.alter_table_online_debug 'nobinlog' w9 [ fail ]

        Test ended at 2025-09-30 13:22:59

CURRENT_TEST: main.alter_table_online_debug

mysqltest: At line 98: query 'reap' failed with wrong errno ER_ALTER_INFO (1088): 'Error updating stats for table after table rebuild: Lock wait timeout', instead of ER_LOCK_WAIT_TIMEOUT (1205)...

The result from queries just before the failure was:

< snip >

5

123

456

789

select variable_value-@otd from information_schema.session_status where variable_name='Opened_table_definitions';

variable_value-@otd

1

# long transaction and add column

create or replace table t1 (a int);

insert t1 values (5);

connection con2;

set debug_sync= 'now WAIT_FOR ended';

connection default;

set debug_sync= 'alter_table_copy_end SIGNAL ended WAIT_FOR end';

alter table t1 nowait add b int NULL, algorithm= copy, lock= none;

connection con2;

start transaction;

insert into t1 values (123), (456), (789);

set debug_sync= 'now SIGNAL end';

connection default;