c.o: sometimes the site crashes when we edit blog posts
I don't know if it's linked to Gutenberg, but I only see this on blog posts:
- Try to add a new blog post
- or edit an existing blog post.
The site will spin for a while, and sometimes it will crash and cause a 404 (redirect to install.php).
It causes MySQL to crash completely, resulting in a few seconds of downtime.
In the site's error.log, I see this:
2020/11/06 19:30:04 [error] 11217#11217: *23884119 FastCGI sent in stderr: "PHP message: PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php on line 79 #0 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(416): PDO->__construct('mysql:host=127....', '..', '..', Array)
#1 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(371): Drupal\Core\Database\Driver\mysql\Connection::open(Array)
#2 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(166): Drupal\Core\Database\Database::openConnection('default', 'default')
#3 [internal function]: Drupal\Core\Database\Database::getConnection('default')
#4 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php(79): call_user_func_array('Drupal\\Core\\Dat...', Array)
#5 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/Container.php(173): Drupal\Component\DependencyIn" while reading response header from upstream, client: 70.53.192.166, server: civicrm.org, request: "GET /blog/dev-team/civicrm-530-release HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "civicrm.org"
2020/11/06 19:30:04 [error] 11217#11217: *23884119 FastCGI sent in stderr: "PHP message: PDOException: SQLSTATE[HY000] [2002] Connection refused in /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php on line 79 #0 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(416): PDO->__construct('mysql:host=127....', '..', '..', Array)
#1 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(371): Drupal\Core\Database\Driver\mysql\Connection::open(Array)
#2 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Core/Database/Database.php(166): Drupal\Core\Database\Database::openConnection('default', 'default')
#3 [internal function]: Drupal\Core\Database\Database::getConnection('default')
#4 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/PhpArrayContainer.php(79): call_user_func_array('Drupal\\Core\\Dat...', Array)
#5 /var/aegir/platforms/civicrm-d8/core/lib/Drupal/Component/DependencyInjection/Container.php(173): Drupal\Component\DependencyIn" while reading response header from upstream, client: 70.53.192.166, server: civicrm.org, request: "GET /blog/dev-team/civicrm-530-release HTTP/2.0", upstream: "fastcgi://unix:/var/run/php/php7.2-fpm.sock:", host: "civicrm.org"
MySQL shows this:
MariaDB [civicrmorg]> show processlist;
+----+------------+-----------------+------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------------+-----------------+------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
| 58 | civicrmorg | localhost:57070 | civicrmorg | Query | 0 | init | show processlist | 0.000 |
| 66 | civicrmorg | localhost:57088 | civicrmorg | Query | 25 | statistics | SELECT cid, data, created, expire, serialized, tags, checksum FROM cache_entity WHERE cid IN ( 'valu | 0.000 |
+----+------------+-----------------+------------+---------+------+------------+------------------------------------------------------------------------------------------------------+----------+
2 rows in set (0.00 sec)
The query is too long to display the full version.