sqlitelock

amarok:   END__: virtual bool CurrentTrackJob::doJob() - Took 1.3s
amarok: END__: virtual void ThreadWeaver::Thread::run() - Took 1.3s
amarok: BEGIN: void EngineSubject::stateChangedNotify(Engine::State)
amarok:   BEGIN: virtual void ContextBrowser::engineStateChanged(Engine::State, Engine::State)
amarok:     [ContextBrowser] Rendering showCurrentTrack()
amarok:     [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] Query-start: SELECT COUNT( url ) FROM statistics LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM statistics LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] Query-start: SELECT COUNT( url ) FROM podcastchannels LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] SQL-query (0s): SELECT COUNT( url ) FROM podcastchannels LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] Query-start: SELECT COUNT( url ) FROM podcastepisodes LIMIT 1 OFFSET 0;
amarok:     [CollectionDB] SQL-query (0s): SELECT COUNT( url ) FROM podcastepisodes LIMIT 1 OFFSET 0;
amarok:   END__: virtual void ContextBrowser::engineStateChanged(Engine::State, Engine::State) - Took 0.035s
amarok: END__: void EngineSubject::stateChangedNotify(Engine::State) - Took 0.056s
amarok: [ThreadWeaver] Job aborted: CurrentTrackJob. Jobs pending: 1
amarok: [CollectionDB] Query-start: SELECT playcounter, createdate, accessdate, rating FROM statistics WHERE url = '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3';
amarok: [CollectionDB] SQL-query (0s): SELECT playcounter, createdate, accessdate, rating FROM statistics WHERE url = '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3';
amarok: [CollectionDB] Query-start: REPLACE INTO statistics ( url, createdate, accessdate, percentage, playcounter, rating ) VALUES ( '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3', '1148143515', '1151619582', 70, 14, 0 );
amarok: BEGIN: virtual void ThreadWeaver::Thread::run()
amarok:   BEGIN: virtual bool CurrentTrackJob::doJob()
amarok:     BEGIN: void CurrentTrackJob::showHome()
amarok:       [CollectionDB] Query-start: SELECT tags.title,tags.url,artist.name,album.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url  WHERE 1  ORDER BY COALESCE( statistics.accessdate, 0 ) DESC  LIMIT 10 OFFSET 0 ;
amarok:       BEGIN: SqliteConnection::SqliteConnection(const SqliteConfig*)
amarok:       END__: SqliteConnection::SqliteConnection(const SqliteConfig*) - Took 0.00058s
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT tags.title,tags.url,artist.name,album.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url  WHERE 1  ORDER BY COALESCE( statistics.accessdate, 0 ) DESC  LIMIT 10 OFFSET 0 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT tags.title,tags.url,artist.name,album.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url  WHERE 1  ORDER BY COALESCE( statistics.accessdate, 0 ) DESC  LIMIT 10 OFFSET 0 ;
amarok:       [CollectionDB] Query-start: SELECT DISTINCT Count(tags.url) AS Counttagsurl FROM tags  WHERE 1 ;
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT DISTINCT Count(tags.url) AS Counttagsurl FROM tags  WHERE 1 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT DISTINCT Count(tags.url) AS Counttagsurl FROM tags  WHERE 1 ;
amarok:       [CollectionDB] Query-start: SELECT DISTINCT Count(artist.id) AS Countartistid FROM artist  WHERE 1 ;
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT DISTINCT Count(artist.id) AS Countartistid FROM artist  WHERE 1 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT DISTINCT Count(artist.id) AS Countartistid FROM artist  WHERE 1 ;
amarok:       [CollectionDB] Query-start: SELECT DISTINCT Count(album.id) AS Countalbumid FROM album  WHERE 1 ;
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT DISTINCT Count(album.id) AS Countalbumid FROM album  WHERE 1 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT DISTINCT Count(album.id) AS Countalbumid FROM album  WHERE 1 ;
amarok:       [CollectionDB] Query-start: SELECT DISTINCT Count(genre.id) AS Countgenreid FROM genre  WHERE 1 ;
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT DISTINCT Count(genre.id) AS Countgenreid FROM genre  WHERE 1 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT DISTINCT Count(genre.id) AS Countgenreid FROM genre  WHERE 1 ;
amarok:       [CollectionDB] Query-start: SELECT Sum(tags.length) AS Sumtagslength FROM tags  WHERE 1 ;
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT Sum(tags.length) AS Sumtagslength FROM tags  WHERE 1 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT Sum(tags.length) AS Sumtagslength FROM tags  WHERE 1 ;
amarok:       [CollectionDB] Query-start: SELECT album.name,album.id,Max(tags.createdate) AS Maxtagscreatedate,artist.id FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist  WHERE 1 AND ( 1 AND album.name <> 'Unknown' AND album.name <> ''  ) AND tags.sampler = 0  GROUP BY album.id,artist.id,album.name ORDER BY COALESCE( Maxtagscreatedate, 0 ) DESC  LIMIT 5 OFFSET 0 ;
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT album.name,album.id,Max(tags.createdate) AS Maxtagscreatedate,artist.id FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist  WHERE 1 AND ( 1 AND album.name <> 'Unknown' AND album.name <> ''  ) AND tags.sampler = 0  GROUP BY album.id,artist.id,album.name ORDER BY COALESCE( Maxtagscreatedate, 0 ) DESC  LIMIT 5 OFFSET 0 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT album.name,album.id,Max(tags.createdate) AS Maxtagscreatedate,artist.id FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist  WHERE 1 AND ( 1 AND album.name <> 'Unknown' AND album.name <> ''  ) AND tags.sampler = 0  GROUP BY album.id,artist.id,album.name ORDER BY COALESCE( Maxtagscreatedate, 0 ) DESC  LIMIT 5 OFFSET 0 ;
amarok:       [CollectionDB] Query-start: SELECT album.name,album.id,Avg(COALESCE(NULLIF(statistics.percentage, 0), 50)) AS Avgstatisticspercentage,artist.id FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url  WHERE 1 AND ( 1 AND album.name <> 'Unknown' AND album.name <> ''  ) AND tags.sampler = 0  GROUP BY album.id,artist.id,album.name HAVING Count(album.id)>3 AND Avg(statistics.percentage)>0 ORDER BY Avgstatisticspercentage DESC  LIMIT 5 OFFSET 0 ;
amarok:       [CollectionDB] [ERROR!] [virtual QStringList SqliteConnection::query(const QString&)]  sqlite3_compile error:
amarok:       [CollectionDB] [ERROR!] database is locked
amarok:       [CollectionDB] [ERROR!] on query: SELECT album.name,album.id,Avg(COALESCE(NULLIF(statistics.percentage, 0), 50)) AS Avgstatisticspercentage,artist.id FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url  WHERE 1 AND ( 1 AND album.name <> 'Unknown' AND album.name <> ''  ) AND tags.sampler = 0  GROUP BY album.id,artist.id,album.name HAVING Count(album.id)>3 AND Avg(statistics.percentage)>0 ORDER BY Avgstatisticspercentage DESC  LIMIT 5 OFFSET 0 ;
amarok:       [CollectionDB] SQL-query (0s): SELECT album.name,album.id,Avg(COALESCE(NULLIF(statistics.percentage, 0), 50)) AS Avgstatisticspercentage,artist.id FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist LEFT JOIN statistics ON statistics.url=tags.url  WHERE 1 AND ( 1 AND album.name <> 'Unknown' AND album.name <> ''  ) AND tags.sampler = 0  GROUP BY album.id,artist.id,album.name HAVING Count(album.id)>3 AND Avg(statistics.percentage)>0 ORDER BY Avgstatisticspercentage DESC  LIMIT 5 OFFSET 0 ;
amarok:     END__: void CurrentTrackJob::showHome() - Took 0.014s
amarok:   END__: virtual bool CurrentTrackJob::doJob() - Took 0.014s
amarok: END__: virtual void ThreadWeaver::Thread::run() - Took 0.017s
amarok: [CollectionDB] SQL-query (0s): REPLACE INTO statistics ( url, createdate, accessdate, percentage, playcounter, rating ) VALUES ( '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3', '1148143515', '1151619582', 70, 14, 0 );
amarok: [CollectionDB] Query-start: SELECT playcounter FROM statistics WHERE url = '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3';
amarok: [CollectionDB] SQL-query (0.01s): SELECT playcounter FROM statistics WHERE url = '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3';
amarok: [CollectionDB] Query-start: SELECT accessdate FROM statistics WHERE url = '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3';
amarok: [CollectionDB] SQL-query (0s): SELECT accessdate FROM statistics WHERE url = '/mnt/hda4/dc/Mirror Ball/08 - Peace And Love.mp3';
amarok: [ThreadWeaver] Job completed: CurrentTrackJob. Jobs pending: 0
amarok: [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok: [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok: BEGIN: ScanController::ScanController(CollectionDB*, bool, const QStringList&)
amarok:   BEGIN: void ScanController::initIncremental()
amarok:     [CollectionDB] Query-start: SELECT dir, changedate FROM directories;
amarok:     [CollectionDB] SQL-query (0.01s): SELECT dir, changedate FROM directories;
amarok:   END__: void ScanController::initIncremental() - Took 0.046s
amarok: END__: ScanController::ScanController(CollectionDB*, bool, const QStringList&) - Took 0.046s
amarok: BEGIN: virtual void ThreadWeaver::Thread::run()
amarok:   BEGIN: virtual bool ScanController::doJob()
amarok:     BEGIN: SqliteConnection::SqliteConnection(const SqliteConfig*)
amarok:     END__: SqliteConnection::SqliteConnection(const SqliteConfig*) - Took 0.001s
amarok:   END__: virtual bool ScanController::doJob() - Took 0.0045s
amarok:   [CollectionDB] JobFinishedEvent from Incremental ScanController received.
amarok:   [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [CollectionDB] SQL-query (0.02s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [ThreadWeaver] Job completed: CollectionScanner. Jobs pending: 0
amarok:   BEGIN: virtual ScanController::~ScanController()
amarok:   END__: virtual ScanController::~ScanController() - Took 0.00014s
amarok: END__: virtual void ThreadWeaver::Thread::run() - Took 0.036s
amarok: [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok: [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok: BEGIN: ScanController::ScanController(CollectionDB*, bool, const QStringList&)
amarok:   BEGIN: void ScanController::initIncremental()
amarok:     [CollectionDB] Query-start: SELECT dir, changedate FROM directories;
amarok:     [CollectionDB] SQL-query (0.01s): SELECT dir, changedate FROM directories;
amarok:   END__: void ScanController::initIncremental() - Took 0.044s
amarok: END__: ScanController::ScanController(CollectionDB*, bool, const QStringList&) - Took 0.044s
amarok: BEGIN: virtual void ThreadWeaver::Thread::run()
amarok:   BEGIN: virtual bool ScanController::doJob()
amarok:     BEGIN: SqliteConnection::SqliteConnection(const SqliteConfig*)
amarok:     END__: SqliteConnection::SqliteConnection(const SqliteConfig*) - Took 0.001s
amarok:   END__: virtual bool ScanController::doJob() - Took 0.0034s
amarok:   [CollectionDB] JobFinishedEvent from Incremental ScanController received.
amarok:   [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [CollectionDB] Query-start: SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [CollectionDB] SQL-query (0.01s): SELECT COUNT( url ) FROM tags LIMIT 1 OFFSET 0;
amarok:   [ThreadWeaver] Job completed: CollectionScanner. Jobs pending: 0
amarok:   BEGIN: virtual ScanController::~ScanController()
amarok:   END__: virtual ScanController::~ScanController() - Took 0.00015s
amarok: END__: virtual void ThreadWeaver::Thread::run() - Took 0.035s