szalai1
07/22/2020, 1:57 PMschedule_storage: postgres
my problem:
• scheduled jobs don't start when they supposed to
• when I run dagster schedule up --location 'Business Intelligence'
I get this every time:
Errors Resolved:
Schedule daily_answer_position_pipeline is set to be running, but the scheduler is not running the schedule.
Schedule daily_events_rounds_pipeline is set to be running, but the scheduler is not running the schedule
I renamed the repo several times, now when I run dagster schedule debug
I can see schedules from those repos with status: RUNNING
what can be the problem?sashank
07/22/2020, 2:18 PMdagster schedule logs
commanddagster schedule logs --location 'Business Intelligence' daily_answer_position_pipeline
szalai1
07/22/2020, 2:41 PMTitouan
07/22/2020, 3:03 PMszalai1
07/22/2020, 3:04 PMschedule up
but not the --start-all
sashank
07/22/2020, 3:05 PM--start-all
shouldn’t really matter, since you have manually started the schedule through the UI.szalai1
07/22/2020, 3:06 PMcrontab -l
, I listed the scheduled jobssashank
07/22/2020, 3:07 PMdagster schedule debug
command here? It should show us everything including the cron tabszalai1
07/22/2020, 3:08 PMroot@dagster-dagit-6f6c6c64bd-85jpw:/opt/dagster/app# dagster schedule debug
Errors (Run `dagster schedule up` to resolve)
=============================================
Schedule daily_answer_position_pipeline is set to be running, but the scheduler is not running the schedule.
Schedule daily_events_rounds_pipeline is set to be running, but the scheduler is not running the schedule.
Scheduler Configuration
=======================
Scheduler:
module: dagster_cron.cron_scheduler
class: SystemCronScheduler
config:
{}
Scheduler Info
==============
Running Cron Jobs:
0 1 * * * /opt/dagster/dagster_home/schedules/scripts/cb7af3fe21f2fc954ea60dad4502658594ede1fa.sh > /opt/dagster/dagster_home/schedules/logs/cb7af3fe21f2fc954ea60dad4502658594ede1fa/scheduler.log 2>&1 # dagster-schedule: cb7af3fe21f2fc954ea60dad4502658594ede1fa
@daily /opt/dagster/dagster_home/schedules/scripts/f9b01b67ce89b111f67ea06bf192c062e5698471.sh > /opt/dagster/dagster_home/schedules/logs/f9b01b67ce89b111f67ea06bf192c062e5698471/scheduler.log 2>&1 # dagster-schedule: f9b01b67ce89b111f67ea06bf192c062e5698471
@daily /opt/dagster/dagster_home/schedules/scripts/b03f3aa7aa968b38665e82bfb4fecbbf405c280a.sh > /opt/dagster/dagster_home/schedules/logs/b03f3aa7aa968b38665e82bfb4fecbbf405c280a/scheduler.log 2>&1 # dagster-schedule: b03f3aa7aa968b38665e82bfb4fecbbf405c280a
@daily /opt/dagster/dagster_home/schedules/scripts/3f340cb3cd5b02d635e20de3012be5aec6d28fe4.sh > /opt/dagster/dagster_home/schedules/logs/3f340cb3cd5b02d635e20de3012be5aec6d28fe4/scheduler.log 2>&1 # dagster-schedule: 3f340cb3cd5b02d635e20de3012be5aec6d28fe4
Scheduler Storage Info
======================
daily_answer_position_pipeline:
cron_schedule: 0 0 * * *
python_path: /usr/local/bin/python
repository_origin_id: 94883ff7995e2aeb02a9caf1f8ba503b654dd122
repository_pointer: /opt/dagster/app/src/repositories.py::kafka_topic_loader_repository
schedule_origin_id: d5c6079c7dfb3d375c01e431aad6a52c0d24f978
status: STOPPED
daily_events_rounds_pipeline:
cron_schedule: 0 0 * * *
python_path: /usr/local/bin/python
repository_origin_id: 94883ff7995e2aeb02a9caf1f8ba503b654dd122
repository_pointer: /opt/dagster/app/src/repositories.py::kafka_topic_loader_repository
schedule_origin_id: 60590970adb2fa159911597e625a5cdffeab4e78
status: STOPPED
daily_answer_position_pipeline:
cron_schedule: 0 0 * * *
python_path: /usr/local/bin/python
repository_origin_id: c2a9de0a59b1f05956c1688d4c3a7dce90d949ea
repository_pointer: /opt/dagster/app/src/repositories.py::bi_repository
schedule_origin_id: e785e863d275b277ec030e30e446e60a68412c11
status: RUNNING
daily_events_rounds_pipeline:
cron_schedule: 0 0 * * *
python_path: /usr/local/bin/python
repository_origin_id: c2a9de0a59b1f05956c1688d4c3a7dce90d949ea
repository_pointer: /opt/dagster/app/src/repositories.py::bi_repository
schedule_origin_id: 4ac68c41140226dc41b6382b02e37117baba6d5f
status: RUNNING
daily_answer_position_pipeline:
cron_schedule: 0 0 * * *
python_path: /usr/local/bin/python
repository_origin_id: cd0eff9914141ed9ca53ba32b71349d7d82a9903
repository_pointer: /opt/dagster/app/src/repositories.py::business_intelligence_repository
schedule_origin_id: f9b01b67ce89b111f67ea06bf192c062e5698471
status: RUNNING
daily_events_rounds_pipeline:
cron_schedule: 0 0 * * *
python_path: /usr/local/bin/python
repository_origin_id: cd0eff9914141ed9ca53ba32b71349d7d82a9903
repository_pointer: /opt/dagster/app/src/repositories.py::business_intelligence_repository
schedule_origin_id: b03f3aa7aa968b38665e82bfb4fecbbf405c280a
status: RUNNING
daily_maker_organisation_changes:
cron_schedule: 0 0 * * *
python_path: /usr/local/bin/python
repository_origin_id: cd0eff9914141ed9ca53ba32b71349d7d82a9903
repository_pointer: /opt/dagster/app/src/repositories.py::business_intelligence_repository
schedule_origin_id: 3f340cb3cd5b02d635e20de3012be5aec6d28fe4
status: RUNNING
daily_aggregate_model_monitoring_pipeline:
cron_schedule: 0 1 * * *
python_path: /usr/local/bin/python
repository_origin_id: 1837b1588a140ee6a1f478dc3d0bece0c3c083d4
repository_pointer: /opt/dagster/app/src/model_repo.py::ds_models_repository
schedule_origin_id: cb7af3fe21f2fc954ea60dad4502658594ede1fa
status: RUNNING
bi_repository
repo to business_intelligence_repository
, but I still can see the schedules in there ^sashank
07/22/2020, 3:12 PMup
with the new location. To prevent this again, I would recommend manually setting a location name in your dagster.yaml
that stays consistent.
For now, the first thing I would do is run dagster schedule wipe
then dagster schedule up
again to get us into a clean state.szalai1
07/22/2020, 3:16 PMsashank
07/22/2020, 3:16 PM* * * * * echo "test" > testfile.txt
dagster schedule debug
shows and issues after you run dagster schedule up
and dagster schedule up
szalai1
07/23/2020, 8:42 AMscheduled.log
is empty
• there are files like this 20200723T070117_f9b01b67ce89b111f67ea06bf192c062e5698471.result
though. and an error message: You have attempted to fetch the environment variable \"DAGSTER_PG_PASSWORD\" which is not set.
dagster.yaml
schedule_storage:
module: dagster_postgres.schedule_storage
class: PostgresScheduleStorage
config:
postgres_db:
username: dagster
password:
env: DAGSTER_PG_PASSWORD
hostname: dagster-postgresql
db_name: dagster
port: 5432
sashank
07/23/2020, 2:59 PMszalai1
07/23/2020, 3:03 PMsashank
07/23/2020, 3:04 PMPaul Wyatt
07/23/2020, 8:07 PMszalai1
07/24/2020, 7:11 AM(
) then it will make generated script fail with syntax error.
I solved the problem by escaping the string : f"\"{os.environ.get(key)}\""
.