I am trying to remove revisions from each entity type which has the revision feature via drush command. The amount of entities are quite a lot: around 10K nodes, 2k paragraphs.

On localhost everything is fine. But in the cloud the drush_print($log) successfully runs and the following error appears:

 [warning] PDO::beginTransaction(): MySQL server has gone away Connection.php:1165
 [warning] PDO::beginTransaction(): Error reading result set's header Connection.php:1165

In Connection.php line 1165:

  SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

The two environments are close to identical. Any suggestions where could I start to investigate?

  • You could do a diff on each environments php.ini and my.cnf. – leymannx Jan 14 at 14:24
  • Well here is a work around. Backup of live site, put live site in maintenance mode, import backup to local, do your clean up on local and then upload db to live site. – No Sssweat Jan 15 at 11:36
  • Additional information request. RAM size, # cores, any SSD devices on MySQL Host server? Post on pastebin.com and share the links. From SSH login root, Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; E) complete MySQLTuner report for server workload tuning analysis to provide suggestions. – Wilson Hauck Jan 15 at 18:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.