Public bug reported:
Binary package hint: amarok-kde4
On a upgraded/updated Ubuntu Intrepid using Gnome running:
rm ~/.kde/share/apps/amarok/collection.db
amarok -d
from terminal, i get a crash, on collection rescan, i have just no
scanned update my long collection before.
"The application Amarok (amarok) crashed and caused the signal 11
(SIGSEGV)."
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.
Below i report some terminal copied error during collection scan:
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.021s
amarok: BEGIN: void ScanManager::slotFinished()
amarok: END__: void ScanManager::slotFinished() - Took 0.00035s
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 2.1s
amarok: BEGIN: void DatabaseUpdater::removeTemporaryTables()
amarok: END__: void DatabaseUpdater::removeTemporaryTables() - Took 0.089s
amarok: Sending changed signal
amarok: BEGIN: ScanResultProcessor::~ScanResultProcessor()
amarok: END__: ScanResultProcessor::~ScanResultProcessor() - Took 0.0053s
amarok: END__: virtual void XmlParseJob::run() - Took 13s
amarok: BEGIN: virtual XmlParseJob::~XmlParseJob()
amarok(14011) KDE::ProgressBar::~ProgressBar: " "
amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.0013s
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/Joan Baez - Will the Circle.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://289f90e2cadc9d95edf61986f60cb37f';"
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/Joan Baez - Will the Circle.mp3',
'amarok-sqltrackuid://289f90e2cadc9d95edf61986f60cb37f' );"
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 ( 1762,235,438,3,1,3,'Will the Circle be
Unbroken','',1,0,160,260,44100,5204096,0,0,0,0);"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: artists_temp
amarok: [ERROR!] on query: "SELECT id FROM artists_temp WHERE name =
'Johannes Brahms';"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: artists_temp
amarok: [ERROR!] on insert: "INSERT INTO artists_temp( name ) VALUES
('Johannes Brahms');"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: albums_temp
amarok: [ERROR!] on query: "SELECT id FROM albums_temp WHERE artist = 1762
AND name = '';"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: albums_temp
amarok: [ERROR!] on insert: "INSERT INTO albums_temp(artist, name) VALUES(
1762, '' );"
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/Johannes Brahms - Hungarian Dance
No. 6.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://0c04b7f639ec3bbf8c5f0f9de8f4e45c';"
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/Johannes Brahms - Hungarian Dance No. 6.mp3',
'amarok-sqltrackuid://0c04b7f639ec3bbf8c5f0f9de8f4e45c' );"
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 ( 1762,1762,1762,1,1,3,'Hungarian Dance No.
6','',0,0,192,179,44100,4292429,0,0,0,0);"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: artists_temp
amarok: [ERROR!] on query: "SELECT id FROM artists_temp WHERE name =
'Patrick Riley';"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: artists_temp
amarok: [ERROR!] on insert: "INSERT INTO artists_temp( name ) VALUES
('Patrick Riley');"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: albums_temp
amarok: [ERROR!] on query: "SELECT id FROM albums_temp WHERE artist = 1762
AND name = 'Miscellaneous II';"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: albums_temp
amarok: [ERROR!] on insert: "INSERT INTO albums_temp(artist, name) VALUES(
1762, 'Miscellaneous II' );"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: genres_temp
amarok: [ERROR!] on query: "SELECT id FROM genres_temp WHERE name =
'genre';"
amarok: [ERROR!] sqlite3_compile error:
amarok: [ERROR!] no such table: genres_temp
amarok: [ERROR!] on insert: "INSERT INTO genres_temp( name ) VALUES
('genre');"
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/Johannes Brahms - Ninna Nanna -
Chitarra Classica.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://5b09d1001c18f8847b1f2a1810529066';"
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/Johannes Brahms - Ninna Nanna - Chitarra
Classica.mp3', 'amarok-sqltrackuid://5b09d1001c18f8847b1f2a1810529066' );"
..
...
...
Amarok end messages before crash:
[EMAIL PROTECTED]:~$ 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.1e-05s
amarok: END__: void ScanManager::handleRestart() - Took 0.00047s
amarok: END__: void ScanManager::slotError(QProcess::ProcessError) - Took
0.00074s
amarok: BEGIN: virtual XmlParseJob::~XmlParseJob()
amarok(14392) KDE::ProgressBar::~ProgressBar: " "
amarok: END__: virtual XmlParseJob::~XmlParseJob() - Took 0.0011s
amarok: BEGIN: void ScanManager::restartScanner()
amarok: BEGIN: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*)
amarok(14392) KDE::ProgressBar::ProgressBar: " "
amarok: p before: QPoint(2,-15)
amarok: p after: QPoint(14,690)
amarok: BEGIN: KDE::ProgressBar& KDE::ProgressBar::setAbortSlot(QObject*, const
char*)
amarok: END__: KDE::ProgressBar& KDE::ProgressBar::setAbortSlot(QObject*, const
char*) - Took 0.00064s
amarok: END__: XmlParseJob::XmlParseJob(ScanManager*, SqlCollection*) - Took
0.14s
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.15s
QSocketNotifier: Invalid socket 25 and type 'Read', disabling...
KCrash: Application 'amarok' crashing...
sock_file=/home/danilo/.kde/socket-ubuntu/kdeinit4__0
QSocketNotifier: Invalid socket 9 and type 'Read', disabling...
QSocketNotifier: Invalid socket 11 and type 'Read', disabling...
amarok: Fatal IO error: client killed
amarok: BEGIN: virtual TrackToolTip::~TrackToolTip()
amarok: END__: virtual TrackToolTip::~TrackToolTip() - Took 0.0002s
amarok: BEGIN: virtual MountPointManager::~MountPointManager()
amarok: END__: virtual MountPointManager::~MountPointManager() - Took 0.00015s
amarok: BEGIN: Amarok::MessageQueue::~MessageQueue()
amarok: END__: Amarok::MessageQueue::~MessageQueue() - Took 9.2e-05s
amarok: BEGIN: SvgHandler::~SvgHandler()
amarok: END__: SvgHandler::~SvgHandler() - Took 0.00015s
amarok: BEGIN: virtual CurrentEngine::~CurrentEngine()
amarok: END__: virtual CurrentEngine::~CurrentEngine() - Took 0.00012s
amarok: BEGIN: virtual ContextObserver::~ContextObserver()
amarok: BEGIN: void ContextSubject::detach(ContextObserver*)
amarok: END__: void ContextSubject::detach(ContextObserver*) - Took 7e-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()
QProcess: Destroyed while process is still running.
amarok: BEGIN: virtual XmlParseJob::~XmlParseJob()
Unable to start Dr. Konqi
** Affects: amarok-kde4 (Ubuntu)
Importance: Undecided
Status: New
--
[ intrepid ] amarok-kde4 crash on upgrading collection at startup
https://bugs.launchpad.net/bugs/264426
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
