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
Server crashes while compiling a stored procedure being in use [CORE3524] #3881
Comments
Commented by: Jesus Angel Garcia Zarco (cointec) I have now a test case To reproduce the error |
Commented by: @hvlad So why don't provide test case here ? |
Commented by: Jesus Angel Garcia Zarco (cointec) Application to reproduce the error in two steps |
Modified by: Jesus Angel Garcia Zarco (cointec)Attachment: fbcrash1.rar [ 11969 ] |
Commented by: Jesus Angel Garcia Zarco (cointec) Database Part 1 |
Modified by: Jesus Angel Garcia Zarco (cointec)Attachment: FBCRASHDB.part01.rar [ 11970 ] |
Commented by: Jesus Angel Garcia Zarco (cointec) Database part 2 |
Modified by: Jesus Angel Garcia Zarco (cointec)Attachment: FBCRASHDB.part02.rar [ 11971 ] |
Commented by: Jesus Angel Garcia Zarco (cointec) Open the application The database is 2.1.4, but opening from 2.5 also crash. |
Modified by: Jesus Angel Garcia Zarco (cointec)Version: 2.1.4 [ 10361 ] |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad Reproduced, looking into |
Commented by: Jesus Angel Garcia Zarco (cointec) I open the same bug in CORE3513, but because i did not see any action, i clone one issue i reported in December, then there is a duplicate. |
Commented by: @hvlad The call stack is > fbserver.exe!TRA_detach_request(Jrd::jrd_req * request=0x09ad0018) Line 159 + 0x32 bytes C++ And the crash happens here : void TRA_detach_request(Jrd::jrd_req* request)
Note, fb_assert is triggered in DEBUG build and request->req_tra_next points to already deallocated request. Research shows that deallocated request is clone of the trigger request and this "main" trigger request was The problem is that TRA_detach_request (usually called by EXE_unwind) was not called for clone and main The simples solution is to call EXE_unwind for all clones before deallocation of main request and its memory pool |
Commented by: @hvlad Fix is committed into 2.5.1 and 2.1.5 branches. v3 is not affected. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5.1 [ 10333 ] Fix Version: 2.1.5 [ 10420 ] |
Commented by: @hvlad > I open the same bug in CORE3513, but because i did not see any action, i clone one issue i reported in December, then there is a duplicate. It is strange that i missed CORE3513... I closed it as duplicate. Next time when you see no reaction in your ticket, please, ask in tracker and then in fb-devel, but don't clone tickets. |
Modified by: @dyemanovsummary: Compiling stored procedure while in use shutdown database => Server crashes while compiling a stored procedure being in use |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: Jesus Angel Garcia Zarco (cointec)
Is duplicated by CORE3513
Attachments:
fbcrash1.rar
FBCRASHDB.part01.rar
FBCRASHDB.part02.rar
Our database has one stored procedure called from 2 triggers. Today doing something that has been done before without problem, that is compile one stored procedure while others users connected to the database, and recompiling the two triggers that calls the stored procedure makes the server crash. I have done the process 2 times. First i have recompiled the stored procedure and the two triggers and 7 minutes after i have done the process again. After the second time, the database has been sutted down, when compiling the triggers that calls the stored procedure.
This is the firebird log file.
SVD13SL03 (Server) Mon Dec 13 13:02:07 2010
Modifying procedure PET_FORMULA_CALC_RESULTADO which is currently in use by active user requests
SVD13SL03 (Server) Mon Dec 13 13:09:51 2010
Modifying procedure PET_FORMULA_CALC_RESULTADO which is currently in use by active user requests
SVD13SL03 (Client) Mon Dec 13 13:10:02 2010
"C:\Archivos de programa\Firebird\Firebird_2_5\bin\fbserver.exe": terminated abnormally (4294967295)
SVD13SL03 (Client) Mon Dec 13 13:10:07 2010
Guardian starting: "C:\Archivos de programa\Firebird\Firebird_2_5\bin\fbserver.exe"
SVD13SL03 (Client) Mon Dec 13 13:10:09 2010
INET/inet_error: send errno = 10054
SVD13SL03 (Client) Mon Dec 13 13:11:00 2010
INET/inet_error: send errno = 10054
SVD13SL03 (Client) Mon Dec 13 13:11:00 2010
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
SVD13SL03 (Client) Mon Dec 13 13:11:59 2010
REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
Uncommitted work may have been lost
Commits: b3cc1c2 86a63f7
The text was updated successfully, but these errors were encountered: