mariadb/mysql-test/suite/atomic/README.txt
Sergey Vojtovich 9b0294cd12 MDEV-36666 - atomic.alter_table still times out often
According to buildbot cross-reference atomic.alter_table is failing ~10
times a day due to 900 seconds test case timeout. Split it into two
tests: atomic.alter_table_myisam and atomic.alter_table_innodb.
It should reduce failure frequency down to once a day or so, similarly
to atomic.alter_table_aria test.

Diabling InnoDB for MyISAM/Aria/RocksDB tests makes them 20-35% faster.
2025-04-25 10:40:47 +04:00

19 lines
747 B
Text

To debug a the ddl_recovery code in a failing ddl_recovery test one could do
the following:
- Add # before --exec echo "restart" ...
- Force $e (engine), $c (crash point) and $r (crash position) to the values
where things goes wrong. See comments in alter_table.inc for how to do this.
- start mariadbd in a debugger
run the following in the debugger
(Replace 'atomic.create_trigger' with the failing test case)
#break ha_recover
#break MYSQL_BIN_LOG::recover
#break MYSQL_BIN_LOG::open
break ddl_log_close_binlogged_events
break ddl_log_execute_action
break ddl_log_execute_recovery
run --datadir=/my/maria-10.6/mysql-test/var/log/atomic.create_trigger/mysqld.1/data --log-basename=master --log-bin-index=mysqld-bin.index --debug --log-bin