doctrine fix mysql server gone away

doctrine_mysql_server_gone_away.php

try {
	$this->em->getConnection()->fetchAll("select * from tbl where id=1");
	sleep(30); // set this bigger than mysql wait_timeout
	$this->em->getConnection()->fetchAll("select * from tbl where id=2"); // and then you will see mysql has gone away here
} catch (DBALException $exception) { // don't worry, let's catch this exception and reconnect to mysql
	if (false !== strpos($exception->getPrevious()->getMessage(), 'server has gone away')) {
		$this->em->getConnection()->close();
		$this->em->getConnection()->->connect();
		
		// or use $this->container->get('doctrine.orm.entity_manager') if you don't have $this->em

		// redo job
		$this->em->getConnection()->fetchAll("select * from tbl where id=2");
	}
}