http://opendata.kedirikab.go.id/index.php/dataset?page=117

Exceptions

An exception occurred in driver: SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?

Exceptions 3

Doctrine\DBAL\Exception\ ConnectionException

  1.             case '42P07':
  2.                 return new TableExistsException($message$exception);
  3.             case '08006':
  4.                 return new Exception\ConnectionException($message$exception);
  5.             case '7':
  6.                 // Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.3.22 and PHP 7.4.10),
  7.                 // in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code.
  8.                 // The exception code would be always set to 7 here.
  1.         if ($driverEx instanceof DriverException) {
  2.             return $driverEx;
  3.         }
  4.         if ($driver instanceof ExceptionConverterDriver && $driverEx instanceof DeprecatedDriverException) {
  5.             return $driver->convertException($msg$driverEx);
  6.         }
  7.         return new Exception($msg0$driverEx);
  8.     }
  1.      *
  2.      * @return Exception
  3.      */
  4.     public static function driverException(Driver $driverThrowable $driverEx)
  5.     {
  6.         return self::wrapException($driver$driverEx'An exception occurred in driver: ' $driverEx->getMessage());
  7.     }
  8.     /**
  9.      * @return Exception
  10.      */
  1.                 $pdo->exec('SET NAMES \'' $params['charset'] . '\'');
  2.             }
  3.             return $pdo;
  4.         } catch (PDOException $e) {
  5.             throw Exception::driverException($this$e);
  6.         }
  7.     }
  8.     /**
  9.      * Constructs the Postgres PDO DSN.
  1.         $driverOptions $this->params['driverOptions'] ?? [];
  2.         $user          $this->params['user'] ?? null;
  3.         $password      $this->params['password'] ?? null;
  4.         $this->_conn $this->_driver->connect($this->params$user$password$driverOptions);
  5.         $this->transactionNestingLevel 0;
  6.         if ($this->autoCommit === false) {
  7.             $this->beginTransaction();
  1.      *
  2.      * @return DriverConnection
  3.      */
  4.     public function getWrappedConnection()
  5.     {
  6.         $this->connect();
  7.         assert($this->_conn !== null);
  8.         return $this->_conn;
  9.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> getWrappedConnection (line 1290)
  1.     {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql$params$types$qcp);
  4.         }
  5.         $connection $this->getWrappedConnection();
  6.         $logger $this->_config->getSQLLogger();
  7.         if ($logger) {
  8.             $logger->startQuery($sql$params$types);
  9.         }
  1.      *
  2.      * @return Result
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  5.         return $executor->execute($this->_em->getConnection(), $sqlParams$types);
  6.     }
  7.     /**
  8.      * @param array<string,mixed> $sqlParams
  9.      * @param array<string,Type>  $types
  1.             $setCacheEntry = static function ($data) use ($cache$result$cacheItem$realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  5.         $stmt $this->_doExecute();
  6.         if (is_numeric($stmt)) {
  7.             $setCacheEntry($stmt);
  8.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 1166)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters$hydrationMode);
  4.         }
  5.         return $this->executeIgnoreQueryCache($parameters$hydrationMode);
  6.     }
  7.     /**
  8.      * Execute query ignoring second level cache.
  9.      *
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getScalarResult()
  5.     {
  6.         return $this->execute(nullself::HYDRATE_SCALAR);
  7.     }
  8.     /**
  9.      * Get exactly one result or null.
  10.      *
  1.     #[ReturnTypeWillChange]
  2.     public function count()
  3.     {
  4.         if ($this->count === null) {
  5.             try {
  6.                 $this->count = (int) array_sum(array_map('current'$this->getCountQuery()->getScalarResult()));
  7.             } catch (NoResultException $e) {
  8.                 $this->count 0;
  9.             }
  10.         }
Paginator->count()
  1.         $paginator = new Paginator($event->target$fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count count($paginator);
  7.         }
  8.         $event->items iterator_to_array($paginator);
  9.     }
  10.     public static function getSubscribedEvents(): array
  1.         $this->priority $dispatcher->getListenerPriority($eventName$this->listener);
  2.         $e $this->stopwatch->start($this->name'event_listener');
  3.         try {
  4.             ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         } finally {
  6.             if ($e->isStarted()) {
  7.                 $e->stop();
  8.             }
  9.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         $this->eventDispatcher->dispatch($beforeEvent'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page ceil($itemsEvent->count $limit)) {
  11.             $pageOutOfRangeOption $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
  1.     public function paginate($targetint $page 1, ?int $limit null, array $options = []) : \Knp\Component\Pager\Pagination\PaginationInterface
  2.     {
  3.         $this->initializer56dfc && ($this->initializer56dfc->__invoke($valueHolderd14db$this'paginate', array('target' => $target'page' => $page'limit' => $limit'options' => $options), $this->initializer56dfc) || 1) && $this->valueHolderd14db $valueHolderd14db;
  4.         if ($this->valueHolderd14db === $returnValue $this->valueHolderd14db->paginate($target$page$limit$options)) {
  5.             return $this;
  6.         }
  7.         return $returnValue;
  8.     }
PaginatorInterface_82dac15->paginate() in src/Controller/Frontend/DatasetController.php (line 79)
  1.             $queryBuilder $queryBuilder->andWhere("this.sektor = " $request->get('sektor'));
  2.         }
  3.         $queryBuilder $queryBuilder->addOrderBy('this.id''desc');
  4.         // dump($queryBuilder->getQuery()->getResult());exit;
  5.         $pagination $paginatorInterface->paginate($queryBuilder$request->query->getInt('page'1), 10);
  6.         $kategori = array();
  7.         $icons = array();
  8.         foreach ($pagination as $pub) {
  9.             $kategori_detail $mUrusanDetailRepository->findBy(['reff_id' => $pub->getId(), 'reff_name' => 'PUBLIKASI'], ['id' => 'ASC']);
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
Kernel->handle() in public/index.php (line 20)
  1.     Debug::enable();
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  4. $request Request::createFromGlobals();
  5. $response $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request$response);

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections?

  1.  */
  2. final class Exception extends PDOException
  3. {
  4.     public static function new(\PDOException $exception): self
  5.     {
  6.         return new self($exception);
  7.     }
  8. }
  1.         try {
  2.             parent::__construct($dsn, (string) $user, (string) $password, (array) $options);
  3.             $this->setAttribute(PDO::ATTR_STATEMENT_CLASS, [Statement::class, []]);
  4.             $this->setAttribute(PDO::ATTR_ERRMODEPDO::ERRMODE_EXCEPTION);
  5.         } catch (PDOException $exception) {
  6.             throw Exception::new($exception);
  7.         }
  8.     }
  9.     /**
  10.      * {@inheritdoc}
  1.      */
  2.     public function connect(array $params$username null$password null, array $driverOptions = [])
  3.     {
  4.         try {
  5.             $pdo = new PDO\Connection(
  6.                 $this->_constructPdoDsn($params),
  7.                 $username,
  8.                 $password,
  9.                 $driverOptions
  10.             );
  1.         $driverOptions $this->params['driverOptions'] ?? [];
  2.         $user          $this->params['user'] ?? null;
  3.         $password      $this->params['password'] ?? null;
  4.         $this->_conn $this->_driver->connect($this->params$user$password$driverOptions);
  5.         $this->transactionNestingLevel 0;
  6.         if ($this->autoCommit === false) {
  7.             $this->beginTransaction();
  1.      *
  2.      * @return DriverConnection
  3.      */
  4.     public function getWrappedConnection()
  5.     {
  6.         $this->connect();
  7.         assert($this->_conn !== null);
  8.         return $this->_conn;
  9.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> getWrappedConnection (line 1290)
  1.     {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql$params$types$qcp);
  4.         }
  5.         $connection $this->getWrappedConnection();
  6.         $logger $this->_config->getSQLLogger();
  7.         if ($logger) {
  8.             $logger->startQuery($sql$params$types);
  9.         }
  1.      *
  2.      * @return Result
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  5.         return $executor->execute($this->_em->getConnection(), $sqlParams$types);
  6.     }
  7.     /**
  8.      * @param array<string,mixed> $sqlParams
  9.      * @param array<string,Type>  $types
  1.             $setCacheEntry = static function ($data) use ($cache$result$cacheItem$realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  5.         $stmt $this->_doExecute();
  6.         if (is_numeric($stmt)) {
  7.             $setCacheEntry($stmt);
  8.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 1166)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters$hydrationMode);
  4.         }
  5.         return $this->executeIgnoreQueryCache($parameters$hydrationMode);
  6.     }
  7.     /**
  8.      * Execute query ignoring second level cache.
  9.      *
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getScalarResult()
  5.     {
  6.         return $this->execute(nullself::HYDRATE_SCALAR);
  7.     }
  8.     /**
  9.      * Get exactly one result or null.
  10.      *
  1.     #[ReturnTypeWillChange]
  2.     public function count()
  3.     {
  4.         if ($this->count === null) {
  5.             try {
  6.                 $this->count = (int) array_sum(array_map('current'$this->getCountQuery()->getScalarResult()));
  7.             } catch (NoResultException $e) {
  8.                 $this->count 0;
  9.             }
  10.         }
Paginator->count()
  1.         $paginator = new Paginator($event->target$fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count count($paginator);
  7.         }
  8.         $event->items iterator_to_array($paginator);
  9.     }
  10.     public static function getSubscribedEvents(): array
  1.         $this->priority $dispatcher->getListenerPriority($eventName$this->listener);
  2.         $e $this->stopwatch->start($this->name'event_listener');
  3.         try {
  4.             ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         } finally {
  6.             if ($e->isStarted()) {
  7.                 $e->stop();
  8.             }
  9.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         $this->eventDispatcher->dispatch($beforeEvent'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page ceil($itemsEvent->count $limit)) {
  11.             $pageOutOfRangeOption $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
  1.     public function paginate($targetint $page 1, ?int $limit null, array $options = []) : \Knp\Component\Pager\Pagination\PaginationInterface
  2.     {
  3.         $this->initializer56dfc && ($this->initializer56dfc->__invoke($valueHolderd14db$this'paginate', array('target' => $target'page' => $page'limit' => $limit'options' => $options), $this->initializer56dfc) || 1) && $this->valueHolderd14db $valueHolderd14db;
  4.         if ($this->valueHolderd14db === $returnValue $this->valueHolderd14db->paginate($target$page$limit$options)) {
  5.             return $this;
  6.         }
  7.         return $returnValue;
  8.     }
PaginatorInterface_82dac15->paginate() in src/Controller/Frontend/DatasetController.php (line 79)
  1.             $queryBuilder $queryBuilder->andWhere("this.sektor = " $request->get('sektor'));
  2.         }
  3.         $queryBuilder $queryBuilder->addOrderBy('this.id''desc');
  4.         // dump($queryBuilder->getQuery()->getResult());exit;
  5.         $pagination $paginatorInterface->paginate($queryBuilder$request->query->getInt('page'1), 10);
  6.         $kategori = array();
  7.         $icons = array();
  8.         foreach ($pagination as $pub) {
  9.             $kategori_detail $mUrusanDetailRepository->findBy(['reff_id' => $pub->getId(), 'reff_name' => 'PUBLIKASI'], ['id' => 'ASC']);
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
Kernel->handle() in public/index.php (line 20)
  1.     Debug::enable();
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  4. $request Request::createFromGlobals();
  5. $response $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request$response);

PDOException

SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections?

  1.      * @throws PDOException In case of an error.
  2.      */
  3.     public function __construct($dsn$user null$password null, ?array $options null)
  4.     {
  5.         try {
  6.             parent::__construct($dsn, (string) $user, (string) $password, (array) $options);
  7.             $this->setAttribute(PDO::ATTR_STATEMENT_CLASS, [Statement::class, []]);
  8.             $this->setAttribute(PDO::ATTR_ERRMODEPDO::ERRMODE_EXCEPTION);
  9.         } catch (PDOException $exception) {
  10.             throw Exception::new($exception);
  11.         }
  1.      * @throws PDOException In case of an error.
  2.      */
  3.     public function __construct($dsn$user null$password null, ?array $options null)
  4.     {
  5.         try {
  6.             parent::__construct($dsn, (string) $user, (string) $password, (array) $options);
  7.             $this->setAttribute(PDO::ATTR_STATEMENT_CLASS, [Statement::class, []]);
  8.             $this->setAttribute(PDO::ATTR_ERRMODEPDO::ERRMODE_EXCEPTION);
  9.         } catch (PDOException $exception) {
  10.             throw Exception::new($exception);
  11.         }
  1.      */
  2.     public function connect(array $params$username null$password null, array $driverOptions = [])
  3.     {
  4.         try {
  5.             $pdo = new PDO\Connection(
  6.                 $this->_constructPdoDsn($params),
  7.                 $username,
  8.                 $password,
  9.                 $driverOptions
  10.             );
  1.         $driverOptions $this->params['driverOptions'] ?? [];
  2.         $user          $this->params['user'] ?? null;
  3.         $password      $this->params['password'] ?? null;
  4.         $this->_conn $this->_driver->connect($this->params$user$password$driverOptions);
  5.         $this->transactionNestingLevel 0;
  6.         if ($this->autoCommit === false) {
  7.             $this->beginTransaction();
  1.      *
  2.      * @return DriverConnection
  3.      */
  4.     public function getWrappedConnection()
  5.     {
  6.         $this->connect();
  7.         assert($this->_conn !== null);
  8.         return $this->_conn;
  9.     }
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php -> getWrappedConnection (line 1290)
  1.     {
  2.         if ($qcp !== null) {
  3.             return $this->executeCacheQuery($sql$params$types$qcp);
  4.         }
  5.         $connection $this->getWrappedConnection();
  6.         $logger $this->_config->getSQLLogger();
  7.         if ($logger) {
  8.             $logger->startQuery($sql$params$types);
  9.         }
  1.      *
  2.      * @return Result
  3.      */
  4.     public function execute(Connection $conn, array $params, array $types)
  5.     {
  6.         return $conn->executeQuery($this->_sqlStatements$params$types$this->queryCacheProfile);
  7.     }
  8. }
  1.             $sqlParams,
  2.             $types,
  3.             $this->_em->getConnection()->getParams()
  4.         );
  5.         return $executor->execute($this->_em->getConnection(), $sqlParams$types);
  6.     }
  7.     /**
  8.      * @param array<string,mixed> $sqlParams
  9.      * @param array<string,Type>  $types
  1.             $setCacheEntry = static function ($data) use ($cache$result$cacheItem$realCacheKey): void {
  2.                 $cache->save($cacheItem->set($result + [$realCacheKey => $data]));
  3.             };
  4.         }
  5.         $stmt $this->_doExecute();
  6.         if (is_numeric($stmt)) {
  7.             $setCacheEntry($stmt);
  8.             return $stmt;
in vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php -> executeIgnoreQueryCache (line 1166)
  1.     {
  2.         if ($this->cacheable && $this->isCacheEnabled()) {
  3.             return $this->executeUsingQueryCache($parameters$hydrationMode);
  4.         }
  5.         return $this->executeIgnoreQueryCache($parameters$hydrationMode);
  6.     }
  7.     /**
  8.      * Execute query ignoring second level cache.
  9.      *
  1.      *
  2.      * @return mixed[]
  3.      */
  4.     public function getScalarResult()
  5.     {
  6.         return $this->execute(nullself::HYDRATE_SCALAR);
  7.     }
  8.     /**
  9.      * Get exactly one result or null.
  10.      *
  1.     #[ReturnTypeWillChange]
  2.     public function count()
  3.     {
  4.         if ($this->count === null) {
  5.             try {
  6.                 $this->count = (int) array_sum(array_map('current'$this->getCountQuery()->getScalarResult()));
  7.             } catch (NoResultException $e) {
  8.                 $this->count 0;
  9.             }
  10.         }
Paginator->count()
  1.         $paginator = new Paginator($event->target$fetchJoinCollection);
  2.         $paginator->setUseOutputWalkers($useOutputWalkers);
  3.         if (($count $event->target->getHint(self::HINT_COUNT)) !== false) {
  4.             $event->count = (int) $count;
  5.         } else {
  6.             $event->count count($paginator);
  7.         }
  8.         $event->items iterator_to_array($paginator);
  9.     }
  10.     public static function getSubscribedEvents(): array
  1.         $this->priority $dispatcher->getListenerPriority($eventName$this->listener);
  2.         $e $this->stopwatch->start($this->name'event_listener');
  3.         try {
  4.             ($this->optimizedListener ?? $this->listener)($event$eventName$dispatcher);
  5.         } finally {
  6.             if ($e->isStarted()) {
  7.                 $e->stop();
  8.             }
  9.         }
  1.         foreach ($listeners as $listener) {
  2.             if ($stoppable && $event->isPropagationStopped()) {
  3.                 break;
  4.             }
  5.             $listener($event$eventName$this);
  6.         }
  7.     }
  8.     /**
  9.      * Sorts the internal list of listeners for the given event by priority.
  1.         } else {
  2.             $listeners $this->getListeners($eventName);
  3.         }
  4.         if ($listeners) {
  5.             $this->callListeners($listeners$eventName$event);
  6.         }
  7.         return $event;
  8.     }
  1.         try {
  2.             $this->beforeDispatch($eventName$event);
  3.             try {
  4.                 $e $this->stopwatch->start($eventName'section');
  5.                 try {
  6.                     $this->dispatcher->dispatch($event$eventName);
  7.                 } finally {
  8.                     if ($e->isStarted()) {
  9.                         $e->stop();
  10.                     }
  11.                 }
  1.         $this->eventDispatcher->dispatch($beforeEvent'knp_pager.before');
  2.         // items
  3.         $itemsEvent = new Event\ItemsEvent($offset$limit);
  4.         $itemsEvent->options = &$options;
  5.         $itemsEvent->target = &$target;
  6.         $this->eventDispatcher->dispatch($itemsEvent'knp_pager.items');
  7.         if (!$itemsEvent->isPropagationStopped()) {
  8.             throw new \RuntimeException('One of listeners must count and slice given target');
  9.         }
  10.         if ($page ceil($itemsEvent->count $limit)) {
  11.             $pageOutOfRangeOption $options[PaginatorInterface::PAGE_OUT_OF_RANGE] ?? $this->defaultOptions[PaginatorInterface::PAGE_OUT_OF_RANGE];
  1.     public function paginate($targetint $page 1, ?int $limit null, array $options = []) : \Knp\Component\Pager\Pagination\PaginationInterface
  2.     {
  3.         $this->initializer56dfc && ($this->initializer56dfc->__invoke($valueHolderd14db$this'paginate', array('target' => $target'page' => $page'limit' => $limit'options' => $options), $this->initializer56dfc) || 1) && $this->valueHolderd14db $valueHolderd14db;
  4.         if ($this->valueHolderd14db === $returnValue $this->valueHolderd14db->paginate($target$page$limit$options)) {
  5.             return $this;
  6.         }
  7.         return $returnValue;
  8.     }
PaginatorInterface_82dac15->paginate() in src/Controller/Frontend/DatasetController.php (line 79)
  1.             $queryBuilder $queryBuilder->andWhere("this.sektor = " $request->get('sektor'));
  2.         }
  3.         $queryBuilder $queryBuilder->addOrderBy('this.id''desc');
  4.         // dump($queryBuilder->getQuery()->getResult());exit;
  5.         $pagination $paginatorInterface->paginate($queryBuilder$request->query->getInt('page'1), 10);
  6.         $kategori = array();
  7.         $icons = array();
  8.         foreach ($pagination as $pub) {
  9.             $kategori_detail $mUrusanDetailRepository->findBy(['reff_id' => $pub->getId(), 'reff_name' => 'PUBLIKASI'], ['id' => 'ASC']);
  1.         $this->dispatcher->dispatch($eventKernelEvents::CONTROLLER_ARGUMENTS);
  2.         $controller $event->getController();
  3.         $arguments $event->getArguments();
  4.         // call controller
  5.         $response $controller(...$arguments);
  6.         // view
  7.         if (!$response instanceof Response) {
  8.             $event = new ViewEvent($this$request$type$response);
  9.             $this->dispatcher->dispatch($eventKernelEvents::VIEW);
  1.     {
  2.         $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  3.         $this->requestStack->push($request);
  4.         try {
  5.             return $this->handleRaw($request$type);
  6.         } catch (\Exception $e) {
  7.             if ($e instanceof RequestExceptionInterface) {
  8.                 $e = new BadRequestHttpException($e->getMessage(), $e);
  9.             }
  10.             if (false === $catch) {
  1.         $this->boot();
  2.         ++$this->requestStackSize;
  3.         $this->resetServices true;
  4.         try {
  5.             return $this->getHttpKernel()->handle($request$type$catch);
  6.         } finally {
  7.             --$this->requestStackSize;
  8.         }
  9.     }
Kernel->handle() in public/index.php (line 20)
  1.     Debug::enable();
  2. }
  3. $kernel = new Kernel($_SERVER['APP_ENV'], (bool) $_SERVER['APP_DEBUG']);
  4. $request Request::createFromGlobals();
  5. $response $kernel->handle($request);
  6. $response->send();
  7. $kernel->terminate($request$response);

Stack Traces 3

[3/3] ConnectionException
Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in driver: SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused
	Is the server running on that host and accepting TCP/IP connections?

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:88
  at Doctrine\DBAL\Driver\AbstractPostgreSQLDriver->convertException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182)
  at Doctrine\DBAL\DBALException::wrapException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169)
  at Doctrine\DBAL\DBALException::driverException()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOPgSql/Driver.php:52)
  at Doctrine\DBAL\Driver\PDOPgSql\Driver->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1290)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:937)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:118)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:93)
  at Knp\Component\Pager\Paginator->paginate()
     (var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php:30)
  at ContainerF3J4NcO\PaginatorInterface_82dac15->paginate()
     (src/Controller/Frontend/DatasetController.php:79)
  at App\Controller\Frontend\DatasetController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:20)                
[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused
	Is the server running on that host and accepting TCP/IP connections?

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:44)
  at Doctrine\DBAL\Driver\PDOConnection->__construct()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOPgSql/Driver.php:27)
  at Doctrine\DBAL\Driver\PDOPgSql\Driver->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1290)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:937)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:118)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:93)
  at Knp\Component\Pager\Paginator->paginate()
     (var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php:30)
  at ContainerF3J4NcO\PaginatorInterface_82dac15->paginate()
     (src/Controller/Frontend/DatasetController.php:79)
  at App\Controller\Frontend\DatasetController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:20)                
[1/3] PDOException
PDOException:
SQLSTATE[08006] [7] connection to server at "127.0.0.1", port 5432 failed: Connection refused
	Is the server running on that host and accepting TCP/IP connections?

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
  at PDO->__construct()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40)
  at Doctrine\DBAL\Driver\PDOConnection->__construct()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOPgSql/Driver.php:27)
  at Doctrine\DBAL\Driver\PDOPgSql\Driver->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1290)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php:31)
  at Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Query.php:325)
  at Doctrine\ORM\Query->_doExecute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1212)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:1166)
  at Doctrine\ORM\AbstractQuery->execute()
     (vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php:937)
  at Doctrine\ORM\AbstractQuery->getScalarResult()
     (vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php:118)
  at Doctrine\ORM\Tools\Pagination\Paginator->count()
  at count()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Event/Subscriber/Paginate/Doctrine/ORM/QuerySubscriber.php:46)
  at Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items()
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:118)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:230)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (vendor/symfony/event-dispatcher/EventDispatcher.php:59)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:154)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (vendor/knplabs/knp-components/src/Knp/Component/Pager/Paginator.php:93)
  at Knp\Component\Pager\Paginator->paginate()
     (var/cache/dev/ContainerF3J4NcO/PaginatorInterface_82dac15.php:30)
  at ContainerF3J4NcO\PaginatorInterface_82dac15->paginate()
     (src/Controller/Frontend/DatasetController.php:79)
  at App\Controller\Frontend\DatasetController->index()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:20)