I can reproduce this error everytime - maybe NTFS is slow, but not that slow look:

Put a medium collecion on read-only NTFS partition (let's make it about 5000 files). After loading up the collection open playlists tab. Clear the playlist and click to populate the list with "never played tracks" (there has to be a lot of them - around 4000). Now as the list is being populated start typing something in "filter" field. The results will start to be filtered and amarok will freeze. I thought that it's dead. But it's not! After 20 minutes it actually creates a filtered list. Here's the shell output (end):

Code: Select all

amarok: BEGIN: void CollectionDB::copyTempTables()
amarok:         [CollectionDB] [ERROR!] [virtual int SqliteConnection::insert(const QString&, const QString&)] sqlite_step error.
amarok:         [CollectionDB] [ERROR!] columns dir, deviceid are not unique
amarok:         [CollectionDB] [ERROR!] on insert: INSERT INTO directories SELECT * FROM directories_temp;
amarok: END__: void CollectionDB::copyTempTables() - Took 1.4s
amarok: END__: virtual bool ScanController::doJob() - Took 95s
amarok: END__: virtual void ThreadWeaver::Thread::run() - Took 95s
[Thread -1270551632 (LWP 28048) exited]

[Thread -1270551632 (LWP 28048) exited]
amarok: BEGIN: virtual void UrlLoader::completeJob()
amarok: END__: virtual void UrlLoader::completeJob() - Took 0.01s
amarok:   [ThreadWeaver] Job completed: UrlLoader. Jobs pending: 0
amarok: END__: UrlLoader - Took 1.3e+03s
amarok: [virtual KDE::ProgressBar::~ProgressBar()]
amarok: [CollectionDB] JobFinishedEvent from Incremental ScanController received.
amarok: current browser is not collection, aborting renderView()
amarok: [ThreadWeaver] Job completed: CollectionScanner. Jobs pending: 0
amarok: BEGIN: virtual ScanController::~ScanController()
amarok: END__: virtual ScanController::~ScanController() - Took 0.00058s
amarok: [virtual KDE::ProgressBar::~ProgressBar()]
amarok: [virtual QDragObject* Playlist::dragObject()] thread: None
amarok: [virtual QDragObject* Playlist::dragObject()] thread: None
amarok: BEGIN: virtual void PlaylistBrowserView::startDrag()
amarok: END__: virtual void PlaylistBrowserView::startDrag() - Took 0.023s
amarok: [void ContextBrowser::tabChanged(QWidget*)]
amarok: current browser is not collection, aborting renderView()
amarok: [virtual QDragObject* Playlist::dragObject()] thread: None
amarok: BEGIN: ScanController::ScanController(CollectionDB*, bool, const QStringList&)
amarok: BEGIN: void ScanController::initIncremental()
amarok:     [ThreadWeaver] Threads in pool: 2
amarok:     [ScanController] Collection dir changed: /home/pielgrzym/Desktop
amarok:     [ScanController] Collection dir changed: /home/pielgrzym/muza - temp
amarok:     [ScanController] Collection dir changed: /home/pielgrzym/download
amarok:     [ScanController] Collection dir changed: /home/pielgrzym/download/niedociagniete
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b/data
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b/data/buttons
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b/data/icons
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b/services
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b/extensions
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b/imageformats
amarok:     [ScanController] Collection dir removed: /home/pielgrzym/Last.fm_Client_1.0.0b/cache
amarok:     [ScanController] Collection dir changed: /home/pielgrzym/fotki
amarok:     [ScanController] Collection dir changed: /home/pielgrzym
amarok:     [ScanController] Collection was modified.



During the populating of "Never played tracks list" I get a huge bunch of such errors in shell:

Code: Select all

amarok:           [CollectionDB] [ERROR!] no such table: uniqueid_temp
amarok:           [CollectionDB] [ERROR!] on query: SELECT uniqueid FROM uniqueid_temp WHERE deviceid = 1 AND url = './muza od Racia/I{azik/Kazik Melassa/Kazik17.mp3';
amarok:           [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:           [CollectionDB] [ERROR!] no such table: uniqueid_temp
amarok:           [CollectionDB] [ERROR!] on query: SELECT uniqueid FROM uniqueid_temp WHERE deviceid = 2 AND url = './mp3/od DJa/Łzy- Narcyz.mp3';
amarok: END__: virtual bool SqlLoader::doJob() - Took 18s
amarok: END__: virtual void ThreadWeaver::Thread::run() - Took 18s
[Thread -1287775312 (LWP 28049) exited]


Any idea how to fix this? It happent on standard Kubuntu package as well as on self compiled one.


I'm trying to get some debug info, but afer running the configure with debug enabled copiling results mostly with "nothing to do in dir " and everything done in dir ". Is it ok? Did I actually installed debug output?

just a couple of things... Amarok versions tried with? Have you recently up/downgraded amarok versions? Did you have any trouble actually building the collection?

And what happens with a local collection (native file system, I mean) - the desired result only faster?

Also, have you tried with mysql as well?

Your console output looks ok.

I can confirm it's not just RO NTFS... I experience similar delays with loading any large playlist then entering a filter while it's loading. It appears to lock up the GUI (but only amarok) while loading. Meanwhile, amarok is using 94% CPU for the duration.
My collection is on a network drive (NFS), I'm using mysql, with amarok SVN from about 3 days ago.

While it's not an ideal solution, it's not recommended that you use amarok for large playlists, simply for the reason that manipulation of such lists is quite CPU and RAM intense - an alternative would be to use the collection filter instead, or construct smart playlists and use dynamic playlists to load them.

I recently upgraded from Amarok 1.3.9 to 1.4.2. When this (and other lockups) occured I thought it reqiuers more horsepower so I compiled it (1.4.2) using instructions from FAQ.

I don't have any collection on linux partitions. I can say that filtering collection in the sidebar works fine (yet, it also freezes sometimes).

I haven't tried mySQL.  Sometimes amarok just plainly quits (without a reason in the middle of track).

As for installing mySQL - when I was recompiling amarok to use debugging I provided "--enable-mysql" option, but configure output said it won't be availible. Guess I need to install mySQL first EDIT: doublechecked - I've got mySQL common files it must be a compilation problem


And a question regarding recompiling with other configure options. I typed in the amarok package directory:

Code: Select all

sudo make uninstall

It removed amarok. After succesfully running configure the "make" command ran really fast, apparently skipping most (if not all) operations. Is it normal behaviour or I did something wrong?

Thanks for help

Ah, if you've changed the config around, it can be helpful to do 'make clean' to clear out pre-compiled code, and start fresh with the new configure options.

for mysql you may also require mysql-server (as well as the devel packages if you're going to compile against mysql) and/or mysql-client.

I've recompiled successfully amarok. Now I can have a mySQL collection. I followed all the rules in mySQL FAQ it amarok doesn't start building collection. Damn, this is all pretty frustrating

I don't know why amarok on my system is so damn unstablem. Random crashes, freezes wher trying tu run last.fm (with no reason in debugger). It drives me mad