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

Crash in my_strnncoll_binary while running point-select

    XMLWordPrintable

    Details

      Description

      • Running a CPU bound workload (point-select) with increase scalability from 1-1024 (in multiple of 2).
      • Hit the said issue at 32 threads but it is random could hit is even at different scalability.
      • Issues seems to suggest something wrong with memcmp (less likely memory violation more likely alignment issue).
      • Observed with MDB-10.5-trunk (10.5.6) on ARM only. Not observed with x86 yet. If present may need different test-case.
        Existing bug in this area MDEV-20619

      ----------------

      (gdb) bt
      #0  0x0000ffffbe077f50 in memcmp () from /lib64/libc.so.6
      #1  0x0000aaaaab82747c in my_strnncoll_binary (cs=<optimized out>, s=<optimized out>, slen=14, t=<optimized out>, tlen=14, t_is_prefix=0 '\000')
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/strings/ctype-bin.c:87
      #2  0x0000aaaaab817898 in l_find (head=0xffe998006cf8, head@entry=0xaaab058aec20, cs=0xaaaaac02d3f0 <my_charset_bin>, hashnr=<optimized out>, 
          key=key@entry=0xffe924b3c668 "\002arm", keylen=keylen@entry=14, cursor=0xffeafc4c55d8, cursor@entry=0xffeafc4c5618, pins=pins@entry=0xaaab058a3c00, 
          callback=callback@entry=0x0) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/mysys/lf_hash.c:132
      #3  0x0000aaaaab818240 in l_search (pins=0xaaab058a3c00, keylen=14, key=0xffe924b3c668 "\002arm", hashnr=<optimized out>, cs=<optimized out>, 
          head=0xaaab058aec20) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/mysys/lf_hash.c:286
      #4  lf_hash_search_using_hash_value (hash=hash@entry=0xaaaaac0b9010 <mdl_locks>, pins=pins@entry=0xaaab058a3c00, hashnr=<optimized out>, 
          key=key@entry=0xffe924b3c668, keylen=14) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/mysys/lf_hash.c:488
      #5  0x0000aaaaab8183b4 in lf_hash_search (hash=hash@entry=0xaaaaac0b9010 <mdl_locks>, pins=pins@entry=0xaaab058a3c00, key=key@entry=0xffe924b3c668, 
          keylen=<optimized out>) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/mysys/lf_hash.c:528
      #6  0x0000aaaaab24acb4 in MDL_map::find_or_insert (this=0xaaaaac0b9010 <mdl_locks>, pins=0xaaab058a3c00, mdl_key=0xffe924b3c660)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/mdl.cc:825
      #7  0x0000aaaaab24c1e0 in MDL_context::try_acquire_lock_impl (this=this@entry=0xffe9240009f8, mdl_request=mdl_request@entry=0xffe924b3c640, 
          out_ticket=0xffeafc4c5768, out_ticket@entry=0xffeafc4c57e8) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/mdl.cc:2076
      #8  0x0000aaaaab24c860 in MDL_context::acquire_lock (this=this@entry=0xffe9240009f8, mdl_request=mdl_request@entry=0xffe924b3c640, 
          lock_wait_timeout=86400) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/mdl.cc:2251
      #9  0x0000aaaaab122f10 in open_table_get_mdl_lock (thd=thd@entry=0xffe9240008d8, ot_ctx=ot_ctx@entry=0xffeafc4c6118, 
          mdl_request=mdl_request@entry=0xffe924b3c640, flags=flags@entry=0, mdl_ticket=0xffeafc4c5ae0, mdl_ticket@entry=0xffeafc4c5b60)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_base.cc:1542
      #10 0x0000aaaaab126640 in open_table (thd=thd@entry=0xffe9240008d8, table_list=table_list@entry=0xffe924b3c1f8, ot_ctx=ot_ctx@entry=0xffeafc4c6118)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_base.cc:1803
      #11 0x0000aaaaab1291bc in open_and_process_table (ot_ctx=0xffeafc4c6118, has_prelocking_list=24, prelocking_strategy=0xffeafc4c6218, flags=65514, 
          counter=0xffeafc4c619c, tables=0xffe924b3c1f8, thd=0xffe9240008d8)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_base.cc:3784
      #12 open_tables (thd=thd@entry=0xffe9240008d8, options=..., start=0xffeafc4c6188, start@entry=0xffeafc4c61a8, counter=0xffeafc4c619c, 
          counter@entry=0xffeafc4c61bc, flags=65514, flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0xffeafc4c6218)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_base.cc:4256
      #13 0x0000aaaaab12995c in open_and_lock_tables (thd=thd@entry=0xffe9240008d8, options=..., tables=<optimized out>, tables@entry=0xffe924b3c1f8, 
          derived=derived@entry=true, flags=flags@entry=0, prelocking_strategy=prelocking_strategy@entry=0xffeafc4c6218)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_base.cc:5160
      #14 0x0000aaaaab17d1c8 in open_and_lock_tables (flags=0, derived=true, tables=0xffe924b3c1f8, thd=0xffe9240008d8)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_base.h:509
      #15 execute_sqlcom_select (thd=thd@entry=0xffe9240008d8, all_tables=0xffe924b3c1f8)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_parse.cc:6131
      #16 0x0000aaaaab17a3a8 in mysql_execute_command (thd=0xffe9240008d8) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_parse.cc:3932
      #17 0x0000aaaaab1910c0 in Prepared_statement::execute (this=this@entry=0xffe924c04908, expanded_query=expanded_query@entry=0xffeafc4c6db0, 
          open_cursor=open_cursor@entry=false) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_prepare.cc:4736
      ---Type <return> to continue, or q <return> to quit---
      #18 0x0000aaaaab1911bc in Prepared_statement::execute_loop (this=0xffe924c04908, expanded_query=0xffeafc4c6db0, open_cursor=false, 
          packet=<optimized out>, packet_end=<optimized out>) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_prepare.cc:4225
      #19 0x0000aaaaab191a28 in mysql_stmt_execute_common (thd=thd@entry=0xffe9240008d8, stmt_id=42, packet=packet@entry=0xffe924c144e2 "", 
          packet_end=0xffe924c144ec "", packet_end@entry=0xffe924c144d9 "*", cursor_flags=<optimized out>, bulk_op=bulk_op@entry=false, 
          read_types=read_types@entry=false) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_prepare.cc:3226
      #20 0x0000aaaaab191ab4 in mysqld_stmt_execute (thd=thd@entry=0xffe9240008d8, packet_arg=packet_arg@entry=0xffe924c144d9 "*", 
          packet_length=packet_length@entry=0) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_prepare.cc:3121
      #21 0x0000aaaaab177558 in dispatch_command (command=command@entry=COM_STMT_EXECUTE, thd=thd@entry=0xffe9240008d8, 
          packet=packet@entry=0xffe924c144d9 "*", packet_length=0, packet_length@entry=19, is_com_multi=is_com_multi@entry=false, 
          is_next_command=is_next_command@entry=false) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_parse.cc:1791
      #22 0x0000aaaaab176914 in do_command (thd=0xffe9240008d8) at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_parse.cc:1348
      #23 0x0000aaaaab244870 in do_handle_one_connection (connect=<optimized out>, connect@entry=0xaaab059451b8, put_in_cache=put_in_cache@entry=true)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_connect.cc:1410
      #24 0x0000aaaaab244c70 in handle_one_connection (arg=arg@entry=0xaaab059451b8)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/sql/sql_connect.cc:1312
      #25 0x0000aaaaab5337e0 in pfs_spawn_thread (arg=0xaaab05876d48)
          at /opt/projects/mysql/105/non-forked-mdb/mdb/codebase/server/storage/perfschema/pfs.cc:2201
      #26 0x0000ffffbe767d38 in start_thread () from /lib64/libpthread.so.0
      #27 0x0000ffffbe0cf5f0 in thread_start () from /lib64/libc.so.6
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              danblack Daniel Black
              Reporter:
              krunalbauskar Krunal Bauskar
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration