Jose Uribe
03/22/2023, 7:06 PMdagster._core.errors.DagsterInvariantViolationError: InstigatorState 4bac3b8c656c8a19dde9d79e81c105e115a1fc26 is already present in storage
File "/root/.pyenv/versions/3.9.0/lib/python3.9/site-packages/dagster_graphql/implementation/utils.py", line 130, in _fn
return fn(*args, **kwargs)
File "/root/.pyenv/versions/3.9.0/lib/python3.9/site-packages/dagster_graphql/implementation/fetch_schedules.py", line 31, in start_schedule
schedule_state = instance.start_schedule(
File "/root/.pyenv/versions/3.9.0/lib/python3.9/site-packages/dagster/_core/instance/__init__.py", line 2154, in start_schedule
return self._scheduler.start_schedule(self, external_schedule)
File "/root/.pyenv/versions/3.9.0/lib/python3.9/site-packages/dagster/_core/scheduler/scheduler.py", line 98, in start_schedule
instance.add_instigator_state(started_state)
File "/root/.pyenv/versions/3.9.0/lib/python3.9/site-packages/dagster/_core/instance/__init__.py", line 2272, in add_instigator_state
return self._schedule_storage.add_instigator_state(state)
File "/root/.pyenv/versions/3.9.0/lib/python3.9/site-packages/dagster/_core/storage/schedules/sql_schedule_storage.py", line 157, in add_instigator_state
raise DagsterInvariantViolationError(
The above exception was caused by the following exception:
sqlalchemy.exc.IntegrityError: (psycopg2.errors.UniqueViolation) duplicate key value violates unique constraint "jobs_job_origin_id_key"
DETAIL: Key (job_origin_id)=(4bac3b8c656c8a19dde9d79e81c105e115a1fc26) already exists.
is there a standard remediation procedure for such things?prha
03/22/2023, 7:14 PMdagster instance migrate
after upgrading?Adam Bloom
03/22/2023, 7:30 PMJose Uribe
03/22/2023, 8:13 PMJose Uribe
03/22/2023, 8:18 PMdagster instance migrate
to perform the migrationprha
03/22/2023, 8:20 PMprha
03/22/2023, 8:21 PMjobs
table you have in your DB.