https://bugs.kde.org/show_bug.cgi?id=466401
id1...@web.de changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |id1...@web.de
--- Comment #2 from id1...@web.de ---
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
--
You are receiving this mail because:
You are watching all bug changes.
