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

Cascade foreign key updates do not apply in online alter

Details

    Description

      --source include/have_debug_sync.inc
      		 
      --source include/have_innodb.inc
      		 
       
      		 
      create table t1 (a int primary key) engine=InnoDB;
      		 
      insert into t1 values (1),(2),(3);
      		 
      create table t2 (b int, foreign key (b) references t1 (a) on update cascade) engine=InnoDB;
      		 
      insert into t2 values (1),(2),(3);
      		 
      --send
      		 
        set debug_sync= 'now wait_for downgraded';
      		 
       
      		 
      --connect (con_alter,localhost,root,,test)
      		 
      set debug_sync= 'alter_table_online_downgraded signal downgraded wait_for goforit';
      		 
      --send
      		 
        alter table t2 add c int, algorithm=copy, lock=none;
      		 
       
      		 
      --connection default
      		 
      --reap
      		 
      update t1 set a = 22 where a = 2;
      		 
      set debug_sync= 'now signal goforit';
      		 
       
      		 
      --connection con_alter
      		 
      --reap
      		 
      select * from t2;
      		 
       
      		 
      # Cleanup
      		 
      drop table t2, t1;
      		 
      set debug_sync= reset;

      bb-10.10-MDEV-16329 49ad87590

      		 
      connection default;
      		 
      update t1 set a = 22 where a = 2;
      		 
      set debug_sync= 'now signal goforit';
      		 
      connection con_alter;
      		 
      select * from t2;
      		 
      b	c
      		 
      1	NULL
      		 
      2	NULL
      		 
      3	NULL

      Expected 22 instead of 2, via update cascade. 2 is now an orphan row.

      Attachments

        Issue Links

          is caused by

          Task - A task that needs to be done. MDEV-16329 Engine-independent online ALTER TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20640 [ERROR] InnoDB: tried to purge non-delete-marked record and Assertion `0' failed in row_purge_remove_sec_if_poss_leaf

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29182 Assertion `fld->field_no < table->n_v_def' failed on cascade FK update of table with vcol index in parent

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Technical task - A technical task. MDEV-28808 Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Nikita Malyavin made transition -
            Open In Progress
            		10d 18h 57m 1
            Nikita Malyavin made transition -
            In Progress In Review
            		2d 6h 14m 1
            Nikita Malyavin made transition -
            Stalled In Progress
            		2d 3h 37m 1
            Nikita Malyavin made transition -
            In Progress Stalled
            		26d 4h 32m 1
            Nikita Malyavin made transition -
            Stalled In Review
            		13d 13h 45m 2
            Sergei Golubchik made transition -
            In Review Stalled
            		167d 22h 25m 3
            Nikita Malyavin made transition -
            Stalled In Testing
            		3d 1h 13m 1
            Sergei Golubchik made transition -
            In Testing Closed
            		177d 12h 21m 1

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              Votes:
              1 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.