[MDEV-18479] Assertion `join->best_read < double(1.79769313486231570815e+308L)' or server crashes in JOIN::fix_all_splittings_in_plan after EXPLAIN Created: 2019-02-05  Updated: 2019-06-11  Resolved: 2019-05-28

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s: 10.2.25, 5.5.65, 10.1.41, 10.3.16, 10.4.6

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-13607 MariaDB crash in fix_semijoin_strateg... Closed
Relates
relates to MDEV-19132 Strange combination of JOIN with NULL... Confirmed
relates to MDEV-19484 Server crashes in fix_semijoin_strate... Closed
relates to MDEV-19615 CRASH : [ERROR] mysqld got signal 11 Closed

 Description   

Please run the test with --repeat=N --force-restart, test is sporadic on debug version. Repeatable with MyIsam/Innodb on 5.5-10.4

CREATE TABLE t1 (id int auto_increment primary key, uid int NOT NULL, gp_id int NOT NULL, r int NOT NULL) ;
 
INSERT INTO `t1`(uid,gp_id,r)  VALUES (1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,1,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,2,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,3,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,4,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,5,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,6,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,7,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,8,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,9,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,10,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1),(1,11,1);
 
 
 
CREATE TABLE t2 (id int) ;
 
INSERT INTO t2 VALUES (1);
 
 
 
explain SELECT 1 FROM t2 JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
   )   gp_1 ON gp_1.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_2 ON gp_2.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p1 ON p1.r=1 AND p1.uid=t2.id
 
  JOIN t1 p3 ON p3.r=3 AND p3.uid=t2.id
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  ) gp_3 ON gp_3.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p1 ON p1.r=1 AND p1.uid=t2.id
 
  JOIN t1 p3 ON p3.r=3 AND p3.uid=t2.id
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_4 ON gp_4.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p1 ON p1.r=1 AND p1.uid=t2.id
 
  JOIN t1 p3 ON p3.r=3 AND p3.uid=t2.id
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_5 ON gp_5.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p1 ON p1.r=1 AND p1.uid=t2.id
 
  JOIN t1 p3 ON p3.r=3 AND p3.uid=t2.id
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_6 ON gp_6.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p1 ON p1.r=1 AND p1.uid=t2.id
 
  JOIN t1 p3 ON p3.r=3 AND p3.uid=t2.id
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  WHERE p1.gp_id=7)   gp_7 ON gp_7.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_8 ON gp_8.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_9 ON gp_9.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_14 ON gp_14.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )   gp_15 ON gp_15.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )  gp_16 ON gp_16.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
    JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
    JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
 
 
    JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
    JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
    JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
    JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
    )gp_17 ON gp_17.id=t2.id
 
JOIN
 
(SELECT t2.id
 
  FROM t2
 
  JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
  JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
  JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
  JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
  JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
  JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
  JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
  )gp_18 ON gp_18.id=t2.id
 
JOIN
 
(SELECT t2.id
 
 FROM t2
 
 JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
 JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
 JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
 JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
 JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
 JOIN t1 p9 ON p9.r=9 AND p9.uid=t2.id
 
 JOIN t1 p10 ON p10.r=10 AND p10.uid=t2.id
 
 )gp_19 ON gp_19.id=t2.id
 
JOIN
 
(SELECT t2.id
 
 FROM t2
 
 JOIN t1 p4 ON p4.r=4 AND p4.uid=t2.id
 
 JOIN t1 p5 ON p5.r=5 AND p5.uid=t2.id
 
 JOIN t1 p6 ON p6.r=6 AND p6.uid=t2.id
 
 JOIN t1 p7 ON p7.r=7 AND p7.uid=t2.id
 
 JOIN t1 p8 ON p8.r=8 AND p8.uid=t2.id
 
 ) gp_20 ON gp_20.id=t2.id ;
 
 
 
DROP TABLE  t1, t2;

5.5 9034e5e18e756eb8d

 
 /5.5/sql/sql_select.cc:6666: bool greedy_search(JOIN*, table_map, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
 
190205 12:32:59 [ERROR] mysqld got signal 6 ;
 
 
 
/usr/lib/x86_64-linux-gnu/libasan.so.2(+0x4a077)[0x7fea06315077]
 
row/row0row.c:235(row_build)[0x14e2448]
 
sql/sql_insert.cc:396(check_update_fields(THD*, TABLE_LIST*, List<Item>&, List<Item>&, bool, unsigned long long*))[0xa2fa07]
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7fea05a6b390]
 
linux/raise.c:54(__GI_raise)[0x7fea04e36428]
 
stdlib/abort.c:91(__GI_abort)[0x7fea04e3802a]
 
assert/assert.c:92(__assert_fail_base)[0x7fea04e2ebd7]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fea04e2ec82]
 
/5.5/sql/mysqld(_Z11choose_planP4JOINy+0xc72)[0x70594b]
 
/5.5/sql/mysqld(_ZN4JOIN8optimizeEv+0x72d0)[0x7610f0]
 
/5.5/sql/mysqld(_Z12mysql_selectP3THDPPP4ItemP10TABLE_LISTjR4ListIS1_ES2_jP8st_orderSB_S2_SB_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x1bad)[0x76808c]
 
/5.5/sql/mysqld(_Z19mysql_explain_unionP3THDP18st_select_lex_unitP13select_result+0x4b5)[0x7693db]
 
/5.5/sql/mysqld[0x66a9b9]
 
/5.5/sql/mysqld(_Z21mysql_execute_commandP3THD+0x16b5)[0x680967]
 
/5.5/sql/mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x3e9)[0x692640]
 
/5.5/sql/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x19e2)[0x695a3d]
 
/5.5/sql/mysqld(_Z10do_commandP3THD+0x695)[0x699b1b]
 
/5.5/sql/mysqld(_Z24do_handle_one_connectionP3THD+0x34d)[0x8cbd08]
 
/5.5/sql/mysqld(handle_one_connection+0xdc)[0x8cbf81]
 
myisam/rt_mbr.c:502(rtree_overlapping_area)[0x1439774]
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fea05a616ba]
 
x86_64/clone.S:111(clone)[0x7fea04f0841d]

on Non-Debug versions:

10.3 7293ce0ee81f05b1ec3ac9dd

 
Thread 1 (Thread 0x7f1b907f9700 (LWP 25102)):
 
#0  __pthread_kill (threadid=<optimized out>, signo=signo@entry=11) at ../sysdeps/unix/sysv/linux/pthread_kill.c:62
 
#1  0x000055fe9e3207da in my_write_core (sig=sig@entry=11) at /10.3/mysys/stacktrace.c:481
 
#2  0x000055fe9de705b5 in handle_fatal_signal (sig=11) at /10.3/sql/signal_handler.cc:305
 
#3  <signal handler called>
 
#4  JOIN::fix_all_splittings_in_plan (this=this@entry=0x7f1b3c155878) at /10.3/sql/opt_split.cc:1146
 
#5  0x000055fe9dcfda8b in JOIN::optimize_inner (this=this@entry=0x7f1b3c155878) at /10.3/sql/sql_select.cc:1905
 
#6  0x000055fe9dcfdd3f in JOIN::optimize (this=this@entry=0x7f1b3c155878) at /10.3/sql/sql_select.cc:1451
 
#7  0x000055fe9dcffcb4 in mysql_select (thd=thd@entry=0x7f1b3c0009a8, tables=0x7f1b3c0142a0, wild_num=<optimized out>, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748612, result=0x7f1b3c155240, unit=0x7f1b3c0046a0, select_lex=0x7f1b3c004e10) at /10.3/sql/sql_select.cc:4225
 
#8  0x000055fe9dcfffc5 in mysql_explain_union (thd=thd@entry=0x7f1b3c0009a8, unit=unit@entry=0x7f1b3c0046a0, result=result@entry=0x7f1b3c155240) at /10.3/sql/sql_select.cc:25873
 
#9  0x000055fe9dbd64b6 in execute_sqlcom_select (thd=thd@entry=0x7f1b3c0009a8, all_tables=<optimized out>) at /10.3/sql/sql_parse.cc:6490
 
#10 0x000055fe9dcb1f13 in mysql_execute_command (thd=thd@entry=0x7f1b3c0009a8) at /10.3/sql/sql_parse.cc:3772
 
#11 0x000055fe9dcb4149 in mysql_parse (thd=thd@entry=0x7f1b3c0009a8, rawbuf=<optimized out>, length=5470, parser_state=parser_state@entry=0x7f1b907f84b0, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /10.3/sql/sql_parse.cc:8095
 
#12 0x000055fe9dcb69e8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f1b3c0009a8, packet=packet@entry=0x7f1b3c009329 "", packet_length=packet_length@entry=5471, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /10.3/sql/sql_parse.cc:1854
 
#13 0x000055fe9dcb7490 in do_command (thd=0x7f1b3c0009a8) at /10.3/sql/sql_parse.cc:1396
 
#14 0x000055fe9dd7c5a4 in do_handle_one_connection (connect=connect@entry=0x55fea0f04418) at /10.3/sql/sql_connect.cc:1403
 
#15 0x000055fe9dd7c724 in handle_one_connection (arg=arg@entry=0x55fea0f04418) at /10.3/sql/sql_connect.cc:1309
 
#16 0x000055fe9e2de8b4 in pfs_spawn_thread (arg=0x55fea0f28f78) at /10.3/storage/perfschema/pfs.cc:1862
 
#17 0x00007f1b97d256ba in start_thread (arg=0x7f1b907f9700) at pthread_create.c:333
 
#18 0x00007f1b971ba41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109



 Comments   
Comment by Alice Sherepa [ 2019-05-17 ]

The same test as reported, but not EXPLAIN SELECT, just SELECT ...: server crashes on 10.2-10.4:

mysqld: /git/10.2/sql/sql_select.cc:7510: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
 
190517 10:31:00 [ERROR] mysqld got signal 6 ;
 
 
 
sql/sql_select.cc:7512(greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int))[0x55c5184446f3]
 
sql/sql_select.cc:7080(choose_plan(JOIN*, unsigned long long))[0x55c518442ab0]
 
sql/sql_select.cc:4570(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*))[0x55c518431771]
 
sql/sql_select.cc:1583(JOIN::optimize_inner())[0x55c518415a6e]
 
sql/sql_select.cc:1116(JOIN::optimize())[0x55c51841126d]
 
sql/sql_select.cc:3806(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55c51842a7d5]
 
sql/sql_select.cc:376(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55c51840a0b5]
 
sql/sql_parse.cc:6486(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55c518391b51]
 
sql/sql_parse.cc:3534(mysql_execute_command(THD*))[0x55c51837ef46]
 
sql/sql_parse.cc:8020(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55c51839a2b5]
 
sql/sql_parse.cc:1835(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55c51837593f]
 
sql/sql_parse.cc:1387(do_command(THD*))[0x55c518372abc]
 
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x55c51869c108]
 
sql/sql_connect.cc:1242(handle_one_connection)[0x55c51869bb10]
 
perfschema/pfs.cc:1864(pfs_spawn_thread)[0x55c519848f0a]
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fe022da56ba]
 
x86_64/clone.S:111(clone)[0x7fe02223a41d]

10.4 d448cfc92a47b9afb, non-debug

 
190517 10:47:45 [ERROR] mysqld got signal 11 ;
 
 
 
sql/opt_split.cc:1148(JOIN::fix_all_splittings_in_plan())[0x55eafc126d10]
 
sql/sql_select.cc:2208(JOIN::optimize_inner())[0x55eafc02cae1]
 
sql/sql_select.cc:1563(JOIN::optimize())[0x55eafc02d273]
 
sql/sql_select.cc:4589(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55eafc02dd8e]
 
sql/sql_select.cc:424(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55eafc02e79e]
 
sql/sql_parse.cc:6600(execute_sqlcom_select(THD*, TABLE_LIST*) [clone .constprop.283])[0x55eafbef35b7]
 
sql/sql_parse.cc:3887(mysql_execute_command(THD*))[0x55eafbfdf026]
 
sql/sql_parse.cc:8150(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55eafbfe0d89]
 
sql/sql_parse.cc:1893(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55eafbfe3026]
 
sql/sql_parse.cc:1362(do_command(THD*))[0x55eafbfe4659]
 
sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x55eafc0b1d54]
 
sql/sql_connect.cc:1308(handle_one_connection)[0x55eafc0b1e74]
 
perfschema/pfs.cc:1865(pfs_spawn_thread)[0x55eafc64a654]
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f73f44a56ba]
 
x86_64/clone.S:111(clone)[0x7f73f373641d]

10.2 cd16d6d518761d1448 non-debug

 
190517 11:09:40 [ERROR] mysqld got signal 11 ;
 
 
 
sql/opt_subselect.cc:3594(fix_semijoin_strategies_for_picked_join_order(JOIN*))[0x5626e6314b49]
 
sql/sql_select.cc:9008(JOIN::get_best_combination())[0x5626e6248775]
 
sql/sql_select.cc:4602(make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*) [clone .constprop.357])[0x5626e62611a5]
 
sql/sql_select.cc:1583(JOIN::optimize_inner())[0x5626e62663c5]
 
sql/sql_select.cc:1117(JOIN::optimize())[0x5626e626938a]
 
sql/sql_select.cc:3806(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x5626e626b38e]
 
sql/sql_select.cc:376(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5626e626b4ee]
 
sql/sql_parse.cc:6488(execute_sqlcom_select(THD*, TABLE_LIST*) [clone .constprop.198])[0x5626e6169ad1]
 
sql/sql_parse.cc:3534(mysql_execute_command(THD*))[0x5626e621c098]
 
sql/sql_parse.cc:8020(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5626e622139d]
 
sql/sql_parse.cc:1833(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5626e6224004]
 
sql/sql_parse.cc:1389(do_command(THD*))[0x5626e62248ef]
 
sql/sql_connect.cc:1335(do_handle_one_connection(CONNECT*))[0x5626e62e3cb4]
 
sql/sql_connect.cc:1243(handle_one_connection)[0x5626e62e3e24]
 
perfschema/pfs.cc:1865(pfs_spawn_thread)[0x5626e682d264]
 
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f58349be6ba]
 
x86_64/clone.S:111(clone)[0x7f5833e5341d]

Comment by Igor Babaev [ 2019-05-28 ]

I tried to run the reported test case on MySQL-8.0 without any success.

Comment by Igor Babaev [ 2019-05-28 ]

A fix of this bug was pushed into 5.5.
The patch should be merged upstream as it is.

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