When a varnish purger is enabled drush cron throws errors

Open on Drupal.org →

Created on 27 October 2023, about 1 year ago

Updated 23 April 2024, 8 months ago

Problem/Motivation

ddev drush cron
PHP Fatal error: Uncaught TypeError: Drupal\Core\Database\StatementWrapperIterator::__construct(): Argument #2 ($clientConnection) must be of type object, null given, called in /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php on line 527 and defined in /var/www/html/web/core/lib/Drupal/Core/Database/StatementWrapperIterator.php:53
Stack trace:
#0 /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php(527): Drupal\Core\Database\StatementWrapperIterator->__construct(Object(Drupal\mysql\Driver\Database\mysql\Connection), NULL, 'SELECT COUNT(*)...', Array, false)
#1 /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php(787): Drupal\Core\Database\Connection->prepareStatement('SELECT COUNT(*)...', Array)
#2 /var/www/html/web/core/lib/Drupal/Core/Database/Query/Select.php(525): Drupal\Core\Database\Connection->query('SELECT COUNT(*)...', Array, Array)
#3 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/DatabaseQueue.php(112): Drupal\Core\Database\Query\Select->execute()
#4 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/QueueService.php(473): Drupal\purge\Plugin\Purge\Queue\DatabaseQueue->numberOfItems()
#5 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/QueueService.php(209): Drupal\purge\Plugin\Purge\Queue\QueueService->numberOfItems()
#6 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/QueueService.php(345): Drupal\purge\Plugin\Purge\Queue\QueueService->commit()
#7 /var/www/html/web/modules/contrib/purge/modules/purge_drush/src/Commands/PurgeDrushCommands.php(1131): Drupal\purge\Plugin\Purge\Queue\QueueService->destruct()
#8 [internal function]: Drupal\purge_drush\Commands\PurgeDrushCommands->__destruct()
#9 {main}
thrown in /var/www/html/web/core/lib/Drupal/Core/Database/StatementWrapperIterator.php on line 53

Fatal error: Uncaught TypeError: Drupal\Core\Database\StatementWrapperIterator::__construct(): Argument #2 ($clientConnection) must be of type object, null given, called in /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php on line 527 and defined in /var/www/html/web/core/lib/Drupal/Core/Database/StatementWrapperIterator.php:53
Stack trace:
#0 /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php(527): Drupal\Core\Database\StatementWrapperIterator->__construct(Object(Drupal\mysql\Driver\Database\mysql\Connection), NULL, 'SELECT COUNT(*)...', Array, false)
#1 /var/www/html/web/core/lib/Drupal/Core/Database/Connection.php(787): Drupal\Core\Database\Connection->prepareStatement('SELECT COUNT(*)...', Array)
#2 /var/www/html/web/core/lib/Drupal/Core/Database/Query/Select.php(525): Drupal\Core\Database\Connection->query('SELECT COUNT(*)...', Array, Array)
#3 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/DatabaseQueue.php(112): Drupal\Core\Database\Query\Select->execute()
#4 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/QueueService.php(473): Drupal\purge\Plugin\Purge\Queue\DatabaseQueue->numberOfItems()
#5 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/QueueService.php(209): Drupal\purge\Plugin\Purge\Queue\QueueService->numberOfItems()
#6 /var/www/html/web/modules/contrib/purge/src/Plugin/Purge/Queue/QueueService.php(345): Drupal\purge\Plugin\Purge\Queue\QueueService->commit()
#7 /var/www/html/web/modules/contrib/purge/modules/purge_drush/src/Commands/PurgeDrushCommands.php(1131): Drupal\purge\Plugin\Purge\Queue\QueueService->destruct()
#8 [internal function]: Drupal\purge_drush\Commands\PurgeDrushCommands->__destruct()
#9 {main}
thrown in /var/www/html/web/core/lib/Drupal/Core/Database/StatementWrapperIterator.php on line 53

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report

Status

Postponed: needs info

Version

2.0

Component

Code

Created by

🇺🇸United States nicxvan

Live updates comments and jobs are added and updated live.

Sign in to follow issues

Comments & Activities

Issue created by @nicxvan
Comment about 1 year ago →
🇺🇸United States nicxvan
Comment about 1 year ago →
🇺🇸United States nicxvan
The error is thrown in the purge module, but only happens when the varnish image purge module is also enabled.
Comment about 1 year ago →
🇺🇸United States nicxvan
After further investigation this is not from the varnish image purger, it's the varnish purger module in general, if there is a varnish purger enabled then it fails.
Comment about 1 year ago →
🇺🇸United States nicxvan
Comment about 1 year ago →
🇺🇸United States nicxvan
This also occurs on config import if there is config to import. If there are no config changes config import is fine.
Comment about 1 year ago →
🇸🇪Sweden MiSc
Thanks for the report. I never had this issue myself, do you have steps to reproduce the error? Which version of the Purge module are you using?
Status changed to Postponed: needs info about 1 year ago8:36pm 29 October 2023
Comment about 1 year ago →
🇸🇪Sweden MiSc
Comment about 1 year ago →
🇺🇸United States nicxvan
For me it occurs when I have a cache tag invalidation set to an ip address with ban requests and then run a drush command that accomplishes something.
E.g. drush cim when there are config changes to import, updb when there is a database update or cron when there is a batch to process.

I am using the following:
queuers
core tags, p:queue-add, Purge blocks

Queue
database

Processors
p:invalidate, p:queue-work, Purge blocks

This only started after updating to Drupal 10 and Drush 11.
I am using drupal/purge 3.5
I am using drupal/varnish_purge 2.2.0
Comment 8 months ago →
🇪🇸Spain vidorado Pamplona (Navarra)
@Nicxvan, Maybe it is related with this issue and you have, like me, a patch applied?

https://www.drupal.org/project/purge/issues/2921309 →

https://www.drupal.org/files/issues/2921309-17-port-purge-drush-9.patch →
Comment 8 months ago →
🇺🇸United States nicxvan
I think you're right

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024