mysqli_sql_exception ExecutionFailureException

HTTP 500 Whoops, looks like something went wrong.

Query execution was interrupted (max_statement_time exceeded)

Exceptions 2

Joomla\Database\Exception\ ExecutionFailureException

Show exception properties 
Joomla\Database\Exception\ExecutionFailureException {#1234
  -query: "SHOW SESSION STATUS WHERE `Variable_name` IN ('Ssl_version', 'Ssl_cipher')"
}
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 411)
  1.         try {
  2.             if (!$this->statement->execute()) {
  3.                 throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  4.             }
  5.         } catch (\Throwable $e) {
  6.             throw new ExecutionFailureException($this->query, $e->getMessage(), $e->getCode(), $e);
  7.         }
  9.         if ($this->columnNames === null) {
  10.             $meta = $this->statement->result_metadata();
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 651)
  1.         foreach ($bounded as $key => $obj) {
  2.             $this->statement->bindParam($key, $obj->value, $obj->dataType);
  3.         }
  5.         try {
  6.             $this->executed = $this->statement->execute();
  8.             // If there is a monitor registered, let it know we have finished this query
  9.             if ($this->monitor) {
  10.                 $this->monitor->stopQuery();
  11.             }
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 1304)
  1.                 $this->statement->setFetchMode($fetchMode, $class);
  2.             }
  3.         }
  5.         // Execute the query and get the result set cursor.
  6.         $this->execute();
  8.         // Get all of the rows from the result set as objects of type $class.
  9.         while ($row = $this->fetchObject()) {
  10.             if ($key) {
  11.                 $array[$row->$key] = $row;
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> loadObjectList (line 492)
  1.     public function getConnectionEncryption(): string
  2.     {
  3.         $this->connect();
  5.         $variables = $this->setQuery('SHOW SESSION STATUS WHERE `Variable_name` IN (\'Ssl_version\', \'Ssl_cipher\')')
  6.             ->loadObjectList('Variable_name');
  8.         if (!empty($variables['Ssl_cipher']->Value)) {
  9.             return $variables['Ssl_version']->Value . ' (' . $variables['Ssl_cipher']->Value . ')';
  10.         }
MysqliDriver->getConnectionEncryption() in /usr/share/nginx/nili/administrator/components/com_admin/src/Model/SysinfoModel.php (line 321)
  1.             'php'                    => php_uname(),
  2.             'dbserver'               => $db->getServerType(),
  3.             'dbversion'              => $db->getVersion(),
  4.             'dbcollation'            => $db->getCollation(),
  5.             'dbconnectioncollation'  => $db->getConnectionCollation(),
  6.             'dbconnectionencryption' => $db->getConnectionEncryption(),
  7.             'dbconnencryptsupported' => $db->isConnectionEncryptionSupported(),
  8.             'phpversion'             => PHP_VERSION,
  9.             'server'                 => $_SERVER['SERVER_SOFTWARE'] ?? getenv('SERVER_SOFTWARE'),
  10.             'sapi_name'              => PHP_SAPI,
  11.             'version'                => (new Version())->getLongVersion(),
SysinfoModel->getInfo() in /usr/share/nginx/nili/plugins/system/debug/src/DataCollector/InfoCollector.php (line 136)
  1.             'joomlaVersion' => JVERSION,
  2.             'requestId'     => $this->requestId,
  3.             'identity'      => $this->getIdentityInfo($application->getIdentity()),
  4.             'response'      => $this->getResponseInfo($application->getResponse()),
  5.             'template'      => $this->getTemplateInfo($application->getTemplate(true)),
  6.             'database'      => $this->getDatabaseInfo($model->getInfo()),
  7.         ];
  8.     }
  10.     /**
  11.      * Get Identity info.
in /usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 238)
  1.                 $request_variables
  2.             )
  3.         );
  5.         foreach ($this->collectors as $name => $collector) {
  6.             $this->data[$name] = $collector->collect();
  7.         }
  9.         // Remove all invalid (non UTF-8) characters
  10.         array_walk_recursive($this->data, function (&$item) {
  11.                 if (is_string($item) && !mb_check_encoding($item, 'UTF-8')) {
in /usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 265)
  1.      * @return array
  2.      */
  3.     public function getData()
  4.     {
  5.         if ($this->data === null) {
  6.             $this->collect();
  7.         }
  8.         return $this->data;
  9.     }
  11.     /**
DebugBar->getData() in /usr/share/nginx/nili/plugins/system/debug/src/JavascriptRenderer.php (line 119)
  1.                 $js .= $this->getAddDatasetCode($id, $data, '(stacked)');
  2.             }
  3.         }
  5.         $suffix = !$initialize ? '(ajax)' : null;
  6.         $js .= $this->getAddDatasetCode($this->debugBar->getCurrentRequestId(), $this->debugBar->getData(), $suffix);
  8.         $nonce = '';
  10.         if ($doc->cspNonce) {
  11.             $nonce = ' nonce="' . $doc->cspNonce . '"';
JavascriptRenderer->render() in /usr/share/nginx/nili/plugins/system/debug/src/Extension/Debug.php (line 368)
  1.             echo $contents;
  3.             return;
  4.         }
  6.         echo str_replace('</body>', $debugBarRenderer->renderHead() . $debugBarRenderer->render() . '</body>', $contents);
  7.     }
  9.     /**
  10.      * AJAX handler
  11.      *
in /usr/share/nginx/nili/libraries/vendor/joomla/event/src/Dispatcher.php -> onAfterRespond (line 454)
  1.             foreach ($this->listeners[$event->getName()] as $listener) {
  2.                 if ($event->isStopped()) {
  3.                     return $event;
  4.                 }
  6.                 $listener($event);
  7.             }
  8.         }
  10.         return $event;
  11.     }
in /usr/share/nginx/nili/libraries/vendor/joomla/application/src/AbstractApplication.php -> dispatch (line 99)
  1.             $dispatcher = $this->getDispatcher();
  2.         } catch (\UnexpectedValueException $exception) {
  3.             return null;
  4.         }
  6.         return $dispatcher->dispatch($eventName, $event ?: new ApplicationEvent($eventName, $this));
  7.     }
  9.     /**
  10.      * Method to run the application routines.
  11.      *
AbstractApplication->dispatchEvent() in /usr/share/nginx/nili/libraries/src/Application/CMSApplication.php (line 351)
  1.         $this->respond();
  3.         // Trigger the onAfterRespond event.
  4.         $this->dispatchEvent(
  5.             'onAfterRespond',
  6.             new AfterRespondEvent('onAfterRespond', ['subject' => $this])
  7.         );
  8.     }
  10.     /**
  11.      * Check if the user is required to reset their password.
CMSApplication->execute() in /usr/share/nginx/nili/includes/app.php (line 58)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/usr/share/nginx/nili/includes/app.php') in /usr/share/nginx/nili/index.php (line 32)
  1.  * define() is used rather than "const" to not error for PHP 5.2 and lower
  2.  */
  3. define('_JEXEC', 1);
  5. // Run the application - All executable code should be triggered through this file
  6. require_once dirname(__FILE__) . '/includes/app.php';

mysqli_sql_exception

Query execution was interrupted (max_statement_time exceeded)

in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php (line 407)
  1.                 throw new PrepareStatementFailureException($this->statement->error, $this->statement->errno);
  2.             }
  3.         }
  5.         try {
  6.             if (!$this->statement->execute()) {
  7.                 throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  8.             }
  9.         } catch (\Throwable $e) {
  10.             throw new ExecutionFailureException($this->query, $e->getMessage(), $e->getCode(), $e);
  11.         }
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php -> execute (line 407)
  1.                 throw new PrepareStatementFailureException($this->statement->error, $this->statement->errno);
  2.             }
  3.         }
  5.         try {
  6.             if (!$this->statement->execute()) {
  7.                 throw new ExecutionFailureException($this->query, $this->statement->error, $this->statement->errno);
  8.             }
  9.         } catch (\Throwable $e) {
  10.             throw new ExecutionFailureException($this->query, $e->getMessage(), $e->getCode(), $e);
  11.         }
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 651)
  1.         foreach ($bounded as $key => $obj) {
  2.             $this->statement->bindParam($key, $obj->value, $obj->dataType);
  3.         }
  5.         try {
  6.             $this->executed = $this->statement->execute();
  8.             // If there is a monitor registered, let it know we have finished this query
  9.             if ($this->monitor) {
  10.                 $this->monitor->stopQuery();
  11.             }
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php -> execute (line 1304)
  1.                 $this->statement->setFetchMode($fetchMode, $class);
  2.             }
  3.         }
  5.         // Execute the query and get the result set cursor.
  6.         $this->execute();
  8.         // Get all of the rows from the result set as objects of type $class.
  9.         while ($row = $this->fetchObject()) {
  10.             if ($key) {
  11.                 $array[$row->$key] = $row;
in /usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php -> loadObjectList (line 492)
  1.     public function getConnectionEncryption(): string
  2.     {
  3.         $this->connect();
  5.         $variables = $this->setQuery('SHOW SESSION STATUS WHERE `Variable_name` IN (\'Ssl_version\', \'Ssl_cipher\')')
  6.             ->loadObjectList('Variable_name');
  8.         if (!empty($variables['Ssl_cipher']->Value)) {
  9.             return $variables['Ssl_version']->Value . ' (' . $variables['Ssl_cipher']->Value . ')';
  10.         }
MysqliDriver->getConnectionEncryption() in /usr/share/nginx/nili/administrator/components/com_admin/src/Model/SysinfoModel.php (line 321)
  1.             'php'                    => php_uname(),
  2.             'dbserver'               => $db->getServerType(),
  3.             'dbversion'              => $db->getVersion(),
  4.             'dbcollation'            => $db->getCollation(),
  5.             'dbconnectioncollation'  => $db->getConnectionCollation(),
  6.             'dbconnectionencryption' => $db->getConnectionEncryption(),
  7.             'dbconnencryptsupported' => $db->isConnectionEncryptionSupported(),
  8.             'phpversion'             => PHP_VERSION,
  9.             'server'                 => $_SERVER['SERVER_SOFTWARE'] ?? getenv('SERVER_SOFTWARE'),
  10.             'sapi_name'              => PHP_SAPI,
  11.             'version'                => (new Version())->getLongVersion(),
SysinfoModel->getInfo() in /usr/share/nginx/nili/plugins/system/debug/src/DataCollector/InfoCollector.php (line 136)
  1.             'joomlaVersion' => JVERSION,
  2.             'requestId'     => $this->requestId,
  3.             'identity'      => $this->getIdentityInfo($application->getIdentity()),
  4.             'response'      => $this->getResponseInfo($application->getResponse()),
  5.             'template'      => $this->getTemplateInfo($application->getTemplate(true)),
  6.             'database'      => $this->getDatabaseInfo($model->getInfo()),
  7.         ];
  8.     }
  10.     /**
  11.      * Get Identity info.
in /usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 238)
  1.                 $request_variables
  2.             )
  3.         );
  5.         foreach ($this->collectors as $name => $collector) {
  6.             $this->data[$name] = $collector->collect();
  7.         }
  9.         // Remove all invalid (non UTF-8) characters
  10.         array_walk_recursive($this->data, function (&$item) {
  11.                 if (is_string($item) && !mb_check_encoding($item, 'UTF-8')) {
in /usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php -> collect (line 265)
  1.      * @return array
  2.      */
  3.     public function getData()
  4.     {
  5.         if ($this->data === null) {
  6.             $this->collect();
  7.         }
  8.         return $this->data;
  9.     }
  11.     /**
DebugBar->getData() in /usr/share/nginx/nili/plugins/system/debug/src/JavascriptRenderer.php (line 119)
  1.                 $js .= $this->getAddDatasetCode($id, $data, '(stacked)');
  2.             }
  3.         }
  5.         $suffix = !$initialize ? '(ajax)' : null;
  6.         $js .= $this->getAddDatasetCode($this->debugBar->getCurrentRequestId(), $this->debugBar->getData(), $suffix);
  8.         $nonce = '';
  10.         if ($doc->cspNonce) {
  11.             $nonce = ' nonce="' . $doc->cspNonce . '"';
JavascriptRenderer->render() in /usr/share/nginx/nili/plugins/system/debug/src/Extension/Debug.php (line 368)
  1.             echo $contents;
  3.             return;
  4.         }
  6.         echo str_replace('</body>', $debugBarRenderer->renderHead() . $debugBarRenderer->render() . '</body>', $contents);
  7.     }
  9.     /**
  10.      * AJAX handler
  11.      *
in /usr/share/nginx/nili/libraries/vendor/joomla/event/src/Dispatcher.php -> onAfterRespond (line 454)
  1.             foreach ($this->listeners[$event->getName()] as $listener) {
  2.                 if ($event->isStopped()) {
  3.                     return $event;
  4.                 }
  6.                 $listener($event);
  7.             }
  8.         }
  10.         return $event;
  11.     }
in /usr/share/nginx/nili/libraries/vendor/joomla/application/src/AbstractApplication.php -> dispatch (line 99)
  1.             $dispatcher = $this->getDispatcher();
  2.         } catch (\UnexpectedValueException $exception) {
  3.             return null;
  4.         }
  6.         return $dispatcher->dispatch($eventName, $event ?: new ApplicationEvent($eventName, $this));
  7.     }
  9.     /**
  10.      * Method to run the application routines.
  11.      *
AbstractApplication->dispatchEvent() in /usr/share/nginx/nili/libraries/src/Application/CMSApplication.php (line 351)
  1.         $this->respond();
  3.         // Trigger the onAfterRespond event.
  4.         $this->dispatchEvent(
  5.             'onAfterRespond',
  6.             new AfterRespondEvent('onAfterRespond', ['subject' => $this])
  7.         );
  8.     }
  10.     /**
  11.      * Check if the user is required to reset their password.
CMSApplication->execute() in /usr/share/nginx/nili/includes/app.php (line 58)
  2. // Set the application as global app
  3. \Joomla\CMS\Factory::$application = $app;
  5. // Execute the application.
  6. $app->execute();
require_once('/usr/share/nginx/nili/includes/app.php') in /usr/share/nginx/nili/index.php (line 32)
  1.  * define() is used rather than "const" to not error for PHP 5.2 and lower
  2.  */
  3. define('_JEXEC', 1);
  5. // Run the application - All executable code should be triggered through this file
  6. require_once dirname(__FILE__) . '/includes/app.php';

Stack Traces 2

[2/2] ExecutionFailureException 
Joomla\Database\Exception\ExecutionFailureException:
Query execution was interrupted (max_statement_time exceeded)

  at /usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:411
  at Joomla\Database\Mysqli\MysqliStatement->execute()
     (/usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php:651)
  at Joomla\Database\DatabaseDriver->execute()
     (/usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php:1304)
  at Joomla\Database\DatabaseDriver->loadObjectList()
     (/usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:492)
  at Joomla\Database\Mysqli\MysqliDriver->getConnectionEncryption()
     (/usr/share/nginx/nili/administrator/components/com_admin/src/Model/SysinfoModel.php:321)
  at Joomla\Component\Admin\Administrator\Model\SysinfoModel->getInfo()
     (/usr/share/nginx/nili/plugins/system/debug/src/DataCollector/InfoCollector.php:136)
  at Joomla\Plugin\System\Debug\DataCollector\InfoCollector->collect()
     (/usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:238)
  at DebugBar\DebugBar->collect()
     (/usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:265)
  at DebugBar\DebugBar->getData()
     (/usr/share/nginx/nili/plugins/system/debug/src/JavascriptRenderer.php:119)
  at Joomla\Plugin\System\Debug\JavascriptRenderer->render()
     (/usr/share/nginx/nili/plugins/system/debug/src/Extension/Debug.php:368)
  at Joomla\Plugin\System\Debug\Extension\Debug->onAfterRespond()
     (/usr/share/nginx/nili/libraries/vendor/joomla/event/src/Dispatcher.php:454)
  at Joomla\Event\Dispatcher->dispatch()
     (/usr/share/nginx/nili/libraries/vendor/joomla/application/src/AbstractApplication.php:99)
  at Joomla\Application\AbstractApplication->dispatchEvent()
     (/usr/share/nginx/nili/libraries/src/Application/CMSApplication.php:351)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/usr/share/nginx/nili/includes/app.php:58)
  at require_once('/usr/share/nginx/nili/includes/app.php')
     (/usr/share/nginx/nili/index.php:32)
