Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Provide ability to see current state of DB encryption [CORE6048] #6298

Closed
firebird-automations opened this issue Apr 14, 2019 · 5 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

It will be good to obtain current state of encryption / decryption process or its result (finished / not started), either via RDB$GET_CONTEXT() or using new field in MON$DATABASE table.
Returned data must contain "kind" of process that currently is going (i.e. ENCryption or DECryption) and percent of its progress.
Perhaps, one can use positive number for encryption, negative for decryption and zero when there is no activity related to this.

Commits: ee4c8f2 76088c2

====== Test Details ======

Test checks presense on mon$database.mon$crypt_state column and its changing when DB is encrypted / decrypted.
Changes of mon$crypt_page column are not watched because this requires large DB and relatively slow CPU to be seen.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

Added mon$crypt_state field with values as documented in README.monitoring_tables. Field mon$crypt_page, returning currently processed page (0 when no encryption/decryption in progress) is present since 3.0. Using it and MON$PAGES field percent calculation is trivial.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 2 [ 10888 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

Test Details: Test checks presense on mon$database.mon$crypt_state column and its changing when DB is encrypted / decrypted.
Changes of mon$crypt_page column are not watched because this requires large DB and relatively slow CPU to be seen.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants