Improve error message when encrypted system tablespace is started without keyring plugin

Description

2018-09-25T11:49:57.394872Z 0 [ERROR] InnoDB: Encryption can't find master key, please check the keyring plugin is loaded **
2018-09-25T11:49:57.394883Z 0 [ERROR] InnoDB: Encryption information in datafile: ./ibdata1 can't be decrypted, please check if a keyring plugin is loaded and initialized successfully.**
2018-09-25T11:49:57.394904Z 0 [ERROR] InnoDB: Corrupted page [page id: space=0, page number=0] of datafile './ibdata1' could not be found in the doublewrite buffer.**
2018-09-25T11:49:57.394917Z 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[2099] with error Data structure corruption **
 
The corrupted page message is bit misleading because of missing keyring plugin. The purpose of the bug is to avoid this page corruption message.

Environment

None

Smart Checklist

Activity

Show:

Julia Vural March 4, 2025 at 9:03 PM

It appears that this issue is no longer being worked on, so we are closing it for housekeeping purposes. If you believe the issue still exists, please open a new ticket after confirming it's present in the latest release.

mohit.joshi September 15, 2020 at 7:30 AM
Edited

This bug is not valid anymore. Innodb system tablespace encryption needs to be enabled during bootstrap (data-directory initialisation) & also during server start. It is not a dynamic variable.

If during bootstrap, keyring parameters are not passed, then below error is seen 

2020-09-15T07:27:19.763706Z 0 [ERROR] InnoDB: Encryption can't find master key, please check the keyring plugin is loaded.
2020-09-15T07:27:19.763737Z 0 [ERROR] InnoDB: InnoDB Database creation was aborted at srv0start.cc[2449] with error Generic error. You may need to delete the ibdata1 file before trying to start up again.
2020-09-15T07:27:20.865486Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-09-15T07:27:20.865512Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-09-15T07:27:20.865522Z 0 [ERROR] Failed to initialize builtin plugins.
2020-09-15T07:27:20.865531Z 0 [ERROR] Aborting

Peter Schwaller November 27, 2018 at 1:29 PM

Not related to 8.0 GA.

roel.vandepaar September 26, 2018 at 8:13 AM

Thank you

Won't Do

Details

Assignee

Reporter

Time tracking

17m logged

Affects versions

Priority

Smart Checklist

Created September 26, 2018 at 7:33 AM
Updated March 4, 2025 at 9:03 PM
Resolved March 4, 2025 at 9:03 PM