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

Assertion `marked_for_read()' failed in virtual String *Field_varstring::val_str(String *, String *)

    XMLWordPrintable

Details

    Description

      --source include/have_innodb.inc
       
      SET transaction_isolation='READ-UNCOMMITTED';
      CREATE TABLE t (a VARCHAR(10),b INT,c CHAR(10) GENERATED ALWAYS AS (a) VIRTUAL,KEY(b,c)) ENGINE=InnoDB;
      INSERT INTO t (a) VALUES ('A');
      SELECT * FROM t WHERE b IS NULL ORDER BY a;
      

      Leads to:

      CS 11.4.8 9e1c1d429f51042cf98fe78e33e0570d6fff7cd1 (Debug) Build 26/05/2025

      mariadbd: /test/11.4_dbg/sql/field.cc:8038: virtual String *Field_varstring::val_str(String *, String *): Assertion `marked_for_read()' failed.
      

      CS 11.4.8 9e1c1d429f51042cf98fe78e33e0570d6fff7cd1 (Debug) Build 26/05/2025

      Core was generated by `/test/MD260525-mariadb-11.4.8-linux-x86_64-dbg/bin/mariadbd --no-defaults --max'.
      Program terminated with signal SIGABRT, Aborted.
      Download failed: Invalid argument.  Continuing without source file ./nptl/./nptl/pthread_kill.c.
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
       
      [Current thread is 1 (LWP 1536204)]
      (gdb) bt
      #0  __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
      #1  __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
      #2  __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
      #3  0x000075704ec4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
      #4  0x000075704ec288ff in __GI_abort () at ./stdlib/abort.c:79
      #5  0x000075704ec2881b in __assert_fail_base (fmt=0x75704edd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5fe73271f710 "marked_for_read()", file=file@entry=0x5fe73271f1fa "/test/11.4_dbg/sql/field.cc", line=line@entry=8038, function=function@entry=0x5fe732721c88 "virtual String *Field_varstring::val_str(String *, String *)") at ./assert/assert.c:96
      #6  0x000075704ec3b517 in __assert_fail (assertion=0x5fe73271f710 "marked_for_read()", file=0x5fe73271f1fa "/test/11.4_dbg/sql/field.cc", line=8038, function=0x5fe732721c88 "virtual String *Field_varstring::val_str(String *, String *)") at ./assert/assert.c:105
      #7  0x00005fe731a994af in Field_varstring::val_str (this=0x755170030438, val_buffer=0x75704c1dda48, val_ptr=0x75704c1dda48)at /test/11.4_dbg/sql/field.cc:8038
      #8  0x00005fe731a99a52 in Field_varstring::sort_string (this=0x755170030438, to=0x755170079409 '\245' <repeats 200 times>..., length=10)at /test/11.4_dbg/sql/field.cc:8184
      #9  0x00005fe731a7cda7 in Field::make_sort_key_part (this=0x755170030438, buff=0x755170079409 '\245' <repeats 200 times>..., length=10)at /test/11.4_dbg/sql/field.cc:1080
      #10 0x00005fe731abe1bb in make_sortkey (param=0x75704c1de378, to=0x755170079408 "\001", '\245' <repeats 199 times>...)at /test/11.4_dbg/sql/filesort.cc:2969
      #11 0x00005fe731ab726f in make_sortkey (param=0x75704c1de378, to=0x755170079408 "\001", '\245' <repeats 199 times>..., ref_pos=0x755170031250 "", using_packed_sortkeys=false)at /test/11.4_dbg/sql/filesort.cc:1434
      #12 0x00005fe731ab7d46 in find_all_keys (thd=0x755170000d58, param=0x75704c1de378, select=0x75517001ecb8, fs_info=0x7551700779a0, buffpek_pointers=0x75704c1de030, tempfile=0x75704c1de1a0, pq=0x0, found_rows=0x755170077b90) at /test/11.4_dbg/sql/filesort.cc:1050
      #13 0x00005fe731ab58fd in filesort (thd=0x755170000d58, table=0x755170028478, filesort=0x75517001f640, tracker=0x75517001fdc0, join=0x75517001b5a8, first_table_bit=1) at /test/11.4_dbg/sql/filesort.cc:407
      #14 0x00005fe73176920a in create_sort_index (thd=0x755170000d58, join=0x75517001b5a8, tab=0x75517001dc40, fsort=0x75517001f640)at /test/11.4_dbg/sql/sql_select.cc:27808
      #15 0x00005fe731768e6a in st_join_table::sort_table (this=0x75517001dc40)at /test/11.4_dbg/sql/sql_select.cc:25320
      #16 0x00005fe73173fd34 in join_init_read_record (tab=0x75517001dc40)at /test/11.4_dbg/sql/sql_select.cc:25240
      #17 0x00005fe73171bfe1 in sub_select (join=0x75517001b5a8, join_tab=0x75517001dc40, end_of_records=false)at /test/11.4_dbg/sql/sql_select.cc:24235
      #18 0x00005fe7317434f5 in do_select (join=0x75517001b5a8, procedure=0x0)at /test/11.4_dbg/sql/sql_select.cc:23749
      #19 0x00005fe73174283a in JOIN::exec_inner (this=0x75517001b5a8)at /test/11.4_dbg/sql/sql_select.cc:5052
      #20 0x00005fe73174171e in JOIN::exec (this=0x75517001b5a8)at /test/11.4_dbg/sql/sql_select.cc:4838
      #21 0x00005fe73171c95d in mysql_select (thd=0x755170000d58, tables=0x75517001a1b0, fields=@0x755170019e30: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x75517001a160, last = 0x75517001c130, elements = 3}, <No data fields>}, conds=0x75517001a9f8, og_num=1, order=0x75517001b438, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x75517001b580, unit=0x755170005000, select_lex=0x755170019b78)at /test/11.4_dbg/sql/sql_select.cc:5368
      #22 0x00005fe73171c3e5 in handle_select (thd=0x755170000d58, lex=0x755170004f20, result=0x75517001b580, setup_tables_done_option=0)at /test/11.4_dbg/sql/sql_select.cc:642
      #23 0x00005fe7316c4431 in execute_sqlcom_select (thd=0x755170000d58, all_tables=0x75517001a1b0) at /test/11.4_dbg/sql/sql_parse.cc:6183
      #24 0x00005fe7316b93c0 in mysql_execute_command (thd=0x755170000d58, is_called_from_prepared_stmt=false) at /test/11.4_dbg/sql/sql_parse.cc:3975
      #25 0x00005fe7316b1544 in mysql_parse (thd=0x755170000d58, rawbuf=0x755170019ac0 "SELECT * FROM t WHERE b IS NULL ORDER BY a", length=42, parser_state=0x75704c1e0a30)at /test/11.4_dbg/sql/sql_parse.cc:7898
      #26 0x00005fe7316ae9f4 in dispatch_command (command=COM_QUERY, thd=0x755170000d58, packet=0x75517000afd9 "", packet_length=42, blocking=true) at /test/11.4_dbg/sql/sql_parse.cc:1904
      #27 0x00005fe7316b20f3 in do_command (thd=0x755170000d58, blocking=true)at /test/11.4_dbg/sql/sql_parse.cc:1417
      #28 0x00005fe731894919 in do_handle_one_connection (connect=0x5fe750b5e408, put_in_cache=true) at /test/11.4_dbg/sql/sql_connect.cc:1408
      #29 0x00005fe7318946b2 in handle_one_connection (arg=0x5fe750c2e878)at /test/11.4_dbg/sql/sql_connect.cc:1320
      #30 0x000075704ec9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
      #31 0x000075704ed29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
      

      Bug Detection Matrix

          Rel    o/d  Build   Commit                                    UniqueID observed             
       
      CS  10.5   dbg  280425  c461188ca6ad6ec3a54201eb87ebd75797d296df  No bug found                  
      CS  10.5   opt  280425  c461188ca6ad6ec3a54201eb87ebd75797d296df  No bug found                  
      CS  10.6   dbg  260525  8a4d3a044f9de992eabe725522bceea49fdd0e61  No bug found                  
      CS  10.6   opt  260525  8a4d3a044f9de992eabe725522bceea49fdd0e61  No bug found                  
      CS  10.11  dbg  260525  db188083c38a9aeba146c9d591e3ed12cce0b200  No bug found                  
      CS  10.11  opt  260525  db188083c38a9aeba146c9d591e3ed12cce0b200  No bug found                  
      CS  11.4   dbg  260525  9e1c1d429f51042cf98fe78e33e0570d6fff7cd1  marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey                 
      CS  11.4   opt  260525  9e1c1d429f51042cf98fe78e33e0570d6fff7cd1  No bug found                  
      CS  11.8   dbg  220425  805e7ca3adef50e17889ea17a1b86da6c3fb8580  marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey
      CS  11.8   opt  220425  805e7ca3adef50e17889ea17a1b86da6c3fb8580  No bug found                  
      CS  12.0   dbg  130525  00a9afb5818433c26537ccaf6b2c59ad493dd473  marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey               
      ES  10.5   dbg  050525  0d368ec0042a81d9549fc939fb742f82350b20ab  No bug found                  
      ES  10.5   opt  050525  0d368ec0042a81d9549fc939fb742f82350b20ab  No bug found                  
      ES  10.6   dbg  050525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  No bug found                  
      ES  10.6   opt  050525  6111fbaf7bdcb6f1170f556ffd05d6e1a4159f62  No bug found                  
      ES  11.4   dbg  050525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  marked_for_read()|SIGABRT|Field_varstring::val_str|Field_varstring::sort_string|Field::make_sort_key_part|make_sortkey
      ES  11.4   opt  050525  9cd12544ebfd0d52d2158af66b5aced58121cf1f  No bug found                  
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.