Upstream 5.5 test failures with --repeat=2

[Laurynas Biveinis]

Missed testcase cleanups:

rpl.rpl_rotate_logs 'mix' [ pass ] 1082
rpl.rpl_rotate_logs 'mix' [ fail ]
        Test ended at 2016-08-05 10:23:08

CURRENT_TEST: rpl.rpl_rotate_logs
mysqltest: At line 25: File already exist: '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/mysqld.2/data//master.info'

[Laurynas Biveinis (laurynas-biveinis)]

binlog.binlog_bug36391 'mix' [ pass ] 209
binlog.binlog_bug36391 'mix' [ fail ]
        Test ended at 2016-08-05 10:33:28

CURRENT_TEST: binlog.binlog_bug36391
ERROR 1051 (42S02) at line 23: Unknown table 't1'
mysqltest: At line 26: command "$MYSQL_BINLOG $binlog_path | $MYSQL test" failed

Output from before failure:
exec of '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/client//mysqlbinlog --defaults-file=/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/my.cnf /Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/mysqld.1/data/master-bin.000002 | /Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/client//mysql --defaults-file=/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/my.cnf test' failed, error: 256, status: 1, errno: 22

The result from queries just before the failure was:
CREATE TABLE t1(id INT);
SHOW TABLES;
Tables_in_test
t1
FLUSH LOGS;
DROP TABLE t1;

[Laurynas Biveinis (laurynas-biveinis)]

main.func_str [ pass ] 680
main.func_str [ fail ]
        Test ended at 2016-08-05 11:22:14

CURRENT_TEST: main.func_str
mysqltest: At line 1379: query 'SELECT 'aaaaaaaaaaaaaa' INTO OUTFILE '$MYSQLTEST_VARDIR/tmp/bug58165.txt';' failed: 1086: File '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/tmp/bug58165.txt' already exists

The result from queries just before the failure was:
< snip >
1
1
DROP TABLE t1;
#
# Bug#57913 large negative number to string conversion functions crash
# Bug#57810 case/when/then : Assertion failed: length || !scale
#
SELECT '1' IN ('1', SUBSTRING(-9223372036854775809, 1));
'1' IN ('1', SUBSTRING(-9223372036854775809, 1))
1
SELECT CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3));
CONVERT(('' IN (REVERSE(CAST(('') AS DECIMAL)), '')), CHAR(3))
1
Warnings:
Warning 1292 Truncated incorrect DECIMAL value: ''
#
# Bug#58165: "my_empty_string" gets modified and causes LOAD DATA to fail
# and other crashes
#
CREATE TABLE t1 ( a TEXT );

[Laurynas Biveinis (laurynas-biveinis)]

parts.partition_special_myisam [ pass ] 3138
parts.partition_special_myisam [ fail ]
        Test ended at 2016-08-05 11:24:44

CURRENT_TEST: parts.partition_special_myisam
mysqltest: At line 66: File already exist: '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/mysqld.1/data//test/load.in'

The result from queries just before the failure was:
< snip >
2000-06-15 jukg zikhuk m 45675 6465754.13 435242623462 18 2000-06-15 jukg zikhuk m 45675 6465754.13 435242623462 18 2000-06-15 jukg zikhuk m 45675 6465754.13 435242623462 18 2000-06-15 jukg zikhuk m 45675 6465754.13 435242623462 18 pib mdotkbm.m
select * from t1 where a<19851231;
a b c d e f g h a1 b1 c1 d1 e1 f1 g1 h1 a2 b2 c2 d2 e2 f2 g2 h2 a3 b3 c3 d3 e3 f3 g3 h3 i
1980-10-14 fgbbd dtzndtz w 67856 5463354.67 3567845333 124 1980-10-14 fgbbd dtzndtz w 67856 5463354.67 3567845333 124 1980-10-14 fgbbd dtzndtz w 67856 5463354.67 3567845333 124 1980-10-14 fgbbd dtzndtz w 67856 5463354.67 3567845333 124 d,f söierugsig msireg siug ei5ggth lrutluitgzeöjrtnb.rkjthuekuhzrkuthgjdnffjmbr
1983-12-31 cdef srtbvsr w 45634 13452.56 3452346456 127 1983-12-31 cdef srtbvsr w 45634 13452.56 3452346456 127 1983-12-31 cdef srtbvsr w 45634 13452.56 3452346456 127 1983-12-31 cdef srtbvsr w 45634 13452.56 3452346456 127 liuugbzvdmrlti b itiortudirtfgtibm dfi
1975-01-01 abcde abcde m 1234 123.45 32412341234 113 1975-01-01 abcde abcde m 1234 123.45 32412341234 113 1975-01-01 abcde abcde m 123123.45 32412341234 113 1975-01-01 abcde abcde m 1234 123.45 32412341234 113 tbhth nrzh ztfghgfh fzh ftzhj fztjh
drop table t1;
#
# Bug#53770: Server crash at handler.cc:2076 on LOAD DATA
# after timed out COALESCE PARTITION
CREATE TABLE t1 ( i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, f INT )
ENGINE = MyISAM PARTITION BY HASH(i) PARTITIONS 3;
# Connection 1 starts transaction and gets lock
START TRANSACTION;
SELECT * FROM t1;
i f
SET lock_wait_timeout = 2;
# Connection 2 tries to coalesce partitions (timeout):
ALTER TABLE t1 COALESCE PARTITION 2;
ERROR HY000: Lock wait timeout exceeded; try restarting transaction

