Connection pool exhausted when retrying on locking table

Since 19dd3baea755 we retry to lock tables but each time with a new connection and without put back the previous one. This can exhaust the connection pool.

Indeed there is no need to get a new connection as it is rollbacked.