[MDEV-27456] Assertion `!thd->is_error()' fails in vers_create_partitions upon DML with ER_UNKNOWN_PARTITION Created: 2022-01-10  Updated: 2023-06-16  Resolved: 2022-02-08

Status: Closed
Project: MariaDB Server
Component/s: Partitioning, Versioned Tables
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Aleksey Midenkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-27217 DELETE partition selection doesn't wo... Closed
Problem/Incident
is caused by MDEV-17554 Auto-create history partitions for sy... Closed
Relates
relates to MDEV-31490 [draft] Assertion `table->part_info->... Open

 Description   

--source include/have_partition.inc
 
CREATE TABLE t (a INT) WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME INTERVAL 1 MINUTE AUTO;
SET @@timestamp= @@timestamp + 61;
SELECT * FROM t;
--error ER_UNKNOWN_PARTITION
DELETE FROM t PARTITION (px);
 
# Cleanup
DROP TABLE t;

preview-10.8-MDEV-17554-auto-create-partition 86a5c6fcfe

mariadbd: /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/partition_info.cc:937: bool vers_create_partitions(THD*, TABLE_LIST*, uint): Assertion `!thd->is_error()' failed.
220110  2:28:43 [ERROR] mysqld got signal 6 ;
 
#7  0x00007f697a1d7662 in __GI___assert_fail (assertion=0x55c8bea3d3b0 "!thd->is_error()", file=0x55c8bea3cd98 "/data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/partition_info.cc", line=937, function=0x55c8bea3d3c8 "bool vers_create_partitions(THD*, TABLE_LIST*, uint)") at assert.c:101
#8  0x000055c8bd47b387 in vers_create_partitions (thd=0x7f6964000db8, tl=0x7f6964015dd0, num_parts=1) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/partition_info.cc:937
#9  0x000055c8bd02ea99 in Open_table_context::recover_from_failed_open (this=0x7f69741610c0) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_base.cc:3421
#10 0x000055c8bd03399c in open_tables (thd=0x7f6964000db8, options=..., start=0x7f6974161138, counter=0x7f6974161154, flags=0, prelocking_strategy=0x7f69741611d8) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_base.cc:4565
#11 0x000055c8bd037750 in open_and_lock_tables (thd=0x7f6964000db8, options=..., tables=0x7f6964015540, derived=true, flags=0, prelocking_strategy=0x7f69741611d8) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_base.cc:5507
#12 0x000055c8bcfae32b in open_and_lock_tables (thd=0x7f6964000db8, tables=0x7f6964015540, derived=true, flags=0) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_base.h:509
#13 0x000055c8bd0bd36b in mysql_delete (thd=0x7f6964000db8, table_list=0x7f6964015540, conds=0x0, order_list=0x7f6964005ca8, limit=18446744073709551615, options=0, result=0x0) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_delete.cc:341
#14 0x000055c8bd184df9 in mysql_execute_command (thd=0x7f6964000db8, is_called_from_prepared_stmt=false) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_parse.cc:4806
#15 0x000055c8bd19ab92 in mysql_parse (thd=0x7f6964000db8, rawbuf=0x7f6964015410 "DELETE FROM t PARTITION (px)", length=28, parser_state=0x7f69741622c0) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_parse.cc:8029
#16 0x000055c8bd171f15 in dispatch_command (command=COM_QUERY, thd=0x7f6964000db8, packet=0x7f696400b999 "DELETE FROM t PARTITION (px)", packet_length=28, blocking=true) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_parse.cc:1895
#17 0x000055c8bd16f106 in do_command (thd=0x7f6964000db8, blocking=true) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_parse.cc:1403
#18 0x000055c8bd4cde83 in do_handle_one_connection (connect=0x55c8c1ec2648, put_in_cache=true) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_connect.cc:1418
#19 0x000055c8bd4cd68a in handle_one_connection (arg=0x55c8c1fb6838) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/sql/sql_connect.cc:1312
#20 0x000055c8bddb57f8 in pfs_spawn_thread (arg=0x55c8c1ec2188) at /data/src/preview-10.8-MDEV-17554-auto-create-partition-gcov/storage/perfschema/pfs.cc:2201
#21 0x00007f697a6a3ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477
#22 0x00007f697a2a0def in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95

Non-debug build returns ER_UNKNOWN_PARTITION.



 Comments   
Comment by Ralf Gebhardt [ 2022-01-26 ]

MDEV-17554 was moved to 10.9, so I am changing fixVersion for this bug to 10.9. I am also removing the 10.8V1 support case ID label

Generated at Thu Feb 08 09:53:03 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.