I had added this to another issue regarding user profiles yesterday, but I think it is different enough to warrant a separate post

My Commons site is on an Aegir-Barracuda server running multiple other sites (no other issues and only the one Commons site for now). The only modules I've added, if I remember correctly, are og_mailinglist and leaguesite, and there has been very little modification of the site other than to mess around with the Commons functionality.

I was having trouble adding cached images to a view, so I was examining the image cache profiles for both leaguesite and Commons...next thing I know the site is no longer pulling info from the database. When I try to access the database in chive, I get the following error:

CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query.

If I go into php-fpm-slow.log, I see the following, which seems odd, but I can't work it out:

Nov 17 08:34:29.038128 pid 9271 (pool default)
script_filename = /data/disk/octopus/distro/001/drupal_commons-6.x-1.1/index.php
[0xbfe318cc] mysqli_query() /data/all/001/drupal_commons-6.x-1.1/includes/database.mysqli.inc:114
[0xbfe31c3c] _db_query() /data/all/001/drupal_commons-6.x-1.1/includes/database.mysql-common.inc:42
[0xbfe321ec] db_query() /data/all/001/drupal_commons-6.x-1.1/includes/cache.inc:26
[0xbfe326ac] cache_get() /data/all/001/drupal_commons-6.x-1.1/profiles/drupal_commons/modules/contrib/strongarm/strongarm.module:24
[0xbfe3297c] strongarm_set_conf() /data/all/001/drupal_commons-6.x-1.1/profiles/drupal_commons/modules/contrib/strongarm/strongarm.module:8
[0xbfe32b18] strongarm_init() unknown:0
[0xbfe32fcc] call_user_func_array() /data/all/001/drupal_commons-6.x-1.1/includes/module.inc:483
[0xbfe334ac] module_invoke_all() /data/all/001/drupal_commons-6.x-1.1/includes/common.inc:2654
[0xbfe33eec] _drupal_bootstrap_full() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:1555
[0xbfe341fc] _drupal_bootstrap() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:1412
[0xbfe3459c] drupal_bootstrap() /data/all/001/drupal_commons-6.x-1.1/index.php:16

Nov 17 08:47:46.416059 pid 11933 (pool default)
script_filename = /data/disk/octopus/distro/001/drupal_commons-6.x-1.1/index.php
[0xbfe2dffc] sleep() /data/all/001/drupal_commons-6.x-1.1/includes/lock.inc:188
[0xbfe2e50c] lock_wait() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:578
[0xbfe2ea1c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe2ef2c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe2f43c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe2f94c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe2fe5c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3036c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3087c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe30d8c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3129c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe317ac] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe31cbc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe321cc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe326dc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe32bec] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe330fc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3360c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe33b1c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3402c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585

Nov 17 08:52:03.235708 pid 11063 (pool default)
script_filename = /data/disk/octopus/distro/001/drupal_commons-6.x-1.1/index.php
[0xbfe2f94c] sleep() /data/all/001/drupal_commons-6.x-1.1/includes/lock.inc:188
[0xbfe2fe5c] lock_wait() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:578
[0xbfe3036c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3087c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe30d8c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3129c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe317ac] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe31cbc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe321cc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe326dc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe32bec] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe330fc] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3360c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe33b1c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3402c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3453c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe34a4c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe34f5c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3546c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585
[0xbfe3597c] variable_init() /data/all/001/drupal_commons-6.x-1.1/includes/bootstrap.inc:585

I can log into the database from the command line, but I lose the connection as soon as I try to view a table. As I said, I don't really have anything of value in the site right now, but before I trash it, want to make sure I understand why this actually happened, since I will be running these same modules again.

Comments

mstef’s picture

mstef CreditAttribution: mstef commented
Status: Active » Postponed

Sorry, but I cannot help with anything Aegir-related.

Perhaps someone else can?

ezra-g’s picture

ezra-g CreditAttribution: ezra-g commented
Category: bug » support
Priority: Critical » Normal
Status: Postponed » Closed (cannot reproduce)

If you're unable to access the database via the command line, this suggests a server-level problem.

It's been ~7 months since this issue was filed. I'm marking this as "cannot reproduce" but if you are able to reproduce on a fresh install, please post reproduction steps here so that someone can replicate and try to address this.