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

TRACE: add ability for logging ERRORs that occur in runtime (lock conflicts, PK/UK/FK violations et al) [CORE3539] #3896

Closed
firebird-automations opened this issue Jun 28, 2011 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Replaces CORE3334
Relate to DNET463

sibj.

Commits: d78703c 1bcb480

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue replaces CORE3334 [ CORE3334 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 2.5.2 [ 10450 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Component: Engine [ 10000 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

The feature is committed into v2.5.2 and will be ported forward into v3.

New trace configuration parameter is added : "log_errors". It could be used in both <database> and <services> sections.
The parameter could have boolean value "true" or "false" (default). If "log_errors"set to "true" every time user status-vector
contains error or warning corresponding event will be placed into the trace output, for example :

2012-05-03T00:02:59.9390 (3324:0000000002D0A410) UNAUTHORIZED ATTACH_DATABASE
TEST.FDB (ATT_0, SYSDBA, WIN1251, XNET:W2K3-X64)
D:\IBExpert\ibexpert.exe:3196

2012-05-03T00:02:59.9390 (3324:0000000002D0A410) ERROR AT jrd8_attach_database
TEST.FDB (ATT_0, SYSDBA, WIN1251, XNET:W2K3-X64)
D:\IBExpert\ibexpert.exe:3196
335544472 : Your user name and password are not defined. Ask your database administrator to set up a Firebird login.

or

2012-05-03T00:04:16.4080 (3324:0000000002D0A410) ERROR AT jrd8_fetch
TEST.FDB (ATT_11, SYSDBA:NONE, WIN1251, XNET:W2K3-X64)
D:\IBExpert\ibexpert.exe:3196
335544321 : arithmetic exception, numeric overflow, or string truncation
335544778 : Integer divide by zero. The code attempted to divide an integer value by an integer divisor of zero.

There are two new trace events : "ERROR" and "WARNING" followed by API entrypoint name which returns error.
Since tracing performed inside the engine (not inside y-valve or network listener) there will be "jrd8_XXX"
entrypoints names reported, not "isc_XXX" equivalents as could be expected.

Transaction (statement) is not reported as part of "ERROR" and "WARNING" events as there could be no
transaction (statement) active at the point where error is catched. Database attachment or service connection
information is reported however.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @cincuranet

Link: This issue relate to DNET463 [ DNET463 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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