First of all, thanks so much for your recent attention and efforts to get this project back on track. I have been eagerly waiting for this module.

We're on Drupal 8.5.4, PHP 7.0.30, with 512M memory in a Pantheon instance and added Business Rules dev, and Dbug as instructed. Upon clicking Save on my first adding an action, the site goes back to the install.php screen. The following message was found in the watchdog:

Warning: Error while sending QUERY packet. PID=26379 in Drupal\Core\Database\Statement->execute() (line 59 of /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Statement.php) #0 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/includes/bootstrap.inc(582): _drupal_error_handler_real(2, 'Error while sen...', '/srv/bindings/9...', 59, Array) #1 [internal function]: _drupal_error_handler(2, 'Error while sen...', '/srv/bindings/9...', 59, Array) #2 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Statement.php(59): PDOStatement->execute(Array) #3 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Connection.php(625): Drupal\Core\Database\Statement->execute(Array, Array) #4 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87): Drupal\Core\Database\Connection->query('SELECT 1 FROM {...', Array, Array) #5 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(216): Drupal\Core\Database\Driver\mysql\Connection->query('SELECT 1 FROM {...', Array, Array) #6 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php(642): Drupal\Core\Database\Driver\mysql\Connection->queryRange('SELECT 1 FROM {...', 0, 1) #7 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Installer/InstallerRedirectTrait.php(75): Drupal\Core\Database\Driver\mysql\Schema->tableExists('sessions') #8 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/EventSubscriber/ExceptionDetectNeedsInstallSubscriber.php(43): Drupal\Core\EventSubscriber\ExceptionDetectNeedsInstallSubscriber->shouldRedirectToInstaller(Object(Drupal\Core\Database\DatabaseExceptionWrapper), Object(Drupal\Core\Database\Driver\mysql\Connection)) #9 [internal function]: Drupal\Core\EventSubscriber\ExceptionDetectNeedsInstallSubscriber->onException(Object(Symfony\Component\HttpKernel\Event\GetResponseForExceptionEvent), 'kernel.exceptio...', Object(Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher)) #10 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Component/EventDispatcher/ContainerAwareEventDispatcher.php(111): call_user_func(Array, Object(Symfony\Component\HttpKernel\Event\GetResponseForExceptionEvent), 'kernel.exceptio...', Object(Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher)) #11 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/vendor/symfony/http-kernel/HttpKernel.php(228): Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.exceptio...', Object(Symfony\Component\HttpKernel\Event\GetResponseForExceptionEvent)) #12 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/vendor/symfony/http-kernel/HttpKernel.php(79): Symfony\Component\HttpKernel\HttpKernel->handleException(Object(Drupal\Core\Database\DatabaseExceptionWrapper), Object(Symfony\Component\HttpFoundation\Request), 1) #13 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/StackMiddleware/Session.php(57): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(47): Drupal\Core\StackMiddleware\Session->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/modules/page_cache/src/StackMiddleware/PageCache.php(99): Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/modules/page_cache/src/StackMiddleware/PageCache.php(78): Drupal\page_cache\StackMiddleware\PageCache->pass(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/modules/jsonapi/src/StackMiddleware/FormatSetter.php(41): Drupal\page_cache\StackMiddleware\PageCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(47): Drupal\jsonapi\StackMiddleware\FormatSetter->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(52): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/vendor/stack/builder/src/Stack/StackedHttpKernel.php(23): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/DrupalKernel.php(666): Stack\StackedHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/index.php(19): Drupal\Core\DrupalKernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main}.

If there anything else I can provide to make troubleshooting easier, please feel free.

Comments

jeppy64 created an issue. See original summary.

yseki’s picture

yseki commented

Hi @jeppy64,

Thanks for your feedback.
I've never seen this behavior before with BR. Unfortunately, the error description is too much truncated on your post and I could not dig in anything that could help me to understand what had happened. So, let's do some trivial debug. Here are my questions:

1. Is it a with other contrib or custom module installed?
2. Which action have you created? The action itself is not executed if it's not triggered by an event (registered and active rule).
3. Are your webserver logging the errors? If yes we can dig there as well.

jeppy64’s picture

jeppy64 commented

Hi @Yuriseki,

This is for a higher education ecosystem, so there is one "main" site and 21 individual sub domains. Using Pantheon's shared upstream, the codebase is available to any site in the ecosystem. There are zero custom modules. All of the sites have been in the wild for almost a full year.

So with no other BR's, actions, conditions etc, upon trying to add an action of "Show A Message" and clicking the Save button, is when the site redirects to install.php

We did try to use BR very early on in the life of BR and we did encounter issues which lead us to postpone using it. Back then, I suspected that the token tree and memory may have had something to do with the issues. I'm not sure on that as I am not a qualified module developer, but it was just a guess.

The following is from the Pantheon dashboard error tracking after the site goes to install.php:

Uncaught PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away in /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Statement.php:59 Stack trace: #0 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Statement.php(59): PDOStatement->execute(Array) #1 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Connection.php(625): Drupal\Core\Database\Statement->execute(Array, Array) #2 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87): Drupal\Core\Database\Connection->query('DELETE FROM {ke...', Array, Array) #3 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/Database/Query/Delete.php(55): Drupal\Core\Database\Driver\mysql\Connection->query('DELETE FROM {ke...', Array, Array) #4 /srv/bindings/9b8eddfa734c42aeaeb95c696d95c307/code/core/lib/Drupal/Core/KeyValueStore/DatabaseStorage.php(165): Dcore/lib/Drupal/Core/Database/Connection.php:686Invalid date

Does this offer any help in troubleshooting?

yseki’s picture

yseki commented

This error seems to be related to MySQL memory.

It's possible to you to check and if its the case, increase the max_allowed_packet attribute (possibly on /etc/mysql/my.cnf or /etc/mysql/mysql.conf.d/mysqld.cnf or the right location, depending on your installation). The minimun recomended is 16MB.

After that, you need to restart the MySQL service

sudo service mysqld restart

Then please, let me know if it worked.

See https://www.drupal.org/node/259580 and here

yseki’s picture

yseki commented
Status: Active » Postponed (maintainer needs more info)
markdc’s picture

markdc
Location Selters
commented

Having the same issue using 1.0-alpha19+3-dev. Adding any kind of action, condition or variable redirects to install.php.
Like @jeppy64, we are also working in a multi-domain environment.

Config:
Drupal 8.5.5
PHP 7.0.30
MySQL 5.7.22
Commerce Kickstarter
Domain Access

Log:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: CREATE TABLE {cache_bootstrap} ( `cid` VARCHAR(255) BINARY CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '' COMMENT 'Primary Key: Unique cache ID.', `data` LONGBLOB NULL DEFAULT NULL COMMENT 'A collection of data to cache.', `expire` INT NOT NULL DEFAULT 0 COMMENT 'A Unix timestamp indicating when the cache entry should expire, or -1 for never.', `created` DECIMAL(14, 3) NOT NULL DEFAULT 0 COMMENT 'A timestamp with millisecond precision indicating when the cache entry was created.', `serialized` SMALLINT NOT NULL DEFAULT 0 COMMENT 'A flag to indicate whether content is serialized (1) or not (0).', `tags` LONGTEXT NULL DEFAULT NULL COMMENT 'Space-separated list of cache tags for this entry.', `checksum` VARCHAR(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The tag invalidation checksum when this entry was saved.', PRIMARY KEY (`cid`), INDEX `expire` (`expire`), INDEX `created` (`created`) ) ENGINE = InnoDB DEFAULT CHARACTER SET utf8mb4 COMMENT 'Storage for the cache API.'; Array ( ) in Drupal\Core\Extension\ModuleHandler->writeCache() (line 336 of /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Extension/ModuleHandler.php) #0 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Database/Connection.php(650): Drupal\Core\Database\Connection->handleQueryException(Object(PDOException), 'CREATE TABLE {c...', Array, Array) #1 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87): Drupal\Core\Database\Connection->query('CREATE TABLE {c...', Array, Array) #2 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Database/Schema.php(602): Drupal\Core\Database\Driver\mysql\Connection->query('CREATE TABLE {c...') #3 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Cache/DatabaseBackend.php(406): Drupal\Core\Database\Schema->createTable('cache_bootstrap', Array) #4 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Cache/DatabaseBackend.php(197): Drupal\Core\Cache\DatabaseBackend->ensureBinExists() #5 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Cache/DatabaseBackend.php(181): Drupal\Core\Cache\DatabaseBackend->setMultiple(Array) #6 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/Extension/ModuleHandler.php(336): Drupal\Core\Cache\DatabaseBackend->set('module_implemen...', Array) #7 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/EventSubscriber/RequestCloseSubscriber.php(42): Drupal\Core\Extension\ModuleHandler->writeCache() #8 [internal function]: Drupal\Core\EventSubscriber\RequestCloseSubscriber->onTerminate(Object(Symfony\Component\HttpKernel\Event\PostResponseEvent), 'kernel.terminat...', Object(Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher)) #9 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Component/EventDispatcher/ContainerAwareEventDispatcher.php(111): call_user_func(Array, Object(Symfony\Component\HttpKernel\Event\PostResponseEvent), 'kernel.terminat...', Object(Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher)) #10 /var/www/vhosts/example.com/world.example.com/vendor/symfony/http-kernel/HttpKernel.php(88): Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.terminat...', Object(Symfony\Component\HttpKernel\Event\PostResponseEvent)) #11 /var/www/vhosts/example.com/world.example.com/vendor/stack/builder/src/Stack/StackedHttpKernel.php(32): Symfony\Component\HttpKernel\HttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\domain\DomainRedirectResponse)) #12 /var/www/vhosts/example.com/world.example.com/web/core/lib/Drupal/Core/DrupalKernel.php(644): Stack\StackedHttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\domain\DomainRedirectResponse)) #13 /var/www/vhosts/example.com/world.example.com/web/index.php(22): Drupal\Core\DrupalKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Drupal\domain\DomainRedirectResponse)) #14 {main}.

markdc’s picture

markdc
Location Selters
commented

#4 was the solution.

After setting max_allowed_packet in my.cnf I'm no longer redirected. However, 16M wasn't enough in my case; I needed 64M.

Thank you @yuriseki

yseki’s picture

yseki commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)
tavor999’s picture

tavor999 commented

#4 Also resolved my issue. Thanks yuriseki!

mattshoaf’s picture

mattshoaf
he/him
Primary language English
Location Kansas City, MO, USA
commented

I was facing the same issue running a new site locally using Lando/Docker containers and #4 didn't resolve it completely for me. I also increased the wait_timeout variable. Default is 28800 seconds, I bumped it up to 60000 and all is working on my system now.

ab2211’s picture

ab2211 commented

I have the same issue on a shared hosting, but not the ability to edit the settings. What else can I do?