Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37397

Assertion `bitmap_is_set(&read_partitions, next->id)' failed in int partition_info::vers_set_hist_part(THD *)

    XMLWordPrintable

Details

    • 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

          Activity

            People

              serg Sergei Golubchik
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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