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

Server crash or UBSAN errors in Item_func_nextval::update_table upon INSERT DELAYED

    XMLWordPrintable

Details

    • Bug
    • Status: Approved (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.6, 10.11, 11.4, 11.8, 12.1
    • 10.11, 11.4, 11.8
    • Sequences
    • None

    Description

      nikitamalyavin confirmed that this is a different issue from MDEV-37345, specific to INSERT DELAYED. I am thus filing as Minor, because nobody really cares about INSERT DELAYED, but I need it to be filed for tests to start ignoring it.

      CREATE SEQUENCE s ENGINE=MyISAM;
      CREATE TABLE t (id BIGINT DEFAULT(NEXTVAL(s))) ENGINE=MyISAM;
      INSERT DELAYED INTO t () VALUES();
      

      10.11 4918fc5780fe961c16ad590afab79150712f578e

      /data/bld/10.11-asan-ubsan/sql/item_func.h:4279:38: runtime error: member access within null pointer of type 'struct TABLE_LIST'
      251020 19:25:27 [ERROR] /share8t/bld/10.11-asan-ubsan/sql/mariadbd got signal 11 ;
       
      #4  <signal handler called>
      #5  0x000055879fcb013a in Item_func_nextval::update_table (this=0x62d00005d138) at /data/bld/10.11-asan-ubsan/sql/item_func.h:4279
      #6  Item_func_nextval::val_int (this=0x62d00005d138) at /data/bld/10.11-asan-ubsan/sql/item_func.cc:7144
      #7  0x000055879fa5257f in Item::save_int_in_field (this=this@entry=0x62d00005d138, field=field@entry=0x62d00005c0a8, no_conversions=no_conversions@entry=false) at /data/bld/10.11-asan-ubsan/sql/item.cc:7084
      #8  0x000055879f235914 in Type_handler_int_result::Item_save_in_field (this=<optimized out>, item=0x62d00005d138, field=0x62d00005c0a8, no_conversions=<optimized out>) at /data/bld/10.11-asan-ubsan/sql/sql_type.cc:4433
      #9  0x000055879f9db82e in Item::save_in_field (this=0x62d00005d138, field=0x62d00005c0a8, no_conversions=<optimized out>) at /data/bld/10.11-asan-ubsan/sql/item.cc:7104
      #10 0x000055879ed29027 in TABLE::update_default_fields (this=this@entry=0x62d00005bc38, ignore_errors=ignore_errors@entry=false) at /data/bld/10.11-asan-ubsan/sql/table.cc:9257
      #11 0x000055879e3375d9 in fill_record (thd=thd@entry=0x62c0000b0218, table_arg=table_arg@entry=0x62d00005bc38, fields=..., values=..., ignore_errors=ignore_errors@entry=false, update=update@entry=false) at /data/bld/10.11-asan-ubsan/sql/sql_base.cc:9151
      #12 0x000055879e337e67 in fill_record_n_invoke_before_triggers (thd=thd@entry=0x62c0000b0218, table=table@entry=0x62d00005bc38, fields=..., values=..., ignore_errors=ignore_errors@entry=false, event=event@entry=TRG_EVENT_INSERT) at /data/bld/10.11-asan-ubsan/sql/sql_base.cc:9295
      #13 0x000055879e4fd257 in mysql_insert (thd=thd@entry=0x62c0000b0218, table_list=<optimized out>, fields=..., values_list=..., update_fields=..., update_values=..., duplic=<optimized out>, ignore=<optimized out>, result=<optimized out>) at /data/bld/10.11-asan-ubsan/sql/sql_insert.cc:1130
      #14 0x000055879e68f3c5 in mysql_execute_command (thd=thd@entry=0x62c0000b0218, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:4628
      #15 0x000055879e6aa995 in mysql_parse (thd=thd@entry=0x62c0000b0218, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fa1d234fab0) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:8184
      #16 0x000055879e6b3d20 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x62c0000b0218, packet=packet@entry=0x62900024e219 "INSERT DELAYED INTO t () VALUES()", packet_length=packet_length@entry=33, blocking=blocking@entry=true) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:1906
      #17 0x000055879e6c095c in do_command (thd=thd@entry=0x62c0000b0218, blocking=blocking@entry=true) at /data/bld/10.11-asan-ubsan/sql/sql_parse.cc:1419
      #18 0x000055879eeb8ee4 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x6080000039b8, put_in_cache=put_in_cache@entry=true) at /data/bld/10.11-asan-ubsan/sql/sql_connect.cc:1475
      #19 0x000055879eeba041 in handle_one_connection (arg=0x6080000039b8) at /data/bld/10.11-asan-ubsan/sql/sql_connect.cc:1387
      #20 0x00005587a082b789 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/10.11-asan-ubsan/storage/perfschema/pfs.cc:2201
      #21 0x00007fa1dcea81c4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #22 0x00007fa1dcf2885c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: