mariadb/mysql-test/suite/encryption/r
Thirunarayanan Balathandayuthapani f8cf493290 MDEV-34898 Doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages does not work
- InnoDB fails to recover the full crc32 encrypted page from
doublewrite buffer. The reason is that buf_dblwr_t::recover()
fails to identify the space id from the page because the page has
been encrypted from FIL_PAGE_FILE_FLUSH_LSN_OR_KEY_VERSION bytes.

Fix:
===
buf_dblwr_t::recover(): preserve any pages whose space_id
does not match a known tablespace. These could be encrypted pages
of tablespaces that had been created with
innodb_checksum_algorithm=full_crc32.

buf_page_t::read_complete(): If the page looks corrupted and the
tablespace is encrypted and in full_crc32 format, try to
restore the page from doublewrite buffer.

recv_dblwr_t::recover_encrypted_page(): Find the page which
has the same page number and try to decrypt the page using
space->crypt_data. After decryption, compare the space id.
Write the recovered page back to the file.
2025-01-07 19:33:56 +05:30
..
aria_tiny.result MDEV-25507 CHECK on encrypted Aria table complains about "Wrong LSN" 2021-04-30 15:45:07 +03:00
compressed_import_tablespace.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
corrupted_during_recovery.result Fix occasional failure of encryption.corrupted_during_recovery 2023-12-04 11:21:58 +02:00
create_or_replace.result MDEV-23776: Re-apply the fix and make the test more robust 2020-09-22 13:08:09 +03:00
create_or_replace_big.result Merge 10.3 into 10.4 2020-09-21 17:42:02 +03:00
debug_key_management.result MDEV-34898 Doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages does not work 2025-01-07 19:33:56 +05:30
doublewrite_debug.result MDEV-34898 Doublewrite recovery of innodb_checksum_algorithm=full_crc32 encrypted pages does not work 2025-01-07 19:33:56 +05:30
encrypt_and_grep,undo3.rdiff Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
encrypt_and_grep.result Merge 10.2 into 10.3 2021-11-09 08:26:59 +02:00
encryption_force.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
encryption_key_corruption.result MDEV-27882 Innodb - recognise MySQL-8.0 innodb flags and give a specific error message 2022-11-11 10:21:28 +11:00
file_creation.result Problem: 2019-08-16 18:11:32 +05:30
filekeys_emptyfile.result
filekeys_encfile.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
filekeys_encfile_bad.result
filekeys_encfile_badfile.result
filekeys_encfile_file.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
filekeys_encfile_no.result
filekeys_nofile.result
filekeys_secret_openssl_rand_128bits.result MDEV-25343 Error log message not helpful when filekey is too long 2022-10-21 15:54:17 +11:00
filekeys_secret_too_long.result MDEV-25343 Error log message not helpful when filekey is too long 2022-10-21 15:54:17 +11:00
filekeys_syntax.result
filekeys_tooshort.result
filekeys_unencfile.result
import_4k.result MDEV-29692 Assertion `(writeptr + (i * size)) != local_frame' failed upon IMPORT TABLESPACE 2023-03-21 14:33:54 +02:00
innochecksum.result Merge 10.3 into 10.4 2022-04-06 08:59:09 +03:00
innodb-bad-key-change.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-bad-key-change2.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-bad-key-change3.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-bad-key-change4.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-checksum-algorithm,32k.rdiff MDEV-25105 Remove innodb_checksum_algorithm values none,innodb,... 2021-03-11 12:46:18 +02:00
innodb-checksum-algorithm,64k.rdiff MDEV-25105 Remove innodb_checksum_algorithm values none,innodb,... 2021-03-11 12:46:18 +02:00
innodb-checksum-algorithm.result Merge 10.3 into 10.4 2021-03-11 19:33:45 +02:00
innodb-compressed-blob.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-discard-import-change.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb-discard-import.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb-encr-threads.result
innodb-encryption-alter.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb-encryption-disable.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-force-corrupt.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-key-rotation-disable.result Merge 10.3 into 10.4 2021-06-21 12:38:25 +03:00
innodb-missing-key.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-page_encryption-32k.result MDEV-21664 Add opt files for have_innodb_Xk.inc 2023-09-11 09:09:02 +03:00
innodb-page_encryption.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-page_encryption_compression.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-page_encryption_log_encryption.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb-read-only.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb-redo-badkey.result MDEV-34830: LSN in the future is not being treated as serious corruption 2024-10-17 17:24:20 +03:00
innodb-redo-nokeys.result Merge 10.5 into 10.6 2024-02-08 10:38:53 +02:00
innodb-remove-encryption,undo3.rdiff Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
innodb-remove-encryption.result Merge 10.4 into 10.5 2021-06-08 16:03:53 +03:00
innodb-spatial-index,full_crc32.rdiff Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb-spatial-index,strict_full_crc32.rdiff Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb-spatial-index.result MDEV-18644: Support full_crc32 for page_compressed 2019-03-18 14:08:43 +02:00
innodb_encrypt_freed,undo3.rdiff Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
innodb_encrypt_freed.result MDEV-24792 Assertion `!newest_lsn || fil_page_get_type(page)' failed upon MariaBackup prepare in buf_flush_init_for_writing with innodb_log_optimize_ddl=off 2021-02-14 10:11:03 +03:00
innodb_encrypt_key_rotation_age,undo3.rdiff Remove dates from all rdiff files 2025-01-05 16:40:11 +02:00
innodb_encrypt_key_rotation_age.result MDEV-28484 InnoDB encryption key rotation is not being marked completed 2022-05-06 11:23:13 +03:00
innodb_encrypt_log.result Merge 10.3 into 10.4 2020-08-20 11:01:47 +03:00
innodb_encrypt_log_corruption.result MDEV-24412: Create a separate test 2022-11-30 06:57:32 +02:00
innodb_encrypt_temporary_tables.result MDEV-20142 encryption.innodb_encrypt_temporary_tables fails 2023-12-10 13:19:21 +02:00
innodb_encryption-page-compression.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb_encryption.result MDEV-28484 InnoDB encryption key rotation is not being marked completed 2022-05-06 11:23:13 +03:00
innodb_encryption_discard_import.result MDEV-34670 IMPORT TABLESPACE unnecessary traverses tablespace list 2024-07-31 14:13:38 +05:30
innodb_encryption_filekeys.result MDEV-29446 Change SHOW CREATE TABLE to display default collation 2022-09-12 22:10:39 +04:00
innodb_encryption_is.result
innodb_encryption_row_compressed.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb_encryption_tables.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb_first_page.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
innodb_import.result Merge 10.4 into 10.5 2021-08-18 18:22:35 +03:00
innodb_onlinealter_encryption.result Merge 10.3 into 10.4 2022-09-13 16:36:38 +03:00
innodb_page_encryption_key_change.result Write information about restart in .result 2019-04-01 19:47:24 +03:00
instant_alter_import.result MDEV-18543 IMPORT TABLESPACE fails after instant DROP COLUMN 2021-10-26 22:50:58 +06:00
key_version_rotation.result Merge 10.3 into 10.4 2021-06-21 12:38:25 +03:00
second_plugin-12863.result
tempfiles.result Updated mtr files to support different compiled in options 2019-09-01 19:17:35 +03:00
tempfiles_encrypted.result Merge branch '10.5' into 10.6 2024-08-03 09:04:24 +02:00