[MDEV-18479] Assertion `join->best_read < double(1.79769313486231570815e+308L)' or server crashes in JOIN::fix_all_splittings_in_plan after EXPLAIN - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
Fix Version/s: 10.2.25, 5.5.65, 10.1.41, 10.3.16, 10.4.6
Component/s: Optimizer
Labels:
None

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

Attachments

Issue Links

duplicates

MDEV-13607 MariaDB crash in fix_semijoin_strategies_for_picked_join_order

Closed

relates to

MDEV-19132 Strange combination of JOIN with NULL crash the server

Confirmed

MDEV-19484 Server crashes in fix_semijoin_strategies_for_picked_join_order

Closed

MDEV-19615 CRASH : [ERROR] mysqld got signal 11

Closed

Activity

People

Assignee:: Igor Babaev

Reporter:: Alice Sherepa

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2019-02-05 12:12

Updated:: 2019-06-11 09:05

Resolved:: 2019-05-28 04:39

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.