[MDEV-5418] Server crashes on SELECT from I_S table Created: 2013-12-08  Updated: 2014-01-15  Resolved: 2014-01-15

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.6
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Elena Stepanova
Resolution: Duplicate Votes: 0
Labels: upstream

Issue Links:
Duplicate
duplicates MDEV-5416 Server crashes on SELECT from InnoDB ... Closed

 Description   

It might be the same as MDEV-5415, MDEV-5416, MDEV-5417 but the stack trace is different again. It needs to be re-checked after MDEV-5415 is fixed.

Preliminary test case:

SET optimizer_use_condition_selectivity=3;
SELECT * FROM INFORMATION_SCHEMA . `INNODB_SYS_DATAFILES` AS table1 WHERE  table1 . `PATH` <> 'se'   ORDER BY table1 . `PATH` , table1 . `PATH` LIMIT 14;

If it's run via MTR, should be run as

perl ./mtr bug.t1 --mysqld=--plugin-innodb-sys-datafiles

#3  <signal handler called>
#4  0x000000000094fa51 in step_down_to (arg=0x7fc2723dd6b0, key_tree=0x7fc267f4c368) at 10.0/sql/opt_range_mrr.cc:100
#5  0x000000000094fbea in sel_arg_range_seq_next (rseq=0x7fc2723dd6b0, range=0x7fc2723dd660) at 10.0/sql/opt_range_mrr.cc:165
#6  0x00000000009551ce in records_in_column_ranges (param=0x7fc2723ddca0, idx=0, tree=0x7fc267f4c0a8) at 10.0/sql/opt_range.cc:3360
#7  0x00000000009554fc in calculate_cond_selectivity_for_table (thd=0x7fc26ab3d070, table=0x7fc267c15088, cond=0x7fc267dd8b90) at 10.0/sql/opt_range.cc:3478
#8  0x0000000000000000 in ?? ()

revision-id: bar@mnogosearch.org-20131206150255-und2j89f85by7imn
revno: 3915
branch-nick: 10.0



 Comments   
Comment by Elena Stepanova [ 2014-01-15 ]

Duplicate of MDEV-5416

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