https://bugs.kde.org/show_bug.cgi?id=451415
Bug ID: 451415
Summary: Elisa loops indefinitely trying to fix database
corruption
Product: Elisa
Version: 21.08.3
Platform: Debian testing
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: general
Assignee: matthieu_gall...@yahoo.fr
Reporter: bren...@quantumfurball.net
Target Milestone: ---
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
--
You are receiving this mail because:
You are watching all bug changes.
