Bug 451415

Summary:	Elisa loops indefinitely trying to fix database corruption
Product:	[Applications] Elisa	Reporter:	Brendon Higgins <brendon>
Component:	general	Assignee:	Matthieu Gallien <matthieu_gallien>
Status:	RESOLVED FIXED
Severity:	normal	CC:	jackhill3103
Priority:	NOR
Version First Reported In:	21.08.3
Target Milestone:	---
Platform:	Debian testing
OS:	Linux
Latest Commit:	https://invent.kde.org/multimedia/elisa/-/commit/27f4d86d8865f07c407b60a79ed2a000df057fdb	Version Fixed/Implemented In:
Sentry Crash Report:

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