[Laurynas Biveinis (laurynas-biveinis)]

main.loaddata [ pass ] 348
main.loaddata [ fail ]
        Test ended at 2016-08-05 11:27:07

CURRENT_TEST: main.loaddata
mysqltest: At line 629: query 'SELECT '1\n' INTO DUMPFILE '$file'' failed: 1086: File '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/tmp/bug11735141.txt' already exists

The result from queries just before the failure was:
< snip >
test
DROP TABLE t1;
#
# Bug #52512 : Assertion `! is_set()' in
# Diagnostics_area::set_ok_status on LOAD DATA
#
CREATE TABLE t1 (id INT NOT NULL);
LOAD DATA LOCAL INFILE 'tb.txt' INTO TABLE t1;
DROP TABLE t1;
#
# Bug#11765139 58069: LOAD DATA INFILE: VALGRIND REPORTS INVALID MEMORY READS AND WRITES WITH U
#
CREATE TABLE t1(f1 INT);
SELECT 0xE1BB30 INTO OUTFILE 't1.dat';
LOAD DATA INFILE 't1.dat' IGNORE INTO TABLE t1 CHARACTER SET utf8;
DROP TABLE t1;
#
# Bug#11765141 - 58072: LOAD DATA INFILE: LEAKS IO CACHE MEMORY
# WHEN ERROR OCCURS
#

[Laurynas Biveinis (laurynas-biveinis)]

main.temp_pool w4 [ fail ]
        Test ended at 2016-08-05 00:40:45

CURRENT_TEST: main.temp_pool
mysqltest: At line 27: query 'SELECT a FROM t1 ORDER BY rand(1)' succeeded - should have failed with errno 1...

The result from queries just before the failure was:
#
# BUG#11747548:DETECT ORPHAN TEMP-POOL FILES, AND HANDLE GRACEFULLY.
#
#Set up.
CREATE TABLE pid_table(pid_no INT);
CREATE TABLE t1 (a BLOB);
INSERT INTO t1 VALUES (1), (2);
#Create MYD and MYI files for intrinsic temp table.
LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
#Reports an error since the temp file already exists.
safe_process[11863]: Child process: 11864, exit: 1

 - saving '/mnt/workspace/percona-server-5.5-repeat/BUILD_TYPE/release/Host/amd64/MTR_REPEAT/2/mysql-test/var/4/log/main.temp_pool/' to '/mnt/workspace/percona-server-5.5-repeat/BUILD_TYPE/release/Host/amd64/MTR_REPEAT/2/mysql-test/var/log/main.temp_pool/'

Retrying test main.temp_pool, attempt(2/3)...

[Laurynas Biveinis (laurynas-biveinis)]

rpl.rpl_binlog_errors 'mix' [ pass ] 50118
rpl.rpl_binlog_errors 'mix' [ fail ]
        Test ended at 2016-08-08 13:54:38

CURRENT_TEST: rpl.rpl_binlog_errors
mysqltest: At line 44: query 'SELECT repeat('x',8192) INTO OUTFILE '$load_file'' failed: 1086: File '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/tmp/bug_46166.data' already exists

