Error 500 Internal Server Error

GET https://dev.wunschliefertag.de/run/StateShiftJobs/f651dbb004c78bf6941fd972373b185b5e02fd76bc2b1f8d9b

IP
80.158.57.161
Profiled on
Token
46a3bb
Forwarded to ErrorController (113ec3)

RunController :: run

Request

GET Parameters

None

POST Parameters

None

Uploaded Files

None

Request Attributes

Key Value
_controller 
"App\Controller\RunController::run"
_firewall_context 
"security.firewall.map.context.main"
_remove_csp_headers 
true
_route 
"jobRun"
_route_params 
[
  "taskName" => "StateShiftJobs"
  "hash" => "f651dbb004c78bf6941fd972373b185b5e02fd76bc2b1f8d9b"
]
_security_firewall_run 
"_security_main"
_stopwatch_token 
"8fbdc6"
hash 
"f651dbb004c78bf6941fd972373b185b5e02fd76bc2b1f8d9b"
taskName 
"StateShiftJobs"

Request Headers

Header Value
accept 
"*/*"
host 
"dev.wunschliefertag.de"
x-php-ob-level 
"1"

Request Content

Request content not available (it was retrieved as a resource).

Response

Response Headers

Header Value
cache-control 
"no-cache, private"
content-type 
"text/html; charset=UTF-8"
date 
"Sat, 21 Sep 2024 08:33:28 GMT"
x-debug-exception 
"An%20exception%20occurred%20while%20executing%20a%20query%3A%20SQLSTATE%5B23000%5D%3A%20Integrity%20constraint%20violation%3A%201452%20Cannot%20add%20or%20update%20a%20child%20row%3A%20a%20foreign%20key%20constraint%20fails%20%28%60wlt5_dev%60.%60backup_sending%60%2C%20CONSTRAINT%20%60FK_57C04D25F624B39D%60%20FOREIGN%20KEY%20%28%60sender_id%60%29%20REFERENCES%20%60address%60%20%28%60id%60%29%29"
x-debug-exception-file 
"%2Fvar%2Fwww%2Frevision%2Fdev%2Fv05.00.0687%2Fvendor%2Fdoctrine%2Fdbal%2Fsrc%2FDriver%2FAPI%2FMySQL%2FExceptionConverter.php:56"
x-debug-token 
"46a3bb"
x-debug-token-link 
"https://dev.wunschliefertag.de/_profiler/113ec3"
x-previous-debug-token 
"113ec3"
x-robots-tag 
"noindex"

Cookies

Request Cookies

No request cookies

Response Cookies

No response cookies

Session 1

Session Metadata

No session metadata

Session Attributes

No session attributes

Session Usage

1 Usages
Stateless check enabled
Usage
Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage:41
Show trace 
[
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/security-core/Authentication/Token/Storage/UsageTrackingTokenStorage.php"
    "line" => 41
    "function" => "getMetadataBag"
    "class" => "Symfony\Component\HttpFoundation\Session\Session"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/security-core/Security.php"
    "line" => 78
    "function" => "getToken"
    "class" => "Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/security-core/Security.php"
    "line" => 60
    "function" => "getToken"
    "class" => "Symfony\Component\Security\Core\Security"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/src/Service/DepotLimitService.php"
    "line" => 19
    "function" => "getUser"
    "class" => "Symfony\Component\Security\Core\Security"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/var/cache/dev/ContainerD43Zdiu/App_KernelDevDebugContainer.php"
    "line" => 1326
    "function" => "__construct"
    "class" => "App\Service\DepotLimitService"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/var/cache/dev/ContainerD43Zdiu/App_KernelDevDebugContainer.php"
    "line" => 1289
    "function" => "getDepotLimitServiceService"
    "class" => "ContainerD43Zdiu\App_KernelDevDebugContainer"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/var/cache/dev/ContainerD43Zdiu/App_KernelDevDebugContainer.php"
    "line" => 1263
    "function" => "getDepotRepositoryService"
    "class" => "ContainerD43Zdiu\App_KernelDevDebugContainer"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/var/cache/dev/ContainerD43Zdiu/App_KernelDevDebugContainer.php"
    "line" => 926
    "function" => "getMenuSubscriberService"
    "class" => "ContainerD43Zdiu\App_KernelDevDebugContainer"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 221
    "function" => "ContainerD43Zdiu\{closure}"
    "class" => "ContainerD43Zdiu\App_KernelDevDebugContainer"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/event-dispatcher/EventDispatcher.php"
    "line" => 70
    "function" => "sortListeners"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php"
    "line" => 257
    "function" => "getListeners"
    "class" => "Symfony\Component\EventDispatcher\EventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php"
    "line" => 121
    "function" => "preProcess"
    "class" => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 151
    "function" => "dispatch"
    "class" => "Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/http-kernel/HttpKernel.php"
    "line" => 74
    "function" => "handleRaw"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/http-kernel/Kernel.php"
    "line" => 184
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\HttpKernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php"
    "line" => 35
    "function" => "handle"
    "class" => "Symfony\Component\HttpKernel\Kernel"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/vendor/autoload_runtime.php"
    "line" => 29
    "function" => "run"
    "class" => "Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner"
    "type" => "->"
  ]
  [
    "file" => "/var/www/revision/dev/v05.00.0687/public/index.php"
    "line" => 5
    "args" => [
      "/var/www/revision/dev/v05.00.0687/vendor/autoload_runtime.php"
    ]
    "function" => "require_once"
  ]
]

