[MDEV-10614] main.subselect_innodb fails sporadically in buildbot Created: 2016-08-20  Updated: 2023-11-29  Resolved: 2023-11-29

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

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Petrunia
Resolution: Won't Fix Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-7069 Fix buildbot failures in main server ... Stalled

 Description   

http://buildbot.askmonty.org/buildbot/builders/p8-rhel7-bintar/builds/1458/steps/test/logs/stdio

main.subselect_innodb 'innodb_plugin'    w2 [ fail ]
 
        Test ended at 2016-08-17 11:40:56
 
 
 
CURRENT_TEST: main.subselect_innodb
 
--- /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/r/subselect_innodb.result	2016-08-17 10:03:04.482303275 -0400
 
+++ /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysql-test/r/subselect_innodb.reject	2016-08-17 11:40:55.362804745 -0400
 
@@ -545,5 +545,5 @@
 
 t1;
 
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 
 1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	#	
-2	DEPENDENT SUBQUERY	t2	ref	key1	key1	5	test.t1.a	#	Using where; Using filesort
 
+2	DEPENDENT SUBQUERY	t2	index	key1	key2	5	NULL	#	Using where
 
 drop table t1,t2;
 
 
 
mysqltest: Result length mismatch



 Comments   
Comment by Elena Stepanova [ 2017-12-29 ]

Fresh occurrence on 10.1:
http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles12-amd64/builds/3935/steps/mtr/logs/stdio

main.subselect_innodb 'xtradb'           w3 [ fail ]
 
        Test ended at 2017-12-07 15:51:41
 
 
 
CURRENT_TEST: main.subselect_innodb
 
--- /usr/share/mysql-test/r/subselect_innodb.result	2017-12-07 10:25:32.000000000 -0500
 
+++ /dev/shm/var/3/log/subselect_innodb.reject	2017-12-07 15:51:41.713298499 -0500
 
@@ -574,7 +574,7 @@
 
 t1;
 
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
 
 1	PRIMARY	t1	ALL	NULL	NULL	NULL	NULL	#	
-2	DEPENDENT SUBQUERY	t2	ref	key1	key1	5	test.t1.a	#	Using where; Using filesort
 
+2	DEPENDENT SUBQUERY	t2	index	key1	key2	5	NULL	#	Using where
 
 drop table t1,t2;
 
 #
 
 
 
 # mdev-12931: semi-join in ON expression of STRAIGHT_JOIN 
 
 
mysqltest: Result length mismatch

Generated at Thu Feb 08 07:43:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.