捕捉"Warning: mysqli::mysqli() [mysqli.mysqli]：MySQL服务器已消失“来很好地写入错误

Question

在哪里以及如何编写代码来检查显示"MySQL服务器已经消失“的错误是否出现，并以不同的方式更好地打印一些错误。

Warning: mysqli::mysqli() [mysqli.mysqli]: MySQL server has gone away

Answer 1

还有另一篇文章(Solving "MySQL server has gone away" errors)用以下代码片段回答了这个问题：

try {
  $conn = getDbConn();
  saveData($conn, $val);
} catch (DbException $e) {
  if (strstr($e->getMessage(), 'MySQL server has gone away') {
    // WRITE OUT NICE LOG HERE AND RETRY IF WANTED
    ....
    // RETRY
    $conn = getDbConn();
    saveData($conn, $val);
  } else {
    // we have a problem connecting or something, pass the exception along
    throw $e;
  }
}