Assert trx->n_active_thrs == 1 failed at que0que.c line 1050 with ICP, InnoDB, NOT EXISTS
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Sergey Petrunia |
Bug Description
#7 0xb75c80f0 in abort () from /lib/libc.so.6
#8 0x087cbda2 in que_thr_
at /home/elenst/
#9 0x086738f1 in row_search_
buf=0x9d94690 "\377\217\
at /home/elenst/
#10 0x086342de in ha_innobase:
buf=0x9d94690 "\377\217\
at /home/elenst/
#11 0x08634e75 in ha_innobase:
buf=0x9d94690 "\377\217\
#12 0x081fdbfb in handler:
buf=0x9d94690 "\377\217\
#13 0x082acae8 in join_read_first (tab=0x9da3370)
at /home/elenst/
#14 0x082aab75 in sub_select (join=0x9d9b420, join_tab=0x9da3370, end_of_
at /home/elenst/
#15 0x082aa4e4 in do_select (join=0x9d9b420, fields=0x9d81834, table=0x0, procedure=0x0)
at /home/elenst/
#16 0x0828dec3 in JOIN::exec (this=0x9d9b420)
at /home/elenst/
#17 0x08473e76 in subselect_
at /home/elenst/
#18 0x0846d937 in Item_subselect:
at /home/elenst/
#19 0x0846f98c in Item_exists_
at /home/elenst/
#20 0x0840fff2 in Item_func_
at /home/elenst/
#21 0x081d06ce in Item::val_
at /home/elenst/
#22 0x08406b50 in Item_cache_
at /home/elenst/
#23 0x0840c173 in Item_cache:
at /home/elenst/
#24 0x08406d99 in Item_cache_
at /home/elenst/
#25 0x083f187a in Item::val_bool (this=0x9da2520)
at /home/elenst/
#26 0x0841c7f0 in Item_cond_
at /home/elenst/
#27 0x0863dd0f in innobase_index_cond (file=0x9d8d570)
at /home/elenst/
#28 0x086710bb in row_search_
prebuilt=
at /home/elenst/
#29 0x08672fea in row_search_
prebuilt=
at /home/elenst/
#30 0x086342de in ha_innobase:
key_
at /home/elenst/
#31 0x083ef082 in handler:
key=0x9d93060 "", keypart_map=1, find_flag=
at /home/elenst/
#32 0x081fd992 in handler:
key=0x9d93060 "", keypart_map=1, find_flag=
at /home/elenst/
#33 0x082ac36a in join_read_
at /home/elenst/
#34 0x082aab75 in sub_select (join=0x9d94e18, join_tab=0x9da20f0, end_of_
at /home/elenst/
#35 0x083720d3 in JOIN_CACHE:
rec_
#36 0x08371e2c in JOIN_CACHE:
at /home/elenst/
#37 0x0837190d in JOIN_CACHE:
at /home/elenst/
#38 0x082aa7fd in sub_select_cache (join=0x9d94e18, join_tab=0x9da1eec,
end_
#39 0x082aa9d1 in sub_select (join=0x9d94e18, join_tab=0x9da1ce8, end_of_
at /home/elenst/
#40 0x082aa50d in do_select (join=0x9d94e18, fields=0x0, table=0x9dc47e0, procedure=0x0)
at /home/elenst/
#41 0x0828c5f9 in JOIN::exec (this=0x9d94e18)
at /home/elenst/
#42 0x0828e69c in mysql_select (thd=0x9cd0750, rref_pointer_
tables=
order=
result=
at /home/elenst/
#43 0x082864ba in handle_select (thd=0x9cd0750, lex=0x9cd1c8c, result=0x9d91dc0,
setup_
#44 0x082626cd in execute_
at /home/elenst/
#45 0x0825b674 in mysql_execute_
at /home/elenst/
#46 0x08264ca8 in mysql_parse (thd=0x9cd0750,
rawbuf=
parser_
#47 0x0825913e in dispatch_command (command=COM_QUERY, thd=0x9cd0750,
packet=
at /home/elenst/
#48 0x08258603 in do_command (thd=0x9cd0750)
at /home/elenst/
#49 0x08341236 in do_handle_
at /home/elenst/
#50 0x08340d84 in handle_
at /home/elenst/
#51 0x085621e9 in pfs_spawn_thread (arg=0x9d3c9e0)
at /home/elenst/
#52 0xb789eb25 in start_thread () from /lib/libpthread
#53 0xb766e34e in clone () from /lib/libc.so.6
bzr version-info
revision-id: <email address hidden>
date: 2012-01-20 22:32:31 +0100
build-date: 2012-01-22 23:12:25 +0400
revno: 3228
branch-nick: maria-5.5
Could not reproduce on MariaDB-5.3 or MySQL-5.6.4.
Minimal optimizer_switch: in_to_exists=
Full optimizer_switch: index_merge=
EXPLAIN:
id select_type table type possible_keys key key_len ref rows filtered Extra
1 PRIMARY t1 ALL NULL NULL NULL NULL 2 100.00 Using temporary; Using filesort
1 PRIMARY t2 ALL NULL NULL NULL NULL 2 100.00 Using where; Using join buffer (flat, BNL join)
1 PRIMARY t3 ref d d 4 test.t2.b 1 100.00 Using index condition; Using where
2 SUBQUERY t3 index NULL d 9 NULL 19 100.00 Using index
Warnings:
Note 1003 select `test`.`t1`.`a` AS `a`,`test`.`t2`.`b` AS `b`,`test`.`t3`.`c` AS `c`,`test`.`t3`.`d` AS `d`,`test`.`t3`.`e` AS `e` from `test`.`t1` join `test`.`t2` join `test`.`t3` where ((`test`.`t3`.`d` = `test`.`t2`.`b`) and (<cache>
Test case:
--source include/
# in_to_exists is required because
# otherwise the query isn't executed
SET optimizer_switch = 'in_to_
# t1 and t3 have to be InnoDB
CREATE TABLE t1 ( a INT )
ENGINE=InnoDB;
INSERT INTO t1 VALUES (7),(7);
CREATE TABLE t2 ( b VARCHAR(1) );
INSERT INTO t2 VALUES ('j'),('v');
CREATE TABLE t3 (
c INT, d VARCHAR(1), e VARCHAR(1),
KEY (d,c)
) ENGINE=InnoDB;
INSERT INTO t3
VALUES (6,'w','w'),
(1,
(7,
(9,
(9,
(8,
(6,
SELECT *
FROM t1 INNER JOIN t2 INNER JOIN t3
ON d = b
WHERE
NOT EXISTS ( SELECT * FROM t3 )
OR a = c
ORDER BY e;
Changed in maria: | |
assignee: | Igor Babaev (igorb-seattle) → Sergey Petrunia (sergefp) |
Changed in maria: | |
status: | New → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Also filed as JIRA issue MDEV-114