Redo Optimized DDL operation (like CREATE INDEX with sorted index build) that doesn't flush REDO log immediately can cause SST to fail.

To reproduce:

• Start a single node cluster

• Create some initial workload to run DDL 

  sysbench --threads=1 --rate=0 --report-interval=1 --percentile=99 --events=0 --time=0 --mysql-ignore-errors=all \ --mysql-user=root --mysql-socket=/tmp/n1.sock /home/krunal.bauskar/tools/sysbench/install/share/sysbench/oltp_insert.lua \ --mysql-db=test1 --tables=1 --table_size=2000000 prepare sysbench --threads=1 --rate=0 --report-interval=1 --percentile=99 --events=0 --time=0 --mysql-ignore-errors=all \ --mysql-user=root --mysql-socket=/tmp/n1.sock /home/krunal.bauskar/tools/sysbench/install/share/sysbench/oltp_insert.lua \ --mysql-db=test2 --tables=1 --table_size=2000000 prepare

• Run the below script to trigger the workload on node-1

  #!/bin/bash echo "drop table if exists test1.sb1"| ./bin/mysql --user root -S /tmp/n1.sock -D test echo "create table test1.sb1 as select id,c from test1.sbtest1 where id < 150000;"| ./bin/mysql --user root -S /tmp/n1.sock -D test echo "create unique index ix on test1.sb1 (id)"| ./bin/mysql --user root -S /tmp/n1.sock -D test echo "show tables" | ./bin/mysql --user root -S /tmp/n1.sock -D test1 sleep 1 echo "drop table if exists test2.sb1"| ./bin/mysql --user root -S /tmp/n1.sock -D test echo "create table test2.sb1 as select id,c from test2.sbtest1 where id < 150000;"| ./bin/mysql --user root -S /tmp/n1.sock -D test echo "create unique index ix on test2.sb1 (id)"| ./bin/mysql --user root -S /tmp/n1.sock -D test echo "show tables" | ./bin/mysql --user root -S /tmp/n1.sock -D test2

• Start node-2 (with clean-data-dir so that it join using SST)

• Backup action on donor (during SST) will fail with the following error

  InnoDB: An optimized (without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet. PXB will not be able take a consistent backup. Retry the backup operation

• SST on JOINER is aborted