Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Done
-
8.0.26-16 (Q3 2021), 5.7.36-39 (Q4 2021)
-
None
-
None
Description
Inplace index build using bulk_btr are not redo logged. So server adds MLOG_ADD_INDEX redo to know such case. It is very important for backup tool to know if any transaction happened without redo logging.
When lock=exclusive and algrotithm=inplace is used. Server is not calling
Builder::write_redo
to write MLOG_ADD_INDEX redo.
CREATE TABLE t1(t1_c1 serial,t1_c2 int); INSERT into t1(t1_c2) VALUES(1),(4); ALTER TABLE t1 ADD INDEX t1_i(t1_c2) , LOCK=EXCLUSIVE, ALGORITHM=INPLACE;
whereas it works fine with LOCK=Default.