Error 500 Internal Server Error

GET http://server.tail2daa0b.ts.net/_profiler/6d6aa7?panel=dump&type=request

Forwarded to ErrorController (9d548a)

Exceptions

Error: Maximum execution time of 30 seconds exceeded

Exception

Symfony\Component\ErrorHandler\Error\ MaxExecutionTimeError

Show exception properties
Symfony\Component\ErrorHandler\Error\MaxExecutionTimeError {#609
  -error: array:4 [
    "type" => 1
    "message" => "Maximum execution time of 30 seconds exceeded"
    "file" => "C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query\AST\Node.php"
    "line" => 24
  ]
}
  1. /**
  2. * Abstract class of an AST node.
  3. *
  4. * @link www.doctrine-project.org
  5. */
  6. abstract class Node implements Stringable
  7. {
  8. /**
  9. * Double-dispatch method, supposed to dispatch back to the walker.
  10. *
  11. * Implementation is not mandatory for all nodes.
  1. // no-op
  2. } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
  3. include $file;
  4. return;
  5. } elseif (false === include $file) {
  6. return;
  7. }
  8. } else {
  9. ($this->classLoader)($class);
  10. $file = '';
  1. /**
  2. * UpdateStatement = UpdateClause [WhereClause]
  3. *
  4. * @link www.doctrine-project.org
  5. */
  6. class UpdateStatement extends Node
  7. {
  8. public WhereClause|null $whereClause = null;
  9. public function __construct(public UpdateClause $updateClause)
  10. {
  1. // no-op
  2. } elseif (\function_exists('opcache_is_script_cached') && @opcache_is_script_cached($file)) {
  3. include $file;
  4. return;
  5. } elseif (false === include $file) {
  6. return;
  7. }
  8. } else {
  9. ($this->classLoader)($class);
  10. $file = '';
  1. /**
  2. * UpdateStatement ::= UpdateClause [WhereClause]
  3. */
  4. public function UpdateStatement(): AST\UpdateStatement
  5. {
  6. $updateStatement = new AST\UpdateStatement($this->UpdateClause());
  7. $updateStatement->whereClause = $this->lexer->isNextToken(TokenType::T_WHERE) ? $this->WhereClause() : null;
  8. return $updateStatement;
  9. }
  1. case TokenType::T_SELECT:
  2. $statement = $this->SelectStatement();
  3. break;
  4. case TokenType::T_UPDATE:
  5. $statement = $this->UpdateStatement();
  6. break;
  7. case TokenType::T_DELETE:
  8. $statement = $this->DeleteStatement();
  9. break;
  1. * Parses and builds AST for the given Query.
  2. */
  3. public function getAST(): AST\SelectStatement|AST\UpdateStatement|AST\DeleteStatement
  4. {
  5. // Parse & build AST
  6. $AST = $this->QueryLanguage();
  7. // Process any deferred validations of some nodes in the AST.
  8. // This also allows post-processing of the AST for modification purposes.
  9. $this->processDeferredIdentificationVariables();
  1. /**
  2. * Parses a query string.
  3. */
  4. public function parse(): ParserResult
  5. {
  6. $AST = $this->getAST();
  7. $customWalkers = $this->query->getHint(Query::HINT_CUSTOM_TREE_WALKERS);
  8. if ($customWalkers !== false) {
  9. $this->customTreeWalkers = $customWalkers;
  10. }
  1. }
  2. // Cache miss.
  3. $parser = new Parser($this);
  4. $this->parserResult = $parser->parse();
  5. $queryCache->save($cacheItem->set($this->parserResult)->expiresAfter($this->queryCacheTTL));
  6. return $this->parserResult;
  7. }
  1. $this->state = self::STATE_DIRTY;
  2. }
  3. private function getSqlExecutor(): AbstractSqlExecutor
  4. {
  5. return $this->parse()->prepareSqlExecutor($this);
  6. }
  7. }
  1. return $this->parserResult;
  2. }
  3. protected function _doExecute(): Result|int
  4. {
  5. $executor = $this->getSqlExecutor();
  6. if ($this->queryCacheProfile) {
  7. $executor->setQueryCacheProfile($this->queryCacheProfile);
  8. } else {
  9. $executor->removeQueryCacheProfile();
  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;
AbstractQuery->executeIgnoreQueryCache() in C:\Users\jayve\moderators\vendor\doctrine\orm\src\AbstractQuery.php (line 886)
  1. ): mixed {
  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. if (!$e->isMainRequest()) return;
  2. try {
  3. $this->em->createQuery(
  4. 'UPDATE App\Entity\Attendance a SET a.clockOut = a.autoOut, a.autoClosed = true
  5. WHERE a.clockOut IS NULL AND a.autoOut IS NOT NULL AND a.autoOut <= :now'
  6. )->setParameter('now', new \DateTimeImmutable(), 'datetime_immutable')->execute();
  7. } catch (\Throwable) {
  8. // tables not created yet — ignore
  9. }
  10. }
  11. }
  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. }
TraceableEventDispatcher->dispatch() in C:\Users\jayve\moderators\vendor\symfony\http-kernel\HttpKernel.php (line 164)
  1. */
  2. private function handleRaw(Request $request, int $type = self::MAIN_REQUEST, ?ControllerMetadata &$controllerMetadata = null): Response
  3. {
  4. // request
  5. $event = new RequestEvent($this, $request, $type);
  6. $this->dispatcher->dispatch($event, KernelEvents::REQUEST);
  7. if ($event->hasResponse()) {
  8. return $this->filterResponse($event->getResponse(), $request, $type);
  9. }
  1. $request->headers->set('X-Php-Ob-Level', (string) ob_get_level());
  2. $this->requestStack->push($request);
  3. $response = null;
  4. try {
  5. return $response = $this->handleRaw($request, $type, $controllerMetadata);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  1. if (!$this->handlingHttpCache) {
  2. $this->resetServices = true;
  3. }
  4. try {
  5. return $this->getHttpKernel()->handle($request, $type, $catch);
  6. } finally {
  7. --$this->requestStackSize;
  8. }
  9. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. $response->send(false);
  7. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
  8. fastcgi_finish_request();
HttpKernelRunner->run() in C:\Users\jayve\moderators\vendor\autoload_runtime.php (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return static function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Logs

Level Channel Message
DEBUG 15:39:24 php User Warning: Configure the "curl.cainfo", "openssl.cafile" or "openssl.capath" php.ini setting to enable the CurlHttpClient
{
    "exception": {
        "severity": 512,
        "file": "C:\\Users\\jayve\\moderators\\vendor\\symfony\\http-client\\HttpClient.php",
        "line": 57,
        "trace": [
            {
                "file": "C:\\Users\\jayve\\moderators\\var\\cache\\dev\\ContainerZxPf1Ec\\App_KernelDevDebugContainer.php",
                "line": 1682,
                "function": "create",
                "class": "Symfony\\Component\\HttpClient\\HttpClient",
                "type": "::"
            }
        ],
        "count": 1
    }
}
DEBUG 15:39:24 php User Notice: Upgrade the curl extension or run "composer require amphp/http-client:^5" to perform async HTTP operations, including full HTTP/2 support
{
    "exception": {
        "severity": 1024,
        "file": "C:\\Users\\jayve\\moderators\\vendor\\symfony\\http-client\\HttpClient.php",
        "line": 64,
        "trace": [
            {
                "file": "C:\\Users\\jayve\\moderators\\var\\cache\\dev\\ContainerZxPf1Ec\\App_KernelDevDebugContainer.php",
                "line": 1682,
                "function": "create",
                "class": "Symfony\\Component\\HttpClient\\HttpClient",
                "type": "::"
            }
        ],
        "count": 1
    }
}
INFO 15:39:24 request Matched route "_profiler".
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "latest"
    },
    "request_uri": "http://server.tail2daa0b.ts.net/_profiler/latest?type=request&url=http%3A%2F%2Fserver.tail2daa0b.ts.net%2Frobots.txt",
    "method": "GET"
}
INFO 15:39:24 deprecation User Deprecated: Support for MySQL < 8 is deprecated and will be removed in DBAL 5 (AbstractMySQLDriver.php:80 called by AbstractDriverMiddleware.php:32, https://github.com/doctrine/dbal/pull/6343, package doctrine/dbal)
{
    "exception": {}
}
INFO 15:39:24 doctrine Connecting with parameters {params}
{
    "params": {
        "driver": "pdo_mysql",
        "idle_connection_ttl": 600,
        "host": "127.0.0.1",
        "port": 3312,
        "user": "root",
        "password": "<redacted>",
        "driverOptions": [],
        "defaultTableOptions": [],
        "dbname": "moderators",
        "serverVersion": "8.0",
        "charset": "utf8mb4"
    }
}
DEBUG 15:39:24 doctrine Executing statement: UPDATE attendance SET clock_out = auto_out, auto_closed = 1 WHERE clock_out IS NULL AND auto_out IS NOT NULL AND auto_out <= ? (parameters: {params}, types: {types})

                            

Stack Trace

MaxExecutionTimeError
Symfony\Component\ErrorHandler\Error\MaxExecutionTimeError:
Error: Maximum execution time of 30 seconds exceeded

  at C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query\AST\Node.php:24
  at include()
     (C:\Users\jayve\moderators\vendor\symfony\error-handler\DebugClassLoader.php:350)
  at Symfony\Component\ErrorHandler\DebugClassLoader->loadClass()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query\AST\UpdateStatement.php:14)
  at include()
     (C:\Users\jayve\moderators\vendor\symfony\error-handler\DebugClassLoader.php:350)
  at Symfony\Component\ErrorHandler\DebugClassLoader->loadClass()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query\Parser.php:863)
  at Doctrine\ORM\Query\Parser->UpdateStatement()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query\Parser.php:823)
  at Doctrine\ORM\Query\Parser->QueryLanguage()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query\Parser.php:243)
  at Doctrine\ORM\Query\Parser->getAST()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query\Parser.php:335)
  at Doctrine\ORM\Query\Parser->parse()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query.php:248)
  at Doctrine\ORM\Query->parse()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query.php:717)
  at Doctrine\ORM\Query->getSqlExecutor()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\Query.php:257)
  at Doctrine\ORM\Query->_doExecute()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\AbstractQuery.php:930)
  at Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache()
     (C:\Users\jayve\moderators\vendor\doctrine\orm\src\AbstractQuery.php:886)
  at Doctrine\ORM\AbstractQuery->execute()
     (C:\Users\jayve\moderators\src\EventSubscriber\AutoClockOutSubscriber.php:26)
  at App\EventSubscriber\AutoClockOutSubscriber->sweep()
     (C:\Users\jayve\moderators\vendor\symfony\event-dispatcher\Debug\WrappedListener.php:115)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke()
     (C:\Users\jayve\moderators\vendor\symfony\event-dispatcher\EventDispatcher.php:206)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
     (C:\Users\jayve\moderators\vendor\symfony\event-dispatcher\EventDispatcher.php:56)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
     (C:\Users\jayve\moderators\vendor\symfony\event-dispatcher\Debug\TraceableEventDispatcher.php:129)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch()
     (C:\Users\jayve\moderators\vendor\symfony\http-kernel\HttpKernel.php:164)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (C:\Users\jayve\moderators\vendor\symfony\http-kernel\HttpKernel.php:79)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (C:\Users\jayve\moderators\vendor\symfony\http-kernel\Kernel.php:143)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (C:\Users\jayve\moderators\vendor\symfony\runtime\Runner\Symfony\HttpKernelRunner.php:34)
  at Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run()
     (C:\Users\jayve\moderators\vendor\autoload_runtime.php:32)
  at require_once()
     (C:\Users\jayve\moderators\public\index.php:5)