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 hangs when compiling big package with error [CORE6068] #6318
Comments
Commented by: Maxim Kuzmin (cybermax) Package for test case - PKG$PAYMENT$BANK_STTM. |
Modified by: Maxim Kuzmin (cybermax)Attachment: database.zip [ 13352 ] |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 2 [ 10888 ] |
Commented by: @pavel-zotov I can not confirm that problem was fixed; rather, it still exists (just checked on WI-V3.0.5.33139 Firebird 3.0). Please download results from here: https://drive.google.com/drive/u/2/folders/1se_wkUh90_sX7lkyIqBIOeJCWwrLiOII There are following files: 1) c6068-database.sql.check_commented_line_No_3359.7z -- .SQL script which was provided by ticket author and adapted by me for running in ISQL. One need to adjust path to test DB in this script:SET SQL DIALECT 3;
|
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Deferred Test Details: Checked on WI-V3.0.5.33139 Firebird 3.0 -- bug was not fixed. |
Commented by: @asfernandes > Fix Version/s: 4.0 Beta 2 You tested master or v3? From your path, v3. I said in fb-devel that backport will be done later. |
Commented by: @pavel-zotov Ooops... :-[ Sorry for noise. Yes - i did use 3.x and did not pay attention that it was not fixed yet. ===
|
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Deferred => Done successfully Test Details: Checked on WI-V3.0.5.33139 Firebird 3.0 -- bug was not fixed. => |
Modified by: @asfernandesFix Version: 3.0.5 [ 10885 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Maxim Kuzmin (cybermax)
Attachments:
database.zip
We have a package with several procedures and functions. If text of body have a problem (in my case no END), Firebird utilize 100% CPU and hangs for many minutes. If step by step to empty body of procedures and functions, time of hangs decreased down to instant response.
If in another connection execute SELECT * FROM MON$ATTACHMENTS, connection also hangs, and server never again normal work.
In attachment - script for create database with example of hangs.
Commits: 04deca3 8e228e9
The text was updated successfully, but these errors were encountered: