Error 500 Internal Server Error

GET https://dc-mining-monitoring-new-test.test.itlabs.top/api/agent/v1/samples

Exceptions

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'expected_seconds' doesn't have a default value

Exceptions 3

Doctrine\DBAL\Exception\ NotNullConstraintViolationException

Show exception properties
Doctrine\DBAL\Exception\NotNullConstraintViolationException {#750
  -query: Doctrine\DBAL\Query {#748
    -sql: """
      \r\n
      INSERT INTO asic_uptime_bucket\r\n
      (location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at)\r\n
      SELECT\r\n
        ? AS location_id,\r\n
        d.asic_id,\r\n
        d.client_id,\r\n
        d.client_name,\r\n
        'hour' AS granularity,\r\n
        d.period_start,\r\n
        d.online,\r\n
        ? AS updated_at\r\n
      FROM (\r\n
        SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online\r\n
      ) d\r\n
      ON DUPLICATE KEY UPDATE\r\n
        online_seconds   = asic_uptime_bucket.online_seconds + VALUES(online_seconds),\r\n
        updated_at       = VALUES(updated_at),\r\n
        client_name      = VALUES(client_name)\r\n
      """
    -params: array:32 [
      0 => 2
      1 => "2026-03-23 15:45:33"
      2 => 1
      3 => 2
      4 => "ivan"
      5 => "2026-03-23 15:00:00"
      6 => 30
      7 => 13
      8 => 2
      9 => "ivan"
      10 => "2026-03-23 15:00:00"
      11 => 30
      12 => 15
      13 => 2
      14 => "ivan"
      15 => "2026-03-23 15:00:00"
      16 => 0
      17 => 8
      18 => 2
      19 => "ivan"
      20 => "2026-03-23 15:00:00"
      21 => 0
      22 => 9
      23 => 2
      24 => "ivan"
      25 => "2026-03-23 15:00:00"
      26 => 0
      27 => 16
      28 => 2
      29 => "ivan"
      30 => "2026-03-23 15:00:00"
      31 => 0
    ]
    -types: []
  }
}
  1. 1138,
  2. 1171,
  3. 1252,
  4. 1263,
  5. 1364,
  6. 1566 => new NotNullConstraintViolationException($exception, $query),
  7. default => new DriverException($exception, $query),
  8. };
  9. }
  10. }
  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);
  7. if ($exception instanceof ConnectionLost) {
  8. $this->close();
  9. }
