Hi @morozov
I have a question regarding this change. In our project, we use ping() to ensure the connection is not lost:

if (false === $this->ping($connection)) {
  $connection->close();
  $connection->connect();
}

Correct me if I'm wrong, but if I understand this change correctly, the difference is that the connection gets closed properly if the connection is lost. But it doesn't execute the query again, in such a case. So it only ensures that the next query succeeds again.
What is the alternative to ensure the connection is not lost due to a connection timeout, so we can safely execute our actual query?
Or is the solution to execute a dummy query and catch the ConnectionLost exception?
Even though I do agree with your reasoning above :)

Correct me if I'm wrong, but if I understand this change correctly, the difference is that the connection gets closed properly if the connection is lost. But it doesn't execute the query again, in such a case. So it only ensures that the next query succeeds again.

Sounds correct.

What is the alternative to ensure the connection is not lost due to a connection timeout, so we can safely execute our actual query?

There's no way to ensure that it's not lost. Even if the query you use to probe the connection succeeds, there's no guarantee that the real query will.

Or is the solution to execute a dummy query and catch the ConnectionLost exception?

See the above. The solution is to catch the ConnectionLost exception and handle it depending on the query. E.g. it is safe to re-execute a SELECT but isn't safe to re-execute an INSERT w/o first checking the current state of the database (the connection may fail after the row has been inserted).

@morozov thx for your reply. Makes all sense.

I catch the exception and immediately retry my SELECT query but get the same exception again.

@flmommens please file a separate issue and provide all the details of the failure. The basic case is covered with this test:

@morozov, why don't you check instanceof ConnectionException?

I think, I got it. ConnectionException is mainly thrown when credentials are invalid, so reconnecting will not help.