Flashes

Flashes

No flash messages were created.

Server Parameters

Server Parameters

Defined in .env

Key Value
APP_DEBUG 
"1"
APP_ENV 
"dev"
APP_SECRET 
"655c01ae6e254a9faa6960d94711b950"
DATABASE_URL 
"mysql://fbusch:L~(R[0X4!UQ5AIT6@80.158.50.170:3306/wlt5_dev?serverVersion=8.0.21-2&charset=utf8"
LOCK_DSN 
"flock"
WLT_MESSAGING_APP 
"wlt_dev"
WLT_MESSAGING_URL 
"https://inout.wunschliefertag.de/messaging/store"
WLT_MSG_FAX_PASS 
"cYD3fN!4NHBB02A56j1?UE8h"
WLT_MSG_FAX_SENDER 
"Wunschliefertag"
WLT_MSG_FAX_URL 
"https://api.wunschliefertag.de/i952"
WLT_MSG_FAX_USER 
"wltrel5"
WLT_MSG_FAX_WLTINT 
"02133215088"
WLT_MSG_MAIL_PASS 
"cYD3fN!4NHBB02A56j1?UE8h"
WLT_MSG_MAIL_SENDER 
"service@wunschliefertag.de"
WLT_MSG_MAIL_URL 
"https://api.wunschliefertag.de/i952"
WLT_MSG_MAIL_USER 
"wltrel5"
WLT_MSG_MAIL_WLTINT 
"fbusch@infi-sol.de"
WLT_MSG_SMS_PASS 
"cYD3fN!4NHBB02A56j1?UE8h"
WLT_MSG_SMS_SENDER 
"Lieferavis"
WLT_MSG_SMS_URL 
"https://api.wunschliefertag.de/i950"
WLT_MSG_SMS_USER 
"wltrel5"
WLT_MSG_SMS_WLTINT 
"491777215087"
WLT_STORAGE_APP 
"wlt_test"
WLT_STORAGE_BASE 
"storage.wunschliefertag.de"

Defined as regular env variables

Key Value
CONTEXT_DOCUMENT_ROOT 
"/var/www/dev/html"
CONTEXT_PREFIX 
""
DOCUMENT_ROOT 
"/var/www/dev/html"
GATEWAY_INTERFACE 
"CGI/1.1"
HTTPS 
"on"
HTTP_ACCEPT 
"*/*"
HTTP_HOST 
"dev.wunschliefertag.de"
PATH 
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin"
PHP_SELF 
"/index.php"
QUERY_STRING 
""
REDIRECT_HTTPS 
"on"
REDIRECT_SSL_TLS_SNI 
"dev.wunschliefertag.de"
REDIRECT_STATUS 
"200"
REDIRECT_URL 
"/run/StateShiftJobs/f651dbb004c78bf6941fd972373b185b5e02fd76bc2b1f8d9b"
REMOTE_ADDR 
"80.158.57.161"
REMOTE_PORT 
"51388"
REQUEST_METHOD 
"GET"
REQUEST_SCHEME 
"https"
REQUEST_TIME 
1726907605
REQUEST_TIME_FLOAT 
1726907605.5137
REQUEST_URI 
"/run/StateShiftJobs/f651dbb004c78bf6941fd972373b185b5e02fd76bc2b1f8d9b"
SCRIPT_FILENAME 
"/var/www/dev/html/index.php"
SCRIPT_NAME 
"/index.php"
SERVER_ADDR 
"172.16.0.5"
SERVER_ADMIN 
"webmaster@wunschliefertag.de"
SERVER_NAME 
"dev.wunschliefertag.de"
SERVER_PORT 
"443"
SERVER_PROTOCOL 
"HTTP/1.1"
SERVER_SIGNATURE 
"<address>Apache/2.4.53 (Debian) Server at dev.wunschliefertag.de Port 443</address>\n"
SERVER_SOFTWARE 
"Apache/2.4.53 (Debian)"
SSL_CIPHER 
"TLS_AES_256_GCM_SHA384"
SSL_CIPHER_ALGKEYSIZE 
"256"
SSL_CIPHER_EXPORT 
"false"
SSL_CIPHER_USEKEYSIZE 
"256"
SSL_CLIENT_VERIFY 
"NONE"
SSL_COMPRESS_METHOD 
"NULL"
SSL_PROTOCOL 
"TLSv1.3"
SSL_SECURE_RENEG 
"true"
SSL_SERVER_A_KEY 
"rsaEncryption"
SSL_SERVER_A_SIG 
"sha256WithRSAEncryption"
SSL_SERVER_I_DN 
"CN=R11,O=Let's Encrypt,C=US"
SSL_SERVER_I_DN_C 
"US"
SSL_SERVER_I_DN_CN 
"R11"
SSL_SERVER_I_DN_O 
"Let's Encrypt"
SSL_SERVER_M_SERIAL 
"0366F431793B4CF84926AB9C5309E68E7248"
SSL_SERVER_M_VERSION 
"3"
SSL_SERVER_SAN_DNS_0 
"dev.wunschliefertag.de"
SSL_SERVER_S_DN 
"CN=dev.wunschliefertag.de"
SSL_SERVER_S_DN_CN 
"dev.wunschliefertag.de"
SSL_SERVER_V_END 
"Nov  8 12:44:02 2024 GMT"
SSL_SERVER_V_START 
"Aug 10 12:44:03 2024 GMT"
SSL_SESSION_ID 
"28dd19fc18ec7f9a28a3a910cccc33b16c657b0cd98f1b8ea74fdc6044b4ffe0"
SSL_SESSION_RESUMED 
"Initial"
SSL_TLS_SNI 
"dev.wunschliefertag.de"
SSL_VERSION_INTERFACE 
"mod_ssl/2.4.53"
SSL_VERSION_LIBRARY 
"OpenSSL/1.1.1n"
SYMFONY_DOTENV_VARS 
"APP_ENV,APP_SECRET,APP_DEBUG,DATABASE_URL,LOCK_DSN,WLT_MESSAGING_APP,WLT_MESSAGING_URL,WLT_MSG_SMS_URL,WLT_MSG_SMS_SENDER,WLT_MSG_SMS_USER,WLT_MSG_SMS_PASS,WLT_MSG_SMS_WLTINT,WLT_MSG_MAIL_URL,WLT_MSG_MAIL_SENDER,WLT_MSG_MAIL_USER,WLT_MSG_MAIL_PASS,WLT_MSG_MAIL_WLTINT,WLT_MSG_FAX_URL,WLT_MSG_FAX_SENDER,WLT_MSG_FAX_USER,WLT_MSG_FAX_PASS,WLT_MSG_FAX_WLTINT,WLT_STORAGE_BASE,WLT_STORAGE_APP"

Sub Requests 1

ErrorController (token = 113ec3)

