symfony cache:clear failed without database

[guikingone]

symfony cache:clear failed without database

[Guikingone]

Alright, could you test it against dev-issue/152? Thanks again and sorry for the bug 🙂

[jvancoillie]

I am very well thank you.

You're too fast, I was investigating and indeed, by deleting the SchedulerCacheClearer registration it works ...

SchedulerBundle/src/DependencyInjection/SchedulerBundleExtension.php

Lines 204 to 216 in 6dc24eb

	private function registerKernelDependencies(ContainerBuilder $container): void
	{
	$container->register(SchedulerCacheClearer::class, SchedulerCacheClearer::class)
	->setArguments([
	new Reference(SchedulerInterface::class, ContainerInterface::EXCEPTION_ON_INVALID_REFERENCE),
	])
	->setPublic(false)
	->addTag('kernel.cache_clearer')
	->addTag('container.preload', [
	'class' => SchedulerCacheClearer::class,
	])
	;
	}

[jvancoillie]

Ho yes, when I say without database it means that at the time of the docker build I do not yet have the database container. I have the following transport configuration in the configuration file

scheduler_bundle:
    transport:
        dsn: 'doctrine://default?execution_mode=first_in_first_out&table_name=scheduler_tasks&auto_setup=false'

I also have the configuration of the database version in the .env as specified in the symfony troubleshooting documentation
https://symfony.com/doc/current/cloud/troubleshooting.html#sqlstate-hy000-2002-connection-refused-during-the-build-step

[Guikingone]

Hi @jvancoillie 👋🏻

Thanks, I'm gonna release it via 0.5.3 🙂

[jvancoillie]

a little more information with the stack trace

In PDOConnection.php line 39:

  [PDOException (2002)]
  SQLSTATE[HY000] [2002] Connection refused


Exception trace:
  at /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39
 PDO->__construct() at /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:39
 Doctrine\DBAL\Driver\PDOConnection->__construct() at /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:25
 Doctrine\DBAL\Driver\PDOMySql\Driver->connect() at /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:400
 Doctrine\DBAL\Connection->connect() at /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1940
 Doctrine\DBAL\Connection->getWrappedConnection() at /var/www/app/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1278
 Doctrine\DBAL\Connection->executeQuery() at /var/www/app/vendor/guikingone/scheduler-bundle/src/Bridge/Doctrine/Transport/Connection.php:369
 SchedulerBundle\Bridge\Doctrine\Transport\Connection->executeQuery() at /var/www/app/vendor/guikingone/scheduler-bundle/src/Bridge/Doctrine/Transport/Connection.php:157
 SchedulerBundle\Bridge\Doctrine\Transport\Connection->create() at /var/www/app/vendor/guikingone/scheduler-bundle/src/Bridge/Doctrine/Transport/DoctrineTransport.php:82
 SchedulerBundle\Bridge\Doctrine\Transport\DoctrineTransport->create() at /var/www/app/vendor/guikingone/scheduler-bundle/src/Scheduler.php:92
 SchedulerBundle\Scheduler->schedule() at /var/www/app/var/cache/dev/ContainerVQV8FEe/App_KernelDevDebugContainer.php:8975
 ContainerVQV8FEe\App_KernelDevDebugContainer->getSchedulerService() at /var/www/app/var/cache/dev/ContainerVQV8FEe/App_KernelDevDebugContainer.php:8677
 ContainerVQV8FEe\App_KernelDevDebugContainer->getSchedulerCacheClearerService() at /var/www/app/var/cache/dev/ContainerVQV8FEe/App_KernelDevDebugContainer.php:721
 ContainerVQV8FEe\App_KernelDevDebugContainer->ContainerVQV8FEe\{closure}() at /var/www/app/vendor/symfony/http-kernel/CacheClearer/ChainCacheClearer.php:35
 Symfony\Component\HttpKernel\CacheClearer\ChainCacheClearer->clear() at /var/www/app/vendor/symfony/framework-bundle/Command/CacheClearCommand.php:114
 Symfony\Bundle\FrameworkBundle\Command\CacheClearCommand->execute() at /var/www/app/vendor/symfony/console/Command/Command.php:256
 Symfony\Component\Console\Command\Command->run() at /var/www/app/vendor/symfony/console/Application.php:989
 Symfony\Component\Console\Application->doRunCommand() at /var/www/app/vendor/symfony/framework-bundle/Console/Application.php:96
 Symfony\Bundle\FrameworkBundle\Console\Application->doRunCommand() at /var/www/app/vendor/symfony/console/Application.php:290
 Symfony\Component\Console\Application->doRun() at /var/www/app/vendor/symfony/framework-bundle/Console/Application.php:82
 Symfony\Bundle\FrameworkBundle\Console\Application->doRun() at /var/www/app/vendor/symfony/console/Application.php:166
 Symfony\Component\Console\Application->run() at /var/www/app/bin/console:43

[Guikingone]

Hi @jvancoillie 👋🏻 , I'm fine thanks you and you?

It seems related to the recently added SchedulerCacheClearer: https://github.com/Guikingone/SchedulerBundle/blob/main/src/CacheClearer/SchedulerCacheClearer.php

If you use a external connection and the connection is not available, an error is thrown, I'm gonna fix this, the solution could be to remove the CacheClearer.

[jvancoillie]

same issue with dev-issue/152

[Guikingone]

Alright, small question, when you say without database, have you configured the transport in the configuration?

[Guikingone]

I just removed the cache clearer, could you test it when you have a moment? thanks 🙂

[jvancoillie]

Hi @Guikingone 👋

I just tested dev-issue / 152 and it works as expected.

Thanks 👍