Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4431

MWL#253: Server crashes in Item_equal_iterator with optimizer_use_condition_selectivity=3 and table statistics

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.2
        • Fix Version/s: 10.0.5
        • Component/s: None
        • Labels:
          None

          Description

          #2  0x00000000007f9d82 in handle_fatal_signal (sig=11) at /home/elenst/bzr/10.0/sql/signal_handler.cc:262
#3  <signal handler called>
#4  0x0000000000696a80 in Item_equal_iterator<List_iterator_fast, Item>::get_curr_field (this=0x7f073f14ea70) at /home/elenst/bzr/10.0/sql/item_cmpfunc.h:1859
#5  0x0000000000912d3d in get_full_func_mm_tree (param=0x7f073f14ef90, cond_func=0x7f0730041e50, field_item=0x7f07300fcda0, value=0x7f0730103d70, inv=false) at /home/elenst/bzr/10.0/sql/opt_range.cc:7708
#6  0x0000000000913ab0 in get_mm_tree (param=0x7f073f14ef90, cond=0x7f0730041e50) at /home/elenst/bzr/10.0/sql/opt_range.cc:7895
#7  0x000000000091300d in get_mm_tree (param=0x7f073f14ef90, cond=0x7f0730118810) at /home/elenst/bzr/10.0/sql/opt_range.cc:7753
#8  0x0000000000912f2c in get_mm_tree (param=0x7f073f14ef90, cond=0x7f07300499a0) at /home/elenst/bzr/10.0/sql/opt_range.cc:7742
#9  0x00000000009099b1 in calculate_cond_selectivity_for_table (thd=0x3659058, table=0x7f07300ef7f8, cond=0x7f07300499a0) at /home/elenst/bzr/10.0/sql/opt_range.cc:3440
#10 0x000000000065f07d in make_join_statistics (join=0x7f0730124500, tables_list=..., conds=0x7f07300499a0, keyuse_array=0x7f0730124838) at /home/elenst/bzr/10.0/sql/sql_select.cc:3834
#11 0x0000000000656234 in JOIN::optimize_inner (this=0x7f0730124500) at /home/elenst/bzr/10.0/sql/sql_select.cc:1301
#12 0x00000000006551da in JOIN::optimize (this=0x7f0730124500) at /home/elenst/bzr/10.0/sql/sql_select.cc:1003
#13 0x000000000065ce96 in mysql_select (thd=0x3659058, rref_pointer_array=0x365c528, tables=0x7f0730043430, wild_num=1, fields=..., conds=0x7f07300499a0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f07301253e0, unit=0x365bb80, select_lex=0x365c278) at /home/elenst/bzr/10.0/sql/sql_select.cc:3215
#14 0x000000000065364b in handle_select (thd=0x3659058, lex=0x365bac8, result=0x7f07301253e0, setup_tables_done_option=0) at /home/elenst/bzr/10.0/sql/sql_select.cc:371
#15 0x0000000000628767 in execute_sqlcom_select (thd=0x3659058, all_tables=0x7f0730043430) at /home/elenst/bzr/10.0/sql/sql_parse.cc:5021
#16 0x0000000000620d89 in mysql_execute_command (thd=0x3659058) at /home/elenst/bzr/10.0/sql/sql_parse.cc:2482
#17 0x000000000062b026 in mysql_parse (thd=0x3659058, rawbuf=0x7f07300ff860 "SELECT * FROM america, europe, city\nWHERE city.country = europe.country AND ( 0 OR america.country = city.country AND ( city.country != 'POL' OR city.country = 'NOR' ) )", length=169, parser_state=0x7f073f152500) at /home/elenst/bzr/10.0/sql/sql_parse.cc:6154
#18 0x000000000061df6e in dispatch_command (command=COM_QUERY, thd=0x3659058, packet=0x365d369 "SELECT * FROM america, europe, city\nWHERE city.country = europe.country AND ( 0 OR america.country = city.country AND ( city.country != 'POL' OR city.country = 'NOR' ) )", packet_length=169) at /home/elenst/bzr/10.0/sql/sql_parse.cc:1274
#19 0x000000000061d3e4 in do_command (thd=0x3659058) at /home/elenst/bzr/10.0/sql/sql_parse.cc:983
#20 0x0000000000737da1 in do_handle_one_connection (thd_arg=0x3659058) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1267
#21 0x0000000000737af4 in handle_one_connection (arg=0x3659058) at /home/elenst/bzr/10.0/sql/sql_connect.cc:1181
#22 0x00000000009c767b in pfs_spawn_thread (arg=0x34d4248) at /home/elenst/bzr/10.0/storage/perfschema/pfs.cc:1800
#23 0x00007f0750ae5e9a in start_thread (arg=0x7f073f153700) at pthread_create.c:308
#24 0x00007f074fdd9cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

          revision-id: igor@askmonty.org-20130423035522-w8b8rz72zdav0p7r
revno: 3744
branch-nick: 10.0

          Test case:

          SET optimizer_use_condition_selectivity=3;
SET use_stat_tables=PREFERABLY;

CREATE TABLE america (country VARCHAR(3)) ENGINE=MyISAM;
INSERT INTO america VALUES ('USA');

CREATE TABLE europe (country VARCHAR(3)) ENGINE=MyISAM;
INSERT INTO europe VALUES ('FRA'),('ITA');

CREATE TABLE city (country VARCHAR(3), name VARCHAR(32)) ENGINE=MyISAM;
INSERT INTO city VALUES ('GBR','London'),('FIN', 'Helsinki');

ANALYZE TABLE america, europe, city;
FLUSH TABLES;

SELECT * FROM america, europe, city
WHERE city.country = europe.country AND ( 0 OR america.country = city.country AND ( city.country != 'POL' OR city.country = 'NOR' ) );

          EXPLAIN also crashes.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                igor Igor Babaev added a comment -

                This bug could not be reproduced for 10.3 (rev 3761).
                Most probably it was fixed after a merge with 5.3

                Show
                igor Igor Babaev added a comment - This bug could not be reproduced for 10.3 (rev 3761). Most probably it was fixed after a merge with 5.3

                  People

                  • Assignee:
                    igor Igor Babaev
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: