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

Jump to bottom

Trace: provide ability to see STATEMENT RESTART events (or their count) [CORE6500] #6730

Closed
firebird-automations opened this issue Mar 1, 2021 · 2 comments
Closed

Trace: provide ability to see STATEMENT RESTART events (or their count) [CORE6500] #6730

firebird-automations opened this issue Mar 1, 2021 · 2 comments
Assignees
@hvlad
Labels
component: tracemgr fix-version: 4.0.2 fix-version: 5.0 Beta 1 priority: minor qa: covered by another tests type: improvement

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Ticket was created after discussion with Vlad.

When engine can not fetch any record for lock it starts undo, restores Tx level to RC READ CONSISTENCY and makes restart of top-level statement.
It will be useful to see this event in the trace log: either like "<timestamp> (<trace_uid>) EXECUTE_STATEMENT_RESTART" or in statistics table.
@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

hvlad added a commit that referenced this issue Jun 23, 2022
@hvlad
Improvement #6730 : Trace: provide ability to see STATEMENT RESTART e…
95b8623 
…vents (or their count) [CORE6500].

Implemented new trace event: EXECUTE_STATEMENT_RESTART.
hvlad added a commit that referenced this issue Jun 27, 2022
@hvlad
Improvement #6730 : Trace: provide ability to see STATEMENT RESTART e…
f121cd4 
…vents (or their count) [CORE6500].

Implemented new trace event: EXECUTE_STATEMENT_RESTART.
@hvlad hvlad closed this as completed Jun 27, 2022
pavel-zotov added a commit to FirebirdSQL/firebird-qa that referenced this issue Feb 27, 2023
@pavel-zotov
Added/Updated tests\functional\transactions\test_read_consist_stateme…
54909b1 
…nt_delete_undone_01.py: Added check for presense of STATEMENT RESTART in the trace (see FirebirdSQL/firebird#6730 )
@pavel-zotov
Copy link

@@@ QA issue @@@
See test functional/transactions/test_read_consist_statement_delete_undone_01.py
(it was re-implemented to check presence in the launched trace log lines about restart statement and number of times when this occurred).

Banan4iG pushed a commit to Banan4iG/firebird-qa that referenced this issue Jul 3, 2023
@red-bot
Merge remote-tracking branch 'remotes/origin/master' into sync/firebi…
f6632c0 
…rd-qa/master

* remotes/origin/master:
  Added/Updated tests\functional\transactions\test_read_consist_statement_delete_undone_01.py: Added check for presense of STATEMENT RESTART in the trace (see FirebirdSQL/firebird#6730 )
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@hvlad hvlad

Labels
component: tracemgr fix-version: 4.0.2 fix-version: 5.0 Beta 1 priority: minor qa: covered by another tests type: improvement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@hvlad @pavel-zotov @firebird-automations