Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.6
-
Not for Release Notes
-
Q4/2025 Server Maintenance
Description
--source include/have_partition.inc
|
|
CREATE TABLE t (f INT,s DATE,e DATE,PERIOD FOR p (s,e),UNIQUE (f,p WITHOUT OVERLAPS)) WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME LIMIT+1 (PARTITION p HISTORY,PARTITION pn CURRENT); |
DELETE FROM t; |
Leads to:
CS 10.6.23 317f099ca56130a14a45b7250996c207cc95d461 (Debug, Clang) Build 04/08/2025 |
mariadbd: /test/10.6_dbg/sql/partition_info.cc:821: int partition_info::vers_set_hist_part(THD *): Assertion `bitmap_is_set(&read_partitions, next->id)' failed.
|
CS 10.6.23 317f099ca56130a14a45b7250996c207cc95d461 (Debug, Clang) Build 04/08/2025 |
Core was generated by `/test/MD040825-mariadb-10.6.23-linux-x86_64-dbg/bin/mariadbd --no-defaults --ma'.
|
Program terminated with signal SIGABRT, Aborted.
|
Download failed: Invalid argument. Continuing without source file ./nptl/./nptl/pthread_kill.c.
|
#0 __pthread_kill_implementation (no_tid=0, signo=6, threadid=<optimized out>)at ./nptl/pthread_kill.c:44
|
|
[Current thread is 1 (LWP 1805732)]
|
(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 0x00007e69e3e4527e in __GI_raise (sig=sig@entry=6)at ../sysdeps/posix/raise.c:26
|
#4 0x00007e69e3e288ff in __GI_abort () at ./stdlib/abort.c:79
|
#5 0x00007e69e3e2881b in __assert_fail_base (fmt=0x7e69e3fd01e8 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x617c971f79db "bitmap_is_set(&read_partitions, next->id)", file=file@entry=0x617c971f77b9 "/test/10.6_dbg/sql/partition_info.cc", line=line@entry=821, function=function@entry=0x617c971f7a05 "int partition_info::vers_set_hist_part(THD *)") at ./assert/assert.c:96
|
#6 0x00007e69e3e3b517 in __assert_fail (assertion=0x617c971f79db "bitmap_is_set(&read_partitions, next->id)", file=0x617c971f77b9 "/test/10.6_dbg/sql/partition_info.cc", line=821, function=0x617c971f7a05 "int partition_info::vers_set_hist_part(THD *)")at ./assert/assert.c:105
|
#7 0x0000617c963e61a8 in partition_info::vers_set_hist_part (this=0x7e4ed0031620, thd=0x7e4ed0000d58)at /test/10.6_dbg/sql/partition_info.cc:821
|
#8 0x0000617c9698f973 in ha_partition::external_lock (this=0x7e4ed0014730, thd=0x7e4ed0000d58, lock_type=1) at /test/10.6_dbg/sql/ha_partition.cc:4324
|
#9 0x0000617c9660986c in handler::ha_external_lock (this=0x7e4ed0014730, thd=0x7e4ed0000d58, lock_type=1) at /test/10.6_dbg/sql/handler.cc:7281
|
#10 0x0000617c966095da in handler::create_lookup_handler (this=0x7e4ed0024768)at /test/10.6_dbg/sql/handler.cc:3370
|
#11 0x0000617c966161db in handler::prepare_for_insert (this=0x7e4ed0024768, do_create=true) at /test/10.6_dbg/sql/handler.cc:7731
|
#12 0x0000617c9681facd in mysql_delete (thd=0x7e4ed0000d58, table_list=0x7e4ed0013428, conds=0x7e4ed0014050, order_list=0x7e4ed0005a68, limit=18446744073709551615, options=0, result=0x0) at /test/10.6_dbg/sql/sql_delete.cc:817
|
#13 0x0000617c9625a3f9 in mysql_execute_command (thd=0x7e4ed0000d58, is_called_from_prepared_stmt=false) at /test/10.6_dbg/sql/sql_parse.cc:4924
|
#14 0x0000617c9624df24 in mysql_parse (thd=0x7e4ed0000d58, rawbuf=0x7e4ed0013360 "DELETE FROM t", length=13, parser_state=0x7e6604e55a48) at /test/10.6_dbg/sql/sql_parse.cc:8200
|
#15 0x0000617c9624b3e4 in dispatch_command (command=COM_QUERY, thd=0x7e4ed0000d58, packet=0x7e4ed000ade9 "DELETE FROM t", packet_length=13, blocking=true) at /test/10.6_dbg/sql/sql_parse.cc:1908
|
#16 0x0000617c9624ead3 in do_command (thd=0x7e4ed0000d58, blocking=true)at /test/10.6_dbg/sql/sql_parse.cc:1421
|
#17 0x0000617c9640b5a9 in do_handle_one_connection (connect=0x617cc8854118, put_in_cache=true) at /test/10.6_dbg/sql/sql_connect.cc:1386
|
#18 0x0000617c9640b342 in handle_one_connection (arg=0x617cc87d70f8)at /test/10.6_dbg/sql/sql_connect.cc:1298
|
#19 0x00007e69e3e9caa4 in start_thread (arg=<optimized out>)at ./nptl/pthread_create.c:447
|
#20 0x00007e69e3f29c3c in clone3 ()at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:78
|
Bug Detection Matrix |
Rel o/d Build Commit UniqueID observed
|
CS 10.6 dbg 040825 317f099ca56130a14a45b7250996c207cc95d461 bitmap_is_set(&read_partitions, next->id)|SIGABRT|partition_info::vers_set_hist_part|ha_partition::external_lock|handler::ha_external_lock|handler::create_lookup_handler
|
CS 10.6 opt 040825 317f099ca56130a14a45b7250996c207cc95d461 No bug found
|
CS 10.11 dbg 040825 55a39f13e40807c3c8fee4573380f3e4d93e8715 No bug found
|
CS 10.11 opt 040825 55a39f13e40807c3c8fee4573380f3e4d93e8715 No bug found
|
CS 11.4 dbg 040825 4e9c252bc4bfef525ff8ec4a37fabd957694285d No bug found
|
CS 11.4 opt 040825 4e9c252bc4bfef525ff8ec4a37fabd957694285d No bug found
|
CS 12.0 dbg 290725 ef3d171e7e739dc79d972b98174db75578afc45b No bug found
|
CS 12.0 opt 290725 ef3d171e7e739dc79d972b98174db75578afc45b No bug found
|
CS 12.1 dbg 210725 7215fe789480c228a91f50ff4f047ea89c16f041 No bug found
|
CS 12.1 opt 210725 7215fe789480c228a91f50ff4f047ea89c16f041 No bug found
|
ES 10.5 dbg 040825 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.5 opt 040825 70586522eacf09d04d49962072e14325a75d8155 No bug found
|
ES 10.6 dbg 040825 9b794f34b48fb7eee490b6da44edc0f33a947447 No bug found
|
ES 10.6 opt 040825 9b794f34b48fb7eee490b6da44edc0f33a947447 No bug found
|
ES 11.4 dbg 040825 a1c03ccd54b582e75506687ee19b273ca897f261 No bug found
|
ES 11.4 opt 040825 a1c03ccd54b582e75506687ee19b273ca897f261 No bug found
|
Attachments
Issue Links
- is caused by
-
MDEV-37312 ASAN errors or assertion failure upon attempt to UPDATE FOR PORTION violating long unique under READ COMMITTED
-
- Closed
-