Description:
Various tests in the mysql test suite are failing due to ALTER TABLE statements not
processing:
Could be related to Bug #39670 Error on rename (errno: 121) from ALTER TABLE ADD KEY in
concurrent test
main.innodb_mysql [ fail ]
mysqltest: In included file "./include/mix1.inc": At line 1219: query 'alter table t1
change i c char(10) default "Two"' failed: 7: Error on rename of './test/#sql-5165_1.frm'
to './test/t1.frm' (Errcode: 2)
This is random and has been observed about 30 times out of 230+ runs of a set of 12
suspect tests:
main.synchronization
main.innodb_mysql
main.index_merge_myisam
main.symlink
main.warnings
main.mysql_upgrade
binlog.binlog_stm_blackhole 'row'
binlog.binlog_stm_blackhole 'stmt'
binlog.binlog_stm_blackhole 'mix'
rpl.rpl_blackhole 'row'
rpl.rpl_blackhole 'stmt'
rpl.rpl_blackhole 'mix'
How to repeat:
Run the above listed tests repeatedly. There doesn't appear to be a particular trigger
or pattern to the failures, but all have been noted to have failing ALTER TABLE
statements.
./mtr --force --timer rpl_blackhole synchronization innodb_mysql index_merge_myisam
symlink warnings mysql_upgrade binlog_stm_blackhole
Suggested fix:
Unknown. However, I would suggest by examining ALTER TABLE code.