The result from queries just before the failure was:
include/master-slave.inc
[connection master]
#######################################################################
####################### PART 1: MASTER TESTS ##########################
#######################################################################
include/stop_slave.inc
call mtr.add_suppression("Can't generate a unique log-filename");
call mtr.add_suppression("Writing one row to the row-based binary log failed.*");
call mtr.add_suppression("Error writing file .*");
SET @old_debug= @@global.debug;

 - saving '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/log/rpl.rpl_binlog_errors-mix/' to '/Users/laurynas/percona/obj-mtr-repeat-fixes-5.5-asan-debug/mysql-test/var/log/rpl.rpl_binlog_errors-mix/'

Only 1 of 3 completed.

[Laurynas Biveinis (laurynas-biveinis)]

rpl.rpl_row_find_row_debug 'row' w2 [ pass ] 316
rpl.rpl_row_find_row_debug 'row' w2 [ fail ]
        Test ended at 2016-08-05 05:48:02

CURRENT_TEST: rpl.rpl_row_find_row_debug
--- /mnt/workspace/percona-server-5.5-param/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/mysql-test/suite/rpl/r/rpl_row_find_row_debug.result 2016-08-05 12:29:57.506027000 +0300
+++ /mnt/workspace/percona-server-5.5-param/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/mysql-test/suite/rpl/r/rpl_row_find_row_debug.reject 2016-08-05 12:48:02.190027000 +0300
@@ -10,7 +10,7 @@
 DELETE FROM t1;
 DROP TABLE t1;
 # Check if any note related to long DELETE_ROWS and UPDATE_ROWS appears in the error log
-Occurrences: update=1, delete=1
+Occurrences: update=2, delete=2
 include/stop_slave.inc
 SET GLOBAL debug = '';
 SET GLOBAL log_warnings = 1;

mysqltest: Result content mismatch

[Laurynas Biveinis (laurynas-biveinis)]

innodb.innodb_bug12400341 [ pass ] 233
innodb.innodb_bug12400341 [ fail ]
        Test ended at 2016-08-08 14:22:33

CURRENT_TEST: innodb.innodb_bug12400341
mysqltest: At line 30: query 'CREATE TABLE mysqltest.transtable (id int unsigned NOT NULL PRIMARY KEY, val int DEFAULT 0) ENGINE=InnoDB' failed: 1005: Can't create table 'mysqltest.transtable' (errno: 177)

The result from queries just before the failure was:
call mtr.add_suppression("InnoDB: Warning: cannot find a free slot for an undo log. Do you have too");
show variables like "max_connections";
Variable_name Value
max_connections 64
show variables like "innodb_thread_concurrency";
Variable_name Value
innodb_thread_concurrency 0
show variables like "innodb_file_per_table";
Variable_name Value
innodb_file_per_table ON
drop database if exists mysqltest;
create database mysqltest;

[Laurynas Biveinis (laurynas-biveinis)]

(MariaDB upstream, already fixed there)

main.group_commit_binlog_pos w4 [ fail ]
        Test ended at 2016-08-05 06:25:34

CURRENT_TEST: main.group_commit_binlog_pos
--- /mnt/workspace/percona-server-5.5-param/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/mysql-test/r/group_commit_binlog_pos.result 2016-08-05 12:29:56.898027000 +0300
+++ /mnt/workspace/percona-server-5.5-param/BUILD_TYPE/debug/Host/ubuntu-precise-64bit/mysql-test/r/group_commit_binlog_pos.reject 2016-08-05 13:25:34.210027000 +0300
@@ -30,6 +30,6 @@
 1
 2
 3
-InnoDB: Last MySQL binlog file position 0 768, file name ./master-bin.000001
+InnoDB: Last MySQL binlog file position 0 872, file name ./master-bin.000002
 SET DEBUG_SYNC= 'RESET';
 DROP TABLE t1;

mysqltest: Result content mismatch

[Laurynas Biveinis (laurynas-biveinis)]

     https://github.com/percona/percona-server/pull/795
     https://github.com/percona/percona-server/pull/796
     https://github.com/percona/percona-server/pull/797

[Shahriyar Rzayev (rzayev-sehriyar)]

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