[MDEV-14687] DELETE HISTORY in prepared stmt crash - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: N/A
Fix Version/s: 10.3.4
Component/s: Prepared Statements, Versioned Tables
Labels:
None

Description

Assertion `s && s->versioned' failed in TABLE::vers_end_field()

CREATE OR REPLACE TABLE t1 (f INT);

PREPARE stmt FROM 'TRUNCATE t1 TO system_time NOW()';

EXECUTE stmt;

# Cleanup

DROP TABLE t1;

bb-10.3-temporal 2ae2876a6ce4b1
mysqld: /data/src/bb-10.3-temporal/sql/table.h:1547: Field* TABLE::vers_end_field() const: Assertion `s && s->versioned' failed.
171217 2:02:45 [ERROR] mysqld got signal 6 ;

#7 0x00007ff90519eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055cc55ea97b6 in TABLE::vers_end_field (this=0x7ff8e400cad0) at /data/src/bb-10.3-temporal/sql/table.h:1547
#9 0x000055cc563784fe in mysql_delete (thd=0x7ff8e4000b00, table_list=0x7ff8e40824a8, conds=0x0, order_list=0x0, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-temporal/sql/sql_delete.cc:333
#10 0x000055cc563b08b4 in Sql_cmd_truncate_table::execute (this=0x7ff8e4082bd8, thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_truncate.cc:503
#11 0x000055cc55eef5a5 in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6258
#12 0x000055cc55f11cad in Prepared_statement::execute (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4682
#13 0x000055cc55f100ca in Prepared_statement::execute_loop (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4111
#14 0x000055cc55f0dd18 in mysql_sql_stmt_execute (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:3218
#15 0x000055cc55ee6e3b in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:3765
#16 0x000055cc55ef40e4 in mysql_parse (thd=0x7ff8e4000b00, rawbuf=0x7ff8e4014c48 "EXECUTE stmt", length=12, parser_state=0x7ff9003b35f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7988
#17 0x000055cc55ee18a7 in dispatch_command (command=COM_QUERY, thd=0x7ff8e4000b00, packet=0x7ff8e411ee21 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1826
#18 0x000055cc55ee02db in do_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
#19 0x000055cc56046ada in do_handle_one_connection (connect=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#20 0x000055cc56046867 in handle_one_connection (arg=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#21 0x000055cc564dccfc in pfs_spawn_thread (arg=0x55cc586e8590) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#22 0x00007ff906e75494 in start_thread (arg=0x7ff9003b4700) at pthread_create.c:333
#23 0x00007ff90525b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Reproducible with InnoDB and MyISAM.

Attachments

Issue Links

relates to

MDEV-18727 System Versioning: optimize DML operation

Closed

Activity

Ascending order - Click to sort in descending order

Elena Stepanova created issue - 2017-12-17 00:03

Elena Stepanova made changes - 2017-12-17 00:04

Field	Original Value	New Value
Assignee	Elena Stepanova [ elenst ]	Aleksey Midenkov [ midenok ]

Elena Stepanova made changes - 2017-12-18 10:33

Assignee

Aleksey Midenkov [ midenok ]

Alexander Krizhanovsky [ krizhanovsky ]

Alexander Krizhanovsky made changes - 2017-12-18 15:39

Assignee

Alexander Krizhanovsky [ krizhanovsky ]

Aleksey Midenkov [ midenok ]

Aleksey Midenkov made changes - 2017-12-19 20:50

Summary

Assertion `s && s->versioned' failed in TABLE::vers_end_field()

DELETE HISTORY in prepared stmt crash

Aleksey Midenkov made changes - 2017-12-19 20:50

Description

{code:sql}
CREATE OR REPLACE TABLE t1 (f INT);
PREPARE stmt FROM 'TRUNCATE t1 TO system_time NOW()';
EXECUTE stmt;

# Cleanup
DROP TABLE t1;
{code}

{noformat:title=bb-10.3-temporal 2ae2876a6ce4b1}
mysqld: /data/src/bb-10.3-temporal/sql/table.h:1547: Field* TABLE::vers_end_field() const: Assertion `s && s->versioned' failed.
171217 2:02:45 [ERROR] mysqld got signal 6 ;

