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

Assertion `!item->null_value' failed upon VEC_TOTEXT call

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • 11.7.1
    • Vector search
    • None

    Description

      Notes:
      The test case uses vector(80) for a more valid scenario, but the issue is not specific to the vector type, the failure happens with blob as well. VEC_ToText call on the right table's column appears to be important.
      We have open bugs for a similar assertion failure with at least UUID function (MDEV-26992, MDEV-34922), so maybe it is a generic issue not related to the vector development at all. If so, please feel free to demote it, although it's still unfortunate that it gets extended onto new functions.

      --source include/have_sequence.inc
      		 
       
      		 
      CREATE TABLE t (v VECTOR(80));
      		 
      INSERT INTO t SELECT VEC_FROMTEXT(CONCAT('[', GROUP_CONCAT(ROUND(RAND(1))), ']')) AS v FROM seq_1_to_80 s1, seq_1_to_900 s2 GROUP BY s2.seq;
      		 
      SELECT VEC_TOTEXT(tb2.v) FROM t tb1 LEFT JOIN t tb2 ON (tb1.v > tb2.v);
      		 
       
      		 
      # Cleanup
      		 
      DROP TABLE t;

      bb-11.6-MDEV-32887-vector c29016301f7095ccc482fdfec1887f61e5adbed1

      		 
      mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_type.cc:7637: bool Type_handler::Item_send_str(Item*, Protocol*, st_value*) const: Assertion `!item->null_value' failed.
      		 
      241021 15:25:07 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #10 0x00007fd4eb253e32 in __GI___assert_fail (assertion=0x5594fd2661cc "!item->null_value", file=0x5594fd266318 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_type.cc", line=7637, function=0x5594fd269ca8 "bool Type_handler::Item_send_str(Item*, Protocol*, st_value*) const") at ./assert/assert.c:101
      		 
      #11 0x00005594fb5e1070 in Type_handler::Item_send_str (this=this@entry=0x5594ffebb4d0 <type_handler_varchar>, item=item@entry=0x7fd4c8017208, protocol=protocol@entry=0x7fd4c8001370, buf=buf@entry=0x7fd4d74facc0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_type.cc:7637
      		 
      #12 0x00005594fb28cce9 in Type_handler_string_result::Item_send (this=0x5594ffebb4d0 <type_handler_varchar>, item=0x7fd4c8017208, protocol=0x7fd4c8001370, buf=0x7fd4d74facc0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_type.h:5723
      		 
      #13 0x00005594fa90ecbf in Item::send (this=0x7fd4c8017208, protocol=0x7fd4c8001370, buffer=0x7fd4d74facc0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/item.h:1250
      		 
      #14 0x00005594faa043b3 in Protocol::send_result_set_row (this=this@entry=0x7fd4c8001370, row_items=row_items@entry=0x7fd4c8016e90) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/protocol.cc:1353
      		 
      #15 0x00005594fabd4e6b in select_send::send_data (this=0x7fd4c80197e0, items=...) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_class.cc:3275
      		 
      #16 0x00005594fafe0cc8 in select_result_sink::send_data_with_check (this=this@entry=0x7fd4c80197e0, items=..., u=u@entry=0x7fd4c8005250, sent=sent@entry=361814) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_class.h:6190
      		 
      #17 0x00005594faf1cb4c in end_send (join=0x7fd4c8019808, join_tab=0x7fd4c8084fd8, end_of_records=<optimized out>) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:24984
      		 
      #18 0x00005594fb3e8bcd in JOIN_CACHE::generate_full_extensions (this=this@entry=0x7fd4c8085ce8, rec_ptr=rec_ptr@entry=0x7fd4c8b0c9d0 "\001\376@\001") at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_join_cache.cc:2537
      		 
      #19 0x00005594fb3ea5e1 in JOIN_CACHE::join_matching_records (this=0x7fd4c8085ce8, skip_last=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_join_cache.cc:2429
      		 
      #20 0x00005594fb3e71f3 in JOIN_CACHE::join_records (this=this@entry=0x7fd4c8085ce8, skip_last=skip_last@entry=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_join_cache.cc:2179
      		 
      #21 0x00005594faee672b in sub_select_cache (join=0x7fd4c8019808, join_tab=0x7fd4c8084b68, end_of_records=<optimized out>) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:23397
      		 
      #22 0x00005594faee5566 in sub_select (join=0x7fd4c8019808, join_tab=0x7fd4c80846f8, end_of_records=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:23587
      		 
      #23 0x00005594faf4d211 in do_select (join=join@entry=0x7fd4c8019808, procedure=<optimized out>) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:23167
      		 
      #24 0x00005594fafcdb22 in JOIN::exec_inner (this=this@entry=0x7fd4c8019808) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:5026
      		 
      #25 0x00005594fafcdfac in JOIN::exec (this=this@entry=0x7fd4c8019808) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:4809
      		 
      #26 0x00005594fafc7ea5 in mysql_select (thd=thd@entry=0x7fd4c8000d58, tables=0x7fd4c8017370, fields=..., conds=conds@entry=0x0, og_num=og_num@entry=0, order=order@entry=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7fd4c80197e0, unit=0x7fd4c8005250, select_lex=0x7fd4c8016bd8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:5342
      		 
      #27 0x00005594fafc89ca in handle_select (thd=thd@entry=0x7fd4c8000d58, lex=lex@entry=0x7fd4c8005170, result=result@entry=0x7fd4c80197e0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:624
      		 
      #28 0x00005594fad9ec74 in execute_sqlcom_select (thd=thd@entry=0x7fd4c8000d58, all_tables=0x7fd4c8017370) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:6151
      		 
      #29 0x00005594fadc7862 in mysql_execute_command (thd=thd@entry=0x7fd4c8000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:3953
      		 
      #30 0x00005594faddc828 in mysql_parse (thd=thd@entry=0x7fd4c8000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fd4d74fc440) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:7873
      		 
      #31 0x00005594fade31fc in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fd4c8000d58, packet=packet@entry=0x7fd4c800b3c9 "1,1,1,0,0,1,1,0,0,1,0,1,0,0,1,0,0,0,1,0,1,1]\242", packet_length=packet_length@entry=70, blocking=blocking@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:1892
      		 
      #32 0x00005594fadeb9ed in do_command (thd=0x7fd4c8000d58, blocking=blocking@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:1405
      		 
      #33 0x00005594fb2e67b0 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5595017312d8, put_in_cache=put_in_cache@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_connect.cc:1448
      		 
      #34 0x00005594fb2e7666 in handle_one_connection (arg=0x5595017312d8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_connect.cc:1350
      		 
      #35 0x00005594fc4b54db in pfs_spawn_thread (arg=0x5595016c2f48) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/storage/perfschema/pfs.cc:2198
      		 
      #36 0x00007fd4eb2a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      		 
      #37 0x00007fd4eb32861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

      Attachments

        Issue Links

          is caused by

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34939 vector search in 11.7

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.