in vendor/doctrine/dbal/src/Connection.php -> handleDriverException (line 1396)
  1. Driver\Exception $e,
  2. string $sql,
  3. array $params = [],
  4. array $types = [],
  5. ): DriverException {
  6. return $this->handleDriverException($e, new Query($sql, $params, $types));
  7. }
  8. /** @internal */
  9. final public function convertException(Driver\Exception $e): DriverException
  10. {
in vendor/doctrine/dbal/src/Connection.php -> convertExceptionDuringQuery (line 911)
  1. ->rowCount();
  2. }
  3. return $connection->exec($sql);
  4. } catch (Driver\Exception $e) {
  5. throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
  6. }
  7. }
  8. /**
  9. * Returns the current transaction nesting level.
Connection->executeStatement(' INSERT INTO asic_uptime_bucket (location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at) SELECT ? AS location_id, d.asic_id, d.client_id, d.client_name, \'hour\' AS granularity, d.period_start, d.online, ? AS updated_at FROM ( SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online ) d ON DUPLICATE KEY UPDATE online_seconds = asic_uptime_bucket.online_seconds + VALUES(online_seconds), updated_at = VALUES(updated_at), client_name = VALUES(client_name) ', array(2, '2026-03-23 15:45:33', 1, 2, 'ivan', '2026-03-23 15:00:00', 30, 13, 2, 'ivan', '2026-03-23 15:00:00', 30, 15, 2, 'ivan', '2026-03-23 15:00:00', 0, 8, 2, 'ivan', '2026-03-23 15:00:00', 0, 9, 2, 'ivan', '2026-03-23 15:00:00', 0, 16, 2, 'ivan', '2026-03-23 15:00:00', 0)) in src/Service/UptimeBucketWriter.php (line 94)
  1. // порядок важен: сначала location_id, потом updated_at, потом параметры derived-таблицы
  2. array_unshift($params, $updatedAtMsk);
  3. array_unshift($params, $locationId);
  4. $this->conn->executeStatement($sql, $params);
  5. }
  6. }
UptimeBucketWriter->upsertHourDeltas(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'))) in src/Service/UptimeBucketWriter.php (line 43)
  1. public function addHourSamplesBulk(int $locationId, array $deltas, int $chunkSize = 1000): void
  2. {
  3. if ($deltas === []) return;
  4. foreach (array_chunk($deltas, $chunkSize) as $chunk) {
  5. $this->upsertHourDeltas($locationId, $chunk);
  6. }
  7. }
  8. private function upsertHourDeltas(int $locationId, array $rows): void
  9. {
UptimeBucketWriter->addHourSamplesBulk(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')), 1000) in src/Controller/Api/AgentApiController.php (line 304)
  1. if ($asicMaxTs !== []) {
  2. $this->batchUpdateAsicStatus($asicMaxTs, 500);
  3. }
  4. if ($bucketDeltas !== []) {
  5. $this->bucketWriter->addHourSamplesBulk(
  6. locationId: $location->getId(),
  7. deltas: array_values($bucketDeltas),
  8. chunkSize: 1000
  9. );
  10. }
  1. $this->dispatcher->dispatch($event, KernelEvents::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, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  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);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  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. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. if (Kernel::VERSION_ID >= 60400) {
  7. $response->send(false);
  8. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Doctrine\DBAL\Driver\PDO\ Exception

SQLSTATE[HY000]: General error: 1364 Field 'expected_seconds' doesn't have a default value

  1. } else {
  2. $code = $exception->getCode();
  3. $sqlState = null;
  4. }
  5. return new self($exception->getMessage(), $sqlState, $code, $exception);
  6. }
  7. }
  1. public function execute(): Result
  2. {
  3. try {
  4. $this->stmt->execute();
  5. } catch (PDOException $exception) {
  6. throw Exception::new($exception);
  7. }
  8. return new Result($this->stmt);
  9. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  1. $stmt = $connection->prepare($sql);
  2. $this->bindParameters($stmt, $params, $types);
  3. return $stmt->execute()
  4. ->rowCount();
  5. }
  6. return $connection->exec($sql);
  7. } catch (Driver\Exception $e) {
Connection->executeStatement(' INSERT INTO asic_uptime_bucket (location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at) SELECT ? AS location_id, d.asic_id, d.client_id, d.client_name, \'hour\' AS granularity, d.period_start, d.online, ? AS updated_at FROM ( SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online ) d ON DUPLICATE KEY UPDATE online_seconds = asic_uptime_bucket.online_seconds + VALUES(online_seconds), updated_at = VALUES(updated_at), client_name = VALUES(client_name) ', array(2, '2026-03-23 15:45:33', 1, 2, 'ivan', '2026-03-23 15:00:00', 30, 13, 2, 'ivan', '2026-03-23 15:00:00', 30, 15, 2, 'ivan', '2026-03-23 15:00:00', 0, 8, 2, 'ivan', '2026-03-23 15:00:00', 0, 9, 2, 'ivan', '2026-03-23 15:00:00', 0, 16, 2, 'ivan', '2026-03-23 15:00:00', 0)) in src/Service/UptimeBucketWriter.php (line 94)
  1. // порядок важен: сначала location_id, потом updated_at, потом параметры derived-таблицы
  2. array_unshift($params, $updatedAtMsk);
  3. array_unshift($params, $locationId);
  4. $this->conn->executeStatement($sql, $params);
  5. }
  6. }
UptimeBucketWriter->upsertHourDeltas(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'))) in src/Service/UptimeBucketWriter.php (line 43)
  1. public function addHourSamplesBulk(int $locationId, array $deltas, int $chunkSize = 1000): void
  2. {
  3. if ($deltas === []) return;
  4. foreach (array_chunk($deltas, $chunkSize) as $chunk) {
  5. $this->upsertHourDeltas($locationId, $chunk);
  6. }
  7. }
  8. private function upsertHourDeltas(int $locationId, array $rows): void
  9. {
UptimeBucketWriter->addHourSamplesBulk(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')), 1000) in src/Controller/Api/AgentApiController.php (line 304)
  1. if ($asicMaxTs !== []) {
  2. $this->batchUpdateAsicStatus($asicMaxTs, 500);
  3. }
  4. if ($bucketDeltas !== []) {
  5. $this->bucketWriter->addHourSamplesBulk(
  6. locationId: $location->getId(),
  7. deltas: array_values($bucketDeltas),
  8. chunkSize: 1000
  9. );
  10. }
  1. $this->dispatcher->dispatch($event, KernelEvents::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, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  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);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  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. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. if (Kernel::VERSION_ID >= 60400) {
  7. $response->send(false);
  8. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

PDOException

SQLSTATE[HY000]: General error: 1364 Field 'expected_seconds' doesn't have a default value

  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. }
  2. public function execute(): Result
  3. {
  4. try {
  5. $this->stmt->execute();
  6. } catch (PDOException $exception) {
  7. throw Exception::new($exception);
  8. }
  9. return new Result($this->stmt);
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. 'sql' => $this->sql,
  2. 'params' => $this->params,
  3. 'types' => $this->types,
  4. ]);
  5. return parent::execute();
  6. }
  7. }
  1. $this->wrappedStatement->bindValue($param, $value, $type);
  2. }
  3. public function execute(): Result
  4. {
  5. return $this->wrappedStatement->execute();
  6. }
  7. }
  1. $this->stopwatch?->start('doctrine', 'doctrine');
  2. $query->start();
  3. try {
  4. return parent::execute();
  5. } finally {
  6. $query->stop();
  7. $this->stopwatch?->stop('doctrine');
  8. }
  9. }
  1. $stmt = $connection->prepare($sql);
  2. $this->bindParameters($stmt, $params, $types);
  3. return $stmt->execute()
  4. ->rowCount();
  5. }
  6. return $connection->exec($sql);
  7. } catch (Driver\Exception $e) {
Connection->executeStatement(' INSERT INTO asic_uptime_bucket (location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at) SELECT ? AS location_id, d.asic_id, d.client_id, d.client_name, \'hour\' AS granularity, d.period_start, d.online, ? AS updated_at FROM ( SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online ) d ON DUPLICATE KEY UPDATE online_seconds = asic_uptime_bucket.online_seconds + VALUES(online_seconds), updated_at = VALUES(updated_at), client_name = VALUES(client_name) ', array(2, '2026-03-23 15:45:33', 1, 2, 'ivan', '2026-03-23 15:00:00', 30, 13, 2, 'ivan', '2026-03-23 15:00:00', 30, 15, 2, 'ivan', '2026-03-23 15:00:00', 0, 8, 2, 'ivan', '2026-03-23 15:00:00', 0, 9, 2, 'ivan', '2026-03-23 15:00:00', 0, 16, 2, 'ivan', '2026-03-23 15:00:00', 0)) in src/Service/UptimeBucketWriter.php (line 94)
  1. // порядок важен: сначала location_id, потом updated_at, потом параметры derived-таблицы
  2. array_unshift($params, $updatedAtMsk);
  3. array_unshift($params, $locationId);
  4. $this->conn->executeStatement($sql, $params);
  5. }
  6. }
UptimeBucketWriter->upsertHourDeltas(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'))) in src/Service/UptimeBucketWriter.php (line 43)
  1. public function addHourSamplesBulk(int $locationId, array $deltas, int $chunkSize = 1000): void
  2. {
  3. if ($deltas === []) return;
  4. foreach (array_chunk($deltas, $chunkSize) as $chunk) {
  5. $this->upsertHourDeltas($locationId, $chunk);
  6. }
  7. }
  8. private function upsertHourDeltas(int $locationId, array $rows): void
  9. {
UptimeBucketWriter->addHourSamplesBulk(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')), 1000) in src/Controller/Api/AgentApiController.php (line 304)
  1. if ($asicMaxTs !== []) {
  2. $this->batchUpdateAsicStatus($asicMaxTs, 500);
  3. }
  4. if ($bucketDeltas !== []) {
  5. $this->bucketWriter->addHourSamplesBulk(
  6. locationId: $location->getId(),
  7. deltas: array_values($bucketDeltas),
  8. chunkSize: 1000
  9. );
  10. }
  1. $this->dispatcher->dispatch($event, KernelEvents::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, $event);
  9. $this->dispatcher->dispatch($event, KernelEvents::VIEW);
  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);
  6. } catch (\Throwable $e) {
  7. if ($e instanceof \Error && !$this->handleAllThrowables) {
  8. throw $e;
  9. }
  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. }
  1. ) {
  2. }
  3. public function run(): int
  4. {
  5. $response = $this->kernel->handle($this->request);
  6. if (Kernel::VERSION_ID >= 60400) {
  7. $response->send(false);
  8. if (\function_exists('fastcgi_finish_request') && !$this->debug) {
in vendor/autoload_runtime.php -> run (line 32)
  1. $app = $app(...$args);
  2. exit(
  3. $runtime
  4. ->getRunner($app)
  5. ->run()
  6. );
require_once('/var/www/vendor/autoload_runtime.php') in public/index.php (line 5)
  1. <?php
  2. use App\Kernel;
  3. require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
  4. return function (array $context) {
  5. return new Kernel($context['APP_ENV'], (bool) $context['APP_DEBUG']);
  6. };

Logs

Level Channel Message
INFO 18:19:38 request Matched route "_profiler".
{
    "route": "_profiler",
    "route_parameters": {
        "_route": "_profiler",
        "_controller": "web_profiler.controller.profiler::panelAction",
        "token": "af27dc"
    },
    "request_uri": "https://dc-mining-monitoring-new-test.test.itlabs.top/_profiler/af27dc",
    "method": "GET"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequestPrettyUrls"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController".
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "ContainerMbIaxxG\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerMbIaxxG\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequestPrettyUrls"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController".
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "ContainerMbIaxxG\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerMbIaxxG\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\Security\Csrf\SameOriginCsrfTokenManager::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Csrf\\SameOriginCsrfTokenManager::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\Security\\Http\\Firewall\\ContextListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ResponseListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\WebLink\EventListener\AddLinkHeaderListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\WebLink\\EventListener\\AddLinkHeaderListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Nelmio\CorsBundle\EventListener\CacheableResponseVaryListener::onResponse".
{
    "event": "kernel.response",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CacheableResponseVaryListener::onResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ProfilerListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::removeCspHeader"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Bundle\\WebProfilerBundle\\EventListener\\WebDebugToolbarListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DisallowRobotsIndexingListener::onResponse"
}
DEBUG 18:19:38 event Notified event "kernel.response" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse".
{
    "event": "kernel.response",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelResponse"
}
DEBUG 18:19:38 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelFinishRequest"
}
DEBUG 18:19:38 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelFinishRequest"
}
DEBUG 18:19:38 event Notified event "kernel.finish_request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelFinishRequest"
}
DEBUG 18:19:38 event Notified event "kernel.finish_request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest".
{
    "event": "kernel.finish_request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelFinishRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\DebugHandlersListener::configure"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ValidateRequestListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Nelmio\CorsBundle\EventListener\CorsListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Nelmio\\CorsBundle\\EventListener\\CorsListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bridge\Doctrine\Middleware\IdleConnection\Listener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bridge\\Doctrine\\Middleware\\IdleConnection\\Listener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\SessionListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::setDefaultLocale"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\RouterListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\LocaleAwareListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::configureLogoutUrlGenerator"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "Symfony\\Bundle\\SecurityBundle\\Debug\\TraceableFirewallListener::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequestPrettyUrls".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequestPrettyUrls"
}
DEBUG 18:19:38 event Notified event "kernel.request" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelRequest".
{
    "event": "kernel.request",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelRequest"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber::onKernelController".
{
    "event": "kernel.controller",
    "listener": "EasyCorp\\Bundle\\EasyAdminBundle\\EventListener\\AdminRouterSubscriber::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Bundle\\FrameworkBundle\\DataCollector\\RouterDataCollector::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller" to listener "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController".
{
    "event": "kernel.controller",
    "listener": "Symfony\\Component\\HttpKernel\\DataCollector\\RequestDataCollector::onKernelController"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsCsrfTokenValidAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsCsrfTokenValidAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\Security\\Http\\EventListener\\IsGrantedAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\CacheAttributeListener::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "ContainerMbIaxxG\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "ContainerMbIaxxG\\RequestPayloadValueResolverGhost01ca9cc::onKernelControllerArguments"
}
DEBUG 18:19:38 event Notified event "kernel.controller_arguments" to listener "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments".
{
    "event": "kernel.controller_arguments",
    "listener": "Symfony\\Component\\HttpKernel\\EventListener\\ErrorListener::onControllerArguments"
}

Stack Traces 3

[3/3] NotNullConstraintViolationException
Doctrine\DBAL\Exception\NotNullConstraintViolationException:
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1364 Field 'expected_seconds' doesn't have a default value

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:101
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1460)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1396)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), '
INSERT INTO asic_uptime_bucket
(location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at)
SELECT
  ? AS location_id,
  d.asic_id,
  d.client_id,
  d.client_name,
  \'hour\' AS granularity,
  d.period_start,
  d.online,
  ? AS updated_at
FROM (
  SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online
) d
ON DUPLICATE KEY UPDATE
  online_seconds   = asic_uptime_bucket.online_seconds + VALUES(online_seconds),
  updated_at       = VALUES(updated_at),
  client_name      = VALUES(client_name)
', array(2, '2026-03-23 15:45:33', 1, 2, 'ivan', '2026-03-23 15:00:00', 30, 13, 2, 'ivan', '2026-03-23 15:00:00', 30, 15, 2, 'ivan', '2026-03-23 15:00:00', 0, 8, 2, 'ivan', '2026-03-23 15:00:00', 0, 9, 2, 'ivan', '2026-03-23 15:00:00', 0, 16, 2, 'ivan', '2026-03-23 15:00:00', 0), array())
     (vendor/doctrine/dbal/src/Connection.php:911)
  at Doctrine\DBAL\Connection->executeStatement('
INSERT INTO asic_uptime_bucket
(location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at)
SELECT
  ? AS location_id,
  d.asic_id,
  d.client_id,
  d.client_name,
  \'hour\' AS granularity,
  d.period_start,
  d.online,
  ? AS updated_at
FROM (
  SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online
) d
ON DUPLICATE KEY UPDATE
  online_seconds   = asic_uptime_bucket.online_seconds + VALUES(online_seconds),
  updated_at       = VALUES(updated_at),
  client_name      = VALUES(client_name)
', array(2, '2026-03-23 15:45:33', 1, 2, 'ivan', '2026-03-23 15:00:00', 30, 13, 2, 'ivan', '2026-03-23 15:00:00', 30, 15, 2, 'ivan', '2026-03-23 15:00:00', 0, 8, 2, 'ivan', '2026-03-23 15:00:00', 0, 9, 2, 'ivan', '2026-03-23 15:00:00', 0, 16, 2, 'ivan', '2026-03-23 15:00:00', 0))
     (src/Service/UptimeBucketWriter.php:94)
  at App\Service\UptimeBucketWriter->upsertHourDeltas(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')))
     (src/Service/UptimeBucketWriter.php:43)
  at App\Service\UptimeBucketWriter->addHourSamplesBulk(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')), 1000)
     (src/Controller/Api/AgentApiController.php:304)
  at App\Controller\Api\AgentApiController->samples(object(Request))
     (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:182)
  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('/var/www/vendor/autoload_runtime.php')
     (public/index.php:5)                
[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HY000]: General error: 1364 Field 'expected_seconds' doesn't have a default value

  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/Statement.php:57)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:905)
  at Doctrine\DBAL\Connection->executeStatement('
INSERT INTO asic_uptime_bucket
(location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at)
SELECT
  ? AS location_id,
  d.asic_id,
  d.client_id,
  d.client_name,
  \'hour\' AS granularity,
  d.period_start,
  d.online,
  ? AS updated_at
FROM (
  SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online
) d
ON DUPLICATE KEY UPDATE
  online_seconds   = asic_uptime_bucket.online_seconds + VALUES(online_seconds),
  updated_at       = VALUES(updated_at),
  client_name      = VALUES(client_name)
', array(2, '2026-03-23 15:45:33', 1, 2, 'ivan', '2026-03-23 15:00:00', 30, 13, 2, 'ivan', '2026-03-23 15:00:00', 30, 15, 2, 'ivan', '2026-03-23 15:00:00', 0, 8, 2, 'ivan', '2026-03-23 15:00:00', 0, 9, 2, 'ivan', '2026-03-23 15:00:00', 0, 16, 2, 'ivan', '2026-03-23 15:00:00', 0))
     (src/Service/UptimeBucketWriter.php:94)
  at App\Service\UptimeBucketWriter->upsertHourDeltas(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')))
     (src/Service/UptimeBucketWriter.php:43)
  at App\Service\UptimeBucketWriter->addHourSamplesBulk(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')), 1000)
     (src/Controller/Api/AgentApiController.php:304)
  at App\Controller\Api\AgentApiController->samples(object(Request))
     (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:182)
  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('/var/www/vendor/autoload_runtime.php')
     (public/index.php:5)                
[1/3] PDOException
PDOException:
SQLSTATE[HY000]: General error: 1364 Field 'expected_seconds' doesn't have a default value

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:55)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:46)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:24)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:58)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:905)
  at Doctrine\DBAL\Connection->executeStatement('
INSERT INTO asic_uptime_bucket
(location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at)
SELECT
  ? AS location_id,
  d.asic_id,
  d.client_id,
  d.client_name,
  \'hour\' AS granularity,
  d.period_start,
  d.online,
  ? AS updated_at
FROM (
  SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online UNION ALL SELECT ? AS asic_id, ? AS client_id, ? AS client_name, ? AS period_start, ? AS online
) d
ON DUPLICATE KEY UPDATE
  online_seconds   = asic_uptime_bucket.online_seconds + VALUES(online_seconds),
  updated_at       = VALUES(updated_at),
  client_name      = VALUES(client_name)
', array(2, '2026-03-23 15:45:33', 1, 2, 'ivan', '2026-03-23 15:00:00', 30, 13, 2, 'ivan', '2026-03-23 15:00:00', 30, 15, 2, 'ivan', '2026-03-23 15:00:00', 0, 8, 2, 'ivan', '2026-03-23 15:00:00', 0, 9, 2, 'ivan', '2026-03-23 15:00:00', 0, 16, 2, 'ivan', '2026-03-23 15:00:00', 0))
     (src/Service/UptimeBucketWriter.php:94)
  at App\Service\UptimeBucketWriter->upsertHourDeltas(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')))
     (src/Service/UptimeBucketWriter.php:43)
  at App\Service\UptimeBucketWriter->addHourSamplesBulk(2, array(array('asic_id' => 1, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 13, 'period_start' => '2026-03-23 15:00:00', 'online' => 30, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 15, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 8, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 9, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan'), array('asic_id' => 16, 'period_start' => '2026-03-23 15:00:00', 'online' => 0, 'client_id' => 2, 'client_name' => 'ivan')), 1000)
     (src/Controller/Api/AgentApiController.php:304)
  at App\Controller\Api\AgentApiController->samples(object(Request))
     (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:182)
  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('/var/www/vendor/autoload_runtime.php')
     (public/index.php:5)