ID: 34647
Comment by: sarstrom at gmail dot com
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:
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
Previous Comments:
[2007-06-14 16:47:33] [EMAIL PROTECTED]
The two time out parameters is used during request startup and it will
not have any effect to change the value at runtime.
I'll look at a way to move these to the connect/query functions, but
until then you should specify these in your php.ini file.
[2007-06-13 11:30:52] sarstrom at gmail dot com
I can still reproduce this problem as of 2007-06-13.
I've tried with PHP 5.2.1 and 5.2.3, And FreeTDS is at 0.64
on a FreeBSD 6.1 install.
This code always waits the 20 seconds and tells me that everything went
according to plan
$dbLink = mssql_connect('sqldmz','sosuser','123456');
ini_set('mssql.timeout','1');
$query = WAITFOR DELAY '000:00:20' SELECT TOP 1 * FROM
tbl_serviceorder;
$res = mssql_query($query,$dbLink);
if(!$res) {
echo 'No, error, warning, timeout!';
}
else {
$row = mssql_fetch_assoc($res);
echo 'Everything is OK: '.$row['OrderNumber'];
}
/hps
[2005-11-14 01:00:03] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to Open.
[2005-11-06 23:19:58] [EMAIL PROTECTED]
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
[2005-09-26 18:51:57] j dot geusebroek at intellit dot nl
Description:
mssql.timeout has no affect, a query will wait an infinite time and the
scripts hangs.
I'm using the FreeTDS library, version 6.3 but i also tried
latest FreeTDS CVS.
FreeTDS debug file shows that a timeout has occured (i also set the
timeout in the FreeTDS client) but PHP keeps running.
(dblib.c:4010:in dbsqlok()
net.c:327:exceeded query timeout: 10
net.c:327:exceeded query timeout: 10
net.c:327:exceeded query timeout: 10
net.c:327:exceeded query timeout: 10
net.c:327:exceeded query timeout: 10
net.c:327:exceeded query timeout: 10
)
Reproduce code:
---
Perform any query that outlasts your mssql.timeout setting.
Expected result:
PHP exiting with a fatal error.
Actual result:
--
Infinite wait.
--
Edit this bug report at http://bugs.php.net/?id=34647edit=1
