[MDEV-19043] few tests do not conduct shutdown or simulate crashes properly Created: 2019-03-25  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.0.38
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Andrei Elkin Assignee: Angelique Sklavounos (Inactive)
Resolution: Unresolved Votes: 0
Labels: None


 Description   

There are few tests that sporadically fail due to missed FLUSH TABLES
right before a crash (shutdown). BB shows few with a trace line the following:

rpl.rpl_mdev12179 'innodb,row' w2 [ fail ] Found warnings/errors in server log file! Test ended at 2018-01-25 22:06:19 line Attempting backtrace. You can use the following information to find out 2018-01-25 22:06:18 6 [ERROR] mysqld: Table './mysql/gtid_slave_pos' is marked as crashed and should be repaired
 
rpl.rpl_domain_id_filter_master_crash 'innodb,mix' w45 [ fail ]  Found warnings/errors in server log file!
        Test ended at 2019-03-25 11:30:18
line
2019-03-25 11:30:17 140138147560448 [ERROR] mysqld: Table './mysql/user' is marked as crashed and should be repaired
 
rpl.rpl_domain_id_filter_restart 'row' [ fail ] Test ended at 2017-12-05 15:17:59 CURRENT_TEST: rpl.rpl_domain_id_filter_restart --- /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/suite/rpl/r/rpl_domain_id_filter_restart.result 2017-12-04 02:52:56.000000000 +0200 +++ /private/var/lib/buildslave/maria-slave/labrador/build/mysql-test/suite/rpl/r/rpl_domain_id_filter_restart.reject 2017-12-05 15:17:59.000000000 +0200 @@ -39,6 +39,10 @@ SELECT * FROM t1; i 1 +Warnings: +Error 145 Table './test/t1' is marked as crashed and should be repaired +Error 1194 Table 't1' is marked as crashed and should be repaired 

These tests, specifically ones for replication, need to be identified and refined.
A hint to locate: https://internal.askmonty.org/buildbot/reports/cross_reference#branch=&revision=&platform=&dt=&bbnum=&typ=&info=&fail_name=rpl&fail_variant=&fail_info_short=&fail_info_full=is+marked+as+crashed&limit=100



 Comments   
Comment by Sergey Vojtovich [ 2019-03-25 ]

Affects 5.5 as well: http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest2/builds/15475/steps/mtr_nm/logs/stdio

I can imagine either 10 seconds is not enough to let server go down or there's race condition on shutdown that makes the server hang (there're plenty of those).

Also please use public xref, so that everybody interested can access it: http://buildbot.askmonty.org/buildbot/reports/cross_reference#branch=&revision=&platform=&dt=&bbnum=&typ=&info=&fail_name=rpl&fail_variant=&fail_info_short=&fail_info_full=is+marked+as+crashed&limit=100

Generated at Thu Feb 08 08:48:38 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.