<@ULVA73B9P> I am using SQLite as default DB for...
# marvin-in-the-wild
p
@Marvin I am using SQLite as default DB for Prefect When i try to reset the database I got the below error , sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: _alembic_tmp_task_run.flow_run_id [SQL: INSERT INTO _alembic_tmp_task_run (id, created, updated, name, state_type, run_count, expected_start_time, next_scheduled_start_time, start_time, end_time, total_run_time, task_key, dynamic_key, cache_key, cache_expiration, task_version, empirical_policy, task_inputs, tags, flow_run_id, state_id, state_name, state_timestamp, flow_run_run_count) SELECT task_run.id, task_run.created, task_run.updated, task_run.name, task_run.state_type, task_run.run_count, task_run.expected_start_time, task_run.next_scheduled_start_time, task_run.start_time, task_run.end_time, task_run.total_run_time, task_run.task_key, task_run.dynamic_key, task_run.cache_key, task_run.cache_expiration, task_run.task_version, task_run.empirical_policy, task_run.task_inputs, task_run.tags, task_run.flow_run_id, task_run.state_id, task_run.state_name, task_run.state_timestamp, task_run.flow_run_run_count FROM task_run] (Background on this error at: https://sqlalche.me/e/20/gkpj) An exception occurred.
m
Your message was too long by 20 tokens - please shorten it and try again. For reference, here's your message at the allowed limit:
I am using SQLite as default DB for Prefect
When i try to reset the database I got the below error , sqlalchemy.exc.IntegrityError: (sqlite3.IntegrityError) NOT NULL constraint failed: _alembic_tmp_task_run.flow_run_id [SQL: INSERT INTO _alembic_tmp_task_run (id, created, updated, name, state_type, run_count, expected_start_time, next_scheduled_start_time, start_time, end_time, total_run_time, task_key, dynamic_key, cache_key, cache_expiration, task_version, empirical_policy, task_inputs, tags, flow_run_id, state_id, state_name, state_timestamp, flow_run_run_count) SELECT task_run.id, task_run.created, task_run.updated, task_run.name, task_run.state_type, task_run.run_count, task_run.expected_start_time, task_run.next_scheduled_start_time, task_run.start_time, task_run.end_time, task_run.total_run_time, task_run.task_key, task_run.dynamic_key, task_run.cache_key, task_run.cache_expiration, task_run.task_version, task_run.empirical_policy, task_run.task_inputs, task_run.tags, task_run.flow_run_id, task_run.state_id, task_run.state_name, task_run.state_timestamp, task_run.flow_run_run_count FROM task_run] (Background on this error at: <https://sqlalche.me/e/20/g