Created
September 14, 2021 18:56
-
-
Save epifanio/f4926f00e2893b8ab1c80b59611dbab6 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| epinux@epinux:~/dev/GeoHealthCheck/docker/compose 2021/09/14 20:29:58 $ docker service logs ghck_ghc_runner | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | START /run-runner.sh | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Container timezone not modified | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Container timezone set to: Europe/Oslo | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | START /configure.sh | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Using DB_TYPE=postgresql | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Check if Postgres is avail/ready... | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | postgis_ghc:5432 - no response | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Exit code=2 - Postgres not ready - sleeping | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | postgis_ghc:5432 - rejecting connections | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Exit code=1 - Postgres not ready - sleeping | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | postgis_ghc:5432 - accepting connections | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Postgres is up - check if DB populated | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | count | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | ------- | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 8 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | (1 row) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Postgres DB already populated | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | END /configure.sh | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | ---> pavement.runner_daemon | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | python GeoHealthCheck/scheduler.py | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,433 - init - INFO - created GHC App instance #1 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,648 - __main__ - INFO - Starting scheduler | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,648 - apscheduler.scheduler - INFO - Scheduler started | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,648 - __main__ - INFO - lifecycle_listener: EVENT_SCHEDULER_STARTED - <SchedulerEvent (code=1)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,704 - __main__ - INFO - Starting job for resource=1 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,782 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,783 - __main__ - INFO - Starting job for resource=2 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,783 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,783 - __main__ - INFO - Starting job for resource=3 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,783 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,783 - __main__ - INFO - Starting job for resource=4 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,784 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,784 - __main__ - INFO - Starting job for resource=5 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,784 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,784 - __main__ - INFO - Starting job for resource=6 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,784 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,785 - __main__ - INFO - Starting job for resource=8 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,785 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,785 - __main__ - INFO - Starting job for resource=7 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,785 - apscheduler.scheduler - INFO - Added job "run_job" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,786 - apscheduler.scheduler - INFO - Added job "flush_runs" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,786 - apscheduler.scheduler - INFO - Added job "check_schedule" to job store "default" | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:18:55,786 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:03,785 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 19:19:03 CEST)" (scheduled at 2021-09-14 19:19:03.783593+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:03,805 - __main__ - INFO - 3 Lock present: try obtaining.. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:03,805 - __main__ - INFO - 3 Lock obtained, delete and renew | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:03,906 - __main__ - INFO - 3 Lock deleted, add new | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:03,927 - __main__ - INFO - 3 Lock Add OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:03,951 - GeoHealthCheck.probe - INFO - Requesting: GET url=https://nordatanet.csw.met.no/csw | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,313 - GeoHealthCheck.probe - INFO - response: status=200 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,313 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.HttpStatusNoError result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,315 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.XmlParse result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,316 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.NotContainsOwsException result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,316 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.ContainsStrings result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,316 - GeoHealthCheck.probe - INFO - Result: success=True msg=OK response_time=0.363920 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,378 - __main__ - INFO - 3 run_resource OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:19:04,378 - apscheduler.executors.default - INFO - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:19:03 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:00,791 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 19:20:00 CEST)" (scheduled at 2021-09-14 19:20:00.783955+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:00,801 - __main__ - INFO - 4 Lock present: try obtaining.. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:00,801 - __main__ - INFO - 4 Lock obtained, delete and renew | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:00,819 - __main__ - INFO - 4 Lock deleted, add new | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:00,836 - __main__ - INFO - 4 Lock Add OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:00,852 - GeoHealthCheck.probe - INFO - Requesting: GET url=https://adc.csw.met.no/csw | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,223 - GeoHealthCheck.probe - INFO - response: status=200 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,223 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.HttpStatusNoError result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,225 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.XmlParse result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,226 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.NotContainsOwsException result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,226 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.ContainsStrings result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,226 - GeoHealthCheck.probe - INFO - Result: success=True msg=OK response_time=0.370907 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,316 - __main__ - INFO - 4 run_resource OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:20:01,317 - apscheduler.executors.default - INFO - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:20:00 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:23:55,792 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:23:55 CEST)" (scheduled at 2021-09-14 19:23:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:23:55,793 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:23:55,798 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:28:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:23:55,835 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:36,791 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 19:24:36 CEST)" (scheduled at 2021-09-14 19:24:36.785087+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:36,806 - __main__ - INFO - 8 Lock present: try obtaining.. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:36,806 - __main__ - INFO - 8 Lock obtained, delete and renew | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:36,880 - __main__ - INFO - 8 Lock deleted, add new | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:36,899 - __main__ - INFO - 8 Lock Add OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:36,912 - GeoHealthCheck.probe - INFO - Requesting: GET url=https://thredds.met.no/thredds/wms/remotesensingsatellite/polar-swath/2020/05/23/npp-viirs-dnb-20200523225143-20200523230014.nc?service=WMS&version=1.3.0&request=GetCapabilities | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,811 - GeoHealthCheck.probe - INFO - response: status=200 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,812 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.HttpStatusNoError result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,818 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.XmlParse result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,819 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.NotContainsOwsException result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,819 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.ContainsStrings result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,820 - GeoHealthCheck.probe - INFO - Result: success=True msg=OK response_time=10.900572 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,850 - __main__ - INFO - 8 run_resource OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:24:47,850 - apscheduler.executors.default - INFO - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:24:36 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:45,789 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 19:26:45 CEST)" (scheduled at 2021-09-14 19:26:45.784332+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:45,803 - __main__ - INFO - 5 Lock present: try obtaining.. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:45,803 - __main__ - INFO - 5 Lock obtained, delete and renew | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:45,859 - __main__ - INFO - 5 Lock deleted, add new | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:45,876 - __main__ - INFO - 5 Lock Add OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:45,887 - GeoHealthCheck.probe - INFO - Requesting: GET url=https://nbs.csw.met.no/csw | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,313 - GeoHealthCheck.probe - INFO - response: status=200 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,314 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.HttpStatusNoError result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,315 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.XmlParse result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,316 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.NotContainsOwsException result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,316 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.ContainsStrings result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,316 - GeoHealthCheck.probe - INFO - Result: success=True msg=OK response_time=0.426722 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,372 - __main__ - INFO - 5 run_resource OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:26:46,373 - apscheduler.executors.default - INFO - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:26:45 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:28:55,792 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:28:55 CEST)" (scheduled at 2021-09-14 19:28:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:28:55,793 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:28:55,797 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:33:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:28:55,896 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:33:55,791 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:33:55 CEST)" (scheduled at 2021-09-14 19:33:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:33:55,792 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:33:55,800 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:38:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:33:55,982 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:38:55,792 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:38:55 CEST)" (scheduled at 2021-09-14 19:38:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:38:55,792 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:38:55,805 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:43:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:38:56,025 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:43:55,790 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:43:55 CEST)" (scheduled at 2021-09-14 19:43:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:43:55,791 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:43:55,805 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:48:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:43:56,111 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:48:55,791 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:48:55 CEST)" (scheduled at 2021-09-14 19:48:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:48:55,791 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:48:55,805 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:53:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:48:56,211 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:55,790 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:58:55 CEST)" (scheduled at 2021-09-14 19:53:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:55,791 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:55,803 - apscheduler.executors.default - ERROR - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 19:58:55 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | psycopg2.OperationalError: server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 197, in check_schedule | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | for resource in Resource.query.all(): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3178, in all | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(self) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, statement, parameters, cursor, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | (Background on this error at: http://sqlalche.me/e/e3q8) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:55,803 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:56,264 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:56,785 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:53:56 CEST)" (scheduled at 2021-09-14 19:53:56.784710+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:56,788 - apscheduler.executors.default - ERROR - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:53:56 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | psycopg2.OperationalError: server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 93, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | resource = Resource.query.filter_by(identifier=resource_id).first() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3232, in first | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | ret = list(self[0:1]) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3018, in __getitem__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(res) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, statement, parameters, cursor, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | WHERE resource.identifier = %(identifier_1)s | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | LIMIT %(param_1)s] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [parameters: {'identifier_1': 6, 'param_1': 1}] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | (Background on this error at: http://sqlalche.me/e/e3q8) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:53:56,788 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:55:04,786 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:55:04 CEST)" (scheduled at 2021-09-14 19:55:04.785486+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:55:04,791 - apscheduler.executors.default - ERROR - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:55:04 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | psycopg2.OperationalError: server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 93, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | resource = Resource.query.filter_by(identifier=resource_id).first() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3232, in first | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | ret = list(self[0:1]) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3018, in __getitem__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(res) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, statement, parameters, cursor, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | WHERE resource.identifier = %(identifier_1)s | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | LIMIT %(param_1)s] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [parameters: {'identifier_1': 7, 'param_1': 1}] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | (Background on this error at: http://sqlalche.me/e/e3q8) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:55:04,792 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:58:55,787 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:03:55 CEST)" (scheduled at 2021-09-14 19:58:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:58:55,788 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:58:55,793 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:03:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:58:56,343 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:43,706 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:59:43 CEST)" (scheduled at 2021-09-14 19:59:43.704273+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:43,722 - __main__ - INFO - 1 No Lock at all: obtain new | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:43,828 - GeoHealthCheck.probe - INFO - Requesting: GET url=https://sios.csw.met.no/csw | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,184 - GeoHealthCheck.probe - INFO - response: status=200 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,184 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.HttpStatusNoError result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,186 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.XmlParse result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,186 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.NotContainsOwsException result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,187 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.ContainsStrings result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,187 - GeoHealthCheck.probe - INFO - Result: success=True msg=OK response_time=0.356569 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,251 - __main__ - INFO - 1 run_resource OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 19:59:44,251 - apscheduler.executors.default - INFO - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 20:59:43 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:03:55,787 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:08:55 CEST)" (scheduled at 2021-09-14 20:03:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:03:55,788 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:03:55,798 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:08:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:03:56,426 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:42,784 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:06:42 CEST)" (scheduled at 2021-09-14 20:06:42.783160+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:42,794 - __main__ - INFO - 2 Lock present: try obtaining.. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:42,795 - __main__ - INFO - 2 Lock obtained, delete and renew | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:42,843 - __main__ - INFO - 2 Lock deleted, add new | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:42,859 - __main__ - INFO - 2 Lock Add OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:42,871 - GeoHealthCheck.probe - INFO - Requesting: GET url=https://nmdc.csw.met.no/csw | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,228 - GeoHealthCheck.probe - INFO - response: status=200 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,229 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.HttpStatusNoError result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,230 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.XmlParse result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,231 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.NotContainsOwsException result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,231 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.ContainsStrings result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,232 - GeoHealthCheck.probe - INFO - Result: success=True msg=OK response_time=0.357877 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,281 - __main__ - INFO - 2 run_resource OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:06:43,281 - apscheduler.executors.default - INFO - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:06:42 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:08:55,787 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:13:55 CEST)" (scheduled at 2021-09-14 20:08:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:08:55,788 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:08:55,794 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:13:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:08:56,494 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:13:55,787 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:18:55 CEST)" (scheduled at 2021-09-14 20:13:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:13:55,788 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:13:55,794 - apscheduler.executors.default - INFO - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:18:55 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:13:56,595 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:18:55,787 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:23:55 CEST)" (scheduled at 2021-09-14 20:18:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:18:55,788 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:18:55,792 - apscheduler.executors.default - ERROR - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:23:55 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | psycopg2.OperationalError: server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 197, in check_schedule | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | for resource in Resource.query.all(): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3178, in all | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(self) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, statement, parameters, cursor, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | (Background on this error at: http://sqlalche.me/e/e3q8) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:18:55,793 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:18:56,695 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:19:03,785 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:19:03 CEST)" (scheduled at 2021-09-14 20:19:03.783593+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:19:03,789 - apscheduler.executors.default - ERROR - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:19:03 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1177, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | conn = self._revalidate_connection() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 463, in _revalidate_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | "Can't reconnect until invalid " | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.InvalidRequestError: Can't reconnect until invalid transaction is rolled back | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 93, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | resource = Resource.query.filter_by(identifier=resource_id).first() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3232, in first | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | ret = list(self[0:1]) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3018, in __getitem__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(res) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, util.text_type(statement), parameters, None, None | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1177, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | conn = self._revalidate_connection() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 463, in _revalidate_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | "Can't reconnect until invalid " | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | WHERE resource.identifier = %(identifier_1)s | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | LIMIT %(param_1)s] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [parameters: [{}]] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:19:03,790 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:20:00,785 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:20:00 CEST)" (scheduled at 2021-09-14 20:20:00.783955+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:20:00,789 - apscheduler.executors.default - ERROR - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:20:00 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1177, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | conn = self._revalidate_connection() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 463, in _revalidate_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | "Can't reconnect until invalid " | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.InvalidRequestError: Can't reconnect until invalid transaction is rolled back | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 93, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | resource = Resource.query.filter_by(identifier=resource_id).first() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3232, in first | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | ret = list(self[0:1]) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3018, in __getitem__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(res) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, util.text_type(statement), parameters, None, None | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1177, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | conn = self._revalidate_connection() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 463, in _revalidate_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | "Can't reconnect until invalid " | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | WHERE resource.identifier = %(identifier_1)s | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | LIMIT %(param_1)s] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [parameters: [{}]] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:20:00,790 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:23:55,787 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:28:55 CEST)" (scheduled at 2021-09-14 20:23:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:23:55,788 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:23:55,791 - apscheduler.executors.default - ERROR - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:28:55 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1177, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | conn = self._revalidate_connection() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 463, in _revalidate_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | "Can't reconnect until invalid " | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.InvalidRequestError: Can't reconnect until invalid transaction is rolled back | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 197, in check_schedule | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | for resource in Resource.query.all(): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3178, in all | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(self) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1182, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, util.text_type(statement), parameters, None, None | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1177, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | conn = self._revalidate_connection() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 463, in _revalidate_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | "Can't reconnect until invalid " | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.StatementError: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [parameters: [{}]] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:23:55,792 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:23:56,795 - __main__ - INFO - This prints once in 5 minutes | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:24:36,786 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:24:36 CEST)" (scheduled at 2021-09-14 20:24:36.785087+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:24:36,791 - apscheduler.executors.default - ERROR - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:24:36 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | psycopg2.OperationalError: server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 93, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | resource = Resource.query.filter_by(identifier=resource_id).first() | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3232, in first | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | ret = list(self[0:1]) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3018, in __getitem__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(res) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, statement, parameters, cursor, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | WHERE resource.identifier = %(identifier_1)s | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | LIMIT %(param_1)s] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [parameters: {'identifier_1': 8, 'param_1': 1}] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | (Background on this error at: http://sqlalche.me/e/e3q8) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:24:36,792 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:45,785 - apscheduler.executors.default - INFO - Running job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:26:45 CEST)" (scheduled at 2021-09-14 20:26:45.784332+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:45,800 - __main__ - INFO - 5 Lock present: try obtaining.. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:45,800 - __main__ - INFO - 5 Lock obtained, delete and renew | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:45,845 - __main__ - INFO - 5 Lock deleted, add new | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:45,913 - __main__ - INFO - 5 Lock Add OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:45,929 - GeoHealthCheck.probe - INFO - Requesting: GET url=https://nbs.csw.met.no/csw | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,335 - GeoHealthCheck.probe - INFO - response: status=200 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,335 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.HttpStatusNoError result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,337 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.XmlParse result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,338 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.NotContainsOwsException result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,338 - GeoHealthCheck.probe - INFO - Check: fun=GeoHealthCheck.plugins.check.checks.ContainsStrings result=True | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,338 - GeoHealthCheck.probe - INFO - Result: success=True msg=OK response_time=0.406122 | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,367 - __main__ - INFO - 5 run_resource OK | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:26:46,367 - apscheduler.executors.default - INFO - Job "run_job (trigger: interval[1:00:00], next run at: 2021-09-14 21:26:45 CEST)" executed successfully | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:28:55,787 - apscheduler.executors.default - INFO - Running job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:33:55 CEST)" (scheduled at 2021-09-14 20:28:55.786190+02:00) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:28:55,788 - __main__ - INFO - Checking Job schedules | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:28:55,791 - apscheduler.executors.default - ERROR - Job "check_schedule (trigger: interval[0:05:00], next run at: 2021-09-14 20:33:55 CEST)" raised an exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | psycopg2.OperationalError: server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | The above exception was the direct cause of the following exception: | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | Traceback (most recent call last): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/apscheduler/executors/base.py", line 125, in run_job | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | retval = job.func(*job.args, **job.kwargs) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "GeoHealthCheck/scheduler.py", line 197, in check_schedule | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | for resource in Resource.query.all(): | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3178, in all | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return list(self) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3334, in __iter__ | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return self._execute_and_instances(context) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/orm/query.py", line 3359, in _execute_and_instances | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | result = conn.execute(querycontext.statement, self._params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 988, in execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return meth(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/sql/elements.py", line 287, in _execute_on_connection | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | return connection._execute_clauseelement(self, multiparams, params) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1107, in _execute_clauseelement | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | distilled_params, | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1253, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | e, statement, parameters, cursor, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1473, in _handle_dbapi_exception | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | util.raise_from_cause(sqlalchemy_exception, exc_info) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 398, in raise_from_cause | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | reraise(type(exception), exception, tb=exc_tb, cause=cause) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 152, in reraise | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | raise value.with_traceback(tb) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1249, in _execute_context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor, statement, parameters, context | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | File "/venv/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 552, in do_execute | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | cursor.execute(statement, parameters) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) server closed the connection unexpectedly | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | This probably means the server terminated abnormally | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | before or while processing the request. | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | [SQL: SELECT resource.auth AS resource_auth, resource.identifier AS resource_identifier, resource.resource_type AS resource_resource_type, resource.active AS resource_active, resource.title AS resource_title, resource.url AS resource_url, resource.latitude AS resource_latitude, resource.longitude AS resource_longitude, resource.owner_identifier AS resource_owner_identifier, resource.run_frequency AS resource_run_frequency | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | FROM resource] | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | (Background on this error at: http://sqlalche.me/e/e3q8) | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:28:55,793 - __main__ - ERROR - error_listener: EVENT_JOB_MISSED - <JobExecutionEvent (code=8192)> | |
| ghck_ghc_runner.1.oes3x7uj2a5t@epinux.com | 2021-09-14 20:28:56,877 - __main__ - INFO - This prints once in 5 minutes |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment