Bug #78302 main.status fails on Linux environment for valgrind runs
Submitted: 2 Sep 2015 8:40 Modified: 17 Feb 2016 5:33
Reporter: Mohit Joshi Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:8.0 OS:Linux
Assigned to: Mohit Joshi CPU Architecture:Any

[2 Sep 2015 8:40] Mohit Joshi 
Description:
main.status                              w12 [ fail ]
        Test ended at 2015-08-23 19:46:33

CURRENT_TEST: main.status
==4227== Memcheck, a memory error detector
==4227== Copyright (C) 2002-2012, and GNU GPL'd, by Julian Seward et al.
==4227== Using Valgrind-3.8.1 and LibVEX; rerun with -h for copyright info
==4227== Command: /export/home2/pb2/test/sb_1-16238694-1440343689.13/mysql-advanced-5.8.0-m17-linux-x86_64-valgrind/bin/mysqltest --defaults-file=/dev/shm/mtr-15964/var-all_default_valgrind/12/my.cnf --silent --tmpdir=/dev/shm/mtr-15964/var-all_default_valgrind/tmp/12 --character-sets-dir=/export/home2/pb2/test/sb_1-16238694-1440343689.13/mysql-advanced-5.8.0-m17-linux-x86_64-valgrind/share/charsets --logdir=/dev/shm/mtr-15964/var-all_default_valgrind/12/log --plugin_dir=/export/home2/pb2/test/sb_1-16238694-1440343689.13/mysql-advanced-5.8.0-m17-linux-x86_64-valgrind/lib/plugin --database=test --timer-file=/dev/shm/mtr-15964/var-all_default_valgrind/12/log/timer --test-file=/export/home2/pb2/test/sb_1-16238694-1440343689.13/mysql-advanced-5.8.0-m17-linux-x86_64-valgrind/mysql-test/t/status.test --tail-lines=20 --result-file=/export/home2/pb2/test/sb_1-16238694-1440343689.13/mysql-advanced-5.8.0-m17-linux-x86_64-valgrind/mysql-test/r/status.result
==4227== 
mysqltest: At line 80: query 'reap' failed: 1205: Lock wait timeout exceeded; try restarting transaction

How to repeat:
perl mysql-test-run.pl --timer --debug-server --force --parallel=auto --max-test-fail=0 --comment=all_default_valgrind --vardir=/dev/shm/mtr-15964/var-all_default_valgrind --experimental=collections/default.experimental status --valgrind --valgrind-option=--gen-suppressions=all --valgrind-option=--show-reachable=yes

Suggested fix:
None
[2 Sep 2015 12:15] MySQL Verification Team 
Hello Mohit,

Thank you for the report.

Thanks,
Umesh
[18 Jun 2016 21:27] Omer Barnir 
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0