ID: 34647
Comment by: jaysonsantos2003 at yahoo dot com dot br
Reported By: j dot geusebroek at intellit dot nl
Status: No Feedback
Bug Type: MSSQL related
Operating System: Suse 9.3
PHP Version: 5.0.5
Assigned To: fmk
New Comment:
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.
Previous Comments:
------------------------------------------------------------------------
[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.
------------------------------------------------------------------------
[2007-06-15 11:36:39] sarstrom at gmail dot com
I'm sorry, but setting the timeouts in php.ini doesn't help either.
phpinfo() confirms that the limit is set to 1 second, but it waits an
infinite amount of time for the query to finish!
Deliberatly making a self-join-query will lock up one php-thread
forever, after all threads are locked up, the webserver won't answer any
further requests.
/hps
------------------------------------------------------------------------
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/34647
--
Edit this bug report at http://bugs.php.net/?id=34647&edit=1
