[MDEV-30935] Assertion `marked_for_read()' in Field_double::val_real / Virtual_column_info::fix_expr - Jira

Details

Type: Bug
Status: Confirmed (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.5, 10.6, 10.11
Component/s: Virtual Columns
Labels:
- needs_bisect

Description

It should be related to ~~MDEV-30730~~, but that one has some dependency on Galera and (probably because of that) affected versions are different.

CREATE TABLE t (f DOUBLE NOT NULL, vf DOUBLE AS (RAND(1 AND f)) VIRTUAL);

ALTER TABLE t MODIFY COLUMN IF EXISTS x INT;

INSERT INTO t (f) SELECT f FROM t;

# Cleanup

DROP TABLE t;

10.4 ff3d4395
mysqld: /data/src/10.4/sql/field.cc:4871: virtual double Field_double::val_real(): Assertion `marked_for_read()' failed.
230327 17:50:24 [ERROR] mysqld got signal 6 ;

#9 0x00007f86e6a53df2 in __GI___assert_fail (assertion=0x56279ae21bc0 "marked_for_read()", file=0x56279ae20f40 "/data/src/10.4/sql/field.cc", line=4871, function=0x56279ae24be0 "virtual double Field_double::val_real()") at ./assert/assert.c:101
#10 0x00005627991a48f7 in Field_double::val_real (this=0x619000084410) at /data/src/10.4/sql/field.cc:4871
#11 0x00005627992831e9 in Item_field::val_real (this=0x6190000848c8) at /data/src/10.4/sql/item.cc:3255
#12 0x00005627992e3c33 in Arg_comparator::compare_real (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.cc:851
#13 0x00005627993263fe in Arg_comparator::compare (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.h:104
#14 0x00005627992ef70c in Item_func_ne::val_int (this=0x61d0001fb8e0) at /data/src/10.4/sql/item_cmpfunc.cc:1809
#15 0x0000562798fea2d0 in Type_handler_int_result::Item_val_bool (this=0x56279bc10240 <type_handler_bool>, item=0x61d0001fb8e0) at /data/src/10.4/sql/sql_type.cc:4607
#16 0x00005627987df9b2 in Item::val_bool (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1473
#17 0x0000562798c1b3de in Item::eval_const_cond (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1481
#18 0x000056279930d889 in Item_cond::fix_fields (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item_cmpfunc.cc:4853
#19 0x00005627987fc81d in Item::fix_fields_if_needed (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item.h:966
#20 0x00005627993692f3 in Item_func::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:355
#21 0x0000562799387769 in Item_func_rand::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:2764
#22 0x0000562798da0deb in Virtual_column_info::fix_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3290
#23 0x0000562798da1254 in Virtual_column_info::fix_session_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3316
#24 0x0000562798da1d80 in TABLE::vcol_fix_expr (this=0x62000003c088, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3402
#25 0x0000562798900910 in open_table (thd=0x62b00005b208, table_list=0x62b000062340, ot_ctx=0x7f86dee2f9b0) at /data/src/10.4/sql/sql_base.cc:2233
#26 0x00005627989091ec in open_and_process_table (thd=0x62b00005b208, tables=0x62b000062340, counter=0x7f86dee2fac0, flags=0, prelocking_strategy=0x7f86dee2fbd0, has_prelocking_list=false, ot_ctx=0x7f86dee2f9b0) at /data/src/10.4/sql/sql_base.cc:3909
#27 0x000056279890bc99 in open_tables (thd=0x62b00005b208, options=..., start=0x7f86dee2fad0, counter=0x7f86dee2fac0, flags=0, prelocking_strategy=0x7f86dee2fbd0) at /data/src/10.4/sql/sql_base.cc:4390
#28 0x0000562798910da5 in open_and_lock_tables (thd=0x62b00005b208, options=..., tables=0x62b000062340, derived=true, flags=0, prelocking_strategy=0x7f86dee2fbd0) at /data/src/10.4/sql/sql_base.cc:5337
#29 0x000056279886bdd2 in open_and_lock_tables (thd=0x62b00005b208, tables=0x62b000062340, derived=true, flags=0) at /data/src/10.4/sql/sql_base.h:503
#30 0x0000562798a971c1 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:4682
#31 0x0000562798aae104 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "INSERT INTO t (f) SELECT f FROM t", length=33, parser_state=0x7f86dee31860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7986
#32 0x0000562798a847c9 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x62900023f209 "INSERT INTO t (f) SELECT f FROM t", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#33 0x0000562798a81351 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
#34 0x0000562798e76680 in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
#35 0x0000562798e75f97 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
#36 0x0000562799ac608a in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#37 0x00007f86e6aa7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#38 0x00007f86e6b2866c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

