esperto
Apprentice
Joined: 27 Dec 2004
Posts: 158
Location: Brazil
|
 Posted: Sun Sep 10, 2017 3:03 pm Post subject: Amarok MySQLe repair |
 |
|
Hi all,
My amarok is crashing randomly for about a week now, when I ran amarok debug I got the message below:
| Code: |
*** Error in `amarok: [BiasSolver] collection has 19937 uids
amarok: [BiasSolver] generating playlist
KCrash: Application 'amarok' crashing...
KCrash: Attempting to start from kdeinit
KCrash: Connect sock_file=/home/rafael/.kde4/socket-rafael/kdeinit4__0
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://57eb06dc0147e47140807be8bdca004c';"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50b0003ea8] filesystem access error: read error: Bad file descriptor
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50b0003ea8] core access error: Erro de leitura do arquivo
[00007f50b0003ea8] core access error: O VLC não pode ler o arquivo (Descritor de arquivo inv?lido).
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
KCrash: Attempting to start directly
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
KCrash failed to exec(), errno = 2
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://57eb06dc0147e47140807be8bdca004c"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://e721f8c872b46c637e3c24adec900cf0';"
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://e721f8c872b46c637e3c24adec900cf0"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://140540c40e14e4c95cbdf67612e58278';"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://140540c40e14e4c95cbdf67612e58278"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://5c0eea3760b988e57be0200b745f2240';"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://5c0eea3760b988e57be0200b745f2240"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://1c6ea118e8ce37708cbe23369c8e1efc';"
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://1c6ea118e8ce37708cbe23369c8e1efc"
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://883f3a79d5be5d387c5b95ac12c45a87';"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://883f3a79d5be5d387c5b95ac12c45a87"
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://2581e32bb2e4189f167bc49502b5633d';"
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://2581e32bb2e4189f167bc49502b5633d"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
amarok: [ERROR__] [MySqlStorage] "MySQLe query failed! (126) Incorrect key file for table '/home/rafael/.kde4/share/apps/amarok/mysqle/amarok/urls.MYI'; 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 urls LEFT JOIN tracks ON urls.id = tracks.url LEFT JOIN statistics ON urls.id = statistics.url 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 WHERE urls.uniqueid = 'amarok-sqltrackuid://37faca0d47008a86fb3e3fbded28a9f3';"
amarok: [WARNING] [BiasSolver] trackForUid returned no track for "amarok-sqltrackuid://37faca0d47008a86fb3e3fbded28a9f3"
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
[00007f50a0040118] alsa audio output error: cannot recover playback stream: Erro de entrada/saída
|
It seems the Amarok MySQL embedded database needs repair, but I couldn't find a way how (maybe my google fu is not good today), does anyone knows if it is possible?
[Moderator edit: changed [quote] tags to [code] tags to preserve output layout. -Hu]
_________________
nasci pelado, careca e sem dente, o que vier é lucro |
|
Multimedia
