php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #75171 Killing long running query breaks PHP connection to MSSQL database
Submitted: 2017-09-08 00:51 UTC Modified: 2017-10-24 08:19 UTC
Votes:8
Avg. Score:4.8 ± 0.4
Reproduced:8 of 8 (100.0%)
Same Version:2 (25.0%)
Same OS:7 (87.5%)
From: ron at healthendeavors dot com Assigned:
Status: Open Package: ODBC related
PHP Version: 7.0.23 OS: Windows
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: ron at healthendeavors dot com
New email:
PHP Version: OS:

 

 [2017-09-08 00:51 UTC] ron at healthendeavors dot com
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.


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2017-09-08 00:53 UTC] ron at healthendeavors dot com
point 2: the long running query needs to be run by the PHP application.
 [2017-10-24 08:19 UTC] kalle@php.net
-Package: MSSQL related +Package: ODBC related
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Dec 13 21:01:27 2024 UTC