mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-26 16:38:11 +01:00 
			
		
		
		
	 9b0294cd12
			
		
	
	
	9b0294cd12
	
	
	
		
			
			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.
		
			
				
	
	
		
			19 lines
		
	
	
	
		
			747 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			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
 |