Sporadic failure in spider.spider_fixes_part

spider.spider_fixes_part                 w2 [ fail ]

        Test ended at 2023-03-26 05:57:41

CURRENT_TEST: spider.spider_fixes_part

analyze: sync_with_master

mysqltest: At line 492: sync_with_master failed: 'select master_pos_wait('master-bin.000003', 692, 300, '')' returned NULL indicating slave SQL thread failure

The result from queries just before the failure was:

< snip >

KEY idx1(b),

KEY idx2(c)

) MASTER_1_ENGINE MASTER_1_CHARSET MASTER_1_COMMENT3_P_2_1

INSERT INTO ta_l_int (a, b, c) VALUES (1, 2, 3);

INSERT INTO ta_l_int (a, b, c) SELECT a + 1, b + 1, c + 1 FROM ta_l_int;

INSERT INTO ta_l_int (a, b, c) SELECT a + 2, b + 2, c + 2 FROM ta_l_int;

INSERT INTO ta_l_int (a, b, c) SELECT a + 4, b + 4, c + 4 FROM ta_l_int;

INSERT INTO ta_l_int (a, b, c) SELECT a + 8, b + 8, c + 8 FROM ta_l_int;

connection master_1;

SELECT a, b, c FROM ta_l_int force index(primary, idx1, idx2)

WHERE a = 5 OR b = 5 OR c = 5 ORDER BY a;

a	b	c

3	4	5

4	5	6

5	6	7

2.26

auto_increment with partition

connection master_1;

connection slave1_1;

More results from queries before failure can be found in /<<PKGBUILDDIR>>/builddir/mysql-test/var/2/log/spider_fixes_part.log

 == /<<PKGBUILDDIR>>/builddir/mysql-test/var/2/tmp/analyze-sync_with_master-mysqld.1.1.err ==

############################## default ##############################

**** SHOW WARNINGS on default ****

SHOW WARNINGS;

Level	Code	Message

**** SELECT replication-related variables on default ****

SELECT NOW(), @@SERVER_ID;

NOW()	@@SERVER_ID

2023-03-26 05:57:41	1

**** SHOW SLAVE STATUS on default ****

SHOW SLAVE STATUS;

**** SHOW MASTER STATUS on default ****

SHOW MASTER STATUS;

File	master-bin.000003

Position	692

Binlog_Do_DB	

Binlog_Ignore_DB	

**** SHOW SLAVE HOSTS on default ****

SHOW SLAVE HOSTS;

Server_id	8

Host	localhost

Port	16007

Master_id	1

**** SHOW PROCESSLIST on default ****

SHOW PROCESSLIST;

Id	User	Host	db	Command	Time	State	Info	Progress

92	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

93	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

94	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

95	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

96	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

97	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

98	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

99	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

100	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

101	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

102	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

103	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

104	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

105	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

106	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

107	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

108	system user		NULL	Sleep	1	Reset for next command	NULL	0.000

109	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

110	system user		NULL	Daemon	NULL	Spider table background statistics action handler	NULL	0.000

111	system user		NULL	Daemon	NULL	Spider table background cardinality action handler	NULL	0.000

112	root	localhost:57406	NULL	Binlog Dump	0	Master has sent all binlog to slave; waiting for more updates	NULL	0.000

113	root	localhost	NULL	Query	0	starting	SHOW PROCESSLIST	0.000

**** SHOW BINARY LOGS on default ****

SHOW BINARY LOGS;

Log_name	File_size

master-bin.000001	8704

master-bin.000002	419

master-bin.000003	692

**** SHOW BINLOG EVENTS on default ****

binlog_name = 'master-bin.000003'

SHOW BINLOG EVENTS IN 'master-bin.000003';

Log_name	Pos	Event_type	Server_id	End_log_pos	Info

master-bin.000003	4	Format_desc	1	256	Server ver: 10.11.2-MariaDB-2~ubuntu23.04.1~1679807146.b55a2e, Binlog ver: 4

master-bin.000003	256	Gtid_list	1	299	[0-1-39]

master-bin.000003	299	Binlog_checkpoint	1	343	master-bin.000002

master-bin.000003	343	Binlog_checkpoint	1	387	master-bin.000003

master-bin.000003	387	Gtid	1	429	BEGIN GTID 0-1-40

master-bin.000003	429	Query	1	620	use `mtr`; INSERT INTO test_suppressions (pattern) VALUES ( NAME_CONST('pattern',_latin1'unknown variable' COLLATE 'latin1_swedish_ci'))

master-bin.000003	620	Query	1	692	COMMIT

**** SHOW RELAYLOG EVENTS on default ****

relaylog_name = 'No such row'

SHOW RELAYLOG EVENTS IN 'No such row';

Log_name	Pos	Event_type	Server_id	End_log_pos	Info

connection default;