Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
Description
To help identify hangs, MDEV-33053 introduced an InnoDB warning message. This warning is occasionally being issued during the execution of a number tests. So far, the following tests have been observed failing due to this added warning:
encryption.innodb_encrypt_temporary_tables
|
galera.galera_gcache_recover_full_gcache
|
innodb_fts.innodb_fts_misc_1
|
innodb.ibuf_delete
|
innodb.innodb-64k-crash
|
innodb.innodb_stats_external_pages
|
innodb.innodb-wl5522-debug
|
innodb.purge_secondary
|
Here is an example:
bb-11.2-release fccc1fa3f5e0fed4033a0bb46155e60220a3ba1 |
galera.galera_gcache_recover_full_gcache 'innodb' w1 [ fail ] Found warnings/errors in server log file!
|
Test ended at 2024-01-25 17:27:49
|
line
|
2024-01-25 17:27:34 0 [Warning] InnoDB: Could not free any blocks in the buffer pool! 496 blocks are in use and 0 free. Consider increasing innodb_buffer_pool_size.
|
^ Found warnings in /home/buildbot/amd64-ubuntu-2304/build/mysql-test/var/1/log/mysqld.1.err
|
ok
|
|
- saving '/home/buildbot/amd64-ubuntu-2304/build/mysql-test/var/1/log/galera.galera_gcache_recover_full_gcache-innodb/' to '/home/buildbot/amd64-ubuntu-2304/build/mysql-test/var/log/galera.galera_gcache_recover_full_gcache-innodb/'
|
I think that we simply need to add a global suppression for this warning:
diff --git a/mysql-test/mariadb-test-run.pl b/mysql-test/mariadb-test-run.pl
|
index 2750e10ecf5..3253de4185f 100755
|
--- a/mysql-test/mariadb-test-run.pl
|
+++ b/mysql-test/mariadb-test-run.pl
|
@@ -4454,6 +4454,7 @@ sub extract_warning_lines ($$) {
|
qr/InnoDB: Warning: a long semaphore wait:/,
|
qr/InnoDB: Dumping buffer pool.*/,
|
qr/InnoDB: Buffer pool.*/,
|
+ qr/InnoDB: Could not free any blocks in the buffer pool!/,
|
qr/InnoDB: Warning: Writer thread is waiting this semaphore:/,
|
qr/InnoDB: innodb_open_files .* should not be greater than/,
|
qr/Slave: Unknown table 't1' .* 1051/, |
Attachments
Issue Links
- is caused by
-
MDEV-33053 InnoDB LRU flushing does not run before running out of buffer pool
- Closed