[MDEV-13875] rpl.rpl_row_img_eng_min, rpl.rpl_row_img_blobs, rpl.rpl_row_img_eng_noblob failed in buildbot with command "diff_files" failed Created: 2017-09-22  Updated: 2023-11-29  Resolved: 2023-11-29

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.1
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-14358 rpl.rpl_row_img_eng_noblob failed in ... Closed

 Description   

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/1061

rpl.rpl_row_img_eng_min 'innodb_plugin,row' w4 [ fail ]
        Test ended at 2017-09-16 20:23:35
 
CURRENT_TEST: rpl.rpl_row_img_eng_min
mysqltest: In included file "./include/rpl_row_img_general_loop.inc": 
included from /usr/share/mysql/mysql-test/suite/rpl/t/rpl_row_img_eng_min.test at line 34:
At line 39: command "diff_files" failed with error: 2  my_errno: 0  errno: -1
 
The result from queries just before the failure was:
< snip >
UPDATE t SET c2 = '5' WHERE c1 = 1;
UPDATE t SET c1 = '5' WHERE c1 = 1;
UPDATE t SET c4 = '8' WHERE c2 = '4';
UPDATE t SET c1 = '8' WHERE c2 = '4';
UPDATE t SET c2 = '8' WHERE c2 = '4';
UPDATE t SET c3 = '0' WHERE c4 = NULL;
UPDATE t SET c2 = '0' WHERE c4 = '0';
UPDATE t SET c2 = '2' WHERE c4 = '2';
include/rpl_sync.inc
include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
--- /dev/shm/var/4/mysqld.1/data//diff_table-server_1-test-t	2017-09-16 20:23:35.020158970 -0400
+++ /dev/shm/var/4/mysqld.2/data//diff_table-server_2-test-t	2017-09-16 20:23:35.020158970 -0400
@@ -1,6 +1 @@
-2	1	2	7
-3	1	3	7
-5	5	1	5
-7	7	7	7
-8	8	4	8
-9	9	9	7
+1	1	1	1
 
More results from queries before failure can be found in /dev/shm/var/4/log/rpl_row_img_eng_min.log
 
 - saving '/dev/shm/var/4/log/rpl.rpl_row_img_eng_min-innodb_plugin,row/' to '/dev/shm/var/log/rpl.rpl_row_img_eng_min-innodb_plugin,row/'



 Comments   
Comment by Elena Stepanova [ 2017-11-10 ]

rpl.rpl_row_img_blobs 'row,xtradb'       w2 [ fail ]
        Test ended at 2017-10-09 06:20:39
 
CURRENT_TEST: rpl.rpl_row_img_blobs
mysqltest: In included file "./include/rpl_row_img_general_loop.inc": 
included from /usr/share/mysql/mysql-test/suite/rpl/t/rpl_row_img_blobs.test at line 41:
At line 36: command "diff_files" failed with error: 2  my_errno: 0  errno: -1
 
The result from queries just before the failure was:
< snip >
SET SQL_LOG_BIN=1;
SET SQL_LOG_BIN=1;
INSERT INTO t VALUES (1, "a", 10);
INSERT INTO t VALUES (2, "b", 20);
INSERT INTO t VALUES (3, "c", 30);
include/rpl_sync.inc
UPDATE t SET c1=10 WHERE c2="a";
UPDATE t SET c1=20 WHERE c1=2;
UPDATE t SET c1=30 WHERE c3=30;
UPDATE t SET c3=40 WHERE c1=30;
include/rpl_sync.inc
include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
--- /dev/shm/var/2/mysqld.1/data//diff_table-server_1-test-t	2017-10-09 06:20:39.569721500 -0400
+++ /dev/shm/var/2/mysqld.2/data//diff_table-server_2-test-t	2017-10-09 06:20:39.569721500 -0400
@@ -1,3 +1,3 @@
+2	b	20
+3	c	30
 10	a	10
-20	b	20
-30	c	40

