Catch "Warning: mysqli::mysqli() [mysqli.mysqli]: MySQL server has gone away" to write error nicely

Question

Where and how to write a code that will check if error showing "MySQL server has gone away" appears and print some error diferently and more nicely.

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

Possible duplicate of: http://stackoverflow.com/questions/8689649/solving-mysql-server-has-gone-away-errors/8689738 — Aimon Bustardo, Nov 23 '12 at 08:46

score 1 · Accepted Answer · edited May 23 '17 at 12:04

1

There is another post that answers this (Solving "MySQL server has gone away" errors) with the following code snippet:

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;
  }
}

edited May 23 '17 at 12:04

Community

1
1

answered Nov 23 '12 at 07:51

Aimon Bustardo

158
1
7

perhaps you should link directly to [the answer](http://stackoverflow.com/a/8689738/499214) instead of the question – John Dvorak Nov 23 '12 at 07:55
or better yet link the question as a duplicate through a question comment. – John Dvorak Nov 23 '12 at 07:56
WHat is proper way to link dupes? – Aimon Bustardo Nov 23 '12 at 08:01
"Possible duplicate of [link]" or anything similar – John Dvorak Nov 23 '12 at 08:02
Thx Jan for the helpful netiquette advice. – Aimon Bustardo Nov 23 '12 at 08:49

Catch "Warning: mysqli::mysqli() [mysqli.mysqli]: MySQL server has gone away" to write error nicely

1 Answers1