Details
Description
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-zesty-amd64/builds/606/steps/mtr/logs/stdio
innodb_fts.innodb_fts_plugin 'innodb' w2 [ fail ] Found warnings/errors in server log file!
|
Test ended at 2017-09-06 15:02:02
|
line
|
2017-09-06 15:01:58 139764074350784 [ERROR] mysqld: Table './mysql/plugin' is marked as crashed and should be repaired
|
2017-09-06 15:01:58 139764074350784 [ERROR] mysqld: Table 'plugin' is marked as crashed and should be repaired
|
2017-09-06 15:01:58 139764074350784 [Warning] Checking table: './mysql/plugin'
|
2017-09-06 15:01:58 139764074350784 [ERROR] mysql.plugin: 1 client is using or hasn't closed the table properly
|
^ Found warnings in /dev/shm/var/2/log/mysqld.1.err
|
I suspect that the warnings occurred on slower builders where the server shutdown would time out and the server be forcibly killed. I added a FLUSH TABLES statement after the INSTALL PLUGIN statement to fix that.
Apart from this, the test occasionally delivered results in a different order. I fixed that by adding ORDER BY id to each SELECT statement that would return multiple rows.