Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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