Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Hi guys,
I know this is a new release version for d8 and am aware you guys just picked this up. well done for supporting the module.
I have just tried it out but i get the error below and drush fails to install, any suggestions?.
Error while sending QUERY packet. PID=1976 Statement.php:59 [warning]
PDOException: SQLSTATE[HY000]: General error: 2006 MySQL server has [error]
gone away in
/var/www/site/docroot/core/lib/Drupal/Core/Database/Statement.php:59
Stack trace:
#0
/var/www/site/docroot/core/lib/Drupal/Core/Database/Statement.php(59):
PDOStatement->execute(Array)
#1
/var/www/site/docroot/core/lib/Drupal/Core/Database/Connection.php(624):
Drupal\Core\Database\Statement->execute(Array, Array)
#2
/var/www/site/docroot/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87):
Drupal\Core\Database\Connection->query('CREATE TABLE {c...', Array,
Array)
#3
/var/www/site/docroot/core/lib/Drupal/Core/Database/Schema.php(598):
Drupal\Core\Database\Driver\mysql\Connection->query('CREATE TABLE
{c...')
#4
/var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(405):
Drupal\Core\Database\Schema->createTable('cache_config', Array)
#5
/var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(196):
Drupal\Core\Cache\DatabaseBackend->ensureBinExists()
#6
/var/www/site/docroot/core/lib/Drupal/Core/Cache/ChainedFastBackend.php(191):
Drupal\Core\Cache\DatabaseBackend->setMultiple(Array)
#7
/var/www/site/docroot/core/lib/Drupal/Core/Config/CachedStorage.php(105):
Drupal\Core\Cache\ChainedFastBackend->setMultiple(Array)
#8
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(165):
Drupal\Core\Config\CachedStorage->readMultiple(Array)
#9
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(104):
Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array, false)
#10
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(82):
Drupal\Core\Config\ConfigFactory->doGet('core.extension', false)
#11
/var/www/site/docroot/core/lib/Drupal/Core/Extension/ModuleInstaller.php(78):
Drupal\Core\Config\ConfigFactory->getEditable('core.extension')
#12
/var/www/site/docroot/core/lib/Drupal/Core/ProxyClass/Extension/ModuleInstaller.php(83):
Drupal\Core\Extension\ModuleInstaller->install(Array, true)
#13
phar:///usr/local/bin/drush/commands/core/drupal/environment.inc(131):
Drupal\Core\ProxyClass\Extension\ModuleInstaller->install(Array,
true)
#14
phar:///usr/local/bin/drush/commands/core/drupal/environment.inc(198):
drush_module_install(Array)
#15 phar:///usr/local/bin/drush/commands/pm/pm.drush.inc(1167):
drush_module_enable(Array)
#16 phar:///usr/local/bin/drush/includes/command.inc(422):
drush_pm_enable('menu_per_role')
#17 phar:///usr/local/bin/drush/includes/command.inc(231):
_drush_invoke_hooks(Array, Array)
#18 phar:///usr/local/bin/drush/includes/command.inc(199):
drush_command('menu_per_role')
#19 phar:///usr/local/bin/drush/lib/Drush/Boot/BaseBoot.php(67):
drush_dispatch(Array)
#20 phar:///usr/local/bin/drush/includes/preflight.inc(66):
Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#21 phar:///usr/local/bin/drush/includes/startup.inc(458):
drush_main()
#22 phar:///usr/local/bin/drush/includes/startup.inc(365):
drush_run_main(false, '/', 'Phar detected. ...')
#23 phar:///usr/local/bin/drush/drush(114): drush_startup(Array)
#24 /usr/local/bin/drush(10): require('phar:///usr/loc...')
#25 {main}
Next Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]:
General error: 2006 MySQL server has gone away: CREATE TABLE
{cache_config} (
`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
/var/www/site/docroot/core/lib/Drupal/Core/Database/Connection.php:685
Stack trace:
#0
/var/www/site/docroot/core/lib/Drupal/Core/Database/Connection.php(649):
Drupal\Core\Database\Connection->handleQueryException(Object(PDOException),
'CREATE TABLE {c...', Array, Array)
#1
/var/www/site/docroot/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87):
Drupal\Core\Database\Connection->query('CREATE TABLE {c...', Array,
Array)
#2
/var/www/site/docroot/core/lib/Drupal/Core/Database/Schema.php(598):
Drupal\Core\Database\Driver\mysql\Connection->query('CREATE TABLE
{c...')
#3
/var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(405):
Drupal\Core\Database\Schema->createTable('cache_config', Array)
#4
/var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(196):
Drupal\Core\Cache\DatabaseBackend->ensureBinExists()
#5
/var/www/site/docroot/core/lib/Drupal/Core/Cache/ChainedFastBackend.php(191):
Drupal\Core\Cache\DatabaseBackend->setMultiple(Array)
#6
/var/www/site/docroot/core/lib/Drupal/Core/Config/CachedStorage.php(105):
Drupal\Core\Cache\ChainedFastBackend->setMultiple(Array)
#7
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(165):
Drupal\Core\Config\CachedStorage->readMultiple(Array)
#8
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(104):
Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array, false)
#9
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(82):
Drupal\Core\Config\ConfigFactory->doGet('core.extension', false)
#10
/var/www/site/docroot/core/lib/Drupal/Core/Extension/ModuleInstaller.php(78):
Drupal\Core\Config\ConfigFactory->getEditable('core.extension')
#11
/var/www/site/docroot/core/lib/Drupal/Core/ProxyClass/Extension/ModuleInstaller.php(83):
Drupal\Core\Extension\ModuleInstaller->install(Array, true)
#12
phar:///usr/local/bin/drush/commands/core/drupal/environment.inc(131):
Drupal\Core\ProxyClass\Extension\ModuleInstaller->install(Array,
true)
#13
phar:///usr/local/bin/drush/commands/core/drupal/environment.inc(198):
drush_module_install(Array)
#14 phar:///usr/local/bin/drush/commands/pm/pm.drush.inc(1167):
drush_module_enable(Array)
#15 phar:///usr/local/bin/drush/includes/command.inc(422):
drush_pm_enable('menu_per_role')
#16 phar:///usr/local/bin/drush/includes/command.inc(231):
_drush_invoke_hooks(Array, Array)
#17 phar:///usr/local/bin/drush/includes/command.inc(199):
drush_command('menu_per_role')
#18 phar:///usr/local/bin/drush/lib/Drush/Boot/BaseBoot.php(67):
drush_dispatch(Array)
#19 phar:///usr/local/bin/drush/includes/preflight.inc(66):
Drush\Boot\BaseBoot->bootstrap_and_dispatch()
#20 phar:///usr/local/bin/drush/includes/startup.inc(458):
drush_main()
#21 phar:///usr/local/bin/drush/includes/startup.inc(365):
drush_run_main(false, '/', 'Phar detected. ...')
#22 phar:///usr/local/bin/drush/drush(114): drush_startup(Array)
#23 /usr/local/bin/drush(10): require('phar:///usr/loc...')
#24 {main}
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: [error]
General error: 2006 MySQL server has gone away: CREATE TABLE
{cache_config} (
`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\Cache\ChainedFastBackend->setMultiple() (line 191 of
/var/www/site/docroot/core/lib/Drupal/Core/Cache/ChainedFastBackend.php)
#0
/var/www/site/docroot/core/lib/Drupal/Core/Database/Connection.php(649):
Drupal\Core\Database\Connection->handleQueryException(Object(PDOException),
'CREATE TABLE {c...', Array, Array)
#1
/var/www/site/docroot/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87):
Drupal\Core\Database\Connection->query('CREATE TABLE {c...', Array,
Array)
#2
/var/www/site/docroot/core/lib/Drupal/Core/Database/Schema.php(598):
Drupal\Core\Database\Driver\mysql\Connection->query('CREATE TABLE
{c...')
#3
/var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(405):
Drupal\Core\Database\Schema->createTable('cache_config', Array)
#4
/var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(196):
Drupal\Core\Cache\DatabaseBackend->ensureBinExists()
#5
/var/www/site/docroot/core/lib/Drupal/Core/Cache/ChainedFastBackend.php(191):
Drupal\Core\Cache\DatabaseBackend->setMultiple(Array)
#6
/var/www/site/docroot/core/lib/Drupal/Core/Config/CachedStorage.php(105):
Drupal\Core\Cache\ChainedFastBackend->setMultiple(Array)
#7
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(165):
Drupal\Core\Config\CachedStorage->readMultiple(Array)
#8
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(104):
Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array, true)
#9
/var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(89):
Drupal\Core\Config\ConfigFactory->doGet('automated_cron....')
#10
/var/www/site/docroot/core/modules/automated_cron/src/EventSubscriber/AutomatedCron.php(50):
Drupal\Core\Config\ConfigFactory->get('automated_cron....')
#11
/var/www/site/docroot/core/lib/Drupal/Component/DependencyInjection/Container.php(270):
Drupal\automated_cron\EventSubscriber\AutomatedCron->__construct(Object(Drupal\Core\ProxyClass\Cron),
Object(Drupal\Core\Config\ConfigFactory),
Object(Drupal\Core\State\State))
#12
/var/www/site/docroot/core/lib/Drupal/Component/DependencyInjection/Container.php(171):
Drupal\Component\DependencyInjection\Container->createService(Array,
'automated_cron....')
#13
/var/www/site/docroot/core/lib/Drupal/Component/EventDispatcher/ContainerAwareEventDispatcher.php(105):
Drupal\Component\DependencyInjection\Container->get('automated_cron....')
#14
/var/www/site/docroot/vendor/symfony/http-kernel/HttpKernel.php(88):
Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.terminat...',
Object(Symfony\Component\HttpKernel\Event\PostResponseEvent))
#15
/var/www/site/docroot/vendor/stack/builder/src/Stack/StackedHttpKernel.php(32):
Symfony\Component\HttpKernel\HttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request),
Object(Symfony\Component\HttpFoundation\Response))
#16 /var/www/site/docroot/core/lib/Drupal/Core/DrupalKernel.php(635):
Stack\StackedHttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request),
Object(Symfony\Component\HttpFoundation\Response))
#17 phar:///usr/local/bin/drush/lib/Drush/Boot/DrupalBoot8.php(198):
Drupal\Core\DrupalKernel->terminate(Object(Symfony\Component\HttpFoundation\Request),
Object(Symfony\Component\HttpFoundation\Response))
#18 phar:///usr/local/bin/drush/includes/preflight.inc(75):
Drush\Boot\DrupalBoot8->terminate()
#19 phar:///usr/local/bin/drush/includes/startup.inc(458):
drush_main()
#20 phar:///usr/local/bin/drush/includes/startup.inc(365):
drush_run_main(false, '/', 'Phar detected. ...')
#21 phar:///usr/local/bin/drush/drush(114): drush_startup(Array)
#22 /usr/local/bin/drush(10): require('phar:///usr/loc...')
#23 {main}.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: CREATE TABLE {cache_config} (
`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 /var/www/site/docroot/core/lib/Drupal/Core/Cache/ChainedFastBackend.php on line 191 #0 /var/www/site/docroot/core/lib/Drupal/Core/Database/Connection.php(649): Drupal\Core\Database\Connection->handleQueryException(Object(PDOException), 'CREATE TABLE {c...', Array, Array)
#1 /var/www/site/docroot/core/lib/Drupal/Core/Database/Driver/mysql/Connection.php(87): Drupal\Core\Database\Connection->query('CREATE TABLE {c...', Array, Array)
#2 /var/www/site/docroot/core/lib/Drupal/Core/Database/Schema.php(598): Drupal\Core\Database\Driver\mysql\Connection->query('CREATE TABLE {c...')
#3 /var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(405): Drupal\Core\Database\Schema->createTable('cache_config', Array)
#4 /var/www/site/docroot/core/lib/Drupal/Core/Cache/DatabaseBackend.php(196): Drupal\Core\Cache\DatabaseBackend->ensureBinExists()
#5 /var/www/site/docroot/core/lib/Drupal/Core/Cache/ChainedFastBackend.php(191): Drupal\Core\Cache\DatabaseBackend->setMultiple(Array)
#6 /var/www/site/docroot/core/lib/Drupal/Core/Config/CachedStorage.php(105): Drupal\Core\Cache\ChainedFastBackend->setMultiple(Array)
#7 /var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(165): Drupal\Core\Config\CachedStorage->readMultiple(Array)
#8 /var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(104): Drupal\Core\Config\ConfigFactory->doLoadMultiple(Array, true)
#9 /var/www/site/docroot/core/lib/Drupal/Core/Config/ConfigFactory.php(89): Drupal\Core\Config\ConfigFactory->doGet('automated_cron....')
#10 /var/www/site/docroot/core/modules/automated_cron/src/EventSubscriber/AutomatedCron.php(50): Drupal\Core\Config\ConfigFactory->get('automated_cron....')
#11 /var/www/site/docroot/core/lib/Drupal/Component/DependencyInjection/Container.php(270): Drupal\automated_cron\EventSubscriber\AutomatedCron->__construct(Object(Drupal\Core\ProxyClass\Cron), Object(Drupal\Core\Config\ConfigFactory), Object(Drupal\Core\State\State))
#12 /var/www/site/docroot/core/lib/Drupal/Component/DependencyInjection/Container.php(171): Drupal\Component\DependencyInjection\Container->createService(Array, 'automated_cron....')
#13 /var/www/site/docroot/core/lib/Drupal/Component/EventDispatcher/ContainerAwareEventDispatcher.php(105): Drupal\Component\DependencyInjection\Container->get('automated_cron....')
#14 /var/www/site/docroot/vendor/symfony/http-kernel/HttpKernel.php(88): Drupal\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch('kernel.terminat...', Object(Symfony\Component\HttpKernel\Event\PostResponseEvent))
#15 /var/www/site/docroot/vendor/stack/builder/src/Stack/StackedHttpKernel.php(32): Symfony\Component\HttpKernel\HttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Symfony\Component\HttpFoundation\Response))
#16 /var/www/site/docroot/core/lib/Drupal/Core/DrupalKernel.php(635): Stack\StackedHttpKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Symfony\Component\HttpFoundation\Response))
#17 phar:///usr/local/bin/drush/lib/Drush/Boot/DrupalBoot8.php(198): Drupal\Core\DrupalKernel->terminate(Object(Symfony\Component\HttpFoundation\Request), Object(Symfony\Component\HttpFoundation\Response))
#18 phar:///usr/local/bin/drush/includes/preflight.inc(75): Drush\Boot\DrupalBoot8->terminate()
#19 phar:///usr/local/bin/drush/includes/startup.inc(458): drush_main()
#20 phar:///usr/local/bin/drush/includes/startup.inc(365): drush_run_main(false, '/', 'Phar detected. ...')
#21 phar:///usr/local/bin/drush/drush(114): drush_startup(Array)
#22 /usr/local/bin/drush(10): require('phar:///usr/loc...')
#23 {main}
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: CREATE TABLE {cache_config} (
`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\Cache\ChainedFastBackend->setMultiple() (line 191 of /var/www/site/docroot/core/lib/Drupal/Core/Cache/ChainedFastBackend.php).
Drush command terminated abnormally due to an unrecoverable error. [error]
Comments
Comment #2
GrimreaperHello,
Seing the error message, it seems that your database server shutdown during the process.
"General error: 2006 MySQL server has gone away in..." appears multiple times.
Can you please test on a simplytest.me sandbox and/or provide the steps to reproduce the error?
Comment #3
BigEd CreditAttribution: BigEd as a volunteer commentedI tested this on simple.me and looks and works correctly, so might just be something in my local vm.
I will close this and reopen it if i can replicate the problem.
thanks
Comment #4
BigEd CreditAttribution: BigEd as a volunteer commented