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

Rare segfault when preparing request working with a table with triggers [CORE5428] #5700

Closed
firebird-automations opened this issue Dec 25, 2016 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @AlexPeshkoff

This old and rarely happening bug happens when structure of a table with triggers is modified (DDL) when other attachment is preparing request working with that table. AST by itself does not cause any harm to data structures but rescan of table's metadata (which happens on any call to metadata cache for given table) drops old triggers description and creates new one. But in some cases pointers to old triggers are cached by request compiler and next use of them makes classic server process die.

Commits: 431b33b 0ca6c0d f88dded

====== Test Details ======

Significant (and artificial) slowdown in FB engine is required for reproducing this issue.
There are two tests for check FB stability while applying DDL under strong DML workload, but both of them did not produce any crash.
May be these tests will be added into fbt-repo but I will do it later (after further discuss with Alex).

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

assignee: Alexander Peshkov [ alexpeshkoff ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @AlexPeshkoff

I doubt it makes sense to have a test for this - I had to add artificial delays to cmp.cpp in order to reproduce an issue in a stable way.

@firebird-automations
Copy link
Collaborator Author

Modified by: @AlexPeshkoff

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

resolution: Fixed [ 1 ]

Fix Version: 3.0.2 [ 10785 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Fix Version: 2.5.7 [ 10770 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Cannot be tested

Test Details: Significant (and artificial) slowdown in FB engine is required for reproducing this issue.
There are two tests for check FB stability while applying DDL under strong DML workload, but both of them did not produce any crash.
May be these tests will be added into fbt-repo but I will do it later (after further discuss with Alex).

Test Specifics: [Architecture (SS/CS) specific]

@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