freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] R: Re: Problem with long queries - on one MSSQL server

From: Peter Deacon <peterd AT iea-software.com>
To: Frediano Ziglio <freddy77 AT gmail.com>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] R: Re: Problem with long queries - on one MSSQL server
Date: Tue, 25 Feb 2014 11:26:40 -0800 (Pacific Standard Time)

On Tue, 25 Feb 2014, Frediano Ziglio wrote:

It's actually strange however php disconnect instead of cancelling the query

Yea, I emailed Daryl off list and he managed to get it working.

Some clues 60 seconds is the default TCP retry timeout and payload packet size 1444 bytes is close to normal MSS for 1500 MTU. Most likely the send was never going thru to the peer and the TCP session timed out.

Think this is most likely related to configuring firewalls and networks where all of the following are true:

- Filtering non-initial IP layer fragments
- Disabling Path MTU discovery
- MTU gets reduced somewhere on path

regards,
Peter

[freetds] R: Re: Problem with long queries - on one MSSQL server, Frediano Ziglio, 02/25/2014
- Re: [freetds] R: Re: Problem with long queries - on one MSSQL server, Peter Deacon, 02/25/2014