SET GLOBAL innodb_checksum_algorithm=1, innodb_compression_algorithm=0;
|
CREATE TABLE t (c INT) page_compressed=1 page_compression_level=4 ENGINE=InnoDB;
|
SHUTDOWN;
|
Leads to:
11.0.1 f2dc4d4c10ac36a73b5c1eb765352d3aee808d66 (Optimized)
|
2023-03-07 21:44:53 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
|
2023-03-07 21:44:53 0 [Warning] InnoDB: Page compression errors: 3
|
2023-03-07 21:44:53 0 [Note] InnoDB: Shutdown completed; log sequence number 58233; transaction id 19
|
Bug confirmed present in:
MariaDB: 10.4.29 (dbg), 10.4.29 (opt), 10.7.8 (dbg), 10.7.8 (opt), 10.8.8 (dbg), 10.8.8 (opt), 10.9.6 (dbg), 10.9.6 (opt), 10.10.4 (dbg), 10.10.4 (opt), 10.11.2 (dbg), 10.11.2 (opt), 11.0.1 (dbg), 11.0.1 (opt)
Discussed with danblack who already developed a fix.