#20426 [Fbk->NoF]: php.exe refused to end process: can not close connection to MSSQL

ID: 20426 Updated by: sniper@php.net Reported By: ulysses@mail.fitan.com.tw -Status: Feedback +Status: No Feedback Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.2.3 New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2002-11-15 01:36:34] sniper@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip you don't need to open new reports, you can reclassify them..(and this belongs in mssql) ------------------------------------------------------------------------ [2002-11-15 01:36:03] ulysses@mail.fitan.com.tw OK, I fonud the source of this problem. It's not MSSQL lock/transaction problem, nor Windows 2000 Server/ Profession issue. It's due to i18n locallization settings. You may not be able to reproduce this cause I'm using TRADITINOAL CHINESE version of Windows 2000 Server and TRADITINOAL CHINESE version of SQL Server 2000. Thanks for not responding. You may close this topic, cause this is a re-producable crash. I'm going to raise another topic. ------------------------------------------------------------------------ [2002-11-15 01:15:23] ulysses@mail.fitan.com.tw OK, I fonud the source of this problem. It's not MSSQL lock/transaction problem, nor Windows 2000 Server/ Profession issue. It's due to i18n locallization settings. You may not be able to reproduce this cause I'm using TRADITINOAL CHINESE version of Windows 2000 Server and TRADITINOAL CHINESE version of SQL Server 2000. Thanks for not responding. You may close this topic, cause this is a re-producable crash. I'm going to raise another topic. ------------------------------------------------------------------------ [2002-11-14 21:29:32] ulysses@mail.fitan.com.tw The problem came back again. Service Pack did not fixed the problem. I'll try to reduce all unrelated code, and find out where the problem is. ------------------------------------------------------------------------ [2002-11-14 06:46:50] ulysses@mail.fitan.com.tw I'm not sure which category should this note be classified. IIS related or MS-SQL related. I'm using Windows 2000 Professional and MS-SQL 2000 Developer. Recently I switched to Windows 2000 Server. It should be 100% compatiable, but my applications now have DEADLOCK-like problems. I have one code that handles data display from SQL (when using GET) and data update (when using POST). When user POST something, this code will executing UPDATE SQL commmand and output <meta http-equiv="refresh"> HTML to redirect to it self (using GET,) so that the user would see the change. That code works properly on Windows 2000 Professional. But now PHP would crash sometimes (NOT ALWAYS!) when the browser re-enter the page after executing UPDATE. I've traced my application using lots of echo() and flush (), it DID successfully execute to the last command, but browser refused to close TCP/IP connection. I checked the server status with task manager, the php.exe hangs there for 10 minutes, and I can not stop that process by using task manager, IIS reboot or stop SQL Service. The Only effective way to stop the process is to power-off server. This crash condition only happens when I read one row from SQL server that is just updated (and committed). For example, If I have three rows that have SN=1,2,3 as primary key, and I updated row SN=2, then PHP will crash when reading the row SN=2 immediately, but it would be OK to read rows that SN=1 or 3 at the same time. This should not be the cache problem, cause I changed client to read the page, and I changed the filename of that PHP code. It appear to me that SQL server did not release row-level lock after commit transactions and close connection. When other processes try to read this row, SQL Server whould not close the connection properly, and php.exe could not end the process. This problem seemed to be fixed after installing SQL Server Service Pack 1. But I'm not sure whether will it happen again. I hope that it's just a bug in my code. But I can not explain why SOME record would work while others won't. My PHP4.23 is Windows binary installer version, and the php_mssql.dll is extracted from PHP4.23 Windows binary ZIP version. I did not install other modules. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20426&edit=1