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 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 Previous Comments: ------------------------------------------------------------------------ [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=34647&edit=1