#7 0x00007ff90519eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055cc55ea97b6 in TABLE::vers_end_field (this=0x7ff8e400cad0) at /data/src/bb-10.3-temporal/sql/table.h:1547
#9 0x000055cc563784fe in mysql_delete (thd=0x7ff8e4000b00, table_list=0x7ff8e40824a8, conds=0x0, order_list=0x0, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-temporal/sql/sql_delete.cc:333
#10 0x000055cc563b08b4 in Sql_cmd_truncate_table::execute (this=0x7ff8e4082bd8, thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_truncate.cc:503
#11 0x000055cc55eef5a5 in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6258
#12 0x000055cc55f11cad in Prepared_statement::execute (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4682
#13 0x000055cc55f100ca in Prepared_statement::execute_loop (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4111
#14 0x000055cc55f0dd18 in mysql_sql_stmt_execute (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:3218
#15 0x000055cc55ee6e3b in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:3765
#16 0x000055cc55ef40e4 in mysql_parse (thd=0x7ff8e4000b00, rawbuf=0x7ff8e4014c48 "EXECUTE stmt", length=12, parser_state=0x7ff9003b35f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7988
#17 0x000055cc55ee18a7 in dispatch_command (command=COM_QUERY, thd=0x7ff8e4000b00, packet=0x7ff8e411ee21 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1826
#18 0x000055cc55ee02db in do_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
#19 0x000055cc56046ada in do_handle_one_connection (connect=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#20 0x000055cc56046867 in handle_one_connection (arg=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#21 0x000055cc564dccfc in pfs_spawn_thread (arg=0x55cc586e8590) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#22 0x00007ff906e75494 in start_thread (arg=0x7ff9003b4700) at pthread_create.c:333
#23 0x00007ff90525b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
{noformat}

Reproducible with InnoDB and MyISAM.

Assertion `s && s->versioned' failed in TABLE::vers_end_field()

{code:sql}
CREATE OR REPLACE TABLE t1 (f INT);
PREPARE stmt FROM 'TRUNCATE t1 TO system_time NOW()';
EXECUTE stmt;

# Cleanup
DROP TABLE t1;
{code}

{noformat:title=bb-10.3-temporal 2ae2876a6ce4b1}
mysqld: /data/src/bb-10.3-temporal/sql/table.h:1547: Field* TABLE::vers_end_field() const: Assertion `s && s->versioned' failed.
171217 2:02:45 [ERROR] mysqld got signal 6 ;

#7 0x00007ff90519eee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8 0x000055cc55ea97b6 in TABLE::vers_end_field (this=0x7ff8e400cad0) at /data/src/bb-10.3-temporal/sql/table.h:1547
#9 0x000055cc563784fe in mysql_delete (thd=0x7ff8e4000b00, table_list=0x7ff8e40824a8, conds=0x0, order_list=0x0, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.3-temporal/sql/sql_delete.cc:333
#10 0x000055cc563b08b4 in Sql_cmd_truncate_table::execute (this=0x7ff8e4082bd8, thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_truncate.cc:503
#11 0x000055cc55eef5a5 in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:6258
#12 0x000055cc55f11cad in Prepared_statement::execute (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4682
#13 0x000055cc55f100ca in Prepared_statement::execute_loop (this=0x7ff8e4006960, expanded_query=0x7ff9003b2430, open_cursor=false, packet=0x0, packet_end=0x0) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:4111
#14 0x000055cc55f0dd18 in mysql_sql_stmt_execute (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_prepare.cc:3218
#15 0x000055cc55ee6e3b in mysql_execute_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:3765
#16 0x000055cc55ef40e4 in mysql_parse (thd=0x7ff8e4000b00, rawbuf=0x7ff8e4014c48 "EXECUTE stmt", length=12, parser_state=0x7ff9003b35f0, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:7988
#17 0x000055cc55ee18a7 in dispatch_command (command=COM_QUERY, thd=0x7ff8e4000b00, packet=0x7ff8e411ee21 "EXECUTE stmt", packet_length=12, is_com_multi=false, is_next_command=false) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1826
#18 0x000055cc55ee02db in do_command (thd=0x7ff8e4000b00) at /data/src/bb-10.3-temporal/sql/sql_parse.cc:1371
#19 0x000055cc56046ada in do_handle_one_connection (connect=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1420
#20 0x000055cc56046867 in handle_one_connection (arg=0x55cc586e0620) at /data/src/bb-10.3-temporal/sql/sql_connect.cc:1326
#21 0x000055cc564dccfc in pfs_spawn_thread (arg=0x55cc586e8590) at /data/src/bb-10.3-temporal/storage/perfschema/pfs.cc:1863
#22 0x00007ff906e75494 in start_thread (arg=0x7ff9003b4700) at pthread_create.c:333
#23 0x00007ff90525b93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
{noformat}

Reproducible with InnoDB and MyISAM.

Aleksey Midenkov made changes - 2017-12-20 13:15

Fix Version/s		10.3.3 [ 22644 ]
Fix Version/s	10.3 [ 22126 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Aleksey Midenkov added a comment - 2017-12-21 07:28

Analysis

Aleksey Midenkov added a comment - 2017-12-21 07:28 Analysis

Sergei Golubchik made changes - 2017-12-27 14:10

Fix Version/s		10.3.4 [ 22904 ]
Fix Version/s	10.3.3 [ 22644 ]

Aleksey Midenkov made changes - 2019-02-25 13:27

Link

This issue relates to ~~MDEV-18727~~ [ ~~MDEV-18727~~ ]

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

Workflow

MariaDB v3 [ 84478 ]

MariaDB v4 [ 153381 ]

People

Assignee:: Aleksey Midenkov

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2017-12-17 00:03

Updated:: 2019-02-25 13:27

Resolved:: 2017-12-20 13: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