[MDEV-13882] innodb.innodb_zip_innochecksum2 fails in buildbot with Warning: difficult to find free blocks in Created: 2017-09-22  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Tests
Affects Version/s: 10.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2-big/builds/1218

innodb.innodb_zip_innochecksum2 '16k,innodb_plugin' w1 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2017-09-21 21:00:35
line
2017-09-21 20:59:56 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:56 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:56 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:56 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:56 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
2017-09-21 20:59:57 ab4b2f40  InnoDB: Warning: difficult to find free blocks in
^ Found warnings in /mnt/buildbot/build/mariadb-10.1.27/mysql-test/var/1/log/mysqld.1.err



 Comments   
Comment by Marko Mäkelä [ 2023-11-29 ]

This type of failure is related to the page flushing. The multi-threaded flushing in MariaDB Server 10.1 was replaced with the MySQL 5.7 multi-threaded flushing in MariaDB Server 10.2. It might have fixed this.

In MariaDB Server 10.5, we went back to a single buf_flush_page_cleaner thread, and until MDEV-26055 was fixed, it was easier to trigger this warning message in buffer pool hungry tests.

I guess that the test was renamed to innodb_zip.innochecksum_2 at some point. I did not find this failure in the cross-reference. I also searched for the test encryption.innochecksum and found some failures of this kind. Unfortunately, due to a bug in the cross-reference tool that elenst is aware of, all I got was "Error loading data".

Generated at Thu Feb 08 08:09:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.