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

Assertion `is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || (table->vcol_set && bitmap_is_set(table->vcol_set, field_index)))' failed in Field_time::store_TIME_with_warning

    Details

      Description

      10.1 545c912696

      mysqld: /data/src/10.1/sql/field.cc:5696: int Field_time::store_TIME_with_warning(MYSQL_TIME*, const ErrConv*, int, int): Assertion `is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || (table->vcol_set && bitmap_is_set(table->vcol_set, field_index)))' failed.
      170103  1:40:19 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007ff1aa906266 in __assert_fail_base (fmt=0x7ff1aaa3f238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7ff1adadca68 "is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || (table->vcol_set && bitmap_is_set(table->vcol_set, field_index)))", file=file@entry=0x7ff1adadc754 "/data/src/10.1/sql/field.cc", line=line@entry=5696, function=function@entry=0x7ff1adae0040 <Field_time::store_TIME_with_warning(st_mysql_time*, ErrConv const*, int, int)::__PRETTY_FUNCTION__> "int Field_time::store_TIME_with_warning(MYSQL_TIME*, const ErrConv*, int, int)") at assert.c:92
      #7  0x00007ff1aa906312 in __GI___assert_fail (assertion=0x7ff1adadca68 "is_stat_field || !table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || (table->vcol_set && bitmap_is_set(table->vcol_set, field_index)))", file=0x7ff1adadc754 "/data/src/10.1/sql/field.cc", line=5696, function=0x7ff1adae0040 <Field_time::store_TIME_with_warning(st_mysql_time*, ErrConv const*, int, int)::__PRETTY_FUNCTION__> "int Field_time::store_TIME_with_warning(MYSQL_TIME*, const ErrConv*, int, int)") at assert.c:101
      #8  0x00007ff1ad326207 in Field_time::store_TIME_with_warning (this=0x7ff1a1c9fd58, ltime=0x7ff1ae02af00, str=0x7ff1ae02af30, was_cut=0, have_smth_to_conv=1) at /data/src/10.1/sql/field.cc:5696
      #9  0x00007ff1ad3266d2 in Field_time::store_time_dec (this=0x7ff1a1c9fd58, ltime=0x7ff1ae02b1a0, dec=0) at /data/src/10.1/sql/field.cc:5779
      #10 0x00007ff1ad3409bc in field_conv_incompatible (to=0x7ff1a1c9fd58, from=0x7ff1a1c9fc88) at /data/src/10.1/sql/field_conv.cc:933
      #11 0x00007ff1ad3405f2 in field_conv (to=0x7ff1a1c9fd58, from=0x7ff1a1c9fc88) at /data/src/10.1/sql/field_conv.cc:877
      #12 0x00007ff1ad3698a3 in save_field_in_field (from=0x7ff1a1c9fc88, null_value=0x7ff1a3bd56fa, to=0x7ff1a1c9fd58, no_conversions=false) at /data/src/10.1/sql/item.cc:5866
      #13 0x00007ff1ad369b15 in Item_field::save_in_field (this=0x7ff1a3bd5688, to=0x7ff1a1c9fd58, no_conversions=false) at /data/src/10.1/sql/item.cc:5922
      #14 0x00007ff1ad209b65 in update_virtual_fields (thd=0x7ff1a3bf9070, table=0x7ff1a1c81c70, vcol_update_mode=VCOL_UPDATE_ALL) at /data/src/10.1/sql/table.cc:6906
      #15 0x00007ff1ad0b4ffe in fill_record (thd=0x7ff1a3bf9070, table_arg=0x7ff1a1c81c70, fields=..., values=..., ignore_errors=false) at /data/src/10.1/sql/sql_base.cc:8766
      #16 0x00007ff1ad0b530b in fill_record_n_invoke_before_triggers (thd=0x7ff1a3bf9070, table=0x7ff1a1c81c70, fields=..., values=..., ignore_errors=false, event=TRG_EVENT_INSERT) at /data/src/10.1/sql/sql_base.cc:8863
      #17 0x00007ff1ad0edeaa in mysql_insert (thd=0x7ff1a3bf9070, table_list=0x7ff1a1c43180, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=true) at /data/src/10.1/sql/sql_insert.cc:903
      #18 0x00007ff1ad11271e in mysql_execute_command (thd=0x7ff1a3bf9070) at /data/src/10.1/sql/sql_parse.cc:3898
      #19 0x00007ff1ad11d5b6 in mysql_parse (thd=0x7ff1a3bf9070, rawbuf=0x7ff1a1c43088 "INSERT IGNORE INTO t1 (i) VALUES (1)", length=36, parser_state=0x7ff1ae02c5e0) at /data/src/10.1/sql/sql_parse.cc:7319
      #20 0x00007ff1ad10bf9d in dispatch_command (command=COM_QUERY, thd=0x7ff1a3bf9070, packet=0x7ff1a553e071 "INSERT IGNORE INTO t1 (i) VALUES (1)", packet_length=36) at /data/src/10.1/sql/sql_parse.cc:1487
      #21 0x00007ff1ad10acd4 in do_command (thd=0x7ff1a3bf9070) at /data/src/10.1/sql/sql_parse.cc:1108
      #22 0x00007ff1ad24121d in do_handle_one_connection (thd_arg=0x7ff1a3bf9070) at /data/src/10.1/sql/sql_connect.cc:1350
      #23 0x00007ff1ad240f81 in handle_one_connection (arg=0x7ff1a3bf9070) at /data/src/10.1/sql/sql_connect.cc:1262
      #24 0x00007ff1ad52459c in pfs_spawn_thread (arg=0x7ff1aa027ef0) at /data/src/10.1/storage/perfschema/pfs.cc:1860
      #25 0x00007ff1ac8080a4 in start_thread (arg=0x7ff1ae02db00) at pthread_create.c:309
      #26 0x00007ff1aa9c087d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      CREATE TABLE t1 ( 
       i INT,
       t TIME NOT NULL DEFAULT '00:00:00',
       vt TIME(4) AS (t) VIRTUAL
      ) ENGINE=MyISAM;
      CREATE TRIGGER trg BEFORE UPDATE ON t1 FOR EACH ROW SET @a = 1;
      INSERT IGNORE INTO t1 (i) VALUES (1);
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: