[support] Druapal server fatal error: "MySQL server has gone away", but DB server is still up & accessible. Help troubleshooting?
grantksupport at operamail.com
grantksupport at operamail.com
Sat Jun 14 02:53:37 UTC 2014
On Fri, Jun 13, 2014, at 05:59 AM, Maina wrote:
> Since you adjusted the 'max_allowed_packet' make sure that you restart
> your Web Server. If you already did and still no effect, try running
> the "update.php" file of Drupal and see if that helps.
I decided to simplify matters, and take my current install out of the
equation.
Doing, instead, a completely NEW install from clean source, after a
clean/new install of MariaDB *and* it's datadir&files, I see the SAME
error:
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
here's what I've done:
which drush
/srv/www/drush/drush
cd `which drush`
git log | head
commit c75ae2dc7a40e206c210431fbfda93cc9d1c0109
Author: Moshe Weitzman <weitzman at tejasa.com>
Date: Fri Jun 13 08:39:55 2014 -0400
Fix #637. Avoid tput if TERM is 'unknown'
commit f13c2481214d787978789596b4f54fb9b9e9fdf9
Merge: fe78e58 87be1ac
Author: Jonathan Hedstrom <jhedstrom at gmail.com>
Date: Tue Jun 10 12:56:42 2014 -0700
drush --version
Drush Version : 7.0-dev
export myROOT="/srv/www"
export myPROJ="Drupal7"
export myVER="7.x"
export mySITE="Site Name"
export myMAIL="grantk at localhost"
export mySUBDIR="dev"
export myDB="dTEST01_db"
export myUSRdb="dbUSR"
export myPWDdb="dbPASS
export myUSRadm="admUSR"
export myPWDadm="admPASS"
cd ~
mysqld --version
mysqld Ver 10.0.11-MariaDB-log for Linux on x86_64 (Source
distribution)
mysqladmin --force drop ${myDB}
mysqladmin create ${myDB}
mysqlshow
+--------------------+
| Databases |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| dTEST01_db |
| test |
+--------------------+
mysql mysql
MariaDB [mysql]>
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER,
LOCK TABLES, CREATE TEMPORARY TABLES ON `dTEST01_db`.* TO
'dbUSR'@'localhost' IDENTIFIED BY 'dbPASS';
FLUSH PRIVILEGES;
quit
cd ${myROOT}/${myPROJ}
rm -rf drupal-7*
drush dl drupal
Project drupal (7.28) downloaded to
/srv/www/Drupal7/drupal-7.28. [success]
Project drupal contains:
[success]
- 3 profiles: standard, minimal, testing
- 4 themes: bartik, stark, seven, garland
- 47 modules: overlay, update, path, openid, file, contextual,
dblog, options, number, list, text,
field_sql_storage, field, php, simpletest, shortcut, taxonomy,
toolbar, search, blog, system, filter,
locale, poll, color, trigger, book, field_ui, help, aggregator,
syslog, forum, contact, menu, image,
translation, user, node, block, profile, comment, tracker,
dashboard, rdf, statistics,
drupal_system_listing_incompatible_test,
drupal_system_listing_compatible_test
cp -af drupal-7.28 ${mySUBDIR}
cd ${mySUBDIR}
cd sites/default
cp -af default.settings.php settings.php
cd ${myROOT}/${myPROJ}/${mySUBDIR}
drush -v site-install standard -y --site-name=${mySITE}
--sites-subdir=${mySUBDIR} --site-mail=${myMAIL}
--db-url=mysql://${myUSRdb}:${myPWDdb}@localhost/${myDB}
--account-name=${myUSRadm} --account-pass=${myPWDadm}
...
Initialized Drupal 7.28 root directory at /srv/www/Drupal7/dev
[notice]
Executing: mysql --defaults-extra-file=/tmp/drush_CLONbD
--database=dTEST01_db --host=localhost --silent <
/tmp/drush_SuniOM
You are about to create a sites/dev/settings.php file and DROP
all tables in your 'dTEST01_db' database. Do you want to
continue? (y/n): y
Initialized Drupal site dev at sites/dev
[notice]
Executing: mysql --defaults-extra-file=/tmp/drush_DWuUzk
--database=dTEST01_db --host=localhost --silent <
/tmp/drush_eq6aRt
Executing: mysql --defaults-extra-file=/tmp/drush_GZ4Tz2
--database=dTEST01_db --host=localhost --silent <
/tmp/drush_gF3Szb
Undefined offset: 1 site_install.drush.inc:255
[notice]
Starting Drupal installation. This takes a few seconds ...
[ok]
WD php: Warning: PDOStatement::execute(): MySQL server has gone
away in DatabaseStatementBase->execute() [warning]
(line 2171 of
/srv/www/Drupal7/dev/includes/database/database.inc).
WD php: Warning: PDOStatement::execute(): Error reading result
set's header in [warning]
DatabaseStatementBase->execute() (line 2171 of
/srv/www/Drupal7/dev/includes/database/database.inc).
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
[error]
Command dispatch complete
[notice]
checking, the mysql server is still up and accessible
mysqlshow
+--------------------+
| Databases |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| dTEST01_db |
| test |
+--------------------+
More information about the support
mailing list