[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 Created: 2017-01-02  Updated: 2017-01-13  Resolved: 2017-01-13

Status: Closed
Project: MariaDB Server
Component/s: Virtual Columns
Affects Version/s: 5.5, 10.0, 10.1, 10.2
Fix Version/s: 5.5.55, 10.0.30, 10.1.21, 10.2.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None


 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);


Generated at Thu Feb 08 07:52:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.