Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.9, 10.10, 10.11, 11.0, 11.1
Description
The MDEV-27812 test innodb.log_file_size_online occasionally fails like this on Microsoft Windows:
|
10.9 717e3b3cfdb167e8b930323397dc6e852ef94f17 |
innodb.log_file_size_online 'encrypted,innodb' w8 [ fail ] timeout after 900 seconds
|
Test ended at 2023-05-11 16:08:09
|
|
|
Test case timeout after 900 seconds
|
|
|
== D:/winx64-packages/build/mysql-test/var/8/log/log_file_size_online.log ==
|
SET GLOBAL innodb_log_file_size=4194304;
|
|
|
== D:/winx64-packages/build/mysql-test/var/8/tmp/analyze-timeout-mysqld.1.err ==
|
SHOW PROCESSLIST;
|
Id User Host db Command Time State Info Progress
|
4 root localhost:49727 test Query 940 NULL SET GLOBAL innodb_log_file_size=4194304 0.000
|
5 root localhost:64052 NULL Query 0 starting SHOW PROCESSLIST 0.000
|
|
|
mysqltest failed but provided no output
|
The result from queries just before the failure was:
|
< snip >
|
SET GLOBAL innodb_log_file_size=4194304;
|
|
|
|
|
- saving 'D:/winx64-packages/build/mysql-test/var/8/log/innodb.log_file_size_online-encrypted,innodb/' to 'D:/winx64-packages/build/mysql-test/var/log/innodb.log_file_size_online-encrypted,innodb/'
|
One failure that I checked seemed to have an idle buf_flush_page_cleaner() thread and the SET GLOBAL thread looping in innodb_log_file_size_update(). Possibly a wake-up of the page cleaner is missing.
We will need more data from a debugger in order to understand what is going on. The contents of the global data structure log_sys during the hang needs to be known.
Attachments
Issue Links
- is caused by
-
MDEV-27812 Allow innodb_log_file_size to change without server restart
-
- Closed
-