[MDEV-17349] Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed on concurrent SELECT and DELETE after RENAME from table with index on virtual column - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL), 10.3(EOL)
Fix Version/s: 10.3.11, 10.2.19
Component/s: Data Manipulation - Delete, Virtual Columns
Labels:
- affects-tests

Description

The test case is non-deterministic, run with --repeat=N. Usually the failure happens fast enough (in the first few repetitions), but sometimes it might take several dozen, so use a big enough N.

Also, running with --mem, while not essential for reproducing, make it much faster.

--source include/have_innodb.inc

CREATE TABLE t1 (f TEXT, vf TINYTEXT AS (f), KEY (vf(64))) ENGINE=InnoDB;

INSERT INTO t1 (f) VALUES ('foo');

--connect (con1,localhost,root,,test)

RENAME TABLE t1 TO tmp, tmp TO t1;

--send

  SELECT * from t1;

--connection default

  DELETE FROM t1;

# Cleanup

--connection con1

--reap

--disconnect con1

--connection default

DROP TABLE t1;

10.2 61a6f4bd9
mysqld: /data/src/10.2/sql/field.cc:8108: virtual String* Field_blob::val_str(String, String): Assertion `!table \|\| (!table->read_set \|\| bitmap_is_set(table->read_set, field_index))' failed.
181002 16:07:47 [ERROR] mysqld got signal 6 ;

#7 0x00007f4feb139ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055afec101814 in Field_blob::val_str (this=0x7f4f900a40b8, val_buffer=0x7f4f900a42b8, val_ptr=0x7f4f900a42b8) at /data/src/10.2/sql/field.cc:8108
#9 0x000055afebddd429 in Field::val_str (this=0x7f4f900a40b8, str=0x7f4f900a42b8) at /data/src/10.2/sql/field.h:865
#10 0x000055afec10d6ed in Field_blob::store_field (this=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field.h:3303
#11 0x000055afec1121b3 in field_conv_incompatible (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:831
#12 0x000055afec11220f in field_conv (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:844
#13 0x000055afec13f499 in save_field_in_field (from=0x7f4f900a40b8, null_value=0x7f4f9009b98a, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6421
#14 0x000055afec13f6a0 in Item_field::save_in_field (this=0x7f4f9009b918, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6467
#15 0x000055afebfb41a1 in TABLE::update_virtual_fields (this=0x7f4f900a9400, h=0x7f4f900a24c8, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7621
#16 0x000055afec11fd9a in handler::ha_rnd_next (this=0x7f4f900a24c8, buf=0x7f4f900a4070 "\374\003") at /data/src/10.2/sql/handler.cc:2585
#17 0x000055afec28d6c4 in rr_sequential (info=0x7f4fdc55ced0) at /data/src/10.2/sql/records.cc:485
#18 0x000055afec2b8f9a in mysql_delete (thd=0x7f4f90000b00, table_list=0x7f4f90012550, conds=0x0, order_list=0x7f4f90005078, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.2/sql/sql_delete.cc:559
#19 0x000055afebea6f40 in mysql_execute_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:4633
#20 0x000055afebeb187f in mysql_parse (thd=0x7f4f90000b00, rawbuf=0x7f4f90012488 "DELETE FROM t1", length=14, parser_state=0x7f4fdc55e200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8011
#21 0x000055afebe9f1da in dispatch_command (command=COM_QUERY, thd=0x7f4f90000b00, packet=0x7f4f90095ef1 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
#22 0x000055afebe9db3d in do_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:1378
#23 0x000055afebfefb4e in do_handle_one_connection (connect=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1335
#24 0x000055afebfef8db in handle_one_connection (arg=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1241
#25 0x000055afec413aa8 in pfs_spawn_thread (arg=0x55afef268bf0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#26 0x00007f4fece10494 in start_thread (arg=0x7f4fdc55f700) at pthread_create.c:333
#27 0x00007f4feb1f693f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Reproducible on 10.2, 10.3. Not applicable to 10.1 due to the index on the virtual columns.
Couldn't reproduce on 10.4 in 1000 repetitions.
No visible effect on non-debug builds.

Attachments

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2018-10-02 13:16

Elena Stepanova made changes - 2018-10-02 13:17

Field	Original Value	New Value
Description	The test case is non-deterministic, run with {{--repeat=N}}. Usually the failure happens fast enough (in the first few repetitions), but sometimes it mike take several dozen, so use a big enough {{N}}. Also, running with {{--mem}}, while not essential for reproducing, make it much faster. {code:sql} --source include/have_innodb.inc CREATE TABLE t1 (f TEXT, vf TINYTEXT AS (f), KEY (vf(64))) ENGINE=InnoDB; INSERT INTO t1 (f) VALUES ('foo'); --connect (con1,localhost,root,,test) RENAME TABLE t1 TO tmp, tmp TO t1; --send SELECT * from t1; --connection default DELETE FROM t1; # Cleanup --connection con1 --reap --disconnect con1 --connection default DROP TABLE t1; {code} {noformat:title=10.2 61a6f4bd9} mysqld: /data/src/10.2/sql/field.cc:8108: virtual String* Field_blob::val_str(String, String): Assertion `!table \|\| (!table->read_set \|\| bitmap_is_set(table->read_set, field_index))' failed. 181002 16:07:47 [ERROR] mysqld got signal 6 ; #7 0x00007f4feb139ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055afec101814 in Field_blob::val_str (this=0x7f4f900a40b8, val_buffer=0x7f4f900a42b8, val_ptr=0x7f4f900a42b8) at /data/src/10.2/sql/field.cc:8108 #9 0x000055afebddd429 in Field::val_str (this=0x7f4f900a40b8, str=0x7f4f900a42b8) at /data/src/10.2/sql/field.h:865 #10 0x000055afec10d6ed in Field_blob::store_field (this=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field.h:3303 #11 0x000055afec1121b3 in field_conv_incompatible (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:831 #12 0x000055afec11220f in field_conv (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:844 #13 0x000055afec13f499 in save_field_in_field (from=0x7f4f900a40b8, null_value=0x7f4f9009b98a, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6421 #14 0x000055afec13f6a0 in Item_field::save_in_field (this=0x7f4f9009b918, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6467 #15 0x000055afebfb41a1 in TABLE::update_virtual_fields (this=0x7f4f900a9400, h=0x7f4f900a24c8, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7621 #16 0x000055afec11fd9a in handler::ha_rnd_next (this=0x7f4f900a24c8, buf=0x7f4f900a4070 "\374\003") at /data/src/10.2/sql/handler.cc:2585 #17 0x000055afec28d6c4 in rr_sequential (info=0x7f4fdc55ced0) at /data/src/10.2/sql/records.cc:485 #18 0x000055afec2b8f9a in mysql_delete (thd=0x7f4f90000b00, table_list=0x7f4f90012550, conds=0x0, order_list=0x7f4f90005078, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.2/sql/sql_delete.cc:559 #19 0x000055afebea6f40 in mysql_execute_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:4633 #20 0x000055afebeb187f in mysql_parse (thd=0x7f4f90000b00, rawbuf=0x7f4f90012488 "DELETE FROM t1", length=14, parser_state=0x7f4fdc55e200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8011 #21 0x000055afebe9f1da in dispatch_command (command=COM_QUERY, thd=0x7f4f90000b00, packet=0x7f4f90095ef1 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824 #22 0x000055afebe9db3d in do_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:1378 #23 0x000055afebfefb4e in do_handle_one_connection (connect=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1335 #24 0x000055afebfef8db in handle_one_connection (arg=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1241 #25 0x000055afec413aa8 in pfs_spawn_thread (arg=0x55afef268bf0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #26 0x00007f4fece10494 in start_thread (arg=0x7f4fdc55f700) at pthread_create.c:333 #27 0x00007f4feb1f693f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Reproducible on 10.2, 10.3. Not applicable to 10.1 due to the index on the virtual columns. Couldn't reproduce on 10.4 in 1000 repetitions. No visible effect on non-debug builds.	The test case is non-deterministic, run with {{--repeat=N}}. Usually the failure happens fast enough (in the first few repetitions), but sometimes it mike take several dozen, so use a big enough {{N}}. Also, running with {{--mem}}, while not essential for reproducing, make it much faster. {code:sql} --source include/have_innodb.inc CREATE TABLE t1 (f TEXT, vf TINYTEXT AS (f), KEY (vf(64))) ENGINE=InnoDB; INSERT INTO t1 (f) VALUES ('foo'); --connect (con1,localhost,root,,test) RENAME TABLE t1 TO tmp, tmp TO t1; --send SELECT * from t1; --connection default DELETE FROM t1; # Cleanup --connection con1 --reap --disconnect con1 --connection default DROP TABLE t1; {code} {noformat:title=10.2 61a6f4bd9} mysqld: /data/src/10.2/sql/field.cc:8108: virtual String* Field_blob::val_str(String, String): Assertion `!table \|\| (!table->read_set \|\| bitmap_is_set(table->read_set, field_index))' failed. 181002 16:07:47 [ERROR] mysqld got signal 6 ; #7 0x00007f4feb139ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6 #8 0x000055afec101814 in Field_blob::val_str (this=0x7f4f900a40b8, val_buffer=0x7f4f900a42b8, val_ptr=0x7f4f900a42b8) at /data/src/10.2/sql/field.cc:8108 #9 0x000055afebddd429 in Field::val_str (this=0x7f4f900a40b8, str=0x7f4f900a42b8) at /data/src/10.2/sql/field.h:865 #10 0x000055afec10d6ed in Field_blob::store_field (this=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field.h:3303 #11 0x000055afec1121b3 in field_conv_incompatible (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:831 #12 0x000055afec11220f in field_conv (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:844 #13 0x000055afec13f499 in save_field_in_field (from=0x7f4f900a40b8, null_value=0x7f4f9009b98a, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6421 #14 0x000055afec13f6a0 in Item_field::save_in_field (this=0x7f4f9009b918, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6467 #15 0x000055afebfb41a1 in TABLE::update_virtual_fields (this=0x7f4f900a9400, h=0x7f4f900a24c8, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7621 #16 0x000055afec11fd9a in handler::ha_rnd_next (this=0x7f4f900a24c8, buf=0x7f4f900a4070 "\374\003") at /data/src/10.2/sql/handler.cc:2585 #17 0x000055afec28d6c4 in rr_sequential (info=0x7f4fdc55ced0) at /data/src/10.2/sql/records.cc:485 #18 0x000055afec2b8f9a in mysql_delete (thd=0x7f4f90000b00, table_list=0x7f4f90012550, conds=0x0, order_list=0x7f4f90005078, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.2/sql/sql_delete.cc:559 #19 0x000055afebea6f40 in mysql_execute_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:4633 #20 0x000055afebeb187f in mysql_parse (thd=0x7f4f90000b00, rawbuf=0x7f4f90012488 "DELETE FROM t1", length=14, parser_state=0x7f4fdc55e200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8011 #21 0x000055afebe9f1da in dispatch_command (command=COM_QUERY, thd=0x7f4f90000b00, packet=0x7f4f90095ef1 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824 #22 0x000055afebe9db3d in do_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:1378 #23 0x000055afebfefb4e in do_handle_one_connection (connect=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1335 #24 0x000055afebfef8db in handle_one_connection (arg=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1241 #25 0x000055afec413aa8 in pfs_spawn_thread (arg=0x55afef268bf0) at /data/src/10.2/storage/perfschema/pfs.cc:1862 #26 0x00007f4fece10494 in start_thread (arg=0x7f4fdc55f700) at pthread_create.c:333 #27 0x00007f4feb1f693f in clone () from /lib/x86_64-linux-gnu/libc.so.6 {noformat} Reproducible on 10.2, 10.3. Not applicable to 10.1 due to the index on the virtual columns. Couldn't reproduce on 10.4 in 1000 repetitions. No visible effect on non-debug builds.

