After deleting .kde ... amarok setting... it start without error running from terminal i still see a sql error
.... amarok: BEGIN: virtual void UrlUpdateJob::run() amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: tags amarok: [ERROR!] on query: "SELECT s.deviceid,s.url FROM statistics AS s LEFT JOIN tags AS t ON s.deviceid = t.deviceid AND s.url = t.url WHERE t.url IS NULL AND s.deviceid != -2;" amarok: [MountPointManager] Trying to update 0 statistics rows amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: tags_labels amarok: [ERROR!] on query: "SELECT l.deviceid,l.url FROM tags_labels AS l LEFT JOIN tags as t ON l.deviceid = t.deviceid AND l.url = t.url WHERE t.url IS NULL;" amarok: [MountPointManager] Trying to update 0 tags_labels rows amarok: END__: virtual void UrlUpdateJob::run() - Took 0.0011s .... Then the collection rescan now seems works fine only infos messages about invalid sample rate and so on But after a while... collection was still reading. i get a SIGSEV error. But i can't send back trace. This backtrace appears to be of no use. This is probably because your packages are built in a way which prevents creation of proper backtraces, or the stack frame was seriously corrupted in the crash. On a terminal i see sql insert error i report here. TagLib: MPEG::Properties::read() -- Page headers were invalid. amarok: BEGIN: void ScanManager::slotError(QProcess::ProcessError) amarok: BEGIN: void ScanManager::handleRestart() amarok: Collection scanner crashed, restart count is 1 amarok: BEGIN: virtual void XmlParseJob::requestAbort() amarok: END__: virtual void XmlParseJob::requestAbort() - Took 8.6e-05s amarok: END__: void ScanManager::handleRestart() - Took 0.00048s amarok: END__: void ScanManager::slotError(QProcess::ProcessError) - Took 0.00075s amarok: BEGIN: virtual XmlParseJob::~XmlParseJob() amarok(4898) KDE::ProgressBar::~ProgressBar: " " amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.0057s amarok: BEGIN: void ScanManager::restartScanner() amarok: BEGIN: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) amarok(4898) KDE::ProgressBar::ProgressBar: " " amarok: p before: QPoint(2,-15) amarok: p after: QPoint(128,791) amarok: BEGIN: KDE::ProgressBar& KDE::ProgressBar::setAbortSlot(QObject*, const char*) amarok: END__: KDE::ProgressBar& KDE::ProgressBar::setAbortSlot(QObject*, const char*) - Took 0.0021s amarok: END__: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) - Took 0.074s amarok: BEGIN: virtual void XmlParseJob::run() amarok: BEGIN: ScanResultProcessor::ScanResultProcessor(SqlCollection*) amarok: END__: ScanResultProcessor::ScanResultProcessor(SqlCollection*) - Took 0.0001s amarok: END__: void ScanManager::restartScanner() - Took 0.11s amarok: BEGIN: void DatabaseUpdater::createTemporaryTables() amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table urls_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE urls_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,deviceid INTEGER,rpath VARCHAR(1024),directory INTEGER,uniqueid VARCHAR(128) UNIQUE);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index urls_id_rpath_temp already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX urls_id_rpath_temp ON urls_temp(deviceid, rpath);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index urls_temp_uniqueid already exists amarok: [ERROR!] on query: "CREATE INDEX urls_temp_uniqueid ON urls_temp(uniqueid);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table directories_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE directories_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,deviceid INTEGER,dir VARCHAR(1024),changedate INTEGER);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table artists_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE artists_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(255) NOT NULL);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index artists_temp_name already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX artists_temp_name ON artists_temp(name);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table albums_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE albums_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(255) NOT NULL,artist INTEGER,image INTEGER);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index albums_temp_name already exists amarok: [ERROR!] on query: "CREATE INDEX albums_temp_name ON albums_temp(name);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index albums_temp_artist already exists amarok: [ERROR!] on query: "CREATE INDEX albums_temp_artist ON albums_temp(artist);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index albums_temp_image already exists amarok: [ERROR!] on query: "CREATE INDEX albums_temp_image ON albums_temp(image);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index albums_temp_name_artist already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX albums_temp_name_artist ON albums_temp(name,artist);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table genres_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE genres_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(255) NOT NULL);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index genres_temp_name already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX genres_temp_name ON genres_temp(name);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table composers_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE composers_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(255) NOT NULL);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index composers_temp_name already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX composers_temp_name ON composers_temp(name);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table years_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE years_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,name VARCHAR(255) NOT NULL);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index years_temp_name already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX years_temp_name ON years_temp(name);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table images_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE images_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,path VARCHAR(255) NOT NULL);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index images_temp_name already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX images_temp_name ON images_temp(path);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] table tracks_temp already exists amarok: [ERROR!] on query: "CREATE TEMPORARY TABLE tracks_temp (id INTEGER PRIMARY KEY AUTOINCREMENT,url INTEGER,artist INTEGER,album INTEGER,genre INTEGER,composer INTEGER,year INTEGER,title VARCHAR(255),comment TEXT,tracknumber INTEGER,discnumber INTEGER,bitrate INTEGER,length INTEGER,samplerate INTEGER,filesize INTEGER,filetype INTEGER,bpm FLOAT,createdate INTEGER,modifydate INTEGER);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] index tracks_temp_url already exists amarok: [ERROR!] on query: "CREATE UNIQUE INDEX tracks_temp_url ON tracks_temp(url);" amarok: END__: void DatabaseUpdater::createTemporaryTables() - Took 0.02s amarok: BEGIN: void ScanManager::slotFinished() amarok: END__: void ScanManager::slotFinished() - Took 0.00029s amarok: [ERROR!] sqlite_step error. amarok: [ERROR!] PRIMARY KEY must be unique amarok: [ERROR!] on query: "INSERT INTO directories_temp SELECT * FROM directories;" amarok: BEGIN: void DatabaseUpdater::copyToPermanentTables() amarok: END__: void DatabaseUpdater::copyToPermanentTables() - Took 1.5s amarok: BEGIN: void DatabaseUpdater::removeTemporaryTables() amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: tracks_temp amarok: [ERROR!] on query: "REPLACE INTO tracks_temp(url,artist,album,genre,composer,year,title,comment,tracknumber,discnumber,bitrate,length,samplerate,filesize,filetype,bpm,createdate,modifydate) VALUES ( 1748,247,452,1,1,3,'Perfect Day','08',8,0,320,225,44100,8996864,0,0,0,0);" amarok: END__: void DatabaseUpdater::removeTemporaryTables() - Took 0.17s amarok: Sending changed signal amarok: BEGIN: ScanResultProcessor::~ScanResultProcessor() amarok: END__: ScanResultProcessor::~ScanResultProcessor() - Took 9.2e-05s amarok: END__: virtual void XmlParseJob::run() - Took 8.5s amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: urls_temp amarok: [ERROR!] on query: "SELECT id FROM urls_temp WHERE deviceid = -1 AND rpath = './home/danilo/musica/disco_mp3/Lou Reed - Transformer - 01 - Vicious.mp3';" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: urls_temp amarok: [ERROR!] on query: "SELECT id FROM urls_temp WHERE uniqueid='amarok-sqltrackuid://842182bb699eb53fefba74ba8bd46dc5';" amarok: [ERROR!] sqlite3_compile error: amarok: BEGIN: virtual XmlParseJob::~XmlParseJob() amarok(4898) KDE::ProgressBar::~ProgressBar: " " amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.011s amarok: [ERROR!] no such table: urls_temp amarok: [ERROR!] on insert: "INSERT INTO urls_temp(directory,deviceid,rpath,uniqueid) VALUES ( 220, -1, './home/danilo/musica/disco_mp3/Lou Reed - Transformer - 01 - Vicious.mp3', 'amarok-sqltrackuid://842182bb699eb53fefba74ba8bd46dc5' );" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: tracks_temp amarok: [ERROR!] on query: "REPLACE INTO tracks_temp(url,artist,album,genre,composer,year,title,comment,tracknumber,discnumber,bitrate,length,samplerate,filesize,filetype,bpm,createdate,modifydate) VALUES ( 1748,247,451,5,1,27,'Vicious','',1,0,256,180,44100,5750086,0,0,0,0);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: urls_temp amarok: [ERROR!] on query: "SELECT id FROM urls_temp WHERE deviceid = -1 AND rpath = './home/danilo/musica/disco_mp3/Lou Reed - Transformer - 02 - Andy''s Chest.mp3';" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: urls_temp amarok: [ERROR!] on query: "SELECT id FROM urls_temp WHERE uniqueid='amarok-sqltrackuid://1d704aa554c29333bd0342cb4f9ed7d2';" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: urls_temp amarok: [ERROR!] on insert: "INSERT INTO urls_temp(directory,deviceid,rpath,uniqueid) VALUES ( 220, -1, './home/danilo/musica/disco_mp3/Lou Reed - Transformer - 02 - Andy''s Chest.mp3', 'amarok-sqltrackuid://1d704aa554c29333bd0342cb4f9ed7d2' );" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: tracks_temp amarok: [ERROR!] on query: "REPLACE INTO tracks_temp(url,artist,album,genre,composer,year,title,comment,tracknumber,discnumber,bitrate,length,samplerate,filesize,filetype,bpm,createdate,modifydate) VALUES ( 1748,247,451,5,1,27,'Andy''s Chest','',2,0,320,201,44100,8050705,0,0,0,0);" amarok: [ERROR!] sqlite3_compile error: amarok: [ERROR!] no such table: urls_temp amarok: [ERROR!] on query: "SELECT id FROM urls_temp WHERE deviceid = -1 AND rpath = './home/danilo/musica/disco_mp3/Lou Reed - Transformer - 04 - Hangin'' ''Round.mp3';" amarok: [ERROR!] sqlite3_compile error: . .. .. a lot of SELECT errors same error different songs file here.. ... .. . . amarok: Fatal IO error: client killed amarok: BEGIN: virtual MountPointManager::~MountPointManager() amarok: END__: virtual MountPointManager::~MountPointManager() - Took 0.00034s amarok: BEGIN: virtual TrackToolTip::~TrackToolTip() amarok: END__: virtual TrackToolTip::~TrackToolTip() - Took 0.00028s QSocketNotifier: Invalid socket 21 and type 'Read', disabling... amarok: BEGIN: Amarok::MessageQueue::~MessageQueue() amarok: END__: Amarok::MessageQueue::~MessageQueue() - Took 0.00013s amarok: BEGIN: SvgHandler::~SvgHandler() amarok: END__: SvgHandler::~SvgHandler() - Took 0.00014s amarok: BEGIN: virtual CurrentEngine::~CurrentEngine() amarok: END__: virtual CurrentEngine::~CurrentEngine() - Took 0.0001s amarok: BEGIN: virtual ContextObserver::~ContextObserver() amarok: BEGIN: void ContextSubject::detach(ContextObserver*) amarok: END__: void ContextSubject::detach(ContextObserver*) - Took 8.3e-05s amarok: END__: virtual ContextObserver::~ContextObserver() - Took 0.00027s amarok: BEGIN: virtual PaletteHandler::~PaletteHandler() amarok: END__: virtual PaletteHandler::~PaletteHandler() - Took 0.00012s amarok: BEGIN: virtual CollectionManager::~CollectionManager() KCrash: Application 'amarok' crashing... sock_file=/home/danilo/.kde/socket-ubuntu/kdeinit4__0 QSocketNotifier: Invalid socket 31 and type 'Read', disabling... amarok: END__: virtual CollectionManager::~CollectionManager() - Took 0.15s amarok: BEGIN: virtual EngineController::~EngineController() Unable to start Dr. Konqi Thank you -- [ intrepid ] amarok-kde4 crash on upgrading collection at startup https://bugs.launchpad.net/bugs/264187 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
