[MDEV-24821] Encryption loading fails while running the suite - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Cannot Reproduce
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
Fix Version/s: N/A
Component/s: Platform FreeBSD, Tests
Labels:
- affects-tests

Description

In 10.6, encryption suite test case fails with Test requires plugin

encryption.innodb-compressed-blob '16k,cbc,crc32,innodb' [ skipped ]  Test requires file_key_management plugin

line

2021-02-09 18:35:21 0 [ERROR] InnoDB: cannot enable encryption, encryption plugin is not available

2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' init function returned error.

2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

^ Found warnings in /home/thiru/mariarepo/10.6/10.6-test/bld_sample-debug/mysql-test/var/log/mysqld.1.err

ok

encryption.innodb-checksum-algorithm '4k,cbc,innodb' w2 [ skipped ]  Test requires file_key_management plugin

encryption.innodb-checksum-algorithm '8k,cbc,innodb' w4 [ skipped ]  Test requires file_key_management plugin

encryption.innochecksum '8k,cbc,innodb,strict_crc32' w6 [ skipped ]  Test requires file_key_management plugin

encryption.innochecksum '16k,cbc,innodb,strict_full_crc32' w4 [ skipped ]  Test requires file_key_management plugin

encryption.innochecksum '4k,cbc,innodb,strict_full_crc32' w6 [ skipped ]  Test requires file_key_management plugin

It fails only in 10.6. I debugged further to understand what went wrong.

mtr tool doesn't start the server with file_key_management.so. I used the verbose command to find out what went wrong.

> Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/have_innodb.combinations

> Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/suite/encryption/include/have_file_key_management_plugin.combinations

> Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/innodb_page_size_small.combinations

> Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/innodb_checksum_algorithm.combinations

worker[1] > mysqld_start:  [' --innodb-checksum-algorithm=crc32', '--innodb-page-size=16K', '--skip-innodb-read-only-compressed', '--innodb', '--innodb-cmpmem', '--innodb-cmp-per-index', '--innodb-trx', '--innodb-locks', '--innodb-lock-waits', '--innodb-metrics', '--innodb-buffer-pool-stats', '--innodb-buffer-page', '--innodb-buffer-page-lru', '--innodb-sys-columns', '--innodb-sys-fields', '--innodb-sys-foreign', '--innodb-sys-foreign-cols', '--innodb-sys-indexes', '--innodb-sys-tables', '--innodb-sys-virtual ']

Attachments

Activity

Ascending order - Click to sort in descending order

Thirunarayanan Balathandayuthapani created issue - 2021-02-09 13:08

Thirunarayanan Balathandayuthapani made changes - 2021-02-09 14:18

Field	Original Value	New Value
Description	In 10.6, encryption suite test case fails with {{Test requires plugin}} {code} encryption.innodb-compressed-blob '16k,cbc,crc32,innodb' [ skipped ] Test requires file_key_management plugin line 2021-02-09 18:35:21 0 [ERROR] InnoDB: cannot enable encryption, encryption plugin is not available 2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' init function returned error. 2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. ^ Found warnings in /home/thiru/mariarepo/10.6/10.6-test/bld_sample-debug/mysql-test/var/log/mysqld.1.err ok encryption.innodb-checksum-algorithm '4k,cbc,innodb' w2 [ skipped ] Test requires file_key_management plugin encryption.innodb-checksum-algorithm '8k,cbc,innodb' w4 [ skipped ] Test requires file_key_management plugin encryption.innochecksum '8k,cbc,innodb,strict_crc32' w6 [ skipped ] Test requires file_key_management plugin encryption.innochecksum '16k,cbc,innodb,strict_full_crc32' w4 [ skipped ] Test requires file_key_management plugin encryption.innochecksum '4k,cbc,innodb,strict_full_crc32' w6 [ skipped ] Test requires file_key_management plugin {code} It fails only in 10.6	In 10.6, encryption suite test case fails with {{Test requires plugin}} {code} encryption.innodb-compressed-blob '16k,cbc,crc32,innodb' [ skipped ] Test requires file_key_management plugin line 2021-02-09 18:35:21 0 [ERROR] InnoDB: cannot enable encryption, encryption plugin is not available 2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' init function returned error. 2021-02-09 18:35:21 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. ^ Found warnings in /home/thiru/mariarepo/10.6/10.6-test/bld_sample-debug/mysql-test/var/log/mysqld.1.err ok encryption.innodb-checksum-algorithm '4k,cbc,innodb' w2 [ skipped ] Test requires file_key_management plugin encryption.innodb-checksum-algorithm '8k,cbc,innodb' w4 [ skipped ] Test requires file_key_management plugin encryption.innochecksum '8k,cbc,innodb,strict_crc32' w6 [ skipped ] Test requires file_key_management plugin encryption.innochecksum '16k,cbc,innodb,strict_full_crc32' w4 [ skipped ] Test requires file_key_management plugin encryption.innochecksum '4k,cbc,innodb,strict_full_crc32' w6 [ skipped ] Test requires file_key_management plugin {code} It fails only in 10.6. I debugged further to understand what went wrong. mtr tool doesn't start the server with {{file_key_management.so}}. I used the verbose command to find out what went wrong. {code} > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/have_innodb.combinations > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/suite/encryption/include/have_file_key_management_plugin.combinations > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/innodb_page_size_small.combinations > Read combinations file /home/thiru/mariarepo/10.6/10.6-test/mysql-test/include/innodb_checksum_algorithm.combinations worker[1] > mysqld_start: [' --innodb-checksum-algorithm=crc32', '--innodb-page-size=16K', '--skip-innodb-read-only-compressed', '--innodb', '--innodb-cmpmem', '--innodb-cmp-per-index', '--innodb-trx', '--innodb-locks', '--innodb-lock-waits', '--innodb-metrics', '--innodb-buffer-pool-stats', '--innodb-buffer-page', '--innodb-buffer-page-lru', '--innodb-sys-columns', '--innodb-sys-fields', '--innodb-sys-foreign', '--innodb-sys-foreign-cols', '--innodb-sys-indexes', '--innodb-sys-tables', '--innodb-sys-virtual '] {code}

