Elena Stepanova added a comment - 2016-12-11 01:40 Okay, so, the patch was only pushed in 10.2. Saving the default value is redundant (because the test sets it at the end to Default anyway), but innocent, so let it be. unstable-tests list in 10.2 is meaningless, it shouldn't even be there, just got merged along with everything else. When the time comes, it will be created from scratch, it doesn't matter what's there now, so I won't roll back the change. The real problem is that the fix has nothing to do with the bug, I wish the commit message didn't mention this JIRA item. The problem for 10.0 and 10.1 remains (and no, we can't just disable the test as long as the variable exists). I'll keep the bug open, even though it will create a mess in the history, hopefully it won't matter much since it's just a test. Please in future create a different JIRA item.

Elena Stepanova added a comment - 2016-12-11 01:41 Recent occurrence on 10.1: http://buildbot.askmonty.org/buildbot/builders/kvm-deb-sid-amd64/builds/2425/steps/test_5/logs/stdio

Elena Stepanova added a comment - 2017-11-03 14:23 - edited It's the same issue as MDEV-9713 (with a different test), reproducible in the same way: diff --git a/storage/xtradb/buf/buf0dump.cc b/storage/xtradb/buf/buf0dump.cc index 51c41cc..54c3336 100644 --- a/storage/xtradb/buf/buf0dump.cc +++ b/storage/xtradb/buf/buf0dump.cc @@ -215,6 +215,8 @@ buf_dump( ut_snprintf(tmp_filename, sizeof(tmp_filename), "%s.incomplete", full_filename); + + my_sleep(1000000); buf_dump_status(STATUS_NOTICE, "Dumping buffer pool(s) to %s", full_filename); $ perl ./mtr sys_vars.innodb_buffer_pool_filename_basic,xtradb sys_vars.innodb_buffer_pool_dump_pct_basic,xtradb --mem --noreorder ... sys_vars.innodb_buffer_pool_dump_pct_basic 'xtradb' [ fail ] Test ended at 2017-11-03 16:22:29   CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_pct_basic mysqltest: At line 23: command "file_exists" failed with error: 1 my_errno: 0 errno: 2   The result from queries just before the failure was: SET @orig = @@global.innodb_buffer_pool_dump_pct; SELECT @orig; @orig 100 SET GLOBAL innodb_buffer_pool_dump_pct=3, GLOBAL innodb_buffer_pool_dump_now = ON;

Elena Stepanova added a comment - 2017-11-03 15:03 - edited Another test which still fails with a similar error is CURRENT_TEST: sys_vars.innodb_buffer_pool_dump_at_shutdown_basic mysqltest: At line 42: command "file_exists" failed with error: 1 my_errno: 175 errno: 2 However, on the second look, it doesn't seem to be the same problem. I've filed it separately as MDEV-14280 . sys_vars.innodb_buffer_pool_load_now_basic doesn't fail this way after the fix MDEV-9713 , but it fails with the timeout MDEV-14196 (especially on embedded), so the fix must be revised rather than repeated.

Elena Stepanova added a comment - 2017-11-03 22:35 sys_vars.innodb_buffer_pool_dump_now_basic is prone to the same error and reproducible in the same way as the original MDEV-9713 , but it has never happened in buildbot, apparently just due to the lucky ordering of tests – innodb_buffer_pool_filename_basic never goes before innodb_buffer_pool_dump_now_basic.