Martim Passos
01/18/2022, 4:48 PMsqlalchemy.exc.OperationalError: (sqlite3.OperationalError) database is locked
[SQL: INSERT INTO event_logs (run_id, event, dagster_event_type, timestamp, step_key, asset_key, partition) VALUES (?, ?, ?, ?, ?, ?, ?)]
My use case is rather simple and I don’t need to keep track of all the logs Dagster saves by default. I tried unsetting DAGSTER_HOME
but that just uses a temporary directory that hits the same problem. Is there a way to work around this without having to setup my own SQL db? Something like reducing the amount of events saved or preventing/limiting the DynamicOutput
ops from running in parallel?max_concurrent
the answer I’m looking for?https://docs.dagster.io/_apidocs/execution#dagster.multiprocess_executormax
01/18/2022, 5:16 PMMartim Passos
01/18/2022, 6:35 PMmax_concurrent
to 4 seems to have fixed it though. I’m on a 24 core machine so that’s likely what caused the issue. I’ll experiment to see where the limit is being reached exactly…