Thirunarayanan Balathandayuthapani made changes - 2021-02-09 14:19

Component/s

Storage Engine - InnoDB [ 10129 ]

Thirunarayanan Balathandayuthapani made changes - 2021-02-09 14:19

Labels

affects-tests

Thirunarayanan Balathandayuthapani made changes - 2021-02-09 14:19

Component/s		Tests [ 10800 ]
Component/s	Encryption [ 11200 ]

Thirunarayanan Balathandayuthapani made changes - 2021-02-09 16:53

Assignee

Sergei Golubchik [ serg ]

Marko Mäkelä made changes - 2021-03-17 10:21

Fix Version/s		10.5 [ 23123 ]
Affects Version/s		10.5 [ 23123 ]

Sergei Golubchik made changes - 2021-05-25 12:51

Fix Version/s

10.6 [ 24028 ]

Marko Mäkelä made changes - 2021-07-02 14:25

Fix Version/s

10.6 [ 24028 ]

Julien Fritsch made changes - 2021-11-02 09:19

Priority

Major [ 3 ]

Critical [ 2 ]

Sergei Golubchik made changes - 2021-12-06 21:34

Workflow

MariaDB v3 [ 118966 ]

MariaDB v4 [ 142579 ]

Sergei Golubchik made changes - 2021-12-29 10:57

Status

Open [ 1 ]

Needs Feedback [ 10501 ]

Sergei Golubchik made changes - 2022-02-07 13:58

Status

Needs Feedback [ 10501 ]

Open [ 1 ]

Sergei Golubchik made changes - 2022-04-12 10:15

Fix Version/s		10.6.5 [ 26034 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2022-07-01 07:28

Resolution	Fixed [ 1 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Marko Mäkelä made changes - 2022-07-01 07:29

Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.7 [ 24805 ]
Fix Version/s		10.8 [ 26121 ]
Fix Version/s		10.9 [ 26905 ]
Fix Version/s		10.10 [ 27530 ]
Fix Version/s	10.6.5 [ 26034 ]

Marko Mäkelä made changes - 2022-07-01 07:50

Component/s		Platform FreeBSD [ 10139 ]
Affects Version/s		10.3 [ 22126 ]
Affects Version/s		10.4 [ 22408 ]

Sergei Golubchik made changes - 2022-10-21 15:38

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.7 [ 24805 ]
Fix Version/s	10.8 [ 26121 ]
Fix Version/s	10.9 [ 26905 ]
Fix Version/s	10.10 [ 27530 ]
Resolution		Cannot Reproduce [ 5 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Marko Mäkelä made changes - 2023-11-16 16:04

Resolution	Cannot Reproduce [ 5 ]
Status	Closed [ 6 ]	Stalled [ 10000 ]

Marko Mäkelä made changes - 2023-11-16 16:04

Fix Version/s		10.4 [ 22408 ]
Fix Version/s		10.5 [ 23123 ]
Fix Version/s		10.6 [ 24028 ]
Fix Version/s		10.11 [ 27614 ]
Fix Version/s		11.0 [ 28320 ]
Fix Version/s		11.1 [ 28549 ]
Fix Version/s		11.2 [ 28603 ]
Fix Version/s	N/A [ 14700 ]

Marko Mäkelä made changes - 2023-11-16 16:04

Affects Version/s		10.8 [ 26121 ]
Affects Version/s		10.9 [ 26905 ]
Affects Version/s		10.10 [ 27530 ]
Affects Version/s		10.11 [ 27614 ]

Marko Mäkelä made changes - 2023-11-16 16:04

Affects Version/s		11.0 [ 28320 ]
Affects Version/s		11.1 [ 28549 ]
Affects Version/s		11.2 [ 28603 ]

Julien Fritsch made changes - 2024-05-03 14:39

Fix Version/s

11.0 [ 28320 ]

Sergei Golubchik made changes - 2024-07-24 16:45

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.4 [ 22408 ]
Fix Version/s	10.5 [ 23123 ]
Fix Version/s	10.6 [ 24028 ]
Fix Version/s	10.11 [ 27614 ]
Fix Version/s	11.1 [ 28549 ]
Fix Version/s	11.2 [ 28603 ]
Resolution		Cannot Reproduce [ 5 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

People

Assignee:: Sergei Golubchik

Reporter:: Thirunarayanan Balathandayuthapani

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2021-02-09 13:08

Updated:: 2024-07-24 16:45

Resolved:: 2024-07-24 16:45

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server

Details

Description

Attachments

Activity

People

Dates

Git Integration