Daemonizable Command Mysql Problem

[ghost]

im using the daemonizable command bundle to read my queue's data, and use doctrine2 to persist to databases, but when run a long time, i got a exception "MySQL server has gone away". i found some information in google, it seem is the mysql connect timeout issue. So i want konw do you has some solutions to solve this problem?

[Donjohn]

in the long command process, try catch the exception (DBAL one) and then create a reconnect function in your entity manager extended class.

public function reConnect($force=false)
{

    if (!$this->em->getConnection()->isConnected() || $force) {
        $this->em->getConnection()->close();
        $this->em->getConnection()->connect();
    }

    if (!$this->em->isOpen()) {
        $this->em = $this->em->create(
            $this->em->getConnection(),
            $this->em->getConfiguration()
        );
    }
}

[velikanov]

+1, you need to do it by hand

[mac-cain13]

Yes indeed, you need to check if the connection is still alive since it will time out and reconnect if needed.