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

Assertion `inited != NONE' failed in handler::ha_check_overlaps

    XMLWordPrintable

Details

    Description

      --source include/have_binlog_format_row.inc
      --source include/have_innodb.inc
      --source include/master-slave.inc
       
      --connection master
      CREATE TABLE t1 (
        id int NOT NULL,
        f varchar(16),
        s datetime NOT NULL,
        e datetime NOT NULL,
        PERIOD FOR p (s, e),
        PRIMARY KEY (id,p WITHOUT OVERLAPS)
      ) ENGINE=InnoDB;
       
      INSERT INTO t1 VALUES (1,NULL,'1973-05-16 00:00:00','1981-05-23 00:00:00'),(2,NULL,'1995-04-15 00:00:00','2012-10-02 00:00:00'),(3,NULL,'1994-02-03 00:00:00','2034-03-10 00:00:00');
       
      UPDATE t1 FOR PORTION OF p FROM '1985-06-02' TO '2028-02-01' SET f=1;
       
      --sync_slave_with_master
       
      --connection master
      drop table t1;
      --source include/rpl_end.inc
      

      10.5 c69520c9dfa6e4a26258842a1d35

      mariadbd: /10.5/sql/handler.cc:7002: int handler::ha_check_overlaps(const uchar*, const uchar*): Assertion `inited != NONE' failed.
      200731 10:31:05 [ERROR] mysqld got signal 6 ;
       
      linux/raise.c:51(__GI_raise)[0x7fce7a6387bb]
      stdlib/abort.c:81(__GI_abort)[0x7fce7a623535]
      intl/loadmsgcat.c:1177(_nl_load_domain)[0x7fce7a62340f]
      ??:0(__assert_fail)[0x7fce7a631102]
      sql/handler.cc:7003(handler::ha_check_overlaps(unsigned char const*, unsigned char const*))[0x55807dc182ef]
      sql/handler.cc:7176(handler::ha_update_row(unsigned char const*, unsigned char const*))[0x55807df7a1bd]
      sql/log_event_server.cc:8344(Update_rows_log_event::do_exec_row(rpl_group_info*))[0x55807df64e90]
      sql/log_event_server.cc:5669(Rows_log_event::do_apply_event(rpl_group_info*))[0x55807d1ba3d7]
      sql/log_event.h:1496(Log_event::apply_event(rpl_group_info*))[0x55807d19c5c2]
      sql/slave.cc:4003(apply_event_and_update_pos_apply(Log_event*, THD*, rpl_group_info*, int))[0x55807d19d09a]
      sql/slave.cc:4165(apply_event_and_update_pos(Log_event*, THD*, rpl_group_info*))[0x55807d19e6fe]
      sql/slave.cc:4482(exec_relay_log_event(THD*, Relay_log_info*, rpl_group_info*))[0x55807d1a607e]
      sql/slave.cc:5659(handle_slave_sql)[0x55807e4e1886]
      nptl/pthread_create.c:487(start_thread)[0x7fce7b0f3fa3]
      x86_64/clone.S:97(clone)[0x7fce7a6fa4cf]
       
      Query (0x6120000a465b): UPDATE t1 FOR PORTION OF p FROM '1985-06-02' TO '2028-02-01' SET f=1
      

      Attachments

        Issue Links

          Activity

            People

              nikitamalyavin Nikita Malyavin
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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