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
New connection to the server hangs [CORE6346] #6587
Comments
Commented by: @hvlad Is it reproducible ? If yes - please, provide steps to reproduce. |
Commented by: Daniel Trubač (dant) i have sent download details to you by e-mail. I do not know how to reproduce the issue. Only thing that seems weird to me, is garbage collector and its transaction, which i noticed might be running for days, can that be related? |
Commented by: Virgo Pärna (virgo) I think, that I might have had same issue (I downgraded test system back to 3.0.5). It is 32 bit version. When I upgraded it to 3.0.6, then connecting to database became slow. I was especially bad, because we have software, that in startup checks all possible databases, it can have (current configuration was 36) by connecting them and then making queries to one internal table and RDB$DATABASE and MON$DATABASE. With 3.0.5 it took 6 seconds (with only 1 database existing out of 36), but with 3.0.6 it took ages. It happened with release version (downloaded from homepage). |
Commented by: @hvlad Stack trace |
Modified by: @hvladAttachment: stack.zip [ 13470 ] |
Commented by: @hvlad The issue is related with monitoring tables, accessed from ON CONNECT trigger. |
Commented by: michalk1 (michalk1) Not sure if it is related to this issue, but I also experence serious slowness in FB 3.0.6, when compared with 3.0.5. In my case, the affected operations are The blocks last for several minutes, during which there is no obvious server activity (minimum CPU/HDD/Network load), so it looks rather like a timeout. The process eventually resumes (no error message), but the problem repeates soon after (on another blob segment or ddl command). |
Commented by: @hvlad michalk1, if you have test case - feel free to create new ticket or describe issue in fb-devel if you not sure. |
Commented by: Virgo Pärna (virgo) Ok, mine is also probably different issue, because there are not triggers. But having existing connection to database server is important fact. Wrote powershell script to test connecting databases and it stalls on connecting seventh database, that does not exist. |
Commented by: michalk1 (michalk1) I just found that my case has something to do with wire compression (I set WireCompression = true at client side). When I turn it off, 3.0.6 is back at full speed of 3.0.5. To reproduce the problem, it should be sufficient to insert a large file (say Firebird installation exe file) into any database binary blob field when wire compression is active. I'll probably open a new ticket for it. |
Commented by: Slavomir Skopalik (skopaliks) The code that we do in ON CONNECTION trigger: -- Get connection details May it will help you. PS: Will be good, if there will be a way how to get connection details out of monitoring tables. |
Commented by: @dyemanov RDB$GET_CONTEXT('SYSTEM', 'CLIENT_PROCESS') |
Commented by: Slavomir Skopalik (skopaliks) RDB$GET_CONTEXT('SYSTEM', 'CLIENT_PROCESS') is not defined in FB2.5 docs but works (on FB2.5). |
Commented by: Slavomir Skopalik (skopaliks) You are right, but documentation for FB2.5.9 says: SYSTEM namespace provides read-only access to the following variables. Variable name Value |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad The fix is committed into v3, please check next snapshot build |
Commented by: @mrotteveel @vlad will this also be ported to Firebird 4? Because I believe the problem occurs there as well. |
Commented by: @hvlad Sure |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 RC 1 [ 10930 ] Fix Version: 3.0.7 [ 10940 ] |
Submitted by: Daniel Trubač (dant)
Attachments:
stack.zip
Votes: 1
Hello,
symptoms:
established connections are working without problem, but new connection hangs, tried from .net, ibeexpert.
Please mail me if you would like to have process dump.
Please let me know if there is anything else that i could provide to help with investigation of the issue.
When it happens again, is there anything that i could try to resolve such issue without killing the process?
Thank you
Best regards
Daniel Trubač
Commits: e23273d 1f67b03
The text was updated successfully, but these errors were encountered: