Dziennik synchronizacji źródeł urzędowych z wynikiem, zakresem i wskazówkami do błędów.
| Start | Źródło i cel | Rodzaj | Wynik | Rekordy | Zapytania | Czas |
|---|---|---|---|---|---|---|
| 28.09.2026 12:25 | Dziennik urzędowy – Komenda Główna Policjijournal-41edziennik.policja.gov.pl/GetActPdf.ashx?… | Katalog źródła | CzęściowyOsiągnięto limit pracy |
199 | 2 | 2 s |
1. (2.78ms; exec 2.72 + fetch 0.06; rows 1) SELECT r.id, s.code AS source_code, s.name AS source_name, e.`key` AS endpoint_key, r.kind, r.state, r.started_at, r.fin…2. (34.76ms; exec 34.4 + fetch 0.37; rows 48) SELECT s.code, s.name, s.enabled, (SELECT COUNT(*) FROM source_endpoints e WHERE e.source_id = s.id AND e.enabled = 1) A…
1. (2.78ms; exec 2.72 + fetch 0.06; rows 1) SELECT r.id, s.code AS source_code, s.name AS source_name, e.`key` AS endpoint_key, r.kind, r.state, r.started_at, r.finished_at, r.expected_count, r.observed_count, r.error_code, (SELECT f.requested_url FROM fetches f WHERE f.source_run_id = r.id AND f.endpoint_id = r.endpoint_id ORDER BY f.id DESC LIMIT 1) AS requested_url, (SELECT COUNT(*) FROM fetches f WHERE f.source_run_id = r.id) AS requests FROM source_runs r JOIN sources s ON s.id = r.source_id LEFT JOIN source_endpoints e ON e.id = r.endpoint_id WHERE ('journal-41' IS NULL OR s.code = 'journal-41') AND (NULL IS NULL OR r.state = NULL) AND (NULL IS NULL OR r.id < NULL) ORDER BY r.id DESC LIMIT 502. (34.76ms; exec 34.4 + fetch 0.37; rows 48) SELECT s.code, s.name, s.enabled, (SELECT COUNT(*) FROM source_endpoints e WHERE e.source_id = s.id AND e.enabled = 1) AS enabled_endpoints, last.state AS last_state, last.started_at AS last_started_at, last.finished_at AS last_finished_at, last.error_code AS last_error, (SELECT MAX(r.finished_at) FROM source_runs r WHERE r.source_id = s.id AND r.state = 'completed') AS last_completed_at, (SELECT COUNT(*) FROM source_runs r WHERE r.source_id = s.id AND r.state = 'failed' AND r.started_at >= UTC_TIMESTAMP(6) - INTERVAL 1 DAY) AS failures_24h FROM sources s LEFT JOIN source_runs last ON last.id = (SELECT MAX(r.id) FROM source_runs r WHERE r.source_id = s.id) WHERE s.enabled = 1 OR last.id IS NOT NULL ORDER BY last.id IS NULL, last.id DESC, s.code
(0.38ms) /app/templates/overview/activity.php/app/public/index.php/app/vendor/autoload.php/app/vendor/composer/autoload_real.php/app/vendor/composer/platform_check.php/app/vendor/composer/ClassLoader.php/app/vendor/composer/autoload_static.php/app/vendor/symfony/deprecation-contracts/function.php/app/vendor/symfony/polyfill-php83/bootstrap.php/app/lib/PFrame.php/app/config/credentials/local.php/app/src/Http/AuthRoutes.php/app/src/Http/ReviewDecisionRoutes.php/app/src/Http/TopicDecisionRoutes.php/app/src/Http/WatchRoutes.php/app/src/Http/OverviewController.php/app/src/Overview/ActivityReadModel.php/app/src/Overview/Format.php/app/templates/layout.php