[1/2] mysqli_sql_exception 
mysqli_sql_exception:
Query execution was interrupted (max_statement_time exceeded)

  at /usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407
  at mysqli_stmt->execute()
     (/usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407)
  at Joomla\Database\Mysqli\MysqliStatement->execute()
     (/usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php:651)
  at Joomla\Database\DatabaseDriver->execute()
     (/usr/share/nginx/nili/libraries/vendor/joomla/database/src/DatabaseDriver.php:1304)
  at Joomla\Database\DatabaseDriver->loadObjectList()
     (/usr/share/nginx/nili/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:492)
  at Joomla\Database\Mysqli\MysqliDriver->getConnectionEncryption()
     (/usr/share/nginx/nili/administrator/components/com_admin/src/Model/SysinfoModel.php:321)
  at Joomla\Component\Admin\Administrator\Model\SysinfoModel->getInfo()
     (/usr/share/nginx/nili/plugins/system/debug/src/DataCollector/InfoCollector.php:136)
  at Joomla\Plugin\System\Debug\DataCollector\InfoCollector->collect()
     (/usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:238)
  at DebugBar\DebugBar->collect()
     (/usr/share/nginx/nili/libraries/vendor/maximebf/debugbar/src/DebugBar/DebugBar.php:265)
  at DebugBar\DebugBar->getData()
     (/usr/share/nginx/nili/plugins/system/debug/src/JavascriptRenderer.php:119)
  at Joomla\Plugin\System\Debug\JavascriptRenderer->render()
     (/usr/share/nginx/nili/plugins/system/debug/src/Extension/Debug.php:368)
  at Joomla\Plugin\System\Debug\Extension\Debug->onAfterRespond()
     (/usr/share/nginx/nili/libraries/vendor/joomla/event/src/Dispatcher.php:454)
  at Joomla\Event\Dispatcher->dispatch()
     (/usr/share/nginx/nili/libraries/vendor/joomla/application/src/AbstractApplication.php:99)
  at Joomla\Application\AbstractApplication->dispatchEvent()
     (/usr/share/nginx/nili/libraries/src/Application/CMSApplication.php:351)
  at Joomla\CMS\Application\CMSApplication->execute()
     (/usr/share/nginx/nili/includes/app.php:58)
  at require_once('/usr/share/nginx/nili/includes/app.php')
     (/usr/share/nginx/nili/index.php:32)