Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4731

MDB crashes if query has functional filter working with I_S.columnstore_columns table

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 6.1.1
    • Icebox
    • MDB Plugin
    • None

    Description

      The query:

      select width from information_schema.columnstore_extents e, information_schema.columnstore_columns c where e.object_id = c.object_id and lower(table_name) = 'mcol1347' and column_name in ('mcol1347c1','mcol1347c2', 'mcol1347c3', 'mcol1347v1', 'mcol1347v2', 'mcol1347v3');
      

      that contains lower(table_name) expression crashes reWithDebInfo build of MDB with this stack trace:

      #0  __strcasecmp_l_avx () at ../sysdeps/x86_64/multiarch/strcmp-sse42.S:199
      #1  0x00007fabcd1bec33 in get_cond_item (item=0x7fab54014988, table=0x7fabb01ac740, db=0x7fabb01ac748) at /data/mdb-server/storage/columnstore/columnstore/dbcon/mysql/is_columnstore_columns.cpp:64
      #2  0x00007fabcd1beead in get_cond_items (cond=<optimized out>, table=0x7fabb01ac740, db=0x7fabb01ac748) at /data/mdb-server/storage/columnstore/columnstore/dbcon/mysql/is_columnstore_columns.cpp:99
      #3  0x00007fabcd1bf014 in is_columnstore_columns_fill (thd=0x7fab54000c58, tables=<optimized out>, cond=0x7fab5432d768) at /data/mdb-server/storage/columnstore/columnstore/dbcon/mysql/is_columnstore_columns.cpp:126
      #4  0x0000560f1481c12e in get_schema_tables_result (join=join@entry=0x7fab54016ea8, executed_place=executed_place@entry=PROCESSED_BY_JOIN_EXEC) at /data/mdb-server/sql/sql_show.cc:8727
      #5  0x0000560f14801aaf in JOIN::exec_inner (this=0x7fab54016ea8) at /data/mdb-server/sql/sql_select.cc:4565
      #6  0x0000560f148021f9 in JOIN::exec (this=this@entry=0x7fab54016ea8) at /data/mdb-server/sql/sql_select.cc:4389
      #7  0x0000560f1480012a in mysql_select (thd=0x7fab54000c58, tables=0x7fab54013328, fields=..., conds=0x7fab54014bd0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7fab54016e80, 
          unit=0x7fab54004de0, select_lex=0x7fab54012cc8) at /data/mdb-server/sql/sql_select.cc:4865
      #8  0x0000560f14800b67 in handle_select (thd=thd@entry=0x7fab54000c58, lex=lex@entry=0x7fab54004d18, result=result@entry=0x7fab54016e80, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/mdb-server/sql/sql_select.cc:446
      #9  0x0000560f147933f1 in execute_sqlcom_select (thd=0x7fab54000c58, all_tables=0x7fab54013328) at /data/mdb-server/sql/sql_parse.cc:6244
      #10 0x0000560f1479cb88 in mysql_execute_command (thd=0x7fab54000c58) at /data/mdb-server/sql/sql_parse.cc:3940
      #11 0x0000560f1478e365 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x7fab54000c58) at /data/mdb-server/sql/sql_parse.cc:8018
      #12 mysql_parse (thd=0x7fab54000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /data/mdb-server/sql/sql_parse.cc:7940
      #13 0x0000560f1479a5f8 in dispatch_command (command=COM_QUERY, thd=0x7fab54000c58, 
          packet=0x7fab54007ee9 "select width from information_schema.columnstore_extents e, information_schema.columnstore_columns c where e.object_id = c.object_id and lower(table_name) = 'MCOL1347' and column_name in ('mcol1347c1','mcol1347c2', 'mcol1347c3', 'mcol1347v1', 'mcol1347v2', 'mcol1347v3')", packet_length=<optimized out>, blocking=<optimized out>) at /data/mdb-server/sql/sql_class.h:1333
      #14 0x0000560f1479b5d2 in do_command (thd=0x7fab54000c58, blocking=blocking@entry=true) at /data/mdb-server/sql/sql_parse.cc:1406
      #15 0x0000560f1489c4b7 in do_handle_one_connection (connect=<optimized out>, put_in_cache=true) at /data/mdb-server/sql/sql_connect.cc:1410
      #16 0x0000560f1489c80d in handle_one_connection (arg=arg@entry=0x560f182ed0c8) at /data/mdb-server/sql/sql_connect.cc:1312
      #17 0x0000560f14beea7d in pfs_spawn_thread (arg=0x560f1818ea68) at /data/mdb-server/storage/perfschema/pfs.cc:2201
      #18 0x00007fabceec4609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #19 0x00007fabcedeb293 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            drrtuy Roman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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