Hi, Clemens! On Oct 13, Clemens Dörrhöfer wrote:

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.

Where exactly does it crash? Where do you detect that the key 42 is missing? Could you show a stack trace? Regards, Sergei