Closed (fixed)
Project:
Drupal.org infrastructure
Component:
Servers
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
4 Nov 2013 at 23:31 UTC
Updated:
21 Aug 2014 at 21:00 UTC
Jump to comment: Most recent
While attempting to logout from my dashboard, the following occured. (logout was unsuccessful).
Additional uncaught exception thrown while handling exception.
Original
PDOException: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 110 in drupal_is_denied() (line 1915 of /var/www/drupal.org/htdocs/includes/bootstrap.inc).
Additional
PDOException: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 110 in dblog_watchdog() (line 147 of /var/www/drupal.org/htdocs/modules/dblog/dblog.module).
Comments
Comment #1
tvn commentedCan't reproduce this now. Might have been infrastructure issue.
Comment #2
andros commentedI have had the following message on this url a few minutes ago:
https://drupal.org/project/crm_core
Other urls on drupal.org worked, but this page was for minutes not loadable without this error:
Comment #3
andros commentedAlso, why is the time on each post her so different? My local time is set to Europe/Berlin (current time 11:17 am)
The issue is from: Posted by old_dog on November 5, 2013 at 12:31am
and 1#: Posted by tvn on November 5, 2013 at 10:36am
Comment #4
alan d. commentedServer appears to be getting overloaded. Occasionally the maintenance page with this error:
PDOException: SQLSTATE[00000] [1040] Too many connections in lock_may_be_available() (line 167 of /var/www/drupal.org/htdocs/includes/lock.inc).
The the above errors on others.
Managed to repeat 5 out of 8 loads 10 min ago. About 1 out of 10 loads atm
Probably related:
#2127935: Notice on issue pages - only on dev
#2127943: New D7 @ https://drupal.org/[various sites pages] are crashing on database
#2127947: Too many connections everywhere (random)
Maybe
#2125173: views_content_cache exception when posting an issue
Comment #5
cybernostra commentedSame on the drupal.org/project/biblio
Additional uncaught exception thrown while handling exception.
Original
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT base.vid AS vid, base.name AS name, base.machine_name AS machine_name, base.description AS description, base.hierarchy AS hierarchy, base.module AS module, base.weight AS weight FROM {taxonomy_vocabulary} base WHERE (base.vid IN (:db_condition_placeholder_0)) ORDER BY base.weight ASC, base.name ASC; Array ( [:db_condition_placeholder_0] => 6 ) in DrupalDefaultEntityController->load() (line 191 of /var/www/drupal.org/htdocs/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] => 146161 [: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:429:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT base.vid AS vid, base.name AS name, base.machine_name AS machine_name, base.description AS description, base.hierarchy AS hierarchy, base.module AS module, base.weight AS weight FROM {taxonomy_vocabulary} base WHERE (base.vid IN (:db_condition_placeholder_0)) ORDER BY base.weight ASC, base.name ASC; Array ( [:db_condition_placeholder_0] => 6 ) ";s:9:"%function";s:37:"DrupalDefaultEntityController->load()";s:5:"%file";s:46:"/var/www/drupal.org/htdocs/includes/entity.inc";s:5:"%line";i:191;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => https://drupal.org/project/biblio [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 88.162.242.29 [:db_insert_placeholder_9] => 1383650462 ) in dblog_watchdog() (line 160 of /var/www/drupal.org/htdocs/modules/dblog/dblog.module).
Uncaught exception thrown in session handler.
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in _drupal_session_write() (line 209 of /var/www/drupal.org/htdocs/includes/session.inc).
Comment #6
Jaggi commentedI've got a similar issue when visiting:
https://drupal.org/project/money
Get the following (probably need to turn off such detailed errors):
Comment #7
kenorb commentedThe same here:
Example URL: https://drupal.org/project/block_class
Related:
- #2127559: PDOException: SQLSTATE[HY000] [2013] Lost connection to MySQL server
- #2128027: PDO Exception on random navigation
Comment #8
one_orange_cat commentedLooks like the same issue here "General error: 2006 MySQL server has gone away..." on a number of pages for me including https://drupal.org/project/project_module. Example error included below but it does change slightly with each attempt.
My system: Chrome on Ubuntu and I have a crummy connection (3Mbps absolute max).
Comment #9
PedroMiguel commentedSame here @ https://drupal.org/project/project_module
Comment #10
lucindabeth commentedSame issue here @ https://drupal.org/project/pathauto
was receiving
, now receiving message
What is strange is that I received a PDOException:SQLSTATE[HY000]: General error 2006 on my personal site this morning, after I entered information as an authorized user (not admin). That site has been running for at least 7 months without any issues. Hosting provider just "upgraded" to different server configurations a month ago, but I had no issues at that time.
Comment #11
kenorb commentedURL: https://drupal.org/node/517742#comment-8146325
After posting the comment.
Comment #12
dddave commentedClosed a megaton of reports and made this the main issue.
Comment #13
alan d. commentedThis project have strange status workflow
Steps to replicate involve looking at these pages under high load.
Most errors suggest early bootstrap errors or errors that will block the dblog from working. This is really an issue for the infrastructure team to investigate.
Comment #14
dddave commentedUh. Thanks for correcting that. Kicking over to the infra team although I guess they are already on it.
Comment #15
killes@www.drop.org commentedThe database was overloaded due do an uncached query.
Comment #17
bassplaya commentedI get the same errors on my D7 sites like I see here above.
Could anyone point out how to resolve this issue? It's nice to know that the database was overloaded due to an uncached query but what is the real solution here?
Thanks