Elena Stepanova made changes - 2018-10-02 13:17

Assignee

Elena Stepanova [ elenst ]

Sergei Golubchik [ serg ]

Elena Stepanova made changes - 2018-10-02 13:17

Description

The test case is non-deterministic, run with {{--repeat=N}}. Usually the failure happens fast enough (in the first few repetitions), but sometimes it mike take several dozen, so use a big enough {{N}}.

Also, running with {{--mem}}, while not essential for reproducing, make it much faster.

{code:sql}
--source include/have_innodb.inc

CREATE TABLE t1 (f TEXT, vf TINYTEXT AS (f), KEY (vf(64))) ENGINE=InnoDB;
INSERT INTO t1 (f) VALUES ('foo');

--connect (con1,localhost,root,,test)

RENAME TABLE t1 TO tmp, tmp TO t1;
--send
SELECT * from t1;

--connection default
DELETE FROM t1;

# Cleanup
--connection con1
--reap
--disconnect con1
--connection default
DROP TABLE t1;
{code}

{noformat:title=10.2 61a6f4bd9}
mysqld: /data/src/10.2/sql/field.cc:8108: virtual String* Field_blob::val_str(String*, String*): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
181002 16:07:47 [ERROR] mysqld got signal 6 ;

#7 0x00007f4feb139ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055afec101814 in Field_blob::val_str (this=0x7f4f900a40b8, val_buffer=0x7f4f900a42b8, val_ptr=0x7f4f900a42b8) at /data/src/10.2/sql/field.cc:8108
#9 0x000055afebddd429 in Field::val_str (this=0x7f4f900a40b8, str=0x7f4f900a42b8) at /data/src/10.2/sql/field.h:865
#10 0x000055afec10d6ed in Field_blob::store_field (this=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field.h:3303
#11 0x000055afec1121b3 in field_conv_incompatible (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:831
#12 0x000055afec11220f in field_conv (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:844
#13 0x000055afec13f499 in save_field_in_field (from=0x7f4f900a40b8, null_value=0x7f4f9009b98a, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6421
#14 0x000055afec13f6a0 in Item_field::save_in_field (this=0x7f4f9009b918, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6467
#15 0x000055afebfb41a1 in TABLE::update_virtual_fields (this=0x7f4f900a9400, h=0x7f4f900a24c8, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7621
#16 0x000055afec11fd9a in handler::ha_rnd_next (this=0x7f4f900a24c8, buf=0x7f4f900a4070 "\374\003") at /data/src/10.2/sql/handler.cc:2585
#17 0x000055afec28d6c4 in rr_sequential (info=0x7f4fdc55ced0) at /data/src/10.2/sql/records.cc:485
#18 0x000055afec2b8f9a in mysql_delete (thd=0x7f4f90000b00, table_list=0x7f4f90012550, conds=0x0, order_list=0x7f4f90005078, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.2/sql/sql_delete.cc:559
#19 0x000055afebea6f40 in mysql_execute_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:4633
#20 0x000055afebeb187f in mysql_parse (thd=0x7f4f90000b00, rawbuf=0x7f4f90012488 "DELETE FROM t1", length=14, parser_state=0x7f4fdc55e200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8011
#21 0x000055afebe9f1da in dispatch_command (command=COM_QUERY, thd=0x7f4f90000b00, packet=0x7f4f90095ef1 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
#22 0x000055afebe9db3d in do_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:1378
#23 0x000055afebfefb4e in do_handle_one_connection (connect=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1335
#24 0x000055afebfef8db in handle_one_connection (arg=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1241
#25 0x000055afec413aa8 in pfs_spawn_thread (arg=0x55afef268bf0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#26 0x00007f4fece10494 in start_thread (arg=0x7f4fdc55f700) at pthread_create.c:333
#27 0x00007f4feb1f693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
{noformat}