Comment by Elena Stepanova [ 2017-11-10 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/1192/steps/mtr/logs/stdio

rpl.rpl_row_img_eng_noblob 'row,xtradb'  w1 [ fail ]
        Test ended at 2017-10-22 17:24:45
 
CURRENT_TEST: rpl.rpl_row_img_eng_noblob
mysqltest: In included file "./include/rpl_row_img_general_loop.inc": 
included from /usr/share/mysql/mysql-test/suite/rpl/t/rpl_row_img_eng_noblob.test at line 34:
At line 39: command "diff_files" failed with error: 1  my_errno: 0  errno: -1
 
The result from queries just before the failure was:
< snip >
UPDATE t SET c1 = '5' WHERE c1 = 1;
UPDATE t SET c4 = '8' WHERE c2 = '4';
UPDATE t SET c1 = '8' WHERE c2 = '4';
UPDATE t SET c2 = '8' WHERE c2 = '4';
UPDATE t SET c3 = '0' WHERE c4 = NULL;
UPDATE t SET c2 = '0' WHERE c4 = '0';
UPDATE t SET c2 = '2' WHERE c4 = '2';
include/rpl_sync.inc
include/diff_tables.inc [server_1:test.t, server_2:test.t, server_3:test.t]
--- /dev/shm/var/1/mysqld.1/data//diff_table-server_1-test-t	2017-10-22 17:24:45.253403230 -0400
+++ /dev/shm/var/1/mysqld.2/data//diff_table-server_2-test-t	2017-10-22 17:24:45.253403230 -0400
@@ -1,6 +1,6 @@
+1	5	1	5
 2	1	2	7
 3	1	3	7
-5	5	1	5
+4	4	4	7
 7	7	7	7
-8	8	4	8
 9	9	9	7
 
More results from queries before failure can be found in /dev/shm/var/1/log/rpl_row_img_eng_noblob.log

Comment by Elena Stepanova [ 2018-05-07 ]

http://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-ppc64le/builds/2034

rpl.rpl_row_basic_2myisam 'row'          w3 [ fail ]
        Test ended at 2018-04-10 11:02:14
 
CURRENT_TEST: rpl.rpl_row_basic_2myisam
mysqltest: In included file "./include/diff_tables.inc": 
included from ./extra/rpl_tests/rpl_row_basic.test at line 679:
included from /usr/share/mysql/mysql-test/suite/rpl/t/rpl_row_basic_2myisam.test at line 7:
At line 186: command "diff_files" failed with error: 2  my_errno: 0  errno: -1
 
The result from queries just before the failure was:
< snip >
DELETE FROM t1 WHERE a < 8 LIMIT 8;
INSERT INTO t1 ( a ) VALUES ( 6 );
DELETE FROM t1 WHERE a < 6 LIMIT 7;
UPDATE t1 SET a = 7 WHERE a = 3 LIMIT 7;
UPDATE t1 SET a = 8 WHERE a = 0 LIMIT 6;
INSERT INTO t1 ( a ) VALUES ( 7 );
DELETE FROM t1 WHERE a < 9 LIMIT 4;
INSERT INTO t1 ( a ) VALUES ( 7 );
INSERT INTO t1 ( a ) VALUES ( 6 );
UPDATE t1 SET a = 8 WHERE a = 3 LIMIT 4;
DELETE FROM t1 WHERE a = 2 LIMIT 9;
DELETE FROM t1 WHERE a = 1 LIMIT 4;
UPDATE t1 SET a = 4 WHERE a = 2 LIMIT 7;
INSERT INTO t1 ( a ) VALUES ( 0 );
DELETE FROM t1 WHERE a < 3 LIMIT 0;
UPDATE t1 SET a = 8 WHERE a = 5 LIMIT 2;
INSERT INTO t1 ( a ) VALUES ( 1 );
UPDATE t1 SET a = 9 WHERE a < 5 LIMIT 3;
include/diff_tables.inc [master:t1, slave:t1]
Binary files /dev/shm/var/3/mysqld.1/data//diff_table-master-test-t1 and /dev/shm/var/3/mysqld.2/data//diff_table-slave-test-t1 differ
 
More results from queries before failure can be found in /dev/shm/var/3/log/rpl_row_basic_2myisam.log
 
 - saving '/dev/shm/var/3/log/rpl.rpl_row_basic_2myisam-row/' to '/dev/shm/var/log/rpl.rpl_row_basic_2myisam-row/'
 
Retrying test rpl.rpl_row_basic_2myisam, attempt(2/3)...

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