Connection does not automatically close

[zbinhazzaa]

Expected Behavior

I run

use migration::{Migrator, MigratorTrait};

let connection = sea_orm::Database::connect(&database_url).await?;
Migrator::up(&connection, None).await?;

I expected that at the end of the app the DB would close.

Actual Behavior

Db does not close at the end of the app and still has .shm and .wal files.
I had this problem trying to copy the Db after the migration ended.

[billy1624]

Hey @zbinhazzaa, thanks for the report! This has to do with the underlying database connector: SQLx.

Related Issues:

• sqlite misses database updates when program closes shortly afterwards launchbadge/sqlx#1760
• SQLite backend does not close database launchbadge/sqlx#272

I think at SeaORM we could introduce an async close method to close the connection.

[tyt2y3]

https://docs.rs/sea-orm/latest/sea_orm/entity/prelude/enum.DatabaseConnection.html#method.close