Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] R: Re: Problem with long queries - on one MSSQL server
  • Date: Tue, 25 Feb 2014 18:58:38 +0000

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

Frediano

-------- Messaggio originale --------
Da: "Thomas, Christopher (LLU)" <cwthomas AT llu.edu>
Data: 25/02/2014 18:36 (GMT+00:00)
A: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Oggetto: Re: [freetds] Problem with long queries - on one MSSQL server

In your php.ini file, set the "mssql.timeout" property to a value higher than
60

Chris

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Saturday, February 22, 2014 11:25 AM
To: freetds AT lists.ibiblio.org
Subject: Re: [freetds] Problem with long queries - on one MSSQL server

On Fri, 21 Feb 2014 20:08:49 -0800
Daryl Jones <daryl AT tcomeng.com> wrote:

> 19:44:12.359664 11900 (write.c:137):tds_put_string converting 722
...
> 19:45:12.425125 11900 (util.c:315):tdserror(0x1a21930, 0x7f2f9c1642a0,
> 20003, 0)
> 19:45:12.425307 11900 (dblib.c:7874):dbperror(0x7f2f9c163800, 20003,
> 0)
> 19:45:12.425339 11900 (dblib.c:7927):20003: "Adaptive Server
> connection timed out"
> 19:45:12.425356 11900 (dblib.c:7948):"Adaptive Server connection timed
> out", client returns 2 (INT_CANCEL)

It looks like you've set dbsettime to 60 seconds, and that your query takes
longer than that to execute. 

If you're sure the server is responding within that time, I would look for
some communication interference, perhaps a firewall. 

HTH. 

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



Archive powered by MHonArc 2.6.24.

Top of Page