[MDEV-29987] Bogus errors about file size in the test mariabackup.defer_space Created: 2022-11-09  Updated: 2022-11-21  Resolved: 2022-11-14

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
Fix Version/s: 10.11.2, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: recovery

Issue Links:
Relates
relates to MDEV-24626 Remove synchronous write of page0 and... Closed
relates to MDEV-25909 Unnecessary calls to fil_ibd_load() s... Open

 Description   

Some warnings were reported in a Microsoft Windows environment (also on retry):

10.8 fe9412dbc9ce4cb1764a3669ee89dcf687d68fb5

mariabackup.defer_space 'innodb'         w21 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2022-11-09 12:12:56
line
2022-11-09 12:12:54 0 [ERROR] InnoDB: The size of the file ./test/t1.ibd is only 65535 bytes, should be at least 65536
2022-11-09 12:12:54 0 [ERROR] InnoDB: The size of the file ./test/t1.ibd is only 65535 bytes, should be at least 65536
^ Found warnings in D:/Buildbot/amd64-windows/build/mysql-test/var/21/log/mysqld.1.err
 
innodb.corrupted_during_recovery 'innodb' w27 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2022-11-09 12:25:07
line
2022-11-09 12:24:55 0 [ERROR] InnoDB: The size of the file ./test/t1.ibd is only 65535 bytes, should be at least 65536
2022-11-09 12:24:55 0 [ERROR] InnoDB: The size of the file ./test/t1.ibd is only 65535 bytes, should be at least 65536
^ Found warnings in D:/Buildbot/amd64-windows/build/mysql-test/var/27/log/mysqld.1.err

Note: The file size is 1 smaller than the expected minimum file size.

On the third attempt, both these tests passed.

To me, it looks like the error messages are superfluous and should be removed. The recovery of a newly created file is supposed to work (and it apparently did work also in this case) no matter what the contents of the file is.

The message could be duplicated due to redundant calls (MDEV-25909).



 Comments   
Comment by Marko Mäkelä [ 2022-11-14 ]

The problem was that for some reason, some Perl code in the test that was supposed to overwrite the first page of t1.ibd with NUL bytes was also truncating the last page by 1 byte on Microsoft Windows. Fixed by using slightly different Perl code to corrupt only the desired part of the file.

Generated at Thu Feb 08 10:12:47 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.