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 filter out info and warnings from trace log [CORE5475] #5745

Closed
firebird-automations opened this issue Feb 2, 2017 · 8 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Replaces CORE4486

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
...

Commits: 035d008 370572b 800baa6

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

> 3) errors which actually can not be fixed by application developer or DBA:
it duplicates CORE4486

Patch is committed into master (v4), please check

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue replaces CORE4486 [ CORE4486 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pavel-zotov

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.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

SImplified patch is committed into B2_5_Release (only (1) and (2) points)

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.7 [ 10770 ]

Fix Version: 3.0.2 [ 10785 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@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