On a Drupal 6.10 install with views 6.x-2.3 the site went down experiencing MySQL timeouts (Fatal error: Maximum execution time of 45 seconds exceeded) resulting in a "Warning: MySQL server has gone away query:" error.

This issue was resolved by emptying the views object cache table.

I'm not sure if this goes here but I hope it helps someone avoid a lengthy troubleshooting session.

Comments

niccottrell’s picture

niccottrell CreditAttribution: niccottrell commented

I had similar issues and clearing this table didn't help. I finally worked out that the Views UI had corrupted some config during a save and this was causing some endless loop in the code. I had to restore all views_XXX tables from the previous day's backup to get the site back online again. (The bad view was included as block on every page so affected the whole site). Hope this helps someone else!