Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21606 Improve update handler (long unique keys on blobs)
  3. MDEV-21627

Assertion `inited == NONE || update_handler != this' failed in handler::ha_write_row

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 (f VARCHAR(4096), s DATE, e DATE, PERIOD FOR app(s,e), UNIQUE(f)) ENGINE=MyISAM;
      INSERT INTO t1 VALUES ('foo', '2023-08-30', '2025-07-09'),('bar', '2021-01-01', '2021-12-31');
      DELETE FROM t1 FOR PORTION OF app FROM '2023-08-29' TO '2025-07-01';
       
      # Cleanup
      DROP TABLE t1;
      

      bb-10.5-monty b834d1fc

      mysqld: /data/src/bb-10.5-monty/sql/handler.cc:6706: int handler::ha_write_row(const uchar*): Assertion `inited == NONE || update_handler != this' failed.
      200201 17:59:07 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f26b79d7f12 in __GI___assert_fail (assertion=0x562045277aa0 "inited == NONE || update_handler != this", file=0x5620452755d8 "/data/src/bb-10.5-monty/sql/handler.cc", line=6706, function=0x562045279fa0 <handler::ha_write_row(unsigned char const*)::__PRETTY_FUNCTION__> "int handler::ha_write_row(const uchar*)") at assert.c:101
      #8  0x00005620446b8e27 in handler::ha_write_row (this=0x7f26a01308b8, buf=0x7f26a013a0e8 "\374\003") at /data/src/bb-10.5-monty/sql/handler.cc:6706
      #9  0x00005620444aa7c6 in TABLE::period_make_insert (this=0x7f26a012f5e0, src=0x7f26a0013da0, dst=0x7f26a0130570) at /data/src/bb-10.5-monty/sql/table.cc:8567
      #10 0x00005620444aa9f3 in TABLE::insert_portion_of_time (this=0x7f26a012f5e0, thd=0x7f26a0000b00, period_conds=..., rows_inserted=0x7f26b2382570) at /data/src/bb-10.5-monty/sql/table.cc:8597
      #11 0x000056204487c591 in mysql_delete (thd=0x7f26a0000b00, table_list=0x7f26a0013600, conds=0x7f26a0014a90, order_list=0x7f26a00054e0, limit=18446744073709551615, options=0, result=0x0) at /data/src/bb-10.5-monty/sql/sql_delete.cc:794
      #12 0x0000562044361c9b in mysql_execute_command (thd=0x7f26a0000b00) at /data/src/bb-10.5-monty/sql/sql_parse.cc:4739
      #13 0x000056204436d599 in mysql_parse (thd=0x7f26a0000b00, rawbuf=0x7f26a00134c8 "DELETE FROM t1 FOR PORTION OF app FROM '2023-08-29' TO '2025-07-01'", length=67, parser_state=0x7f26b2383570, is_com_multi=false, is_next_command=false) at /data/src/bb-10.5-monty/sql/sql_parse.cc:7990
      #14 0x00005620443585a9 in dispatch_command (command=COM_QUERY, thd=0x7f26a0000b00, packet=0x7f26a0008461 "DELETE FROM t1 FOR PORTION OF app FROM '2023-08-29' TO '2025-07-01'", packet_length=67, is_com_multi=false, is_next_command=false) at /data/src/bb-10.5-monty/sql/sql_parse.cc:1846
      #15 0x0000562044356d03 in do_command (thd=0x7f26a0000b00) at /data/src/bb-10.5-monty/sql/sql_parse.cc:1364
      #16 0x00005620444f8b85 in do_handle_one_connection (connect=0x562047de2740, put_in_cache=true) at /data/src/bb-10.5-monty/sql/sql_connect.cc:1422
      #17 0x00005620444f88b4 in handle_one_connection (arg=0x562047de2740) at /data/src/bb-10.5-monty/sql/sql_connect.cc:1319
      #18 0x0000562044a5514b in pfs_spawn_thread (arg=0x562047de2380) at /data/src/bb-10.5-monty/storage/perfschema/pfs.cc:1869
      #19 0x00007f26b99604a4 in start_thread (arg=0x7f26b2384700) at pthread_create.c:456
      #20 0x00007f26b7a94d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      The assertion was added in this commit

      commit 574eb36c14d4ca2022c7803bd5c94076937df16a
      Author: Monty
      Date:   Mon Jan 13 18:30:13 2020 +0200
       
          Improve update handler (long unique keys on blobs)
          
          MDEV-21606 Improve update handler (long unique keys on blobs)
          MDEV-21470 MyISAM and Aria start_bulk_insert doesn't work with long unique
      

      so naturally it's not reproducible on 10.5 main tree.
      Not reproducible with InnoDB.

      Attachments

        Activity

          People

            monty Michael Widenius
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.