Database locked during cleanup on startup
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mixxx |
Fix Released
|
Medium
|
Unassigned |
Bug Description
Sometimes the LibraryScanner thread is not able to access the database when executing the cleanup SQL statements:
Info [Main]: DbConnection - Available drivers for database connections: ("QSQLITE")
Info [Main]: DbConnectionPool - Cloned thread-local database connection "MIXXX-1" QSqlDatabase(
Info [Main]: MixxxMainWindow - Connecting to database
Info [Main]: MixxxMainWindow - Initializing or upgrading database schema
Info [Main]: SchemaManager - Current database schema is newer at version 30 and backwards compatible with version 28
Debug [Main]: LibraryScanner - Starting thread
Info [Main]: Library - Connecting database
Debug [LibraryScanner 1]: LibraryScanner - Entering thread
Info [LibraryScanner 1]: DbConnectionPool - Cloned thread-local database connection "MIXXX-2" QSqlDatabase(
Info [LibraryScanner 1]: LibraryScanner - Cleaning up database...
Warning [LibraryScanner 1]: FwdSqlQuery - Failed to execute "delete from LibraryHashes where hash <> 0 and directory_path not in (select directory from track_locations)" : QSqlError("5", "Unable to fetch row", "database is locked")
Warning [LibraryScanner 1]: LibraryScanner - Failed to delete orphaned directory hashes
Info [LibraryScanner 1]: LibraryScanner - Finished database cleanup: 15152 ms
Debug [LibraryScanner 1]: LibraryScanner - Event loop starting
Debug [Main]: Committing transaction on "MIXXX-1" result: true
D
I've only experienced this in a development version yet, never in master or a released version. But now it happened while testing version 2.2.3.
Changed in mixxx: | |
milestone: | 2.2.4 → none |
Changed in mixxx: | |
milestone: | none → 2.3.0 |
status: | Confirmed → In Progress |
Changed in mixxx: | |
status: | In Progress → Fix Committed |
Changed in mixxx: | |
status: | Fix Committed → Fix Released |
Mixxx now uses GitHub for bug tracking. This bug has been migrated to: /github. com/mixxxdj/ mixxx/issues/ 9825
https:/