[MDEV-40938] Assertion `!thd->lex->last_table() || !thd->lex->last_table()->vers_conditions.delete_history' failed - Jira

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.11, 11.4, 11.8, 12.3, 13.0, 13.1
Fix Version/s: 10.11, 11.4, 11.8, 12.3, 13.0
Component/s: Server
Labels:
None

Bug Category:
Can result in hang or crash

Description

CREATE TABLE t (c1 INT) WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME;

DELETE HISTORY FROM t BEFORE SYSTEM_TIME (SELECT * FROM t);

Leads to:

CS 13.0.2 be111d2cd60d035d555b71da019765cfb42ea0d3 (Debug, Clang 22.1.8-20260621) Build 21/08/2026

mariadbd: /test/13.0_dbg/sql/sql_base.cc:1879: bool TABLE::vers_switch_partition(THD *, TABLE_LIST *, Open_table_context *): Assertion `!thd->lex->last_table() || !thd->lex->last_table()->vers_conditions.delete_history' failed.

CS 13.0.2 be111d2cd60d035d555b71da019765cfb42ea0d3 (Debug, Clang 22.1.8-20260621) Build 21/08/2026
Core was generated by `/test/MD210826-mariadb-13.0.2-linux-x86_64-dbg/bin/mariadbd --no-defaults --loo'.
Program terminated with signal SIGABRT, Aborted.
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44

[Current thread is 1 (LWP 2976078)]
(gdb) bt
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
#1 __pthread_kill_internal (signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:78
#2 __GI___pthread_kill (threadid=<optimized out>, signo=signo@entry=6)at ./nptl/pthread_kill.c:89
#3 0x000071de8f84527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
#4 0x000071de8f8288ff in __GI_abort () at ./stdlib/abort.c:79
#5 0x000071de8f82881b in __assert_fail_base (fmt=0x71de8f9d01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x5f11f20ec8e4 "!thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history", file=file@entry=0x5f11f20ec2f1 "/test/13.0_dbg/sql/sql_base.cc", line=line@entry=1879, function=function@entry=0x5f11f20ec937 "bool TABLE::vers_switch_partition(THD , TABLE_LIST , Open_table_context *)") at ./assert/assert.c:96
#6 0x000071de8f83b517 in __assert_fail (assertion=0x5f11f20ec8e4 "!thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history", file=0x5f11f20ec2f1 "/test/13.0_dbg/sql/sql_base.cc", line=1879, function=0x5f11f20ec937 "bool TABLE::vers_switch_partition(THD , TABLE_LIST , Open_table_context *)") at ./assert/assert.c:105
#7 0x00005f11f105a121 in TABLE::vers_switch_partition (this=0x69dd78029f60, thd=0x69dd78000d60, table_list=0x69dd7801ac80, ot_ctx=0x71de8c08dff8)at /test/13.0_dbg/sql/sql_base.cc:1878
#8 0x00005f11f105b162 in open_table (thd=0x69dd78000d60, table_list=0x69dd7801ac80, ot_ctx=0x71de8c08dff8)at /test/13.0_dbg/sql/sql_base.cc:2359
#9 0x00005f11f10600e1 in open_and_process_table (thd=0x69dd78000d60, tables=0x69dd7801ac80, counter=0x69dd7801cc68, flags=0, prelocking_strategy=0x69dd7801cca0, has_prelocking_list=false, ot_ctx=0x71de8c08dff8) at /test/13.0_dbg/sql/sql_base.cc:4297
#10 0x00005f11f105ef2b in open_tables (thd=0x69dd78000d60, options=@0x69dd7800688c: {m_options = DDL_options_st::OPT_NONE}, start=0x71de8c08e108, counter=0x69dd7801cc68, flags=0, prelocking_strategy=0x69dd7801cca0) at /test/13.0_dbg/sql/sql_base.cc:4780
#11 0x00005f11f10622aa in open_tables (thd=0x69dd78000d60, tables=0x71de8c08e108, counter=0x69dd7801cc68, flags=0, prelocking_strategy=0x69dd7801cca0) at /test/13.0_dbg/sql/sql_base.h:275
#12 0x00005f11f106244b in open_tables_for_query (thd=0x69dd78000d60, tables=0x69dd7801ac80, table_count=0x69dd7801cc68, flags=0, prelocking_strategy=0x69dd7801cca0) at /test/13.0_dbg/sql/sql_base.cc:5952
#13 0x00005f11f11d0fdd in Sql_cmd_dml::prepare (this=0x69dd7801cc50, thd=0x69dd78000d60) at /test/13.0_dbg/sql/sql_select.cc:34918
#14 0x00005f11f11d11eb in Sql_cmd_dml::execute (this=0x69dd7801cc50, thd=0x69dd78000d60) at /test/13.0_dbg/sql/sql_select.cc:34983
#15 0x00005f11f1120a00 in mysql_execute_command (thd=0x69dd78000d60, is_called_from_prepared_stmt=false) at /test/13.0_dbg/sql/sql_parse.cc:4446
#16 0x00005f11f1117d18 in mysql_parse (thd=0x69dd78000d60, rawbuf=0x69dd7801a3c0 "DELETE HISTORY FROM t BEFORE SYSTEM_TIME (SELECT * FROM t)", length=58, parser_state=0x71de8c08f9f0)at /test/13.0_dbg/sql/sql_parse.cc:7943
#17 0x00005f11f111546e in dispatch_command (command=COM_QUERY, thd=0x69dd78000d60, packet=0x69dd7800b5f1 "DELETE HISTORY FROM t BEFORE SYSTEM_TIME (SELECT * FROM t)", packet_length=58, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1903
#18 0x00005f11f111879a in do_command (thd=0x69dd78000d60, blocking=true)at /test/13.0_dbg/sql/sql_parse.cc:1437
#19 0x00005f11f12ea75e in do_handle_one_connection (connect=0x5f1209973700, put_in_cache=true) at /test/13.0_dbg/sql/sql_connect.cc:1514
#20 0x00005f11f12ea541 in handle_one_connection (arg=0x5f1209952060)at /test/13.0_dbg/sql/sql_connect.cc:1426
#21 0x000071de8f89cb84 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
#22 0x000071de8f929d6c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78

Bug Detection Matrix
Rel o/d Build Commit UniqueID observed
CS 10.11 dbg 210826 6415902490b1b0a9a500cee9bc0a41c342190605 !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
CS 10.11 opt 210826 6415902490b1b0a9a500cee9bc0a41c342190605 No bug found
CS 11.4 dbg 210826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
CS 11.4 opt 210826 1a052f27e374fc9b4cb5b1fd098cf10f0e1381cc No bug found
CS 11.8 dbg 210826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
CS 11.8 opt 210826 d26f9ab217a7fcf9d4eccc62c01020ff275ff42e No bug found
CS 12.3 dbg 210826 add63991988734383c5e942de2a19c6c45f511f7 !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
CS 12.3 opt 210826 add63991988734383c5e942de2a19c6c45f511f7 No bug found
CS 13.0 dbg 210826 be111d2cd60d035d555b71da019765cfb42ea0d3 !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
CS 13.0 opt 210826 be111d2cd60d035d555b71da019765cfb42ea0d3 No bug found
CS 13.1 dbg 210826 ff09eefbe4e8b57846435ee4a928f17e49f0fdfc !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
CS 13.1 opt 210826 ff09eefbe4e8b57846435ee4a928f17e49f0fdfc No bug found
ES 10.6 dbg 210826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
ES 10.6 opt 210826 fcecb2620f25965723d640decede7c018bcb1dcc No bug found
ES 11.4 dbg 210826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
ES 11.4 opt 210826 3b34189bfe675c18c4ced3ef531d016ea74c76f4 No bug found
ES 11.8 dbg 210826 4694e931d10fecf733c34f83ea2146d31b708eb3 !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
ES 11.8 opt 210826 4694e931d10fecf733c34f83ea2146d31b708eb3 No bug found
ES 12.3 dbg 210826 f513f503feacabfb219d4a6f965b5f72b86d4db0 !thd->lex->last_table() \|\| !thd->lex->last_table()->vers_conditions.delete_history\|SIGABRT\|TABLE::vers_switch_partition\|open_table\|open_and_process_table\|open_tables
ES 12.3 opt 210826 f513f503feacabfb219d4a6f965b5f72b86d4db0 No bug found

Assertion `!thd->lex->last_table() || !thd->lex->last_table()->vers_conditions.delete_history' failed

Details

Description

Attachments

Activity

People

Dates

Time Tracking

Git Integration