| Summary: | Reproducable crash when typing in search field | ||
|---|---|---|---|
| Product: | [Applications] amarok | Reporter: | Bernhard <kdebugs> |
| Component: | general | Assignee: | Amarok Bugs <amarok-bugs-null> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | crash | CC: | heiko.becker, id1402, tuomas |
| Priority: | NOR | Keywords: | drkonqi |
| Version First Reported In: | 2.9.71 | ||
| Target Milestone: | kf5 | ||
| Platform: | openSUSE | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed/Implemented In: | ||
| Sentry Crash Report: | |||
|
Description
Bernhard
2023-02-25 12:23:11 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? 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 *** This bug has been marked as a duplicate of bug 444408 *** |