Reproducible on 10.2, 10.3. Not applicable to 10.1 due to the index on the virtual columns.
Couldn't reproduce on 10.4 in 1000 repetitions.
No visible effect on non-debug builds.

The test case is non-deterministic, run with {{--repeat=N}}. Usually the failure happens fast enough (in the first few repetitions), but sometimes it might take several dozen, so use a big enough {{N}}.

Also, running with {{--mem}}, while not essential for reproducing, make it much faster.

{code:sql}
--source include/have_innodb.inc

CREATE TABLE t1 (f TEXT, vf TINYTEXT AS (f), KEY (vf(64))) ENGINE=InnoDB;
INSERT INTO t1 (f) VALUES ('foo');

--connect (con1,localhost,root,,test)

RENAME TABLE t1 TO tmp, tmp TO t1;
--send
SELECT * from t1;

--connection default
DELETE FROM t1;

# Cleanup
--connection con1
--reap
--disconnect con1
--connection default
DROP TABLE t1;
{code}

{noformat:title=10.2 61a6f4bd9}
mysqld: /data/src/10.2/sql/field.cc:8108: virtual String* Field_blob::val_str(String*, String*): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
181002 16:07:47 [ERROR] mysqld got signal 6 ;

#7 0x00007f4feb139ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055afec101814 in Field_blob::val_str (this=0x7f4f900a40b8, val_buffer=0x7f4f900a42b8, val_ptr=0x7f4f900a42b8) at /data/src/10.2/sql/field.cc:8108
#9 0x000055afebddd429 in Field::val_str (this=0x7f4f900a40b8, str=0x7f4f900a42b8) at /data/src/10.2/sql/field.h:865
#10 0x000055afec10d6ed in Field_blob::store_field (this=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field.h:3303
#11 0x000055afec1121b3 in field_conv_incompatible (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:831
#12 0x000055afec11220f in field_conv (to=0x7f4f900a41d8, from=0x7f4f900a40b8) at /data/src/10.2/sql/field_conv.cc:844
#13 0x000055afec13f499 in save_field_in_field (from=0x7f4f900a40b8, null_value=0x7f4f9009b98a, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6421
#14 0x000055afec13f6a0 in Item_field::save_in_field (this=0x7f4f9009b918, to=0x7f4f900a41d8, no_conversions=false) at /data/src/10.2/sql/item.cc:6467
#15 0x000055afebfb41a1 in TABLE::update_virtual_fields (this=0x7f4f900a9400, h=0x7f4f900a24c8, update_mode=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7621
#16 0x000055afec11fd9a in handler::ha_rnd_next (this=0x7f4f900a24c8, buf=0x7f4f900a4070 "\374\003") at /data/src/10.2/sql/handler.cc:2585
#17 0x000055afec28d6c4 in rr_sequential (info=0x7f4fdc55ced0) at /data/src/10.2/sql/records.cc:485
#18 0x000055afec2b8f9a in mysql_delete (thd=0x7f4f90000b00, table_list=0x7f4f90012550, conds=0x0, order_list=0x7f4f90005078, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.2/sql/sql_delete.cc:559
#19 0x000055afebea6f40 in mysql_execute_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:4633
#20 0x000055afebeb187f in mysql_parse (thd=0x7f4f90000b00, rawbuf=0x7f4f90012488 "DELETE FROM t1", length=14, parser_state=0x7f4fdc55e200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:8011
#21 0x000055afebe9f1da in dispatch_command (command=COM_QUERY, thd=0x7f4f90000b00, packet=0x7f4f90095ef1 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1824
#22 0x000055afebe9db3d in do_command (thd=0x7f4f90000b00) at /data/src/10.2/sql/sql_parse.cc:1378
#23 0x000055afebfefb4e in do_handle_one_connection (connect=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1335
#24 0x000055afebfef8db in handle_one_connection (arg=0x55afef31d6c0) at /data/src/10.2/sql/sql_connect.cc:1241
#25 0x000055afec413aa8 in pfs_spawn_thread (arg=0x55afef268bf0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
#26 0x00007f4fece10494 in start_thread (arg=0x7f4fdc55f700) at pthread_create.c:333
#27 0x00007f4feb1f693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
{noformat}

Reproducible on 10.2, 10.3. Not applicable to 10.1 due to the index on the virtual columns.
Couldn't reproduce on 10.4 in 1000 repetitions.
No visible effect on non-debug builds.

Elena Stepanova made changes - 2018-10-02 16:35

Labels

affects-tests

Sergei Golubchik made changes - 2018-11-02 09:57

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2018-11-03 20:17

Status

Open [ 1 ]

In Progress [ 3 ]

Sergei Golubchik made changes - 2018-11-03 20:17

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Sergei Golubchik made changes - 2018-11-04 07:29

Fix Version/s		10.3.11 [ 23141 ]
Fix Version/s		10.2.19 [ 23207 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:48

Workflow

MariaDB v3 [ 89859 ]

MariaDB v4 [ 155002 ]

People

Assignee:: Sergei Golubchik

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2018-10-02 13:16

Updated:: 2018-11-04 07:29

Resolved:: 2018-11-04 07:29

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration