<@ULVA73B9P> ´´I am using SQLite as default DB fo...
# 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, ...... FROM task_run] (Background on this error at: https://sqlalche.me/e/20/gkpj) An exception occurred.
m
It seems there isn't much directly relevant info in the docs or GitHub issues. However, based on the Prefect documentation: 1. You can try resetting your SQLite database using: prefect server database reset -y This command will clear all data and reapply the schema, which might resolve the issue. For more details, you can refer to the Prefect database guide. If that doesn't help, you might consider switching to PostgreSQL for a more robust database solution. Here's a broader Prefect database configuration guide.