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-issue-importer opened this issue Apr 14, 2019 · 5 comments
Closed

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 14, 2019

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 5, 2019

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 5, 2019

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 2 [ 10888 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 6, 2019

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 6, 2019

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants