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

Server crashes in _ma_reset_history upon UNLOCK table with auto-create history partitions

    XMLWordPrintable

Details

    Description

      --source include/have_partition.inc
       
      set timestamp= unix_timestamp('2000-01-01 00:00:00');
       
      create table t1 (x int) engine=aria with system versioning partition by system_time interval 1 hour auto partitions 3;
      insert into t1 values (1);
       
      create table t2 (x int)engine=aria;
      create trigger tr after insert on t2 for each row update t1 set x= x + 11;
       
      lock tables t1 write, t2 write;
       
      update t1 set x= x + 1;
       
      set timestamp= unix_timestamp('2000-01-01 13:00:00');
      insert into t2 values (5);
       
      unlock tables;
      drop table t1,t2;
      
      

      Version: '10.9.8-MariaDB-debug-log'  
      230811 13:00:49 [ERROR] mysqld got signal 11 ;
       
      Server version: 10.9.8-MariaDB-debug-log source revision: 27dc4cd1fc148960abfca9652b36c26b71ef49ea
       
      sql/signal_handler.cc:241(handle_fatal_signal)[0x55d3689aef57]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x12730)[0x7f433f816730]
      maria/ma_state.c:823(_ma_reset_history)[0x55d368f663c2]
      maria/ma_state.c:484(_ma_trnman_end_trans_hook)[0x55d368f63c49]
      maria/trnman.c:497(trnman_end_trn)[0x55d368fb3e74]
      maria/ma_commit.c:73(ma_commit)[0x55d36903a22f]
      maria/ha_maria.cc:2989(ha_maria::external_lock(THD*, int))[0x55d368fa68df]
      sql/handler.cc:7145(handler::ha_external_lock(THD*, int))[0x55d3689eacef]
      sql/ha_partition.cc:4285(ha_partition::external_lock(THD*, int))[0x55d3691e23ca]
      sql/handler.cc:7145(handler::ha_external_lock(THD*, int))[0x55d3689eabed]
      sql/handler.h:3509(handler::ha_external_unlock(THD*))[0x55d367ddaa88]
      sql/lock.cc:744(unlock_external(THD*, TABLE**, unsigned int))[0x55d368d3d9b5]
      sql/lock.cc:435(mysql_unlock_tables(THD*, st_mysql_lock*, bool))[0x55d368d3b06a]
      sql/lock.cc:421(mysql_unlock_tables(THD*, st_mysql_lock*))[0x55d368d3aeb0]
      sql/sql_base.cc:958(close_thread_tables(THD*))[0x55d367f334bd]
      sql/sql_base.cc:2583(Locked_tables_list::unlock_locked_tables(THD*))[0x55d367f3ce2c]
      sql/sql_parse.cc:5091(mysql_execute_command(THD*, bool))[0x55d3680f4c33]
      sql/sql_parse.cc:8060(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55d368108b3d]
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55d3680dedb0]
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55d3680dbab2]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55d368588314]
      sql/sql_connect.cc:1320(handle_one_connection)[0x55d368587c6a]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55d36922dbdf]
      nptl/pthread_create.c:487(start_thread)[0x7f433f80bfa3]
      x86_64/clone.S:97(clone)[0x7f433f41506f]
       
      Query (0x6290000e62a8): unlock tables
      

      Attachments

        Issue Links

          Activity

            People

              midenok Aleksey Midenkov
              alice Alice Sherepa
              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.