Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:128774
Feedback-ID: idf69468d:Fastmail
Message-ID: <a99fa494-06f5-403c-b2bc-b68145f99fbe@allenjb.me.uk>
Date: Sat, 4 Oct 2025 17:34:11 +0100
Precedence: list
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: [PHP-DEV] [Discuss] Add PDO disconnect() and isConnected()
To: Kamil Tekiela <tekiela246@gmail.com>, Robert Wolf <rposky@gmail.com>
Cc: Claude Pache <claude.pache@gmail.com>,
 PHP internals <internals@lists.php.net>
References: <CANdUeaZhn-8b2+LZDV3UnT1sx+BVFcz=m7neQHyv7huGega+_Q@mail.gmail.com>
 <CE73D727-9546-469F-A723-FE667CA4061D@gmail.com>
 <CANdUeaZ0u-BmdUuX9XD--H2CA0zys+J8j5Cem4YQd2Q555m9Vw@mail.gmail.com>
 <CAGBsUrftu_-XfQQhKpBM_YJp_VOJJ1FyWNi+1wqZ+77q4LQSiQ@mail.gmail.com>
 <7b1f853f-1bb0-4d84-975b-164a71e092cc@allenjb.me.uk>
Content-Language: en-US
In-Reply-To: <7b1f853f-1bb0-4d84-975b-164a71e092cc@allenjb.me.uk>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
From: php.lists@allenjb.me.uk (AllenJB)

On 01/10/2025 15:45, AllenJB wrote:
> As an aside, the manual is unclear on how much management of 
> persistent connections PDO does. I have an open issue on this: 
> https://github.com/php/doc-en/issues/4540
>
> (I did have a brief look again and based on some further investigation 
> I did based (initially) on the answer thecotne gave in the above 
> linked issue, believe that answer may not be accurate, at least in its 
> reasoning, and thus their conclusion is circumspect. Looking at this 
> again is somewhere on my todo list, I think)

An update: Based on testing, PDO (MySQL) does not perform cleanup of 
state of persistent connections - this means transactions, temporary 
tables, locks and other stateful changes may remain, causing the 
connection to be in an unexpected state.

For details of my test see 
https://github.com/php/doc-en/issues/4540#issuecomment-3368381887

In my opinion, this makes a method of forcing a (persistent) connection 
closed explicitly useful.