Hi community,

I am working on implementing page encryption for XtraDB. Encryption itself works fine, now I am focusing on exception handling.

My problem is that whenever page encryption is misconfigured it will crash the entire server, which is no acceptable behaviour.

Example I encrypted a table with key id 42, I delete the key from the keypool thus I can no longer decrypt the table, because the appropriate key is missing.

Ideally whenever a client tries to query data from an encrypted table, which cannot be decrypted, it will receive an error message informing the client that

Table X could not be decrypted because key 42 is missing.

Can you point me out to how to accomplish such a behaviour.

Greetings

Clemens Dörrhöfer