mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-31 10:56:12 +01:00 
			
		
		
		
	 834c013b64
			
		
	
	
	834c013b64
	
	
	
		
			
			During read only mode, InnoDB doesn't allow checkpoint to happen. So InnoDB should throw the warning when InnoDB tries to force the checkpoint when innodb_read_only = 1 or innodb_force_recovery = 6.
		
			
				
	
	
		
			21 lines
		
	
	
	
		
			903 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			21 lines
		
	
	
	
		
			903 B
		
	
	
	
		
			Text
		
	
	
	
	
	
| call mtr.add_suppression("InnoDB: Plugin initialization aborted");
 | |
| call mtr.add_suppression("plugin 'InnoDB' registration as a STORAGE ENGINE failed.");
 | |
| CREATE TABLE t1(f1 INT NOT NULL, f2 TEXT)ENGINE=InnoDB;
 | |
| # restart: --debug_dbug=+d,ib_log_checkpoint_avoid_hard --innodb_flush_sync=0
 | |
| INSERT INTO t1 SELECT seq, repeat('a', 4000) FROM seq_1_to_1800;
 | |
| # restart: --debug_dbug=+d,before_final_redo_apply --innodb_log_file_size=8M
 | |
| # restart: --innodb_log_file_size=10M
 | |
| #
 | |
| # MDEV-34519 innodb_log_checkpoint_now crashes when
 | |
| #              innodb_read_only is enabled
 | |
| #
 | |
| # restart: --innodb-force-recovery=6
 | |
| SET GLOBAL innodb_log_checkpoint_now=1;
 | |
| Warnings:
 | |
| Warning	138	InnoDB doesn't force checkpoint when innodb-force-recovery=6.
 | |
| # restart: --innodb-read-only=1
 | |
| SET GLOBAL innodb_log_checkpoint_now=1;
 | |
| Warnings:
 | |
| Warning	138	InnoDB doesn't force checkpoint when innodb-read-only=1.
 | |
| # restart
 | |
| DROP TABLE t1;
 |