Key Value
_controller 
"error_controller"
_stopwatch_token 
"8b6fe3"
exception 
Doctrine\DBAL\Exception\ForeignKeyConstraintViolationException {#15498
  #message: "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`wlt5_dev`.`backup_sending`, CONSTRAINT `FK_57C04D25F624B39D` FOREIGN KEY (`sender_id`) REFERENCES `address` (`id`))"
  #code: 1452
  #file: "/var/www/revision/dev/v05.00.0687/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php"
  #line: 56
  -previous: Doctrine\DBAL\Driver\PDO\Exception {#15506 …}
  -query: Doctrine\DBAL\Query {#15488 …}
  trace: {
    /var/www/revision/dev/v05.00.0687/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:56 {
      Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(Exception $exception, ?Query $query): DriverException …
      › case 1701:
      ›     return new ForeignKeyConstraintViolationException($exception, $query);
      › 
    }
    /var/www/revision/dev/v05.00.0687/vendor/doctrine/dbal/src/Connection.php:1938 {
      Doctrine\DBAL\Connection->handleDriverException(Exception $driverException, ?Query $query): DriverException …
      › $this->exceptionConverter ??= $this->_driver->getExceptionConverter();
      › $exception                  = $this->exceptionConverter->convert($driverException, $query);
      › 
    }
    /var/www/revision/dev/v05.00.0687/vendor/doctrine/dbal/src/Connection.php:1880 {
      Doctrine\DBAL\Connection->convertExceptionDuringQuery(Exception $e, string $sql, array $params = [], array $types = []): DriverException …
      › ): DriverException {
      ›     return $this->handleDriverException($e, new Query($sql, $params, $types));
      › }
    }
    /var/www/revision/dev/v05.00.0687/vendor/doctrine/dbal/src/Connection.php:1105 {
      Doctrine\DBAL\Connection->executeQuery(string $sql, array $params = [], $types = [], QueryCacheProfile $qcp = null): Result …
      › } catch (Driver\Exception $e) {
      ›     throw $this->convertExceptionDuringQuery($e, $sql, $params, $types);
      › } finally {
    }
    /var/www/revision/dev/v05.00.0687/src/StateJob/StateJobDOBACKUP.php:103 {
      App\StateJob\StateJobDOBACKUP->do(string $sql) …
      ›     //echo $sql . '<br />' . "\n";
      ›     $this->em->getConnection()->executeQuery($sql);
      › }
    }
    /var/www/revision/dev/v05.00.0687/src/StateJob/StateJobDOBACKUP.php:44 {
      App\StateJob\StateJobDOBACKUP->workOnSendingList(array $allIds, RulesAutomatic $rule, EntityManagerInterface $em, LogService $logService, int $endAt): bool …
      ›     . 'hinted, avis_type_id, do_fav, do_asg, do_nsz';
      › $this->do('insert into backup_sending (' . $fields . ') '
      ›     . 'select ' . $fields . ' from sending where id in ' . $idstring);
    }
    /var/www/revision/dev/v05.00.0687/src/Job/StateShiftJobs.php:103 {
      App\Job\StateShiftJobs->run(): string …
      › $ids = $qb->getSingleColumnResult();
      › $job->workOnSendingList($ids, $rule, $this->em, $this->logService, $endAt);
      › $this::$shifted += count($ids);
    }
    /var/www/revision/dev/v05.00.0687/src/Controller/RunController.php:100 {
      App\Controller\RunController->run(EntityManagerInterface $em, JobService $jobService, string $taskName, string $hash, LoggerInterface $logger): Response …
      ›     && (($job->getEnabled() && $job->getEntity()->getHash() == $hash) || $hash == "tryIt")) {
      ›     $job->prepareRun()->run();
      › }
    }
    /var/www/revision/dev/v05.00.0687/vendor/symfony/http-kernel/HttpKernel.php:163 {
      Symfony\Component\HttpKernel\HttpKernel->handleRaw(Request $request, int $type = self::MAIN_REQUEST): Response …
      › // call controller
      › $response = $controller(...$arguments);
      › 
    }
    /var/www/revision/dev/v05.00.0687/vendor/symfony/http-kernel/HttpKernel.php:74 {
      Symfony\Component\HttpKernel\HttpKernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->handleRaw($request, $type);
      › } catch (\Throwable $e) {
    }
    /var/www/revision/dev/v05.00.0687/vendor/symfony/http-kernel/Kernel.php:184 {
      Symfony\Component\HttpKernel\Kernel->handle(Request $request, int $type = HttpKernelInterface::MAIN_REQUEST, bool $catch = true): Response …
      › try {
      ›     return $this->getHttpKernel()->handle($request, $type, $catch);
      › } finally {
    }
    /var/www/revision/dev/v05.00.0687/vendor/symfony/runtime/Runner/Symfony/HttpKernelRunner.php:35 {
      Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run(): int …
      › {
      ›     $response = $this->kernel->handle($this->request);
      ›     $response->send();
    }
    /var/www/revision/dev/v05.00.0687/vendor/autoload_runtime.php:29 {
      require_once …
      ›         ->getRunner($app)
      ›         ->run()
      › );
    }
    /var/www/revision/dev/v05.00.0687/public/index.php:5 {
      › 
      › require_once dirname(__DIR__).'/vendor/autoload_runtime.php';
      › return function (array $context) {
      arguments: {
        "/var/www/revision/dev/v05.00.0687/vendor/autoload_runtime.php"
      }
    }
  }
}
logger 
Symfony\Bridge\Monolog\Logger {#286 …9}