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
Rotated Trace files locked by engine [CORE5838] #6099
Comments
Commented by: @hvlad Could you confirm that all such files are locked by idle Firebird Classic processes ? |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: Sergey Borisov (bsv) Yes, look the screenshot. |
Modified by: Sergey Borisov (bsv)Attachment: screenshot.PNG [ 13256 ] |
Commented by: @hvlad Are you sure PID 2512 is idle ? You may check it using monitoring tables. Also, what happens with fb_trace.2018-05-31T12-11-06.log file when any audited event occurs in |
Commented by: Sergey Borisov (bsv) Yes, PID 2512 was in idle. After running query and commiting transaction on that connection (PID 2512) , the lock disappeared. |
Commented by: @hvlad Thank for confirmation |
Commented by: Sean Leyne (seanleyne) Edited to clarify issue |
Modified by: Sean Leyne (seanleyne)description: Firebird 3.0.4 Classic on Windows OS runed with system trace audit with log rotation param max_log_size = 50. => Firebird 3.0.4 Classic on Windows OS running with system trace audit with log rotation param max_log_size = 50. For many rotated files (not all) the engine still has a lock of the file, so they can not be opened for viewing. Within 6 hours we have 8 such files. summary: Trace files monopoly locked by firebird => Rotated Trace files locked by engine |
Commented by: @hvlad Fix is committed into v4. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: Can not be implemented using current fbtest package: we have no ability to restart FB during tests for turning on/off system audit. |
Submitted by: Sergey Borisov (bsv)
Attachments:
screenshot.PNG
Firebird 3.0.4 Classic on Windows OS running with system trace audit with log rotation param max_log_size = 50.
For many rotated files (not all) the engine still has a lock of the file, so they can not be opened for viewing. Within 6 hours we have 8 such files.
Commits: 27e4264
====== Test Details ======
Can not be implemented using current fbtest package: we have no ability to restart FB during tests for turning on/off system audit.
Probably will be implemented after developing additional batch scenario for this.
The text was updated successfully, but these errors were encountered: