Bug #91632 main.daemonize_opt causes test flakiness
Submitted: 13 Jul 2018 18:51 Modified: 15 Jul 2018 6:10
Reporter: Manuel Ung Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:8.0.11 OS:Any
Assigned to: CPU Architecture:Any

[13 Jul 2018 18:51] Manuel Ung
It seems like there's a race condition in mysql-test-run.pl when the --daemonize option is passed in, such that the server datadir is cleared before the server actually finishes exiting.

How to repeat:
Build in release:

Run a few times, and hopefully main.auto_increment will fail.
./mtr --mem main.daemonize_opt main.auto_increment

main.auto_increment                      w2 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2018-07-12 18:18:35
2018-07-13T01:18:34.643068Z 0 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 2 in a file operation.
2018-07-13T01:18:34.643089Z 0 [ERROR] [MY-012593] [InnoDB] InnoDB: The error means the system cannot find the path specified.
2018-07-13T01:18:34.643098Z 0 [Warning] [MY-012093] [InnoDB] InnoDB: Cannot open './sys/sys_config.ibd'. Have you deleted .ibd files under a running mysqld server?
^ Found warnings in /mysql-test/var/2/log/mysqld.1.err

Suggested fix:
Not sure.
[15 Jul 2018 6:10] Umesh Shastry
Hello Manuel,

Thank you for the report and feedback.