Bug #75171 [NEW]: Killing long running query breaks PHP connection to MSSQL database

From: ron at healthendeavors dot com Operating system: Windows PHP version: 7.0.23 Package: MSSQL related Bug Type: Bug Bug description:Killing long running query breaks PHP connection to MSSQL database Description: ------------ 1. Have you PHP application up and running and connected to database 2. create a long running query that can be seen in SMSS. 3. Query can be seen doing a whois: execute sp_whoisactive 4. Do a Kill command on the long running query: kill (spid) 5. go back to your PHP application and you will get a '[Microsoft][ODBC Driver 13 for SQL Server]Communication link failure' 6. If you go to windows event viewer and look in administrative events you will see 'Session recovery feature data used in login record to open or recover a connection is structurally or semantically invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>]' Expected result: ---------------- I would expect that a problematic query could be killed without interruption to the application as a whole. -- Edit bug report at https://bugs.php.net/bug.php?id=75171&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=75171&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=75171&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=75171&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=75171&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=75171&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=75171&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=75171&r=needscript Try newer version: https://bugs.php.net/fix.php?id=75171&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=75171&r=support Expected behavior: https://bugs.php.net/fix.php?id=75171&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=75171&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=75171&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=75171&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=75171&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=75171&r=dst IIS Stability: https://bugs.php.net/fix.php?id=75171&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=75171&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=75171&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=75171&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=75171&r=mysqlcfg