Many rpl failures under Valgrind

[Laurynas Biveinis]

http://jenkins.percona.com/view/Percona%20Server%205.5/job/percona-server-5.5-valgrind/BUILD_TYPE=valgrind,Host=ubuntu-natty-64bit/6/consoleFull

The same test passes in the upstream Valgrind runs, see -

http://jenkins.percona.com/job/mysql-5.5-trunk-valgrind/BUILD_TYPE=valgrind,Host=ubuntu-natty-64bit/6/consoleFull

rpl.rpl_row_mixing_engines 'row' w2 [ fail ]
        Test ended at 2011-06-23 06:29:55

CURRENT_TEST: rpl.rpl_row_mixing_engines
==12820== Memcheck, a memory error detector
==12820== Copyright (C) 2002-2010, and GNU GPL'd, by Julian Seward et al.
==12820== Using Valgrind-3.6.1 and LibVEX; rerun with -h for copyright info
==12820== Command: /mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/client//mysqltest --defaults-file=/mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/var/2/my.cnf --silent --tmpdir=/tmp/N4usMh90jx/2 --character-sets-dir=/mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/sql/share/charsets --logdir=/mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/var/2/log --plugin_dir=/mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/plugin/auth --database=test --timer-file=/mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/var/2/log/timer --test-file=/mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/suite/rpl/t/rpl_row_mixing_engines.test --tail-lines=20 --result-file=/mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/suite/rpl/r/rpl_row_mixing_engines.result
==12820==
mysqltest: In included file "./extra/rpl_tests/rpl_mixing_engines.inc":
included from ./extra/rpl_tests/rpl_mixing_engines.inc at line 460:
included from ./extra/rpl_tests/rpl_mixing_engines.test at line 1405:
At line 459: Error running query 'SELECT HEX(@command) = HEX('ISe-T<-N')': 2013 Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
master-bin.000001 # Query # # COMMIT
-e-e-e-e-e-e-e-e-e-e-e- >> N << -e-e-e-e-e-e-e-e-e-e-e-
-b-b-b-b-b-b-b-b-b-b-b- >> C << -b-b-b-b-b-b-b-b-b-b-b-
COMMIT;
Log_name Pos Event_type Server_id End_log_pos Info
-e-e-e-e-e-e-e-e-e-e-e- >> C << -e-e-e-e-e-e-e-e-e-e-e-
-b-b-b-b-b-b-b-b-b-b-b- >> B TeN-trig N C << -b-b-b-b-b-b-b-b-b-b-b-
Log_name Pos Event_type Server_id End_log_pos Info
master-bin.000001 # Query # # BEGIN
master-bin.000001 # Table_map # # table_id: # (test.nt_3)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # COMMIT
master-bin.000001 # Query # # BEGIN
master-bin.000001 # Table_map # # table_id: # (test.nt_1)
master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
master-bin.000001 # Query # # COMMIT
-e-e-e-e-e-e-e-e-e-e-e- >> B TeN-trig N C << -e-e-e-e-e-e-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b- >> B << -b-b-b-b-b-b-b-b-b-b-b-
BEGIN;

More results from queries before failure can be found in /mnt/workspace/percona-server-5.5-valgrind/BUILD_TYPE/valgrind/Host/ubuntu-natty-64bit/Percona-Server-5.5.13-rel20.4/mysql-test/var/2/log/rpl_row_mixing_engines.log

Server [mysqld.2 - pid: 4503, winpid: 4503, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
110623 9:24:01 [Note] 'CHANGE MASTER TO executed'. Previous state master_host='127.0.0.1', master_port='13010', master_log_file='', master_log_pos='4'. New state master_host='127.0.0.1', master_port='13010', master_log_file='master-bin.000001', master_log_pos='4'.
110623 9:24:01 [Note] Slave SQL thread initialized, starting replication in log 'master-bin.000001' at position 4, relay log './slave-relay-bin.000001' position: 4
110623 9:24:01 [Note] Slave I/O thread: connected to master 'root@127.0.0.1:13010',replication started in log 'master-bin.000001' at position 4
----------SERVER LOG END-------------

[Laurynas Biveinis (laurynas-biveinis)]

There are more rpl tests failing that did not fail upstream: pl.rpl_row_loaddata_concurrent rpl.rpl_row_func002 rpl.rpl_row_mixing_engines rpl.rpl_row_sp007_innodb, see the same Jenkins logs

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1204