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

Server crashes when executing Admin SQL/DML after setting character_set_collations to utf8mb3_general1400_as_ci

    XMLWordPrintable

Details

    Description

      # mysqld options required for replay: --character_set_collations='utf8mb3=utf8mb3_general1400_as_ci'
       
      --source include/have_innodb.inc
        
      CREATE TABLE t (a VARCHAR(10) CHARACTER SET UTF8MB3,KEY(a)) ENGINE=INNODB;
      EXPLAIN SELECT * FROM t WHERE a LIKE 'a_';
      

      Release build goes to hang mode when executing above test case

      11.5.0 e407d0038c21ee65b4b75dbd6eed5bd2467a8071 (Debug)

      mariadbd: /test/mtest/MDEV-31340/11.5_dbg/strings/ctype-mb.c:628: pad_max_char: Assertion `buflen > 0' failed.
      

      11.5.0 e407d0038c21ee65b4b75dbd6eed5bd2467a8071 (Debug)

      Core was generated by `/test/mtest/MDEV-31340/MD260324-mariadb-11.5.0-linux-x86_64-dbg/bin/mariadbd --'.
      Program terminated with signal SIGABRT, Aborted.
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      [Current thread is 1 (Thread 0x1458e00a4700 (LWP 21798))]
      (gdb) bt
      #0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
      #1  0x00001458e310a859 in __GI_abort () at abort.c:79
      #2  0x00001458e310a729 in __assert_fail_base (fmt=0x1458e32a0588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5584a66d9a50 "buflen > 0", file=0x5584a66d98c8 "/test/mtest/MDEV-31340/11.5_dbg/strings/ctype-mb.c", line=628, function=<optimized out>) at assert.c:92
      #3  0x00001458e311bfd6 in __GI___assert_fail (assertion=assertion@entry=0x5584a66d9a50 "buflen > 0", file=file@entry=0x5584a66d98c8 "/test/mtest/MDEV-31340/11.5_dbg/strings/ctype-mb.c", line=line@entry=628, function=function@entry=0x5584a66d9a60 <__PRETTY_FUNCTION__.16574> "pad_max_char") at assert.c:101
      #4  0x00005584a60d72e3 in pad_max_char (end=0x14589007135d "\245\245\245", '\217' <repeats 197 times>..., str=0x145890071340 '\245' <repeats 32 times>, '\217' <repeats 168 times>..., cs=0x5584a6cf2340 <my_charset_utf8mb3_general1400_as_ci>) at /test/mtest/MDEV-31340/11.5_dbg/strings/ctype-mb.c:628
      #5  my_like_range_mb (cs=0x5584a6cf2340 <my_charset_utf8mb3_general1400_as_ci>, ptr=0x1458e00a157f "_", ptr_length=<optimized out>, escape=92 '\\', w_one=95 '_', w_many=37 '%', res_length=30, min_str=0x145890071339 "\245\245\245", max_str=0x145890071340 '\245' <repeats 32 times>, '\217' <repeats 168 times>..., min_length=0x1458e00a1548, max_length=0x1458e00a1550) at /test/mtest/MDEV-31340/11.5_dbg/strings/ctype-mb.c:708
      #6  0x00005584a5487a4a in charset_info_st::like_range (max_len=0x1458e00a1550, min_len=0x1458e00a1548, max_str=0x14589007133f "a", '\245' <repeats 32 times>, '\217' <repeats 167 times>..., min_str=0x14589007131b "a", res_length=30, w_many=<optimized out>, w_one=<optimized out>, w_prefix=<optimized out>, s_length=<optimized out>, s=<optimized out>, this=<optimized out>) at /test/mtest/MDEV-31340/11.5_dbg/include/m_ctype.h:1122
      #7  Item_func_like::get_mm_leaf (this=<optimized out>, param=0x1458e00a1b10, field=0x1458900293b0, key_part=<optimized out>, type=<optimized out>, value=<optimized out>) at /test/mtest/MDEV-31340/11.5_dbg/sql/opt_range.cc:9114
      #8  0x00005584a548cccb in Item_bool_func::get_mm_parts (this=0x145890019e18, param=0x1458e00a1b10, field=0x1458900293b0, type=type@entry=Item_func::LIKE_FUNC, value=0x14589001b968) at /test/mtest/MDEV-31340/11.5_dbg/sql/opt_range.cc:8958
      #9  0x00005584a54a9ec5 in Item_func_like::get_func_mm_tree (this=<optimized out>, param=<optimized out>, field=<optimized out>, value=<optimized out>) at /test/mtest/MDEV-31340/11.5_dbg/sql/item_cmpfunc.h:2899
      #10 0x00005584a5491576 in Item_bool_func::get_full_func_mm_tree (this=this@entry=0x145890019e18, param=param@entry=0x1458e00a1b10, field_item=field_item@entry=0x145890019bf0, value=value@entry=0x14589001b968) at /test/mtest/MDEV-31340/11.5_dbg/sql/opt_range.cc:8617
      #11 0x00005584a595599a in Item_bool_func::get_full_func_mm_tree_for_args (value=0x14589001b968, item=<optimized out>, param=0x1458e00a1b10, this=0x145890019e18) at /test/mtest/MDEV-31340/11.5_dbg/sql/item_cmpfunc.h:223
      #12 Item_bool_func2::get_mm_tree (cond_ptr=<optimized out>, param=0x1458e00a1b10, this=0x145890019e18) at /test/mtest/MDEV-31340/11.5_dbg/sql/item_cmpfunc.h:479
      #13 Item_func_like::get_mm_tree (this=0x145890019e18, param=0x1458e00a1b10, cond_ptr=<optimized out>) at /test/mtest/MDEV-31340/11.5_dbg/sql/item_cmpfunc.cc:5938
      #14 0x00005584a549be12 in SQL_SELECT::test_quick_select (this=this@entry=0x14589001c940, thd=thd@entry=0x145890000d48, keys_to_use={static BITS_PER_ELEMENT = 64, static ARRAY_ELEMENTS = 1, static ALL_BITS_SET = 18446744073709551615, buffer = {1}}, prev_tables=prev_tables@entry=0, limit=limit@entry=18446744073709551615, force_quick_range=force_quick_range@entry=false, ordered_output=false, remove_false_parts_of_where=true, only_single_index_range_scan=false, note_unusable_keys=<optimized out>) at /test/mtest/MDEV-31340/11.5_dbg/sql/opt_range.cc:2944
      #15 0x00005584a564639f in get_quick_record_count (quick_count=<synthetic pointer>, limit=18446744073709551615, keys=0x14589001bb88, table=0x145890028ea8, select=0x14589001c940, thd=0x145890000d48) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_select.cc:5365
      #16 make_join_statistics (join=join@entry=0x14589001af88, tables_list=@0x1458900190a8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14589001b748, last = 0x14589001b748, elements = 1}, <No data fields>}, keyuse_array=keyuse_array@entry=0x14589001b2e8) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_select.cc:6142
      #17 0x00005584a564de83 in JOIN::optimize_inner (this=this@entry=0x14589001af88) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_select.cc:2657
      #18 0x00005584a564e32f in JOIN::optimize (this=this@entry=0x14589001af88) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_select.cc:1966
      #19 0x00005584a564e44f in mysql_select (thd=thd@entry=0x145890000d48, tables=0x1458900194c0, fields=@0x145890019148: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x145890019478, last = 0x145890019478, elements = 1}, <No data fields>}, conds=0x145890019e18, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2164525828, result=0x14589001a8e8, unit=0x1458900051d0, select_lex=0x145890018e90) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_select.cc:5290
      #20 0x00005584a564ef40 in mysql_explain_union (thd=thd@entry=0x145890000d48, unit=unit@entry=0x1458900051d0, result=result@entry=0x14589001a8e8) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_select.cc:30643
      #21 0x00005584a55aad32 in execute_sqlcom_select (thd=thd@entry=0x145890000d48, all_tables=0x1458900194c0) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_parse.cc:6032
      #22 0x00005584a55b3704 in mysql_execute_command (thd=thd@entry=0x145890000d48, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_parse.cc:3942
      #23 0x00005584a55a4466 in mysql_parse (thd=thd@entry=0x145890000d48, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x1458e00a32b0) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_parse.cc:7815
      #24 0x00005584a55bb6ca in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x145890000d48, packet=packet@entry=0x14589000b1c9 "", packet_length=packet_length@entry=41, blocking=blocking@entry=true) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_class.h:1619
      #25 0x00005584a55be137 in do_command (thd=0x145890000d48, blocking=blocking@entry=true) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_parse.cc:1405
      #26 0x00005584a5742ebd in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5584a819c858, put_in_cache=put_in_cache@entry=true) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_connect.cc:1444
      #27 0x00005584a5743472 in handle_one_connection (arg=arg@entry=0x5584a819c858) at /test/mtest/MDEV-31340/11.5_dbg/sql/sql_connect.cc:1346
      #28 0x00005584a5bc2810 in pfs_spawn_thread (arg=0x5584a812edb8) at /test/mtest/MDEV-31340/11.5_dbg/storage/perfschema/pfs.cc:2201
      #29 0x00001458e361b609 in start_thread (arg=<optimized out>) at pthread_create.c:477
      #30 0x00001458e3207133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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