R: Re: Problem with long queries - on one MSSQL server
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
It's actually strange however php disconnect instead of cancelling the query Frediano -------- Messaggio originale -------- Da: "Thomas, Christopher (LLU)" <[email protected]> Data: 25/02/2014 18:36 (GMT+00:00) A: FreeTDS Development Group <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf Of James K. Lowden Sent: Saturday, February 22, 2014 11:25 AM To: [email protected] Subject: Re: [freetds] Problem with long queries - on one MSSQL server On Fri, 21 Feb 2014 20:08:49 -0800 Daryl Jones <[email protected]> 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 [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds