I am working with Drupal 7 from Commerce Kickstart 2.0. For random times thoughout the day, while I am logged in as admin for the site I will get "MySql Server has gone away" and Internal Server 500" errors. It will last from only a few minutes to upwards of an hour and then be completely fine.

Does anybody have any insight as to what could be the issue? I have been searching for quite a while to find a solution. So far I have changed my php.ini/my.cnf to increase max_allowed_packet along with a few other parameters without success. The database formats were switched to myisam per the host's requests as well.

The site was transferred from a different host and the error did not exist until after the move. WHen I can not access the site, it is still available to authenticated and anonymous users as if nothing is wrong.

Here is the error I am presented when the error occurs:

Additional uncaught exception thrown while handling exception.

Original

PDOException: SQLSTATE[70100]: <>: 1317 Query execution was interrupted: SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM {commerce_order} base INNER JOIN {commerce_order_revision} revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN (:db_condition_placeholder_0)) FOR UPDATE; Array ( [:db_condition_placeholder_0] => 9 ) in DrupalDefaultEntityController->load() (line 196 of /nfs/c06/h06/mnt/93760/domains/accuairtest.com/html/includes/entity.inc).

Additional

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:780:"SQLSTATE[70100]: <>: 1317 Query execution was interrupted: SELECT revision.order_number AS order_number, revision.revision_id AS revision_id, revision.revision_uid AS revision_uid, revision.mail AS mail, revision.status AS status, revision.log AS log, revision.revision_timestamp AS revision_timestamp, revision.revision_hostname AS revision_hostname, revision.data AS data, base.order_id AS order_id, base.type AS type, base.uid AS uid, base.created AS created, base.changed AS changed, base.hostname AS hostname FROM {commerce_order} base INNER JOIN {commerce_order_revision} revision ON revision.revision_id = base.revision_id WHERE (base.order_id IN (:db_condition_placeholder_0)) FOR UPDATE; Array ( [:db_condition_placeholder_0] => 9 ) ";s:9:"%function";s:37:"DrupalDefaultEntityController->load()";s:5:"%file";s:71:"/nfs/c06/h06/mnt/93760/domains/accuairtest.com/html/includes/entity.inc";s:5:"%line";i:196;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://accuairtest.com/ [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 72.29.182.99 [:db_insert_placeholder_9] => 1376943825 ) in dblog_watchdog() (line 160 of /nfs/c06/h06/mnt/93760/domains/accuairtest.com/html/modules/dblog/dblog.module).

Uncaught exception thrown in session handler.

PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SAVEPOINT savepoint_1; Array ( ) in _drupal_session_write() (line 209 of /nfs/c06/h06/mnt/93760/domains/accuairtest.com/html/includes/session.inc).