mirror of
https://github.com/MariaDB/server.git
synced 2025-10-26 16:38:11 +01:00
b2fa874e46
In commit 7a4fbb55b0 (MDEV-25105)
the innochecksum option --write (-w) was removed altogether.
It should have been made a Boolean option, so that old data files
may be converted to a format that is compatible with
innodb_checksum_algorithm=strict_crc32 by executing the following:
innochecksum -n -w ibdata* */*.ibd
It would be better to use an older-version innochecksum
for such a conversion, so that page checksums will be validated
before updating the checksum.
It never was possible for innochecksum to convert files to the
innodb_checksum_algorithm=full_crc32 format that is the default
for new InnoDB data files.
23 lines
1.3 KiB
Text
23 lines
1.3 KiB
Text
call mtr.add_suppression("InnoDB: Unable to read tablespace .* page no .* into the buffer pool after 100 attempts");
|
|
call mtr.add_suppression("InnoDB: Warning: database page corruption or a failed");
|
|
CREATE TABLE tab1(c1 INT PRIMARY KEY,c2 VARCHAR(20)) ENGINE=InnoDB;
|
|
CREATE INDEX idx1 ON tab1(c2(10));
|
|
INSERT INTO tab1 VALUES(1, 'Innochecksum InnoDB1');
|
|
# Shutdown the Server
|
|
# Server Default checksum = innodb
|
|
[1b]: check the innochecksum without --strict-check
|
|
[4]: check the innochecksum with --no-check ignores algorithm check, warning is expected
|
|
FOUND 1 /Error: --no-check must be associated with --write option./ in my_restart.err
|
|
[5]: check the innochecksum with short form --no-check ignores algorithm check, warning is expected
|
|
FOUND 1 /Error: --no-check must be associated with --write option./ in my_restart.err
|
|
[6]: check the innochecksum with full form strict-check & no-check , an error is expected
|
|
FOUND 1 /unknown variable 'strict-check=innodb'/ in my_restart.err
|
|
[7]: check the innochecksum with short form strict-check & no-check , an error is expected
|
|
FOUND 1 /unknown option '-C'/ in my_restart.err
|
|
FOUND 1 /ignoring option '--write' due to invalid value 'crc32'/ in my_restart.err
|
|
FOUND 1 /Error: --no-check must be associated with --write option/ in my_restart.err
|
|
# restart
|
|
SELECT * FROM tab1;
|
|
c1 c2
|
|
1 Innochecksum InnoDB1
|
|
DROP TABLE tab1;
|