mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-07-08 04:18:14 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/atomic
History
Exact
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
..
alter_table.inc MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_aria.result Merge 10.5 into 10.6 2022-09-20 16:53:20 +03:00
alter_table_aria.test MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_big_query.result Merge 10.5 into 10.6 2022-09-20 16:53:20 +03:00
alter_table_big_query.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
alter_table_innodb.opt MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_innodb.result MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_innodb.test MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_myisam.result MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_myisam.test MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_rocksdb.result Merge 10.5 into 10.6 2022-09-20 16:53:20 +03:00
alter_table_rocksdb.test MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
alter_table_trigger.result Merge 10.5 into 10.6 2022-09-20 16:53:20 +03:00
alter_table_trigger.test MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
create_table.result MDEV-24576 Atomic CREATE TABLE 2021-05-19 22:54:13 +02:00
create_table.test Add --source include/long_test.inc to a few long-running tests 2025-03-13 11:26:02 +01:00
create_trigger.result Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
create_trigger.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
create_trigger2.result MDEV-24746 Atomic CREATE TRIGGER 2021-05-19 22:54:13 +02:00
create_trigger2.test MDEV-24746 Atomic CREATE TRIGGER 2021-05-19 22:54:13 +02:00
create_view.result MDEV-24607 Atomic CREATE VIEW 2021-05-19 22:54:13 +02:00
create_view.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_db.result Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_db.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_db_long_names.opt MDEV-24408 Crash-safe DROP DATABASE 2021-05-19 22:54:13 +02:00
drop_db_long_names.result Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_db_long_names.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_sequence.result Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_sequence.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_table.result Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_table.test Add --source include/long_test.inc to a few long-running tests 2025-03-13 11:26:02 +01:00
drop_trigger.result Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_trigger.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_view.result Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
drop_view.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
README.txt MDEV-36666 - atomic.alter_table still times out often 2025-04-25 10:40:47 +04:00
rename_case.result MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_case.test MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_combinations.result MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_combinations.test MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_table.result MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_table.test Add --source include/long_test.inc to a few long-running tests 2025-03-13 11:26:02 +01:00
rename_table_binlog.result MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_table_binlog.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
rename_trigger.result MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_trigger.test Speed up atomic test suite by improving wait_until_connected_again.inc 2021-05-24 21:04:40 +03:00
rename_view.result MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_view.test MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_view2.result MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00
rename_view2.test MDEV-23842 Atomic RENAME TABLE 2021-05-19 22:54:12 +02:00

README.txt 

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