shabbyrobe/pdok

Just like PDO, but with fewer annoyances

pdok's Issues

MySQL server has gone away

PDOK should provide an option to handle "MySQL server has gone away".

Discussion started here: shabbyrobe/amiss#21

Fix supplied by @dig412:

const MYSQL_SERVER_GONE_ERROR = 2006;
//..snip...
try {
    return call_user_func_array(array($pdo, 'query'), $args);
} catch (\PDOException $e) {
    $mysqlErrorCode = isset($e->errorInfo[1]) ? (int) $e->errorInfo[1] : null;

    switch ($mysqlErrorCode) {
        case self::MYSQL_SERVER_GONE_ERROR:
            //Catch "server has gone away" error, reconnect and retry.
            //Even though the error mode is set to "Exception", pdo will log an error
            //See https://bugs.php.net/bug.php?id=63812
            $this->disconnect();
            $this->connect();
            return call_user_func_array(array($this, 'query'), $args);
            break;

        default:
            throw $e;
            break;
    }
}

I'd like to establish some tests around the failure modes before I include this in there, which will be pretty tricky to do but I need to be certain that it's totally impossible for non-idempotent queries to double up. Have you ever seen such a thing?