Description:
During the Random Query Generator (RQG) test "falcon_online_alter" on Windows, suspicious error messages appear in the log, e.g.:
# 23:23:17 Query: ALTER TABLE `cc` DROP KEY q failed: 7 Error on rename of '.\test\#sql-10c0_14.frm' to '.\test\cc.frm' (Errcode: 13)
This is the same type of error message as seen in Bug#39670 ("Error on rename (errno: 121) from ALTER TABLE ADD KEY in concurrent test").
These error messages are typically seen a minute or so into the test on Pushbuild 2. OS Error code 13 is "Permission denied".
The error messages are often accompanied by errors of the following type:
INSERT INTO `aa` ( `varchar_key` , `date_nokey` ) VALUES ( 9 , 9 ) failed: 1017 Can't find file: '.\test\aa.frm' (errno: 13)
and
SELECT `int_key` FROM `bb` WHERE `datetime_key` < 0 failed: 1032 Can't find record in 'bb'
Note that none of these error messages currently make the test fail.
Seems to happen only on Windows.
How to repeat:
You need both a fresh & compiled Falcon repository (mysql-60-falcon-team, referred to as %FALCON%) as well as a fresh copy of the RQG (mysql-test-extra-6.0).
(test-extra:)
cd mysql-test\gentest
perl runall.pl
--basedir=%FALCON%
--mysqld=--loose-falcon-lock-wait-timeout=5
--mysqld=--loose-falcon-debug-mask=2
--mysqld=--skip-safemalloc
--grammar=conf/falcon_online_alter.yy
--reporters=Deadlock,ErrorLog,Backtrace,Recovery,WinPackage,Shutdown
--duration=1200
--vardir=%FALCON%\vardirs
--mysqld=--log-output=file
--queries=100000
--engine=falcon
Observe the test output.
Suggested fix:
See similar bugs Bug#39670 and Bug#38041 for potential hints.