Attachments

Issue Links

relates to

MDEV-30730 Assertion `marked_for_read()' failed in virtual bool Field_newdate::get_TIME(MYSQL_TIME*, const uchar*, date_mode_t) const

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2023-03-27 14:49

Elena Stepanova made changes - 2023-03-27 14:49

Field	Original Value	New Value
Link		This issue relates to ~~MDEV-30730~~ [ ~~MDEV-30730~~ ]

Elena Stepanova made changes - 2023-03-27 14:51

Description

It should be related to ~~MDEV-30730~~, but that one has some dependency on Galera and (probably because of that) affected versions are different.

{code:sql}
CREATE TABLE t (f DOUBLE NOT NULL, vf DOUBLE AS (RAND(1 AND f)) VIRTUAL);
ALTER TABLE t MODIFY COLUMN IF EXISTS x INT;
INSERT INTO t (f) SELECT f FROM X;

# Cleanup
DROP TABLE t;
{code}

{noformat:title=10.4 ff3d4395}
mysqld: /data/src/10.4/sql/field.cc:4871: virtual double Field_double::val_real(): Assertion `marked_for_read()' failed.
230327 17:45:38 [ERROR] mysqld got signal 6 ;

#9 0x00007fb3f9f74df2 in __GI___assert_fail (assertion=0x5646892a7bc0 "marked_for_read()", file=0x5646892a6f40 "/data/src/10.4/sql/field.cc", line=4871, function=0x5646892aabe0 "virtual double Field_double::val_real()") at ./assert/assert.c:101
#10 0x000056468762a8f7 in Field_double::val_real (this=0x619000084410) at /data/src/10.4/sql/field.cc:4871
#11 0x00005646877091e9 in Item_field::val_real (this=0x6190000848c8) at /data/src/10.4/sql/item.cc:3255
#12 0x0000564687769c33 in Arg_comparator::compare_real (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.cc:851
#13 0x00005646877ac3fe in Arg_comparator::compare (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.h:104
#14 0x000056468777570c in Item_func_ne::val_int (this=0x61d0001fb8e0) at /data/src/10.4/sql/item_cmpfunc.cc:1809
#15 0x00005646874702d0 in Type_handler_int_result::Item_val_bool (this=0x56468a096240 <type_handler_bool>, item=0x61d0001fb8e0) at /data/src/10.4/sql/sql_type.cc:4607
#16 0x0000564686c659b2 in Item::val_bool (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1473
#17 0x00005646870a13de in Item::eval_const_cond (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1481
#18 0x0000564687793889 in Item_cond::fix_fields (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item_cmpfunc.cc:4853
#19 0x0000564686c8281d in Item::fix_fields_if_needed (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item.h:966
#20 0x00005646877ef2f3 in Item_func::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:355
#21 0x000056468780d769 in Item_func_rand::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:2764
#22 0x0000564687226deb in Virtual_column_info::fix_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3290
#23 0x0000564687227254 in Virtual_column_info::fix_session_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3316
#24 0x0000564687227d80 in TABLE::vcol_fix_expr (this=0x62000003c088, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3402
#25 0x0000564686d86910 in open_table (thd=0x62b00005b208, table_list=0x62b000062340, ot_ctx=0x7fb3f22859b0) at /data/src/10.4/sql/sql_base.cc:2233
#26 0x0000564686d8f1ec in open_and_process_table (thd=0x62b00005b208, tables=0x62b000062340, counter=0x7fb3f2285ac0, flags=0, prelocking_strategy=0x7fb3f2285bd0, has_prelocking_list=false, ot_ctx=0x7fb3f22859b0) at /data/src/10.4/sql/sql_base.cc:3909
#27 0x0000564686d91c99 in open_tables (thd=0x62b00005b208, options=..., start=0x7fb3f2285ad0, counter=0x7fb3f2285ac0, flags=0, prelocking_strategy=0x7fb3f2285bd0) at /data/src/10.4/sql/sql_base.cc:4390
#28 0x0000564686d96da5 in open_and_lock_tables (thd=0x62b00005b208, options=..., tables=0x62b000062340, derived=true, flags=0, prelocking_strategy=0x7fb3f2285bd0) at /data/src/10.4/sql/sql_base.cc:5337
#29 0x0000564686cf1dd2 in open_and_lock_tables (thd=0x62b00005b208, tables=0x62b000062340, derived=true, flags=0) at /data/src/10.4/sql/sql_base.h:503
#30 0x0000564686f1d1c1 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:4682
#31 0x0000564686f34104 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "INSERT INTO t (f) SELECT f FROM X", length=33, parser_state=0x7fb3f2287860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7986
#32 0x0000564686f0a7c9 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x62900023f209 "INSERT INTO t (f) SELECT f FROM X", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#33 0x0000564686f07351 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
#34 0x00005646872fc680 in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
#35 0x00005646872fbf97 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
#36 0x0000564687f4c08a in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#37 0x00007fb3f9fc8fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#38 0x00007fb3fa04966c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
{noformat}

