Bug 466401 - Reproducable crash when typing in search field
Summary: Reproducable crash when typing in search field
Status: RESOLVED DUPLICATE of bug 444408
Alias: None
Product: amarok
Classification: Applications
Component: general (show other bugs)
Version: 2.9.71
Platform: openSUSE Linux
: NOR crash
Target Milestone: kf5
Assignee: Amarok Developers
URL:
Keywords: drkonqi
Depends on:
Blocks:
 
Reported: 2023-02-25 12:23 UTC by Bernhard
Modified: 2023-06-09 19:26 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Bernhard 2023-02-25 12:23:11 UTC
Application: amarok (2.9.71)

Qt Version: 5.15.8
Frameworks Version: 5.103.0
Operating System: Linux 6.1.12-1-default x86_64
Windowing System: X11
Distribution: "openSUSE Tumbleweed"
DrKonqi: 5.27.0 [KCrashBackend]

-- Information about the crash:
PC booted, Amarok started, try to search in local media collection -> crash

The crash can be reproduced every time.

-- Backtrace:
Application: Amarok (amarok), signal: Segmentation fault

[KCrash Handler]
#4  0x00007f3712e4001e in CollectionTreeItem::row() const () at /lib64/libamaroklib.so.1
#5  0x00007f3712e4e850 in CollectionTreeItemModelBase::itemIndex(CollectionTreeItem*) const () at /lib64/libamaroklib.so.1
#6  0x00007f3712e43340 in CollectionTreeItemModelBase::parent(QModelIndex const&) const () at /lib64/libamaroklib.so.1
#7  0x00007f37118b09b1 in  () at /lib64/libQt5Core.so.5
#8  0x00007f371191360c in  () at /lib64/libQt5Core.so.5
#9  0x00007f371187628c in QAbstractItemModel::dataChanged(QModelIndex const&, QModelIndex const&, QVector<int> const&) () at /lib64/libQt5Core.so.5
#10 0x00007f3712e50103 in CollectionTreeItemModelBase::tracksLoaded(AmarokSharedPointer<Meta::Album> const&, QModelIndex const&, QList<AmarokSharedPointer<Meta::Track> > const&) () at /lib64/libamaroklib.so.1
#11 0x00007f3711907d00 in QObject::event(QEvent*) () at /lib64/libQt5Core.so.5
#12 0x00007f37125a544e in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /lib64/libQt5Widgets.so.5
#13 0x00007f37118dc1e8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /lib64/libQt5Core.so.5
#14 0x00007f37118df181 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () at /lib64/libQt5Core.so.5
#15 0x00007f3711934413 in  () at /lib64/libQt5Core.so.5
#16 0x00007f370e71ba90 in g_main_context_dispatch () at /lib64/libglib-2.0.so.0
#17 0x00007f370e71be48 in  () at /lib64/libglib-2.0.so.0
#18 0x00007f370e71bedc in g_main_context_iteration () at /lib64/libglib-2.0.so.0
#19 0x00007f3711933c16 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /lib64/libQt5Core.so.5
#20 0x00007f37118dac5b in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /lib64/libQt5Core.so.5
#21 0x00007f37118e2dc6 in QCoreApplication::exec() () at /lib64/libQt5Core.so.5
#22 0x000055f9cda3ff76 in  ()
#23 0x00007f371102caf0 in __libc_start_call_main () at /lib64/libc.so.6
#24 0x00007f371102cbb9 in __libc_start_main_impl () at /lib64/libc.so.6
#25 0x000055f9cda40805 in  ()
[Inferior 1 (process 2662) detached]

The reporter indicates this bug may be a duplicate of or related to bug 440801.

Reported using DrKonqi
Comment 1 Tuomas Nurmi 2023-03-10 08:28:28 UTC
A fix for https://bugs.kde.org/show_bug.cgi?id=444408 has been in GIT since 7th Feb 2023, and I'd believe this is the same bug. The most readily available Amarok packages for openSUSE Tumbleweed seem to be
2.9.75git.20221114T02 in repository KDE:Extra and
2.9.75git.20230309T01 in repository KDE:Unstable:Extra

Can you confirm / check from package management (or check from About Amarok -> Build date) if the version you are using is an older build than 7th Feb 2023, and if so, try if the newer version in KDE:Unstable:Extra works for you?
Comment 2 Nihin Dula 2023-06-09 19:22:55 UTC
Hello.
Same problem here.
OpenSUSE Leap 15.5
Amarok 2.9.71
libmysqld19-10.2.44-150000.3.54.1.x86_64
I don't have "Use external MySQL database" marked in Amarok settings.

Try to search in local media collection -> crash
The crash can be reproduced every time.

Is there a solution to solve this problem?
Do I need additional mysql packages?

amarok:   [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Index for table '/home/paracet/.local/share/amarok/mysqle/amarok/albums.MYI' is corrupt; try to repair it on SELECT urls.id, urls.deviceid, urls.rpath, urls.directory, urls.uniqueid, tracks.id, tracks.title, tracks.comment, tracks.tracknumber, tracks.discnumber, statistics.score, statistics.rating, tracks.bitrate, tracks.length, tracks.filesize, tracks.samplerate, statistics.id, statistics.createdate, statistics.accessdate, statistics.playcount, tracks.filetype, tracks.bpm, tracks.createdate, tracks.modifydate, tracks.albumgain, tracks.albumpeakgain, tracks.trackgain, tracks.trackpeakgain, artists.name, artists.id, albums.name, albums.id, albums.artist, genres.name, genres.id, composers.name, composers.id, years.name, years.id FROM  tracks INNER JOIN urls ON tracks.url = urls.id LEFT JOIN artists ON tracks.artist = artists.id LEFT JOIN albums ON tracks.album = albums.id LEFT JOIN genres ON tracks.genre = genres.id LEFT JOIN composers ON tracks.composer = composers.id LEFT JOIN years ON tracks.year = years.id LEFT JOIN statistics ON urls.id = statistics.url WHERE 1  AND urls.deviceid in (1,2,3,4,-1) AND albums.name = 'Enjoy The Silence Vol.3' AND albums.artist IS NULL ORDER BY tracks.discnumber ASC ,tracks.tracknumber ASC ,tracks.title ASC ;"
Got ERROR: "unknown: Index for table '/home/paracet/.local/share/amarok/mysqle/amarok/albums.MYI' is corrupt; try to repair it" errno: 2000
Got ERROR: "unknown: Index for table '/home/paracet/.local/share/amarok/mysqle/amarok/albums.MYI' is corrupt; try to repair it" errno: 2000
Got ERROR: "unknown: Index for table '/home/paracet/.local/share/amarok/mysqle/amarok/albums.MYI' is corrupt; try to repair it" errno: 2000
Got ERROR: "unknown: Index for table '/home/paracet/.local/share/amarok/mysqle/amarok/albums.MYI' is corrupt; try to repair it" errno: 2000
Comment 3 Heiko Becker 2023-06-09 19:26:57 UTC

*** This bug has been marked as a duplicate of bug 444408 ***