Edit report at http://bugs.php.net/bug.php?id=34647&edit=1
ID: 34647
Comment by: bsdports at csnstores dot com
Reported by: j dot geusebroek at intellit dot nl
Summary: mssql.timeout has no affect
Status: No Feedback
Type: Bug
Package: MSSQL related
Operating System: Suse 9.3
PHP Version: 5.0.5
Assigned To: fmk
Block user comment: N
New Comment:
>From what i can tell it's not a bug in php, but in the under lying
freetds library.
For those people on Freebsd or anyone else using freetds .64 and having
problems with the timeout.
Try upgrading your freetds to the latest build.
On Freebsd (until i can get the ports updated):
uninstall php5-mssql and freetds (and/or freetds-msdblib)
then install freetds-devel, and then php5-mssql.
That should get you freetds-devel which in the ports tree is version
0.82 and the mssql.timeout functionality should start working.
Previous Comments:
------------------------------------------------------------------------
[2010-02-26 15:46:28] jaysonsantos2003 at yahoo dot com dot br
The only way to it work is setting it to a huge number.
It will ignore -1 and 0.
Edit php.ini and set mssql.timeout = 854358349583 and it will work fine.
------------------------------------------------------------------------
[2010-01-05 16:40:17] beoe at komplett dot cc
We are experiencing the same behaviour.
PHP Version 5.2.11
freetds-0.64
CentOS 5.4
If our database queries get queued, the connections will never timeout
and as a result all apache processes lock up. Has anyone found a
workaround?
------------------------------------------------------------------------
[2009-05-27 09:58:25] a dot e at inne dot pl
I think i am seeing the same issue on php 5.2.6 on Mac
Im setting timeout 60 in php.ini and 8 at runtime. Im runnig nc -l -p
4000 on localmachine and pointing mssql connection to it.
I can see its connecting and then hangs forever.
If i point mssql connect to non existing ip it fails after
connection_timeout as it should.
Is there any chance for this setting to be fixed? or any way around it?
Thanks
------------------------------------------------------------------------
[2009-04-20 21:41:48] vinsonr at gmail dot com
This is still occurring in 5.2.6. It sits there timing out:
write(1, "Running query...\n", 17Running query...
) = 17
gettimeofday({1240263244, 234960}, NULL) = 0
gettimeofday({1240263244, 234963}, NULL) = 0
select(4, NULL, [3], NULL, {5, 0}) = 1 (out [3], left {5, 0})
gettimeofday({1240263244, 235613}, NULL) = 0
sendto(3, "\1\1...@\0\0\1\0s\0e\0l\0e\0c\0t\0 \0[\0d\0a\0t\0e\0"...,
2112, MSG_NOSIGNAL, NULL, 0) = 2112
gettimeofday({1240263244, 235962}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263249, 235390}, NULL) = 0
gettimeofday({1240263249, 235490}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263254, 235491}, NULL) = 0
gettimeofday({1240263254, 235591}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263259, 235422}, NULL) = 0
gettimeofday({1240263259, 235523}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263264, 235536}, NULL) = 0
gettimeofday({1240263264, 235637}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263269, 235253}, NULL) = 0
gettimeofday({1240263269, 235354}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263274, 235997}, NULL) = 0
gettimeofday({1240263274, 236097}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263279, 236311}, NULL) = 0
gettimeofday({1240263279, 236413}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263284, 236515}, NULL) = 0
gettimeofday({1240263284, 236615}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
gettimeofday({1240263289, 236319}, NULL) = 0
gettimeofday({1240263289, 236419}, NULL) = 0
select(4, [3], NULL, NULL, {5, 0}) = 0 (Timeout)
------------------------------------------------------------------------
[2007-06-20 12:19:05] jochem dot blok at fasterforward dot nl
I also have this problem with PHP 5.2.0.
mssql.timeout is set to Local Value 60 and Master Value 60. Php doesn't
time out. I have a query which run over 60 seconds.
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/bug.php?id=34647
--
Edit this bug report at http://bugs.php.net/bug.php?id=34647&edit=1
