Error 500 Internal Server Error

GET https://www.test.cr-art-auctions.be/en/catalog/46179

IP
216.73.216.99
Profiled on
Token
777402
Forwarded to ErrorController (760a1e)

Exceptions

PDOException Exception ConnectionException

HTTP 500 Internal Server Error

An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused

Exceptions 3

Doctrine\DBAL\Exception\ ConnectionException

Show exception properties 
Doctrine\DBAL\Exception\ConnectionException {#590
  -query: null
}
in vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php (line 112)
  1.             case 1370:
  2.             case 1429:
  3.             case 2002:
  4.             case 2005:
  5.             case 2054:
  6.                 return new ConnectionException($exception, $query);
  8.             case 2006:
  9.             case 4031:
  10.                 return new ConnectionLost($exception, $query);
in vendor/doctrine/dbal/src/Connection.php -> convert (line 1976)
  1.     private function handleDriverException(
  2.         Driver\Exception $driverException,
  3.         ?Query $query
  4.     ): DriverException {
  5.         $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
  6.         $exception                  = $this->exceptionConverter->convert($driverException, $query);
  8.         if ($exception instanceof ConnectionLost) {
  9.             $this->close();
  10.         }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1924)
  1.     }
  3.     /** @internal */
  4.     final public function convertException(Driver\Exception $e): DriverException
  5.     {
  6.         return $this->handleDriverException($e, null);
  7.     }
  9.     /**
  10.      * @param array<int, mixed>|array<string, mixed>                               $params
  11.      * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
in vendor/doctrine/dbal/src/Connection.php -> convertException (line 385)
  1.         }
  3.         try {
  4.             $this->_conn = $this->_driver->connect($this->params);
  5.         } catch (Driver\Exception $e) {
  6.             throw $this->convertException($e);
  7.         }
  9.         if ($this->autoCommit === false) {
  10.             $this->beginTransaction();
  11.         }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1692)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         return $this->_conn;
  9.     }
  11.     /** @return resource|object */
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1087)
  1.     ): Result {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql, $params, $types, $qcp);
  4.         }
  6.         $connection = $this->getWrappedConnection();
  8.         $logger = $this->_config->getSQLLogger();
  9.         if ($logger !== null) {
  10.             $logger->startQuery($sql, $params, $types);
  11.         }
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 31)
  1.      * @param list<mixed>|array<string, mixed>                                     $params
  2.      * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types): Result
  5.     {
  6.         return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 330)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     /**
  10.      * @param array<string,mixed> $sqlParams
  11.      * @param array<string,Type>  $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 1213)
  1.             $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 1167)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 930)
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getSingleColumnResult()
  5.     {
  6.         return $this->execute(null, self::HYDRATE_SCALAR_COLUMN);
  7.     }
  9.     /**
  10.      * Gets the scalar results for the query.
  11.      *
AbstractQuery->getSingleColumnResult() in src/Service/BaseControllerService.php (line 148)
  1.             $language = $this->em->createQueryBuilder()
  2.                 ->select('l.id')
  3.                 ->from(Languages::class, 'l')
  4.                 ->where('l.code = :code')->setParameter('code', $locale)
  5.                 ->getQuery()
  6.                 ->getSingleColumnResult();
  8.             if (!empty($language))
  9.                 $languageId = $language[0];
  11.             $session->set('langIds', [$locale => $languageId]);
BaseControllerService->getLanguageId(object(Session), 'en') in src/Controller/CatalogueController.php (line 52)
  1.             'page' => '\d+',
  2.         ], 
  3.     )]
  4.     public function index(Request $request, Session $session, Security $security, BaseControllerService $baseControllerService, $projectDir, $page = 0): Response
  5.     {
  6.         $this->languageId = $baseControllerService->getLanguageId($session, $request->getLocale());
  8.         $pageCatalogue = $this->cache->get('CatalogueController.index', function ($item) {
  9.             $item->expiresAfter(Utils::getCacheTTL($this->appEnv)); // 10 minutes
  10.             return $this->em->getRepository(PageCatalogue::class)->find(1);
  11.         });
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         $response = null;
  5.         try {
  6.             return $response = $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1.         if (!$this->handlingHttpCache) {
  2.             $this->resetServices = true;
  3.         }
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.     ) {
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  8.         if (Kernel::VERSION_ID >= 60400) {
  9.             $response->send(false);
  11.             if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/crartak/test/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HY000] [2002] Connection refused

in vendor/doctrine/dbal/src/Driver/PDO/Exception.php (line 24)
  1.         } else {
  2.             $code     = $exception->getCode();
  3.             $sqlState = null;
  4.         }
  6.         return new self($exception->getMessage(), $sqlState, $code, $exception);
  7.     }
  8. }
in vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php :: new (line 43)
  1.                 $params['user'] ?? '',
  2.                 $params['password'] ?? '',
  3.                 $driverOptions,
  4.             );
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  9.         return new Connection($pdo);
  10.     }
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 29)
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/doctrine/dbal/src/Logging/Driver.php -> connect (line 34)
  1.         array $params
  2.     ) {
  3.         $this->logger->info('Connecting with parameters {params}', ['params' => $this->maskPassword($params)]);
  5.         return new Connection(
  6.             parent::connect($params),
  7.             $this->logger,
  8.         );
  9.     }
  11.     /**
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 29)
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php -> connect (line 37)
  1.         parent::__construct($driver);
  2.     }
  4.     public function connect(array $params): ConnectionInterface
  5.     {
  6.         $connection = parent::connect($params);
  8.         if ('void' !== (string) (new \ReflectionMethod(ConnectionInterface::class, 'commit'))->getReturnType()) {
  9.             return new DBAL3\Connection(
  10.                 $connection,
  11.                 $this->debugDataHolder,
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 29)
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php -> connect (line 35)
  1.     }
  3.     public function connect(array $params): ConnectionInterface
  4.     {
  5.         $timestamp = time();
  6.         $connection = parent::connect($params);
  7.         $this->connectionExpiries[$this->connectionName] = $timestamp + $this->ttl;
  9.         return $connection;
  10.     }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 383)
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  5.         try {
  6.             $this->_conn = $this->_driver->connect($this->params);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertException($e);
  9.         }
  11.         if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1692)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         return $this->_conn;
  9.     }
  11.     /** @return resource|object */
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1087)
  1.     ): Result {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql, $params, $types, $qcp);
  4.         }
  6.         $connection = $this->getWrappedConnection();
  8.         $logger = $this->_config->getSQLLogger();
  9.         if ($logger !== null) {
  10.             $logger->startQuery($sql, $params, $types);
  11.         }
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 31)
  1.      * @param list<mixed>|array<string, mixed>                                     $params
  2.      * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types): Result
  5.     {
  6.         return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 330)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     /**
  10.      * @param array<string,mixed> $sqlParams
  11.      * @param array<string,Type>  $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 1213)
  1.             $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 1167)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 930)
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getSingleColumnResult()
  5.     {
  6.         return $this->execute(null, self::HYDRATE_SCALAR_COLUMN);
  7.     }
  9.     /**
  10.      * Gets the scalar results for the query.
  11.      *
AbstractQuery->getSingleColumnResult() in src/Service/BaseControllerService.php (line 148)
  1.             $language = $this->em->createQueryBuilder()
  2.                 ->select('l.id')
  3.                 ->from(Languages::class, 'l')
  4.                 ->where('l.code = :code')->setParameter('code', $locale)
  5.                 ->getQuery()
  6.                 ->getSingleColumnResult();
  8.             if (!empty($language))
  9.                 $languageId = $language[0];
  11.             $session->set('langIds', [$locale => $languageId]);
BaseControllerService->getLanguageId(object(Session), 'en') in src/Controller/CatalogueController.php (line 52)
  1.             'page' => '\d+',
  2.         ], 
  3.     )]
  4.     public function index(Request $request, Session $session, Security $security, BaseControllerService $baseControllerService, $projectDir, $page = 0): Response
  5.     {
  6.         $this->languageId = $baseControllerService->getLanguageId($session, $request->getLocale());
  8.         $pageCatalogue = $this->cache->get('CatalogueController.index', function ($item) {
  9.             $item->expiresAfter(Utils::getCacheTTL($this->appEnv)); // 10 minutes
  10.             return $this->em->getRepository(PageCatalogue::class)->find(1);
  11.         });
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         $response = null;
  5.         try {
  6.             return $response = $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1.         if (!$this->handlingHttpCache) {
  2.             $this->resetServices = true;
  3.         }
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.     ) {
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  8.         if (Kernel::VERSION_ID >= 60400) {
  9.             $response->send(false);
  11.             if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/crartak/test/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

PDOException

SQLSTATE[HY000] [2002] Connection refused

in vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php (line 25)
  1.         #[SensitiveParameter]
  2.         string $password,
  3.         array $options
  4.     ): PDO {
  5.         if (PHP_VERSION_ID < 80400) {
  6.             return new PDO($dsn, $username, $password, $options);
  7.         }
  9.         return PDO::connect($dsn, $username, $password, $options);
  10.     }
  11. }
in vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php -> __construct (line 25)
  1.         #[SensitiveParameter]
  2.         string $password,
  3.         array $options
  4.     ): PDO {
  5.         if (PHP_VERSION_ID < 80400) {
  6.             return new PDO($dsn, $username, $password, $options);
  7.         }
  9.         return PDO::connect($dsn, $username, $password, $options);
  10.     }
  11. }
in vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php -> doConnect (line 36)
  2.         $safeParams = $params;
  3.         unset($safeParams['password'], $safeParams['url']);
  5.         try {
  6.             $pdo = $this->doConnect(
  7.                 $this->constructPdoDsn($safeParams),
  8.                 $params['user'] ?? '',
  9.                 $params['password'] ?? '',
  10.                 $driverOptions,
  11.             );
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 29)
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/doctrine/dbal/src/Logging/Driver.php -> connect (line 34)
  1.         array $params
  2.     ) {
  3.         $this->logger->info('Connecting with parameters {params}', ['params' => $this->maskPassword($params)]);
  5.         return new Connection(
  6.             parent::connect($params),
  7.             $this->logger,
  8.         );
  9.     }
  11.     /**
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 29)
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php -> connect (line 37)
  1.         parent::__construct($driver);
  2.     }
  4.     public function connect(array $params): ConnectionInterface
  5.     {
  6.         $connection = parent::connect($params);
  8.         if ('void' !== (string) (new \ReflectionMethod(ConnectionInterface::class, 'commit'))->getReturnType()) {
  9.             return new DBAL3\Connection(
  10.                 $connection,
  11.                 $this->debugDataHolder,
in vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php -> connect (line 29)
  1.      */
  2.     public function connect(
  3.         #[SensitiveParameter]
  4.         array $params
  5.     ) {
  6.         return $this->wrappedDriver->connect($params);
  7.     }
  9.     /**
  10.      * {@inheritDoc}
  11.      */
in vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php -> connect (line 35)
  1.     }
  3.     public function connect(array $params): ConnectionInterface
  4.     {
  5.         $timestamp = time();
  6.         $connection = parent::connect($params);
  7.         $this->connectionExpiries[$this->connectionName] = $timestamp + $this->ttl;
  9.         return $connection;
  10.     }
  11. }
in vendor/doctrine/dbal/src/Connection.php -> connect (line 383)
  1.         if ($this->_conn !== null) {
  2.             return false;
  3.         }
  5.         try {
  6.             $this->_conn = $this->_driver->connect($this->params);
  7.         } catch (Driver\Exception $e) {
  8.             throw $this->convertException($e);
  9.         }
  11.         if ($this->autoCommit === false) {
in vendor/doctrine/dbal/src/Connection.php -> connect (line 1692)
  1.             'https://github.com/doctrine/dbal/issues/4966',
  2.             'Connection::getWrappedConnection() is deprecated.'
  3.                 . ' Use Connection::getNativeConnection() to access the native connection.',
  4.         );
  6.         $this->connect();
  8.         return $this->_conn;
  9.     }
  11.     /** @return resource|object */
in vendor/doctrine/dbal/src/Connection.php -> getWrappedConnection (line 1087)
  1.     ): Result {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql, $params, $types, $qcp);
  4.         }
  6.         $connection = $this->getWrappedConnection();
  8.         $logger = $this->_config->getSQLLogger();
  9.         if ($logger !== null) {
  10.             $logger->startQuery($sql, $params, $types);
  11.         }
in vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php -> executeQuery (line 31)
  1.      * @param list<mixed>|array<string, mixed>                                     $params
  2.      * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types): Result
  5.     {
  6.         return $conn->executeQuery($this->getSqlStatements(), $params, $types, $this->queryCacheProfile);
  7.     }
  8. }
in vendor/doctrine/orm/src/Query.php -> execute (line 330)
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  6.         return $executor->execute($this->_em->getConnection(), $sqlParams, $types);
  7.     }
  9.     /**
  10.      * @param array<string,mixed> $sqlParams
  11.      * @param array<string,Type>  $types
in vendor/doctrine/orm/src/AbstractQuery.php -> _doExecute (line 1213)
  1.             $setCacheEntry = static function ($data) use ($cache, $result, $cacheItem, $realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  6.         $stmt = $this->_doExecute();
  8.         if (is_numeric($stmt)) {
  9.             $setCacheEntry($stmt);
  11.             return $stmt;
in vendor/doctrine/orm/src/AbstractQuery.php -> executeIgnoreQueryCache (line 1167)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters, $hydrationMode);
  4.         }
  6.         return $this->executeIgnoreQueryCache($parameters, $hydrationMode);
  7.     }
  9.     /**
  10.      * Execute query ignoring second level cache.
  11.      *
in vendor/doctrine/orm/src/AbstractQuery.php -> execute (line 930)
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getSingleColumnResult()
  5.     {
  6.         return $this->execute(null, self::HYDRATE_SCALAR_COLUMN);
  7.     }
  9.     /**
  10.      * Gets the scalar results for the query.
  11.      *
AbstractQuery->getSingleColumnResult() in src/Service/BaseControllerService.php (line 148)
  1.             $language = $this->em->createQueryBuilder()
  2.                 ->select('l.id')
  3.                 ->from(Languages::class, 'l')
  4.                 ->where('l.code = :code')->setParameter('code', $locale)
  5.                 ->getQuery()
  6.                 ->getSingleColumnResult();
  8.             if (!empty($language))
  9.                 $languageId = $language[0];
  11.             $session->set('langIds', [$locale => $languageId]);
BaseControllerService->getLanguageId(object(Session), 'en') in src/Controller/CatalogueController.php (line 52)
  1.             'page' => '\d+',
  2.         ], 
  3.     )]
  4.     public function index(Request $request, Session $session, Security $security, BaseControllerService $baseControllerService, $projectDir, $page = 0): Response
  5.     {
  6.         $this->languageId = $baseControllerService->getLanguageId($session, $request->getLocale());
  8.         $pageCatalogue = $this->cache->get('CatalogueController.index', function ($item) {
  9.             $item->expiresAfter(Utils::getCacheTTL($this->appEnv)); // 10 minutes
  10.             return $this->em->getRepository(PageCatalogue::class)->find(1);
  11.         });
in vendor/symfony/http-kernel/HttpKernel.php -> index (line 183)
  1.         $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller = $event->getController();
  3.         $arguments = $event->getArguments();
  5.         // call controller
  6.         $response = $controller(...$arguments);
  8.         // view
  9.         if (!$response instanceof Response) {
  10.             $event = new ViewEvent($this, $request, $type, $response, $event);
  11.             $this->dispatcher->dispatch($event, KernelEvents::VIEW);
in vendor/symfony/http-kernel/HttpKernel.php -> handleRaw (line 76)
  1.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         $response = null;
  5.         try {
  6.             return $response = $this->handleRaw($request, $type);
  7.         } catch (\Throwable $e) {
  8.             if ($e instanceof \Error && !$this->handleAllThrowables) {
  9.                 throw $e;
  10.             }
in vendor/symfony/http-kernel/Kernel.php -> handle (line 193)
  1.         if (!$this->handlingHttpCache) {
  2.             $this->resetServices = true;
  3.         }
  5.         try {
  6.             return $this->getHttpKernel()->handle($request, $type, $catch);
  7.         } finally {
  8.             --$this->requestStackSize;
  9.         }
  10.     }
in vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php -> handle (line 35)
  1.     ) {
  2.     }
  4.     public function run(): int
  5.     {
  6.         $response = $this->kernel->handle($this->request);
  8.         if (Kernel::VERSION_ID >= 60400) {
  9.             $response->send(false);
  11.             if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  3. exit(
  4.     $runtime
  5.         ->getRunner($app)
  6.         ->run()
  7. );
require_once('/home/crartak/test/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  3. use App\Kernel;
  5. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  7. return function (array $context) {
  8.     return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  9. };

Logs

Level Channel Message
DEBUG 16:35:16 php Warning: Zend OPcache API is restricted by "restrict_api" configuration directive 
{
    "exception": {
        "severity": 2,
        "file": "/home/crartak/test/vendor/symfony/error-handler/DebugClassLoader.php",
        "line": 303,
        "trace": [
            {
                "file": "/home/crartak/test/vendor/doctrine/doctrine-bundle/src/DoctrineBundle.php",
                "line": 136,
                "function": "loadClass",
                "class": "Symfony\\Component\\ErrorHandler\\DebugClassLoader",
                "type": "->"
            }
        ],
        "count": 8
    }
}
INFO 16:35:16 request Matched route "_profiler". 
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "777402"
    },
    "request_uri": "https://www.test.cr-art-auctions.be/_profiler/777402",
    "method": "GET"
}
INFO 16:35:16 deprecation User Deprecated: In ORM 3.0, the AttributeDriver will report fields for the classes where they are declared. This may uncover invalid mapping configurations. To opt into the new mode today, set the "reportFieldsWhereDeclared" constructor parameter to true. (AttributeDriver.php:77 called by App_KernelDevDebugContainer.php:1298, https://github.com/doctrine/orm/pull/10455, package doctrine/orm) 
{
    "exception": {}
}

Stack Traces 3

[3/3] ConnectionException 
Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in the driver: SQLSTATE[HY000] [2002] Connection refused

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:112
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), null)
     (vendor/doctrine/dbal/src/Connection.php:1976)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), null)
     (vendor/doctrine/dbal/src/Connection.php:1924)
  at Doctrine\DBAL\Connection->convertException(object(Exception))
     (vendor/doctrine/dbal/src/Connection.php:385)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1692)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1087)
  at Doctrine\DBAL\Connection->executeQuery('SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = ?', array('en'), array(2), null)
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:31)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(object(Connection), array('en'), array(2))
     (vendor/doctrine/orm/src/Query.php:330)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:1213)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 6)
     (vendor/doctrine/orm/src/AbstractQuery.php:1167)
  at Doctrine\ORM\AbstractQuery->execute(null, 6)
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->getSingleColumnResult()
     (src/Service/BaseControllerService.php:148)
  at App\Service\BaseControllerService->getLanguageId(object(Session), 'en')
     (src/Controller/CatalogueController.php:52)
  at App\Controller\CatalogueController->index(object(Request), object(Session), object(Security), object(BaseControllerService), '/home/crartak/test', '46179')
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/home/crartak/test/vendor/autoload_runtime.php')
     (public/index.php:5)
[2/3] Exception 
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HY000] [2002] Connection refused

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:24
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:43)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Logging/Driver.php:34)
  at Doctrine\DBAL\Logging\Driver->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php:37)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect(array('driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'crartaktest.mysql.db', 'port' => 3306, 'user' => 'crartaktest', 'password' => 'iRPnl958T7wHiU8W', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'crartaktest', 'charset' => 'utf8mb4', 'serverVersion' => '13'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php:35)
  at Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver->connect(array('driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'crartaktest.mysql.db', 'port' => 3306, 'user' => 'crartaktest', 'password' => 'iRPnl958T7wHiU8W', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'crartaktest', 'charset' => 'utf8mb4', 'serverVersion' => '13'))
     (vendor/doctrine/dbal/src/Connection.php:383)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1692)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1087)
  at Doctrine\DBAL\Connection->executeQuery('SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = ?', array('en'), array(2), null)
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:31)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(object(Connection), array('en'), array(2))
     (vendor/doctrine/orm/src/Query.php:330)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:1213)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 6)
     (vendor/doctrine/orm/src/AbstractQuery.php:1167)
  at Doctrine\ORM\AbstractQuery->execute(null, 6)
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->getSingleColumnResult()
     (src/Service/BaseControllerService.php:148)
  at App\Service\BaseControllerService->getLanguageId(object(Session), 'en')
     (src/Controller/CatalogueController.php:52)
  at App\Controller\CatalogueController->index(object(Request), object(Session), object(Security), object(BaseControllerService), '/home/crartak/test', '46179')
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/home/crartak/test/vendor/autoload_runtime.php')
     (public/index.php:5)
[1/3] PDOException 
PDOException:
SQLSTATE[HY000] [2002] Connection refused

  at vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php:25
  at PDO->__construct('mysql:host=crartaktest.mysql.db;port=3306;dbname=crartaktest;charset=utf8mb4;', 'crartaktest', object(SensitiveParameterValue), array())
     (vendor/doctrine/dbal/src/Driver/PDO/PDOConnect.php:25)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->doConnect(object(SensitiveParameterValue), 'crartaktest', object(SensitiveParameterValue), array())
     (vendor/doctrine/dbal/src/Driver/PDO/MySQL/Driver.php:36)
  at Doctrine\DBAL\Driver\PDO\MySQL\Driver->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Logging/Driver.php:34)
  at Doctrine\DBAL\Logging\Driver->connect(object(SensitiveParameterValue))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Driver.php:37)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Driver->connect(array('driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'crartaktest.mysql.db', 'port' => 3306, 'user' => 'crartaktest', 'password' => 'iRPnl958T7wHiU8W', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'crartaktest', 'charset' => 'utf8mb4', 'serverVersion' => '13'))
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractDriverMiddleware.php:29)
  at Doctrine\DBAL\Driver\Middleware\AbstractDriverMiddleware->connect(object(SensitiveParameterValue))
     (vendor/symfony/doctrine-bridge/Middleware/IdleConnection/Driver.php:35)
  at Symfony\Bridge\Doctrine\Middleware\IdleConnection\Driver->connect(array('driver' => 'pdo_mysql', 'idle_connection_ttl' => 600, 'host' => 'crartaktest.mysql.db', 'port' => 3306, 'user' => 'crartaktest', 'password' => 'iRPnl958T7wHiU8W', 'driverOptions' => array(), 'defaultTableOptions' => array(), 'dbname' => 'crartaktest', 'charset' => 'utf8mb4', 'serverVersion' => '13'))
     (vendor/doctrine/dbal/src/Connection.php:383)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/src/Connection.php:1692)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/src/Connection.php:1087)
  at Doctrine\DBAL\Connection->executeQuery('SELECT l0_.id AS id_0 FROM languages l0_ WHERE l0_.code = ?', array('en'), array(2), null)
     (vendor/doctrine/orm/src/Query/Exec/FinalizedSelectExecutor.php:31)
  at Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute(object(Connection), array('en'), array(2))
     (vendor/doctrine/orm/src/Query.php:330)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/src/AbstractQuery.php:1213)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(null, 6)
     (vendor/doctrine/orm/src/AbstractQuery.php:1167)
  at Doctrine\ORM\AbstractQuery->execute(null, 6)
     (vendor/doctrine/orm/src/AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->getSingleColumnResult()
     (src/Service/BaseControllerService.php:148)
  at App\Service\BaseControllerService->getLanguageId(object(Session), 'en')
     (src/Controller/CatalogueController.php:52)
  at App\Controller\CatalogueController->index(object(Request), object(Session), object(Security), object(BaseControllerService), '/home/crartak/test', '46179')
     (vendor/symfony/http-kernel/HttpKernel.php:183)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:76)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:193)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (vendor/autoload_runtime.php:32)
  at require_once('/home/crartak/test/vendor/autoload_runtime.php')
     (public/index.php:5)