It should be related to ~~MDEV-30730~~, but that one has some dependency on Galera and (probably because of that) affected versions are different.

{code:sql}
CREATE TABLE t (f DOUBLE NOT NULL, vf DOUBLE AS (RAND(1 AND f)) VIRTUAL);
ALTER TABLE t MODIFY COLUMN IF EXISTS x INT;
INSERT INTO t (f) SELECT f FROM t;

# Cleanup
DROP TABLE t;
{code}

{noformat:title=10.4 ff3d4395}
mysqld: /data/src/10.4/sql/field.cc:4871: virtual double Field_double::val_real(): Assertion `marked_for_read()' failed.
230327 17:50:24 [ERROR] mysqld got signal 6 ;

#9 0x00007f86e6a53df2 in __GI___assert_fail (assertion=0x56279ae21bc0 "marked_for_read()", file=0x56279ae20f40 "/data/src/10.4/sql/field.cc", line=4871, function=0x56279ae24be0 "virtual double Field_double::val_real()") at ./assert/assert.c:101
#10 0x00005627991a48f7 in Field_double::val_real (this=0x619000084410) at /data/src/10.4/sql/field.cc:4871
#11 0x00005627992831e9 in Item_field::val_real (this=0x6190000848c8) at /data/src/10.4/sql/item.cc:3255
#12 0x00005627992e3c33 in Arg_comparator::compare_real (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.cc:851
#13 0x00005627993263fe in Arg_comparator::compare (this=0x61d0001fb9a8) at /data/src/10.4/sql/item_cmpfunc.h:104
#14 0x00005627992ef70c in Item_func_ne::val_int (this=0x61d0001fb8e0) at /data/src/10.4/sql/item_cmpfunc.cc:1809
#15 0x0000562798fea2d0 in Type_handler_int_result::Item_val_bool (this=0x56279bc10240 <type_handler_bool>, item=0x61d0001fb8e0) at /data/src/10.4/sql/sql_type.cc:4607
#16 0x00005627987df9b2 in Item::val_bool (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1473
#17 0x0000562798c1b3de in Item::eval_const_cond (this=0x61d0001fb8e0) at /data/src/10.4/sql/item.h:1481
#18 0x000056279930d889 in Item_cond::fix_fields (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item_cmpfunc.cc:4853
#19 0x00005627987fc81d in Item::fix_fields_if_needed (this=0x6190000849e0, thd=0x62b00005b208, ref=0x619000084c20) at /data/src/10.4/sql/item.h:966
#20 0x00005627993692f3 in Item_func::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:355
#21 0x0000562799387769 in Item_func_rand::fix_fields (this=0x619000084b90, thd=0x62b00005b208, ref=0x61d0001fb8b8) at /data/src/10.4/sql/item_func.cc:2764
#22 0x0000562798da0deb in Virtual_column_info::fix_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3290
#23 0x0000562798da1254 in Virtual_column_info::fix_session_expr (this=0x61d0001fb8a8, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3316
#24 0x0000562798da1d80 in TABLE::vcol_fix_expr (this=0x62000003c088, thd=0x62b00005b208) at /data/src/10.4/sql/table.cc:3402
#25 0x0000562798900910 in open_table (thd=0x62b00005b208, table_list=0x62b000062340, ot_ctx=0x7f86dee2f9b0) at /data/src/10.4/sql/sql_base.cc:2233
#26 0x00005627989091ec in open_and_process_table (thd=0x62b00005b208, tables=0x62b000062340, counter=0x7f86dee2fac0, flags=0, prelocking_strategy=0x7f86dee2fbd0, has_prelocking_list=false, ot_ctx=0x7f86dee2f9b0) at /data/src/10.4/sql/sql_base.cc:3909
#27 0x000056279890bc99 in open_tables (thd=0x62b00005b208, options=..., start=0x7f86dee2fad0, counter=0x7f86dee2fac0, flags=0, prelocking_strategy=0x7f86dee2fbd0) at /data/src/10.4/sql/sql_base.cc:4390
#28 0x0000562798910da5 in open_and_lock_tables (thd=0x62b00005b208, options=..., tables=0x62b000062340, derived=true, flags=0, prelocking_strategy=0x7f86dee2fbd0) at /data/src/10.4/sql/sql_base.cc:5337
#29 0x000056279886bdd2 in open_and_lock_tables (thd=0x62b00005b208, tables=0x62b000062340, derived=true, flags=0) at /data/src/10.4/sql/sql_base.h:503
#30 0x0000562798a971c1 in mysql_execute_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:4682
#31 0x0000562798aae104 in mysql_parse (thd=0x62b00005b208, rawbuf=0x62b000062228 "INSERT INTO t (f) SELECT f FROM t", length=33, parser_state=0x7f86dee31860, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:7986
#32 0x0000562798a847c9 in dispatch_command (command=COM_QUERY, thd=0x62b00005b208, packet=0x62900023f209 "INSERT INTO t (f) SELECT f FROM t", packet_length=33, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1857
#33 0x0000562798a81351 in do_command (thd=0x62b00005b208) at /data/src/10.4/sql/sql_parse.cc:1378
#34 0x0000562798e76680 in do_handle_one_connection (connect=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1420
#35 0x0000562798e75f97 in handle_one_connection (arg=0x6080000009a8) at /data/src/10.4/sql/sql_connect.cc:1324
#36 0x0000562799ac608a in pfs_spawn_thread (arg=0x615000003508) at /data/src/10.4/storage/perfschema/pfs.cc:1869
#37 0x00007f86e6aa7fd4 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#38 0x00007f86e6b2866c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
{noformat}

Elena Stepanova made changes - 2023-04-07 18:53

Affects Version/s

10.7 [ 24805 ]

Julien Fritsch made changes - 2023-04-27 14:48

Fix Version/s

10.8 [ 26121 ]

Julien Fritsch made changes - 2023-11-28 10:22

Fix Version/s

10.9 [ 26905 ]

Julien Fritsch made changes - 2023-11-28 10:27

Fix Version/s

10.10 [ 27530 ]

Julien Fritsch made changes - 2024-05-03 14:41

Fix Version/s

11.0 [ 28320 ]

Julien Fritsch made changes - 2024-09-10 14:59

Fix Version/s

10.4 [ 22408 ]

Roel Van de Paar made changes - 2025-01-31 00:29

Status

Open [ 1 ]

Confirmed [ 10101 ]

Alice Sherepa made changes - 2025-04-08 14:15

Labels

needs_bisect

People

Assignee:: Nikita Malyavin

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-03-27 14:49

Updated:: 2025-04-08 14:15

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration