Running sqlite inmemory for a long time

[IgnisDa]

I am using the SQLite storage for my jobs (sqlite::memory:). I have noticed that when my server is running for a long time, the following error pops ups.

The only way to fix it is to restart the server.

I am not sure where I should start debugging this since it does not happen in local development and only after 1-2 days in production.

[IgnisDa]

NOTE: It is imperative that the SQLite database is started in memory because of how the file system is set up in my project (which does not allow me to write the database to a file).

[geofmureithi]

This seems related to:
launchbadge/sqlx#1647

[IgnisDa]

Thanks!

This does seem to have performance implications. Will have to monitor if it is significant.

[geofmureithi]

The solution

let inner = sqlx::pool::PoolOptions::new()
    .max_lifetime(None)
    .idle_timeout(None)
    .connect(&std::env::var("DATABASE_URL")?)
    .await?;
let storage = SqliteStorage::new(inner);