• Thirunarayanan Balathandayuthapani's avatar
    MDEV-23199 page_compression flag is missing for full_crc32 tablespace · f19da4a0
    Thirunarayanan Balathandayuthapani authored
    Problem:
    ======
    Making the tablespace as page_compressed doesn't do table rebuild.
    It does change only the FSP_SPACE_FLAGS.
    
    During recovery:
    1) InnoDB encounters FILE_CREATE redo log and opens the tablespace
    with old FSP_SPACE_FLAGS value.
    2) Only parsing of redo log has been finished. Now InnoDB tries to
    load the table. If the existing tablespace flags doesn't match
    with table flags then InnoDB should read page0. But in
    fsp_flags_try_adjust(), skips the page read for full_crc32 format.
    3) After that, InnoDB tries to open the clustered index and it
    leads to failure of page validation.
    
    Fix:
    ===
    While parsing the redo log record, track FSP_SPACE_FLAGS in
    recv_spaces for the respective space id. Assign the flags for
    the tablespace when it is loaded.
    
    recv_parse_set_size_and_flags(): Parse the redo log to set the
    tablespace recovery size and flags.
    
    fil_space_set_recv_size_and_flags(): Changed from
    fil_space_set_recv_size(). To set the recovery size and flags of
    the tablespace.
    
    Introduce flags variable in file_name_t to maintain the tablespace
    flag which we encountered during parsing of redo log.
    
    is_flags_full_crc32_equal(), is_flags_non_full_crc32_equal(): Rename
    the variable page_ssize and space_page_ssize with fcrc32_psize and
    non_fcrc32_psize.
    f19da4a0
table_flags.result 6.08 KB