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

RBR breaks with HA_ERR_KEY_NOT_FOUND upon DELETE from table with spatial index

    Details

      Description

      --source include/have_binlog_format_row.inc
      --source include/master-slave.inc
       
      CREATE TABLE t1 (g POINT NOT NULL, SPATIAL INDEX(g));
      INSERT INTO t1 VALUES (ST_GEOMFROMTEXT('Point(1 1)'));
      DELETE FROM t1;
      --sync_slave_with_master
       
      --connection master
      DROP TABLE t1;
      --source include/rpl_end.inc
      

      5.5 3eb2a265ea

      Last_Errno	1032
      Last_Error	Could not execute Delete_rows event on table test.t1; Can't find record in 't1', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log master-bin.000001, end_log_pos 767
      

      It fails on all of MariaDB 5.5-10.3 and MySQL 5.6-8.0 (MySQL 5.6 even throws a debug assertion somewhere). I haven't found an upstream bug report for that and didn't create one.

        Attachments

          Activity

            People

            • Assignee:
              sachin.setiya.007 Sachin Setiya
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: