Hey there, I have a PHP daemon set up to manage requests from RabbitMQ.
However, after running for a day, it stops functioning due to encountering the error "MySQL has gone away."
PHP Warning: PDOStatement::execute(): MySQL server has gone away in /var/www/daemon/www/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Pdo/Statement.php on line 239
PHP Warning: PDOStatement::execute(): Error reading result set\'s header in /var/www/daemon/www/vendor/zendframework/zendframework/library/Zend/Db/Adapter/Driver/Pdo/Statement.php on line 239
I opted not to use Doctrine and instead passed my \Zend\Db\Adapter\Adapter to a database wrapper class with the following function:
public static function executeScalar($statement, $parameters, \Zend\Db\Adapter\Adapter $dbAdapter)
{
// Function code here...
}
The `DbResult` is a custom class that wraps database results to check for errors, empty results, row count, etc.
Shown below is my `database.local.php` configuration file:
return array(
'service_manager' => array(
'factories' => array(
'mysql' => function ($sm)
{
return new Zend\Db\Adapter\Adapter(array(
// Database configurations here...
));
},
)
)
)
Whenever I need to execute SQL queries, I follow this pattern within my controller or other classes:
$service = $this->getServiceLocator();
$dbAdapter = $service->get('mysql');
$get = \Db\Database::executeScalar('SELECT * FROM mytable WHERE id <= ?', array(10), $dbAdapter);
Unfortunately, I am unable to catch the warning messages. Is there a way to force reconnect or should I disconnect after each request?
Would the following strategy work to handle the error?
$dbAdapter->getDriver()->getConnection()->connect();
At the end of the request, would this be sufficient?
$dbAdapter->getDriver()->getConnection()->disconnect();