Framework: Automatically retry beginTransaction() when hit connection "gone away" issue

Created on 22 Jun 2015 · 5Comments · Source: laravel/framework

Noticed there is auto retry on database queries when connection lost, but not in beginTransaction(). Any reason for this discrepancy?

I am getting PDO::beginTransaction(): MySQL server has gone away error frequently in my application, so I wish it has the auto retry too.

Please advice if it is possible. Thanks.

Source

sookteng

Most helpful comment

I have tried in L5.1 with few lines of code below:

DB::connection('db');
sleep(20);  //MySQL idle timeout after 10s
DB::connection('db')->beginTransaction();

It still throw the same error like L4.2:

ERROR: exception 'ErrorException' with message 'PDO::beginTransaction(): MySQL server has gone away' in ...\vendor\laravel\framework\src\Illuminate\Database\Connection.php:491

Please advice. Thanks.

sookteng on 24 Jun 2015

👍3

All 5 comments

This should already be happening in L5.1.

GrahamCampbell on 23 Jun 2015

Can the fixes apply to L4.2 too? I am using L4.2. Thanks.

sookteng on 24 Jun 2015

@sookteng No, 4.2 is not supported anymore.

lukasgeiter on 24 Jun 2015

Noted. Thanks to all the prompt replies.

sookteng on 24 Jun 2015

I have tried in L5.1 with few lines of code below:

DB::connection('db');
sleep(20);  //MySQL idle timeout after 10s
DB::connection('db')->beginTransaction();

It still throw the same error like L4.2:

ERROR: exception 'ErrorException' with message 'PDO::beginTransaction(): MySQL server has gone away' in ...\vendor\laravel\framework\src\Illuminate\Database\Connection.php:491

Please advice. Thanks.

sookteng on 24 Jun 2015

👍3

Was this page helpful?

0 / 5 - 0 ratings