Gracefully handle "MySQL server has gone away" PDOException

ThinkUpLLC / ThinkUp

ThinkUp gives you insights into your social networking activity on Twitter, Facebook, Instagram, and beyond.

http://thinkup.com

GNU General Public License v3.0

3.3k stars 675 forks source link

Gracefully handle "MySQL server has gone away" PDOException #1194

Open ginatrapani opened 12 years ago

ginatrapani commented 12 years ago

On executing a SQL query, if the PDOException "MySQL server has gone away" occurs, it usually means ThinkUp has held the database connection open longer than the server's timeout variable. The PDODAO could detect this exception and attempt to re-open the connection and retry the query once more before bubbling up the exception, which stops execution (especially during crawls).

miguelcabeza commented 12 years ago

Having the same issue as well. I can only update my personal FB and twitter accounts. No g+ o FB pages are updated. I'm using a Shared Godaddy Server.

ginatrapani commented 12 years ago

@miguelcabeza Yes, GoDaddy is known to have this problem. Here are some alternative hosts: http://thinkupapp.com/docs/install/hostingproviders.html