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

Sometimes engine may "hang" using 100% CPU load and no IO activity for the few minutes [CORE1731] #2155

Closed
firebird-automations opened this issue Feb 6, 2008 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

I have test case sent to me privately by one user. It is too big to attach it here (rar is more than 9MB).

Problem is related with precedence graph walk algorithm. Sometimes walk of this graph, performed by function CCH\writable, takes huge amount of time.
In my case i have page cache of 3000 pages and few millions of recursive calls of writable.

Commits: 326cf5b 9df233a 078f55d

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Solution is to modify precedence graph walking algoritm to mark whole sub-trees already viewed and to not walk them repeatedly

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Added 2.0.4 as fix target

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 2.0.4 [ 10211 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Added 2.1.1 as a target

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 2.1.1 [ 10223 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Cannot be tested

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment