As per the title, after upgrading the site to 7.x-3.4 we got white pages of death. Not instantly, it would wait about 20s before stopping as a blank page.

This is on our homepage, which uses the default drupal homepage, with a couple of "Views" blocks.

This was the error from the PHP log, nothing got logged in Drupal log:

[22-Aug-2012 09:23:20 UTC] PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 2006 MySQL server has gone away' in /home/.../public_html/includes/database/database.inc:2139
Stack trace:
#0 /home/.../public_html/includes/database/database.inc(2139): PDOStatement->execute(Array)
#1 /home/.../public_html/includes/database/database.inc(664): DatabaseStatementBase->execute(Array, Array)
#2 /home/.../public_html/includes/database/database.inc(2318): DatabaseConnection->query('SELECT expire, ...', Array, Array)
#3 /home/.../public_html/includes/lock.inc(167): db_query('SELECT expire, ...', Array)
#4 /home/.../public_html/includes/lock.inc(146): lock_may_be_available('theme_registry:...')
#5 /home/.../public_html/includes/theme.inc(447): lock_acquire('theme_registry:...')
#6 /home/.../public_html/includes/bootstrap.inc(427): ThemeRegistry->set(Array)
#7 [internal function]: DrupalCacheArray->__destruct()
#8 {main}
  thrown in /home/.../public_html/includes/database/database.inc on line 2139

Clearing cache did not help, rolling back to 7.x-3.3 cured the issue.

Comments

couturier’s picture

Is this person having your same problem? http://drupal.org/node/1744950

dawehner’s picture

Well if the mysql server is away i don't think there is a specific reason caused by views.

There could be a query which hurts the server too much, but how should we know which kind of code.

MGParisi’s picture

revert back to views 3.3

alexp999’s picture

Found the problem. It's related to this:

http://drupal.org/node/1742942

On our homepage is a "Views" block which grabs Ubercart products (nodes) which have been marked as featured (simple tick box on the node edit page).

The problem was, we have over 1000 nodes, there was no limit set on the Featured Product block, so after the upgrade, as the "Is Featured Product" Filter got broken by the above bug, the query was then pulling in EVERY product on our site.

After checking through each "View" in the admin config, I found that Views was complaining about an invalid boolean operator for the featured products block, once I manually resaved it with the correct setting again (and also set a limit of 10 items incase we have the same problem again), everything was fine.

So basically, the above bug broke the filter and caused a MASSIVE query to be run, resulting in the SQL server timing out.

damiankloip’s picture

Status: Active » Closed (duplicate)