Bug 451415 - Elisa loops indefinitely trying to fix database corruption
Summary: Elisa loops indefinitely trying to fix database corruption
Status: RESOLVED FIXED
Alias: None
Product: Elisa
Classification: Applications
Component: general (other bugs)
Version First Reported In: 21.08.3
Platform: Debian testing Linux
: NOR normal
Target Milestone: ---
Assignee: Matthieu Gallien
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-03-12 01:34 UTC by Brendon Higgins
Modified: 2024-04-12 12:36 UTC (History)
1 user (show)

See Also:
Latest Commit: https://invent.kde.org/multimedia/elisa/-/commit/27f4d86d8865f07c407b60a79ed2a000df057fdb
Version Fixed/Implemented In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Brendon Higgins 2022-03-12 01:34:06 UTC 
SUMMARY

Elisa gets stuck in an apparent infinite loop trying to rebuild its database. I run Elisa like so:
$ QT_LOGGING_RULES="*.elisa.*=true" elisa
This is the output:
qrc:/qml/ElisaMainWindow.qml:19:1: QML ElisaMainWindow: Accessible must be attached to an Item
org.kde.elisa.views: ViewManager::openView 0 0 ViewsListData(0x559c2c944e50)
org.kde.elisa.views: ViewManager::openView selected view 0
org.kde.elisa.views: ViewManager::openView changing view
org.kde.elisa.views: ViewManager::openViewFromData 0
org.kde.elisa.views: ViewManager::openViewFromData unknown model type
org.kde.elisa.views: ViewManager::openViewFromData ViewManager::ContextView 1 "Now Playing" QUrl("image://icon/view-media-lyrics")
file:///usr/lib/x86_64-linux-gnu/qt5/qml/org/kde/kirigami.2/Page.qml:348: Error: Cannot assign QObject* to PageRow_QMLTYPE_82*
file:///usr/lib/x86_64-linux-gnu/qt5/qml/org/kde/kirigami.2/Page.qml:348: Error: Cannot assign QObject* to PageRow_QMLTYPE_82*
org.kde.elisa.views: ViewManager::viewIsLoaded 1 ViewsListData(0x559c2c944e50)
kf.kirigami: Units.devicePixelRatio is deprecated (since 5.86): This returns 1 when using Qt HiDPI scaling.
org.kde.elisa.views: ViewManager::openView 0 1 ViewsListData(0x559c2c944e50)
org.kde.elisa.views: ViewManager::openView selected view 0
org.kde.elisa.views: ViewManager::openView 0 1 ViewsListData(0x559c2c944e50)
org.kde.elisa.views: ViewManager::openView selected view 0
org.kde.elisa.baloo: LocalBalooFileListing::registerToBaloo
org.kde.elisa.baloo: LocalBalooFileListing::registerToBaloo call registerMonitor
org.kde.elisa.baloo: LocalBalooFileListing::registerToBaloo call registerBalooWatcher
org.kde.elisa.indexers.manager: Local file system indexer is inactive
org.kde.elisa.indexers.manager: Baloo indexer is unavailable
org.kde.elisa.indexers.manager: Baloo indexer is inactive
org.kde.elisa.database: database open
org.kde.elisa.database: DatabaseInterface::init yes
org.kde.elisa.database: [[ 36824074 ]] "UPDATE `DatabaseVersion` set `Version` = :version "
org.kde.elisa.database: "Tracks" table has wrong number of columns 23 expected 21
org.kde.elisa.database: Full reset of database due to corrupted database
org.kde.elisa.database: dropping table "DatabaseVersion"
org.kde.elisa.database: dropping table "DatabaseVersionV9"
org.kde.elisa.database: dropping table "DiscoverSource"
org.kde.elisa.database: dropping table "Artists"
org.kde.elisa.database: dropping table "Composer"
org.kde.elisa.database: dropping table "Genre"
org.kde.elisa.database: dropping table "Lyricist"
org.kde.elisa.database: dropping table "Albums"
org.kde.elisa.database: dropping table "Tracks"
org.kde.elisa.database: dropping table "TracksMapping"
org.kde.elisa.database: dropping table "NewAlbums"
org.kde.elisa.database: dropping table "NewTracks"
org.kde.elisa.database: dropping table "DatabaseVersionV11"
org.kde.elisa.database: dropping table "TracksData"
org.kde.elisa.database: dropping table "DatabaseVersionV12"
org.kde.elisa.database: dropping table "NewTracksData"
org.kde.elisa.database: dropping table "DatabaseVersionV13"
org.kde.elisa.database: dropping table "DatabaseVersionV14"
org.kde.elisa.database: dropping table "Radios"
org.kde.elisa.database: dropping table "sqlite_sequence"
org.kde.elisa.database: dropping table "DatabaseVersionV15"
org.kde.elisa.database: dropping table "RadiosNew"
org.kde.elisa.database: dropping table "DatabaseVersion"
org.kde.elisa.database: dropping table "DatabaseVersionV9"
org.kde.elisa.database: dropping table "DiscoverSource"
org.kde.elisa.database: dropping table "Artists"
org.kde.elisa.database: dropping table "Composer"
org.kde.elisa.database: dropping table "Genre"
org.kde.elisa.database: dropping table "Lyricist"
org.kde.elisa.database: dropping table "Albums"
org.kde.elisa.database: dropping table "Tracks"
org.kde.elisa.database: dropping table "TracksMapping"
org.kde.elisa.database: dropping table "NewAlbums"
org.kde.elisa.database: dropping table "NewTracks"
org.kde.elisa.database: dropping table "DatabaseVersionV11"
org.kde.elisa.database: dropping table "TracksData"
org.kde.elisa.database: dropping table "DatabaseVersionV12"
org.kde.elisa.database: dropping table "NewTracksData"
org.kde.elisa.database: dropping table "DatabaseVersionV13"
org.kde.elisa.database: dropping table "DatabaseVersionV14"
org.kde.elisa.database: dropping table "Radios"
org.kde.elisa.database: dropping table "sqlite_sequence"
org.kde.elisa.database: dropping table "DatabaseVersionV15"
org.kde.elisa.database: dropping table "RadiosNew"
org.kde.elisa.database: dropping table "DatabaseVersion"
org.kde.elisa.database: dropping table "DatabaseVersionV9"
...
You get the idea. It keeps going with no apprent end. No music appears in the list.

Not sure how I got myself in this situation. I might have tried not using Baloo to begin with, but now using Baloo - but I can't recall for certain. Baloo is working, e.g. baloosearch does find my music files.

Removing ~/.local/share/elisa/elisaDatabase.db seems to bypass the problem.

SOFTWARE/OS VERSIONS
Linux/KDE Plasma: 
(available in About System)
KDE Plasma Version: 5.24.2
KDE Frameworks Version: 5.90.0
Qt Version: 5.15.2