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

Server crashes in _ma_unpin_all_pages/_ma_search on UPDATE with Aria engine

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 ( id int, s date, e date, period FOR p (s, e), PRIMARY KEY (id, p WITHOUT OVERLAPS)) engine=aria;
      INSERT INTO t1 VALUES (1,'1970-01-01','1970-01-02'),(2,'0000-00-00','2000-01-20');
       
      UPDATE  IGNORE t1 SET s = 'a' ;
      

      Server version: 11.1.2-MariaDB-debug-log source revision: adc13e2c167c90f4b287efa7b1165c68d441be8d
      230801 17:26:36 [ERROR] mysqld got signal 11 ;
       
      sql/signal_handler.cc:241(handle_fatal_signal)[0x556f08d589b8]
      sigaction.c:0(__restore_rt)[0x7f96a7a02420]
      maria/ma_key_recover.c:71(_ma_unpin_all_pages)[0x556f09385f79]
      maria/ma_search.c:100(_ma_search)[0x556f0936dc22]
      maria/ma_rkey.c:104(maria_rkey)[0x556f093696e4]
      maria/ha_maria.cc:2524(ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x556f0929a449]
      sql/handler.cc:3665(handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function))[0x556f08d77df2]
      sql/handler.cc:7647(handler::ha_check_overlaps(unsigned char const*, unsigned char const*))[0x556f08d9b3e3]
      sql/handler.cc:7844(handler::ha_update_row(unsigned char const*, unsigned char const*))[0x556f08d9dc02]
      sql/sql_update.cc:987(Sql_cmd_update::update_single_table(THD*))[0x556f087be851]
      sql/sql_update.cc:3067(Sql_cmd_update::execute_inner(THD*))[0x556f087d3649]
      sql/sql_select.cc:33356(Sql_cmd_dml::execute(THD*))[0x556f0861bda1]
      sql/sql_parse.cc:4393(mysql_execute_command(THD*, bool))[0x556f08437c62]
      sql/sql_parse.cc:7774(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x556f0844f4d7]
      sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x556f08427a5f]
      sql/sql_parse.cc:1405(do_command(THD*, bool))[0x556f084247a9]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x556f088f79a9]
      sql/sql_connect.cc:1320(handle_one_connection)[0x556f088f7306]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x556f09536cb8]
      nptl/pthread_create.c:478(start_thread)[0x7f96a79f6609]
       
      Query (0x62900004b2a8): UPDATE  IGNORE t1 SET s = 'a'
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.