Issue Details (XML | Word | Printable)

Key: CORE-5475
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Provide ability to filter out info and warnings from trace log

Created: 02/Feb/17 10:19 AM   Updated: 09/Feb/17 07:02 AM
Component/s: SVCMGR, TRACEMGR
Affects Version/s: 2.5.6, 3.0.1
Fix Version/s: 2.5.7, 3.0.2, 4.0 Alpha 1

Issue Links:
Replace
 

QA Status: Done successfully


 Description  « Hide
It will be GREAT if one may to filter out following messages from trace:

1) info:
===
2017-02-02T10:45:57.9130 (31572:00F1BFD8) TRACE_INIT
SESSION_2

2017-02-02T10:45:57.9130 (31572:00F1BFD8) TRACE_FINI
SESSION_2
===

2) warnings:
===
 2017-02-02T10:47:58.9080 (23764:00F3BFD8) WARNING AT jrd8_prepare
 ...
 335544807 : SQL warning code = 301
 335544808 : DATE data type is now called TIMESTAMP
===

3) errors which actually can not be fixed by application developer or DBA:
===
2017-02-02T10:46:24.2150 (16216:00FABFD8) ERROR AT jrd8_fetch
some_production (ATT_3103928, QWERTY:MANAGER, WIN1251, TCPv4:192.168.1.1)
335544364 : request synchronization error
===


Trace config could contain smth like:

log_info = true | false
log_warnings = true | false
...


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 05/Feb/17 09:43 AM
> 3) errors which actually can not be fixed by application developer or DBA:
it duplicates CORE-4486

Patch is committed into master (v4), please check

Pavel Zotov added a comment - 07/Feb/17 01:34 PM
All of following options:

#log_warnings = false
#include_gds_codes
#exclude_gds_codes
#log_initfini = true

-- have been verified by simple checks on WI-T4.0.0.530; it seems to me that they all work OK.
More complex test (run oltp-emul) will be done later.


Vlad Khorsun added a comment - 08/Feb/17 12:10 PM
SImplified patch is committed into B2_5_Release (only (1) and (2) points)