17 10 2025 23:26:11 El Archivo 2025-10-17 - log_error.txt se ha creado ************************************************************ -- LM-ERROR: HTTP/1.1 500 Internal Server Error Date: Sat, 18 Oct 2025 04:26:11 GMT Server: Apache/2.4.41 (Ubuntu) X-Powered-By: PHP/8.1.27 Access-Control-Allow-Origin: * Access-Control-Allow-Headers: X-API-KEY, Origin, X-Requested-With, Content-Type, Accept, Access-Control-Request-Method, Authorization, Authentication Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE Allow: GET, POST, OPTIONS, PUT, DELETE X-Debug-Exception: An%20exception%20occurred%20in%20the%20driver%3A%20SQLSTATE%5B08006%5D%20%5B7%5D%20connection%20to%20server%20at%20%2210.231.0.132%22%2C%20port%205432%20failed%3A%20timeout%20expired X-Debug-Exception-File: %2Fwww%2Fphp81%2Fserversoap%2Frecaudos%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FPostgreSQL%2FExceptionConverter.php:77 Cache-Control: no-cache, private X-Robots-Tag: noindex Connection: close Content-Type: text/html; charset=UTF-8 X-Original-Transfer-Encoding: chunked Content-Length: 298333
case '42P07': return new TableExistsException($exception, $query); case '08006': return new ConnectionException($exception, $query); } // Prior to fixing https://bugs.php.net/bug.php?id=64705 (PHP 7.4.10), // in some cases (mainly connection errors) the PDO exception wouldn't provide a SQLSTATE via its code. // We have to match against the SQLSTATE in the error message in these cases. private function handleDriverException( Driver\Exception $driverException, ?Query $query ): DriverException { $this->exceptionConverter ??= $this->_driver->getExceptionConverter(); $exception = $this->exceptionConverter->convert($driverException, $query); if ($exception instanceof ConnectionLost) { $this->close(); } } /** @internal */ final public function convertException(Driver\Exception $e): DriverException { return $this->handleDriverException($e, null); } /** * @param array<int, mixed>|array<string, mixed> $params * @param array<int, int|string|Type|null>|array<string, int|string|Type|null> $types } try { $this->_conn = $this->_driver->connect($this->params); } catch (Driver\Exception $e) { throw $this->convertException($e); } if ($this->autoCommit === false) { $this->beginTransaction(); } 'https://github.com/doctrine/dbal/issues/4966', 'Connection::getWrappedConnection() is deprecated.' . ' Use Connection::getNativeConnection() to access the native connection.', ); $this->connect(); assert($this->_conn !== null); return $this->_conn; } * * @throws Exception */ public function prepare(string $sql): Statement { $connection = $this->getWrappedConnection(); try { $statement = $connection->prepare($sql); } catch (Driver\Exception $e) { throw $this->convertExceptionDuringQuery($e, $sql); ); //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); /* switch ($con) { case 6: case 5: $resultSet = $stmt->executeQuery(); case 24: case 25: return $this->consulta_socket($con,$sql); break; default: return $this->query_normal($con,$sql); break; } } } $name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null; $operador = (!empty($params[0]->operador)) ? $params[0]->operador : null; $version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null; $sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)"; $res_man = $this->cnn->query('0', $sql_man); if (count($res_man) <= 0) { $respuesta["datos"] = "No se encontro ninguna version de SEM"; return $response->setContent(json_encode($respuesta)); } $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS); $controller = $event->getController(); $arguments = $event->getArguments(); // call controller $response = $controller(...$arguments); // view if (!$response instanceof Response) { $event = new ViewEvent($this, $request, $type, $response, $event); $this->dispatcher->dispatch($event, KernelEvents::VIEW); { $request->headers->set('X-Php-Ob-Level', (string) ob_get_level()); $this->requestStack->push($request); try { return $this->handleRaw($request, $type); } catch (\Throwable $e) { if ($e instanceof \Error && !$this->handleAllThrowables) { throw $e; } $this->boot(); ++$this->requestStackSize; $this->resetServices = true; try { return $this->getHttpKernel()->handle($request, $type, $catch); } finally { --$this->requestStackSize; } } $this->request = $request; } public function run(): int { $response = $this->kernel->handle($this->request); $response->send(); if ($this->kernel instanceof TerminableInterface) { $this->kernel->terminate($this->request, $response); }$app = $app(...$args);exit( $runtime ->getRunner($app) ->run());$method = $_SERVER['REQUEST_METHOD'];if($method == "OPTIONS") { die();}require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) { return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);}; } else { $code = $exception->getCode(); $sqlState = null; } return new self($exception->getMessage(), $sqlState, $code, $exception); }} $params['user'] ?? '', $params['password'] ?? '', $driverOptions, ); } catch (PDOException $exception) { throw Exception::new($exception); } if ( ! isset($driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES]) || $driverOptions[PDO::PGSQL_ATTR_DISABLE_PREPARES] === true if ($this->_conn !== null) { return false; } try { $this->_conn = $this->_driver->connect($this->params); } catch (Driver\Exception $e) { throw $this->convertException($e); } if ($this->autoCommit === false) { 'https://github.com/doctrine/dbal/issues/4966', 'Connection::getWrappedConnection() is deprecated.' . ' Use Connection::getNativeConnection() to access the native connection.', ); $this->connect(); assert($this->_conn !== null); return $this->_conn; } * * @throws Exception */ public function prepare(string $sql): Statement { $connection = $this->getWrappedConnection(); try { $statement = $connection->prepare($sql); } catch (Driver\Exception $e) { throw $this->convertExceptionDuringQuery($e, $sql); ); //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); /* switch ($con) { case 6: case 5: $resultSet = $stmt->executeQuery(); case 24: case 25: return $this->consulta_socket($con,$sql); break; default: return $this->query_normal($con,$sql); break; } } } $name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null; $operador = (!empty($params[0]->operador)) ? $params[0]->operador : null; $version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null; $sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)"; $res_man = $this->cnn->query('0', $sql_man); if (count($res_man) <= 0) { $respuesta["datos"] = "No se encontro ninguna version de SEM"; return $response->setContent(json_encode($respuesta)); } $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS); $controller = $event->getController(); $arguments = $event->getArguments(); // call controller $response = $controller(...$arguments); // view if (!$response instanceof Response) { $event = new ViewEvent($this, $request, $type, $response, $event); $this->dispatcher->dispatch($event, KernelEvents::VIEW); { $request->headers->set('X-Php-Ob-Level', (string) ob_get_level()); $this->requestStack->push($request); try { return $this->handleRaw($request, $type); } catch (\Throwable $e) { if ($e instanceof \Error && !$this->handleAllThrowables) { throw $e; } $this->boot(); ++$this->requestStackSize; $this->resetServices = true; try { return $this->getHttpKernel()->handle($request, $type, $catch); } finally { --$this->requestStackSize; } } $this->request = $request; } public function run(): int { $response = $this->kernel->handle($this->request); $response->send(); if ($this->kernel instanceof TerminableInterface) { $this->kernel->terminate($this->request, $response); }$app = $app(...$args);exit( $runtime ->getRunner($app) ->run());$method = $_SERVER['REQUEST_METHOD'];if($method == "OPTIONS") { die();}require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) { return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);}; $driverOptions[PDO::ATTR_PERSISTENT] = true; } try { $pdo = new PDO( $this->constructPdoDsn($params), $params['user'] ?? '', $params['password'] ?? '', $driverOptions, ); } catch (PDOException $exception) { $driverOptions[PDO::ATTR_PERSISTENT] = true; } try { $pdo = new PDO( $this->constructPdoDsn($params), $params['user'] ?? '', $params['password'] ?? '', $driverOptions, ); } catch (PDOException $exception) { if ($this->_conn !== null) { return false; } try { $this->_conn = $this->_driver->connect($this->params); } catch (Driver\Exception $e) { throw $this->convertException($e); } if ($this->autoCommit === false) { 'https://github.com/doctrine/dbal/issues/4966', 'Connection::getWrappedConnection() is deprecated.' . ' Use Connection::getNativeConnection() to access the native connection.', ); $this->connect(); assert($this->_conn !== null); return $this->_conn; } * * @throws Exception */ public function prepare(string $sql): Statement { $connection = $this->getWrappedConnection(); try { $statement = $connection->prepare($sql); } catch (Driver\Exception $e) { throw $this->convertExceptionDuringQuery($e, $sql); ); //$cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); // $this->log->logs("Inicio ejecucion sql0"); $this->cnn = \Doctrine\DBAL\DriverManager::getConnection($connectionParams, $config); //$sql = "SELECT * FROM articles"; $stmt = $this->cnn->prepare($sql); /* switch ($con) { case 6: case 5: $resultSet = $stmt->executeQuery(); case 24: case 25: return $this->consulta_socket($con,$sql); break; default: return $this->query_normal($con,$sql); break; } } } $name_device = (!empty($params[0]->name_device)) ? $params[0]->name_device : null; $operador = (!empty($params[0]->operador)) ? $params[0]->operador : null; $version_app = (!empty($params[0]->version_app)) ? $params[0]->version_app : null; $sql_man = "SELECT version,estado_modulos FROM sem_versiones sv2 WHERE id = (SELECT max(id) FROM sem_versiones sv WHERE estado = 0)"; $res_man = $this->cnn->query('0', $sql_man); if (count($res_man) <= 0) { $respuesta["datos"] = "No se encontro ninguna version de SEM"; return $response->setContent(json_encode($respuesta)); } $this->dispatcher->dispatch($event, KernelEvents::CONTROLLER_ARGUMENTS); $controller = $event->getController(); $arguments = $event->getArguments(); // call controller $response = $controller(...$arguments); // view if (!$response instanceof Response) { $event = new ViewEvent($this, $request, $type, $response, $event); $this->dispatcher->dispatch($event, KernelEvents::VIEW); { $request->headers->set('X-Php-Ob-Level', (string) ob_get_level()); $this->requestStack->push($request); try { return $this->handleRaw($request, $type); } catch (\Throwable $e) { if ($e instanceof \Error && !$this->handleAllThrowables) { throw $e; } $this->boot(); ++$this->requestStackSize; $this->resetServices = true; try { return $this->getHttpKernel()->handle($request, $type, $catch); } finally { --$this->requestStackSize; } } $this->request = $request; } public function run(): int { $response = $this->kernel->handle($this->request); $response->send(); if ($this->kernel instanceof TerminableInterface) { $this->kernel->terminate($this->request, $response); }$app = $app(...$args);exit( $runtime ->getRunner($app) ->run());$method = $_SERVER['REQUEST_METHOD'];if($method == "OPTIONS") { die();}require_once dirname(__DIR__).'/vendor/autoload_runtime.php';return function (array $context) { return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);};No log messages
|
[3/3]
ConnectionException
|
|---|
Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in the driver: SQLSTATE[08006] [7] connection to server at "10.231.0.132", port 5432 failed: timeout expired
at vendor/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php:77
at Doctrine\DBAL\Driver\API\PostgreSQL\ExceptionConverter->convert()
(vendor/doctrine/dbal/src/Connection.php:1908)
at Doctrine\DBAL\Connection->handleDriverException()
(vendor/doctrine/dbal/src/Connection.php:1857)
at Doctrine\DBAL\Connection->convertException()
(vendor/doctrine/dbal/src/Connection.php:348)
at Doctrine\DBAL\Connection->connect()
(vendor/doctrine/dbal/src/Connection.php:1619)
at Doctrine\DBAL\Connection->getWrappedConnection()
(vendor/doctrine/dbal/src/Connection.php:1013)
at Doctrine\DBAL\Connection->prepare()
(src/Services/Conexion.php:563)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:537)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:2902)
at App\Controller\PtatController->login_movil()
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:184)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:29)
at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|
|
[2/3]
Exception
|
|---|
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[08006] [7] connection to server at "10.231.0.132", port 5432 failed: timeout expired
at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
at Doctrine\DBAL\Driver\PDO\Exception::new()
(vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:35)
at Doctrine\DBAL\Driver\PDO\PgSQL\Driver->connect()
(vendor/doctrine/dbal/src/Connection.php:346)
at Doctrine\DBAL\Connection->connect()
(vendor/doctrine/dbal/src/Connection.php:1619)
at Doctrine\DBAL\Connection->getWrappedConnection()
(vendor/doctrine/dbal/src/Connection.php:1013)
at Doctrine\DBAL\Connection->prepare()
(src/Services/Conexion.php:563)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:537)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:2902)
at App\Controller\PtatController->login_movil()
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:184)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:29)
at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|
|
[1/3]
PDOException
|
|---|
PDOException:
SQLSTATE[08006] [7] connection to server at "10.231.0.132", port 5432 failed: timeout expired
at vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:29
at PDO->__construct()
(vendor/doctrine/dbal/src/Driver/PDO/PgSQL/Driver.php:29)
at Doctrine\DBAL\Driver\PDO\PgSQL\Driver->connect()
(vendor/doctrine/dbal/src/Connection.php:346)
at Doctrine\DBAL\Connection->connect()
(vendor/doctrine/dbal/src/Connection.php:1619)
at Doctrine\DBAL\Connection->getWrappedConnection()
(vendor/doctrine/dbal/src/Connection.php:1013)
at Doctrine\DBAL\Connection->prepare()
(src/Services/Conexion.php:563)
at App\Services\Conexion->query_normal()
(src/Services/Conexion.php:537)
at App\Services\Conexion->query()
(src/Controller/PtatController.php:2902)
at App\Controller\PtatController->login_movil()
(vendor/symfony/http-kernel/HttpKernel.php:163)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
(vendor/symfony/http-kernel/HttpKernel.php:74)
at Symfony\Component\HttpKernel\HttpKernel->handle()
(vendor/symfony/http-kernel/Kernel.php:184)
at Symfony\Component\HttpKernel\Kernel->handle()
(vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35)
at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
(vendor/autoload_runtime.php:29)
at require_once('/www/php81/serversoap/recaudos/vendor/autoload_runtime.php')
(public/index.php:16)
|