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

When kernel of remote client crashes, the connection remains established on server side #3457

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2014-03-21 09:55:29 +0100
From: @bartscheers
To: SQL devs <>
Version: 11.17.13 (Jan2014-SP1)
CC: @njnes

Last updated: 2014-05-22 09:52:34 +0200

Comment 19704

Date: 2014-03-21 09:55:29 +0100
From: @bartscheers

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:27.0) Gecko/20100101 Firefox/27.0
Build Identifier:

After the client kernel crashes or client machine is switched off by pressing power button, the original connection remains established on server side. This may cause unexpected huge growth of the sql_logs directory of the corresponding database.

Reproducible: Always

Steps to Reproduce:

  1. mclient -hmyremote.org -dmydb -ume
  2. check netstat to see established tcp connection
  3. push client's power button
  4. repeat step 2

Actual Results:

tcp 0 0 myremote.org:52000 myclient.:48421 ESTABLISHED 18707/mserver5

Expected Results:

Connection should be closed properly

Comment 19705

Date: 2014-03-23 13:45:09 +0100
From: @njnes

is this still the case after the keep alive changes?

Comment 19724

Date: 2014-03-31 12:50:51 +0200
From: @bartscheers

Yes, this works in the Jan2014 branch (hg id f3b9839c7ed6)!

Comment 19725

Date: 2014-03-31 14:05:30 +0200
From: @sjoerdmullender

I guess we can close it then.

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants