{"action":"opened","issue":{"url":"https://api.github.com/repos/clementine-player/Clementine/issues/4858","labels_url":"https://api.github.com/repos/clementine-player/Clementine/issues/4858/labels{/name}","comments_url":"https://api.github.com/repos/clementine-player/Clementine/issues/4858/comments","events_url":"https://api.github.com/repos/clementine-player/Clementine/issues/4858/events","html_url":"https://github.com/clementine-player/Clementine/issues/4858","id":76858386,"number":4858,"title":"crashes periodically when trying to browse large collection","user":{"login":"greenscar","id":4122160,"avatar_url":"https://avatars.githubusercontent.com/u/4122160?v=3","gravatar_id":"","url":"https://api.github.com/users/greenscar","html_url":"https://github.com/greenscar","followers_url":"https://api.github.com/users/greenscar/followers","following_url":"https://api.github.com/users/greenscar/following{/other_user}","gists_url":"https://api.github.com/users/greenscar/gists{/gist_id}","starred_url":"https://api.github.com/users/greenscar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greenscar/subscriptions","organizations_url":"https://api.github.com/users/greenscar/orgs","repos_url":"https://api.github.com/users/greenscar/repos","events_url":"https://api.github.com/users/greenscar/events{/privacy}","received_events_url":"https://api.github.com/users/greenscar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-05-15T21:11:36Z","updated_at":"2015-05-15T21:11:36Z","closed_at":null,"body":"Here is the crash report. Happens once a day or so. Very large collection. After listening for a while, I go over to browse music to put something else on. App hangs and eventually I must kill it.  \r\n\r\nIs sqllite causing it?\r\n'''\r\n\r\nProcess:         clementine (Clementine) [98307]\r\nPath:            /Applications/clementine.app/Contents/MacOS/clementine\r\nArchitecture:    x86_64\r\nParent:          launchd [1]\r\nUID:             501\r\nTask size:       132377 pages (+1079)\r\nCPU Time:        1.024s\r\nNote:            Unresponsive for 477 seconds before sampling\r\nNote:            2 idle work queue threads omitted\r\n\r\n  Thread 0x49eec2     DispatchQueue 1     11 samples (1-11)   priority 4          cpu time 0.988s\r\n  <frontmost, thread QoS background, darwinbg, boosted, received importance donation from WindowServer [265], IO policy utility>\r\n  11  start + 1 (libdyld.dylib + 13769) [0x7fff8efb85c9] 1-11\r\n    11  main + 4077 (clementine + 62845) [0x104e1257d] 1-11\r\n      11  QCoreApplication::exec() + 199 (QtCore + 1030983) [0x107e4fb47] 1-11\r\n        11  QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) + 473 (QtCore + 1020681) [0x107e4d309] 1-11\r\n          11  QEventDispatcherMac::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) + 435 (QtGui + 259283) [0x10720f4d3] 1-11\r\n            11  -[NSApplication run] + 594 (AppKit + 551923) [0x7fff8f916bf3] 1-11\r\n              11  -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 346 (AppKit + 593768) [0x7fff8f920f68] 1-11\r\n                11  _DPSNextEvent + 978 (AppKit + 596411) [0x7fff8f9219bb] 1-11\r\n                  11  _BlockUntilNextEventMatchingListInModeWithFilter + 71 (HIToolbox + 205099) [0x7fff8e86c12b] 1-11\r\n                    11  ReceiveNextEventCommon + 431 (HIToolbox + 205546) [0x7fff8e86c2ea] 1-11\r\n                      11  RunCurrentEventLoopInMode + 235 (HIToolbox + 206191) [0x7fff8e86c56f] 1-11\r\n                        11  CFRunLoopRunSpecific + 296 (CoreFoundation + 465880) [0x7fff8d159bd8] 1-11\r\n                          11  __CFRunLoopRun + 927 (CoreFoundation + 467391) [0x7fff8d15a1bf] 1-11\r\n                            11  __CFRunLoopDoSources0 + 269 (CoreFoundation + 469901) [0x7fff8d15ab8d] 1-11\r\n                              11  __CFRUNLOOP_IS_CALLING_OUT_TO_A_SOURCE0_PERFORM_FUNCTION__ + 17 (CoreFoundation + 526849) [0x7fff8d168a01] 1-11\r\n                                11  processPostedEvents(QEventDispatcherMacPrivate*, bool) + 440 (QtGui + 265272) [0x107210c38] 1-11\r\n                                  11  QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) + 726 (QtCore + 1032358) [0x107e500a6] 1-11\r\n                                    11  QApplication::notify(QObject*, QEvent*) + 6372 (QtGui + 567796) [0x10725a9f4] 1-11\r\n                                      11  QApplicationPrivate::notify_helper(QObject*, QEvent*) + 252 (QtGui + 556988) [0x107257fbc] 1-11\r\n                                        11  QFutureWatcherBase::event(QEvent*) + 192 (QtCore + 78448) [0x107d67270] 1-11\r\n                                          11  QMetaObject::activate(QObject*, QMetaObject const*, int, void**) + 2364 (QtCore + 1113276) [0x107e63cbc] 1-11\r\n                                            11  LibraryModel::qt_static_metacall(QObject*, QMetaObject::Call, int, void**) + 293 (clementine + 3921029) [0x1051c0485] 1-11\r\n                                              11  LibraryModel::ResetAsyncQueryFinished() + 178 (clementine + 1473746) [0x104f6acd2] 1-11\r\n                                                11  QAbstractItemModel::endResetModel() + 317 (QtCore + 1003373) [0x107e48f6d] 1-11\r\n                                                  11  QMetaObject::activate(QObject*, QMetaObject const*, int, void**) + 2364 (QtCore + 1113276) [0x107e63cbc] 1-11\r\n                                                    11  LibraryView::RestoreFocus() + 91 (clementine + 1536043) [0x104f7a02b] 1-11\r\n                                                      11  LibraryView::RestoreLevelFocus(QModelIndex const&) + 878 (clementine + 1536958) [0x104f7a3be] 1-11\r\n                                                        11  LibraryView::RestoreLevelFocus(QModelIndex const&) + 878 (clementine + 1536958) [0x104f7a3be] 1-11\r\n                                                          11  LibraryView::RestoreLevelFocus(QModelIndex const&) + 982 (clementine + 1537062) [0x104f7a426] 1-11\r\n                                                            11  QAbstractItemView::setCurrentIndex(QModelIndex const&) + 139 (QtGui + 4871787) [0x10767566b] 1-11\r\n                                                              11  QItemSelectionModel::setCurrentIndex(QModelIndex const&, QFlags<QItemSelectionModel::SelectionFlag>) + 162 (QtGui + 5211970) [0x1076c8742] 1-11\r\n                                                                11  QItemSelectionModel::select(QModelIndex const&, QFlags<QItemSelectionModel::SelectionFlag>) + 79 (QtGui + 5208223) [0x1076c789f] 1-11\r\n                                                                  11  QItemSelectionModel::select(QItemSelection const&, QFlags<QItemSelectionModel::SelectionFlag>) + 793 (QtGui + 5209161) [0x1076c7c49] 1-11\r\n                                                                    11  QItemSelectionModel::emitSelectionChanged(QItemSelection const&, QItemSelection const&) + 291 (QtGui + 5209811) [0x1076c7ed3] 1-11\r\n                                                                      11  QMetaObject::activate(QObject*, QMetaObject const*, int, void**) + 2364 (QtCore + 1113276) [0x107e63cbc] 1-11\r\n                                                                        11  QAbstractItemView::qt_static_metacall(QObject*, QMetaObject::Call, int, void**) + 719 (QtGui + 4921375) [0x10768181f] 1-11\r\n                                                                          11  QTreeView::selectionChanged(QItemSelection const&, QItemSelection const&) + 31 (QtGui + 5160959) [0x1076bbfff] 1-11\r\n                                                                            11  QAbstractItemView::selectionChanged(QItemSelection const&, QItemSelection const&) + 95 (QtGui + 4914207) [0x10767fc1f] 1-11\r\n                                                                              11  QTreeView::visualRegionForSelection(QItemSelection const&) const + 593 (QtGui + 5148369) [0x1076b8ed1] 1-11\r\n                                                                                11  QTreeView::visualRect(QModelIndex const&) const + 362 (QtGui + 5116218) [0x1076b113a] 1-11\r\n                                                                                  11  QTreeViewPrivate::coordinateForItem(int) const + 298 (QtGui + 5116650) [0x1076b12ea] 1-11\r\n                                                                                    11  QTreeViewPrivate::itemHeight(int) const + 113 (QtGui + 5108897) [0x1076af4a1] 1-11\r\n                                                                                      11  QTreeView::indexRowSizeHint(QModelIndex const&) const + 940 (QtGui + 5108572) [0x1076af35c] 1-11\r\n                                                                                        11  QStyledItemDelegate::sizeHint(QStyleOptionViewItem const&, QModelIndex const&) const + 179 (QtGui + 5504499) [0x10770fdf3] 1-11\r\n                                                                                          11  QStyledItemDelegate::initStyleOption(QStyleOptionViewItem*, QModelIndex const&) const + 673 (QtGui + 5502945) [0x10770f7e1] 1-11\r\n                                                                                            11  QSortFilterProxyModel::data(QModelIndex const&, int) const + 109 (QtGui + 5394701) [0x1076f510d] 1-11\r\n                                                                                              11  LibraryModel::data(QModelIndex const&, int) const + 107 (clementine + 1462507) [0x104f680eb] 1-11\r\n                                                                                                11  LibraryModel::AlbumIcon(QModelIndex const&) + 327 (clementine + 1461031) [0x104f67b27] 1-11\r\n                                                                                                  11  LibraryModel::GetChildSongs(QModelIndex const&) const + 154 (clementine + 1461802) [0x104f67e2a] 1-11\r\n                                                                                                    11  LibraryModel::GetChildSongs(QList<QModelIndex> const&) const + 213 (clementine + 1484389) [0x104f6d665] 1-11\r\n                                                                                                      3   LibraryModel::GetChildSongs(LibraryItem*, QList<QUrl>*, QList<Song>*, QSet<int>*) const + 765 (clementine + 1483469) [0x104f6d2cd] 1-3\r\n                                                                                                        3   LibraryModel::GetChildSongs(LibraryItem*, QList<QUrl>*, QList<Song>*, QSet<int>*) const + 141 (clementine + 1482845) [0x104f6d05d] 1-3\r\n                                                                                                          3   LibraryModel::LazyPopulate(LibraryItem*, bool) + 52 (clementine + 1463812) [0x104f68604] 1-3\r\n                                                                                                            3   LibraryModel::RunQuery(LibraryItem*) + 424 (clementine + 1464680) [0x104f68968] 1-3\r\n                                                                                                              3   LibraryQuery::Next() + 13 (clementine + 1513485) [0x104f7480d] 1-3\r\n                                                                                                                3   QSqlQuery::next() + 104 (QtSql + 13576) [0x107bf4508] 1-3\r\n                                                                                                                  3   ClementineSqlCachedResult::fetchNext() + 54 (clementine + 5184630) [0x1052f4c76] 1-3\r\n                                                                                                                    3   ClementineSqlCachedResult::cacheNext() + 272 (clementine + 5184496) [0x1052f4bf0] 1-3\r\n                                                                                                                      3   QSQLiteResult::gotoNext(QVector<QVariant>&, int) + 15 (clementine + 5169695) [0x1052f121f] 1-3\r\n                                                                                                                        3   QSQLiteResultPrivate::fetchNext(QVector<QVariant>&, int, bool) + 443 (clementine + 5163579) [0x1052efa3b] 1-3\r\n                                                                                                                          3   sqlite3_step + 354 (clementine + 5223506) [0x1052fe452] 1-3\r\n                                                                                                                            1   sqlite3VdbeExec + 59734 (clementine + 6076614) [0x1053ce8c6] (running) 1\r\n                                                                                                                            1   sqlite3VdbeExec + 3825 (clementine + 6020705) [0x1053c0e61] 2\r\n                                                                                                                              1   sqlite3BtreeMovetoUnpacked + 1168 (clementine + 6014128) [0x1053bf4b0] 2\r\n                                                                                                                                1   sqlite3PagerAcquire + 82 (clementine + 5208082) [0x1052fa812] 2\r\n                                                                                                                                  1   sqlite3PcacheFetch + 169 (clementine + 5422105) [0x10532ec19] 2\r\n                                                                                                                                    1   pcache1Fetch + 1527 (clementine + 5431223) [0x105330fb7] 2\r\n                                                                                                                                      1   pthread_mutex_unlock + 63 (libsystem_pthread.dylib + 6990) [0x7fff90cabb4e] 2\r\n                                                                                                                                        1   OSAtomicCompareAndSwapPtrBarrier$VARIANT$mp + 8 (libsystem_platform.dylib + 13128) [0x7fff92566348] (running) 2\r\n                                                                                                                            1   sqlite3VdbeExec + 2074 (clementine + 6018954) [0x1053c078a] 3\r\n                                                                                                                              1   fulltextNext + 791 (clementine + 5326023) [0x1053174c7] 3\r\n                                                                                                                                1   sqlite3_step + 354 (clementine + 5223506) [0x1052fe452] 3\r\n                                                                                                                                  1   sqlite3VdbeExec + 3825 (clementine + 6020705) [0x1053c0e61] 3\r\n                                                                                                                                    1   sqlite3BtreeMovetoUnpacked + 941 (clementine + 6013901) [0x1053bf3cd] (running) 3\r\n                                                                                                      8   LibraryModel::GetChildSongs(LibraryItem*, QList<QUrl>*, QList<Song>*, QSet<int>*) const + 141 (clementine + 1482845) [0x104f6d05d] 4-11\r\n                                                                                                        8   LibraryModel::LazyPopulate(LibraryItem*, bool) + 52 (clementine + 1463812) [0x104f68604] 4-11\r\n                                                                                                          5   LibraryModel::RunQuery(LibraryItem*) + 283 (clementine + 1464539) [0x104f688db] 4-8\r\n                                                                                                            5   LibraryModel::HasCompilations(LibraryQuery const&) + 127 (clementine + 1464063) [0x104f686ff] 4-8\r\n                                                                                                              5   LibraryBackend::ExecQuery(LibraryQuery*) + 63 (clementine + 1413103) [0x104f5bfef] 4-8\r\n                                                                                                                1   LibraryQuery::Exec(QSqlDatabase, QString const&, QString const&) + 1359 (clementine + 1511807) [0x104f7417f] 4\r\n                                                                                                                  1   QSqlQuery::QSqlQuery(QString const&, QSqlDatabase) + 61 (QtSql + 11213) [0x107bf3bcd] 4\r\n                                                                                                                    1   qInit(QSqlQuery*, QString const&, QSqlDatabase) + 310 (QtSql + 11654) [0x107bf3d86] 4\r\n                                                                                                                      1   QSqlQuery::exec(QString const&) + 625 (QtSql + 12657) [0x107bf4171] 4\r\n                                                                                                                        1   QSQLiteResult::reset(QString const&) + 15 (clementine + 5166767) [0x1052f06af] 4\r\n                                                                                                                          1   QSQLiteResult::prepare(QString const&) + 206 (clementine + 5167006) [0x1052f079e] 4\r\n                                                                                                                            1   sqlite3Prepare16 + 551 (clementine + 5254711) [0x105305e37] 4\r\n                                                                                                                              1   sqlite3LockAndPrepare + 125 (clementine + 5253789) [0x105305a9d] 4\r\n                                                                                                                                1   sqlite3Prepare + 923 (clementine + 6002427) [0x1053bc6fb] 4\r\n                                                                                                                                  1   sqlite3RunParser + 528 (clementine + 5259344) [0x105307050] 4\r\n                                                                                                                                    1   sqlite3Parser + 294 (clementine + 5465574) [0x1053395e6] 4\r\n                                                                                                                                      1   yy_reduce + 6111 (clementine + 5486863) [0x10533e90f] 4\r\n                                                                                                                                        1   sqlite3Select + 33685 (clementine + 5690373) [0x105370405] 4\r\n                                                                                                                                          1   sqlite3WhereBegin + 1924 (clementine + 5902740) [0x1053a4194] 4\r\n                                                                                                                                            1   bestVirtualIndex + 1189 (clementine + 5919701) [0x1053a83d5] 4\r\n                                                                                                                                             *1   return_from_trap + 175 (kernel + 2313023) [0xffffff8000434b3f] 4\r\n                                                                                                                                               *1   i386_astintr + 46 (kernel + 2196542) [0xffffff800041843e] 4\r\n                                                                                                                                                 *1   ast_taken + 138 (kernel + 1213050) [0xffffff800032827a] 4\r\n                                                                                                                                                   *1   thread_block_reason + 175 (kernel + 1319343) [0xffffff80003421af] 4\r\n                                                                                                                                                     *1   ??? (kernel + 1329236) [0xffffff8000344854] 4\r\n                                                                                                                                                       *1   machine_switch_context + 367 (kernel + 2176511) [0xffffff80004135ff] (running) 4\r\n                                                                                                                4   LibraryQuery::Exec(QSqlDatabase, QString const&, QString const&) + 1698 (clementine + 1512146) [0x104f742d2] 5-8\r\n                                                                                                                  4   QSqlQuery::exec() + 228 (QtSql + 15412) [0x107bf4c34] 5-8\r\n                                                                                                                    4   QSQLiteResult::exec() + 1614 (clementine + 5168942) [0x1052f0f2e] 5-8\r\n                                                                                                                      4   QSQLiteResultPrivate::fetchNext(QVector<QVariant>&, int, bool) + 443 (clementine + 5163579) [0x1052efa3b] 5-8\r\n                                                                                                                        4   sqlite3_step + 354 (clementine + 5223506) [0x1052fe452] 5-8\r\n                                                                                                                          2   sqlite3VdbeExec + 3825 (clementine + 6020705) [0x1053c0e61] 5-6\r\n                                                                                                                            1   sqlite3BtreeMovetoUnpacked + 1168 (clementine + 6014128) [0x1053bf4b0] 5\r\n                                                                                                                              1   sqlite3PagerAcquire + 276 (clementine + 5208276) [0x1052fa8d4] 5\r\n                                                                                                                                1   read + 10 (libsystem_kernel.dylib + 95874) [0x7fff8b3db682] 5\r\n                                                                                                                                 *1   hndl_unix_scall64 + 22 (kernel + 2315126) [0xffffff8000435376] 5\r\n                                                                                                                                   *1   unix_syscall64 + 662 (kernel + 6601350) [0xffffff800084ba86] 5\r\n                                                                                                                                     *1   read_nocancel + 115 (kernel + 6210067) [0xffffff80007ec213] 5\r\n                                                                                                                                       *1   ??? (kernel + 6210730) [0xffffff80007ec4aa] 5\r\n                                                                                                                                         *1   ??? (kernel + 3559333) [0xffffff8000564fa5] (running) 5\r\n                                                                                                                            1   sqlite3BtreeMovetoUnpacked + 120 (clementine + 6013080) [0x1053bf098] 6\r\n                                                                                                                              1   moveToRoot + 226 (clementine + 6014738) [0x1053bf712] 6\r\n                                                                                                                                1   sqlite3PagerUnref + 162 (clementine + 5209794) [0x1052faec2] 6\r\n                                                                                                                                  1   pthread_mutex_unlock + 63 (libsystem_pthread.dylib + 6990) [0x7fff90cabb4e] 6\r\n                                                                                                                                    1   OSAtomicCompareAndSwapPtrBarrier$VARIANT$mp + 8 (libsystem_platform.dylib + 13128) [0x7fff92566348] (running) 6\r\n                                                                                                                          2   sqlite3VdbeExec + 2074 (clementine + 6018954) [0x1053c078a] 7-8\r\n                                                                                                                            2   fulltextNext + 791 (clementine + 5326023) [0x1053174c7] 7-8\r\n                                                                                                                              2   sqlite3_step + 354 (clementine + 5223506) [0x1052fe452] 7-8\r\n                                                                                                                                1   sqlite3VdbeExec + 12480 (clementine + 6029360) [0x1053c3030] 7\r\n                                                                                                                                  1   allocateCursor + 271 (clementine + 6092063) [0x1053d251f] (running) 7\r\n                                                                                                                                1   sqlite3VdbeExec + 797 (clementine + 6017677) [0x1053c028d] (running) 8\r\n                                                                                                          3   LibraryModel::RunQuery(LibraryItem*) + 390 (clementine + 1464646) [0x104f68946] 9-11\r\n                                                                                                            3   LibraryBackend::ExecQuery(LibraryQuery*) + 63 (clementine + 1413103) [0x104f5bfef] 9-11\r\n                                                                                                              3   LibraryQuery::Exec(QSqlDatabase, QString const&, QString const&) + 1698 (clementine + 1512146) [0x104f742d2] 9-11\r\n                                                                                                                3   QSqlQuery::exec() + 228 (QtSql + 15412) [0x107bf4c34] 9-11\r\n                                                                                                                  3   QSQLiteResult::exec() + 1614 (clementine + 5168942) [0x1052f0f2e] 9-11\r\n                                                                                                                    3   QSQLiteResultPrivate::fetchNext(QVector<QVariant>&, int, bool) + 443 (clementine + 5163579) [0x1052efa3b] 9-11\r\n                                                                                                                      3   sqlite3_step + 354 (clementine + 5223506) [0x1052fe452] 9-11\r\n                                                                                                                        1   sqlite3VdbeExec + 6680 (clementine + 6023560) [0x1053c1988] 9\r\n                                                                                                                          1   fulltextFilter + 1368 (clementine + 5325128) [0x105317148] 9\r\n                                                                                                                            1   evalFts3Expr + 903 (clementine + 5360327) [0x10531fac7] 9\r\n                                                                                                                              1   loadSegmentLeavesInt + 846 (clementine + 5369374) [0x105321e1e] 9\r\n                                                                                                                                1   docListAccumulateUnion + 412 (clementine + 5370508) [0x10532228c] 9\r\n                                                                                                                                  1   dlrStep + 147 (clementine + 5348355) [0x10531cc03] (running) 9\r\n                                                                                                                        2   sqlite3VdbeExec + 3825 (clementine + 6020705) [0x1053c0e61] 10-11\r\n                                                                                                                          2   sqlite3BtreeMovetoUnpacked + 1168 (clementine + 6014128) [0x1053bf4b0] 10-11\r\n                                                                                                                            1   sqlite3PagerAcquire + 276 (clementine + 5208276) [0x1052fa8d4] 10\r\n                                                                                                                              1   read + 10 (libsystem_kernel.dylib + 95874) [0x7fff8b3db682] 10\r\n                                                                                                                               *1   hndl_unix_scall64 + 22 (kernel + 2315126) [0xffffff8000435376] 10\r\n                                                                                                                                 *1   unix_syscall64 + 662 (kernel + 6601350) [0xffffff800084ba86] 10\r\n                                                                                                                                   *1   read_nocancel + 115 (kernel + 6210067) [0xffffff80007ec213] 10\r\n                                                                                                                                     *1   ??? (kernel + 6210730) [0xffffff80007ec4aa] 10\r\n                                                                                                                                       *1   ??? (kernel + 3559377) [0xffffff8000564fd1] 10\r\n                                                                                                                                         *1   hfs_vnop_read + 616 (kernel + 5502456) [0xffffff800073f5f8] 10\r\n                                                                                                                                           *1   cluster_read_ext + 5922 (kernel + 3355042) [0xffffff80005331a2] 10\r\n                                                                                                                                             *1   ??? (kernel + 3369710) [0xffffff8000536aee] (running) 10\r\n                                                                                                                            1   sqlite3PagerAcquire + 82 (clementine + 5208082) [0x1052fa812] 11\r\n                                                                                                                              1   sqlite3PcacheFetch + 294 (clementine + 5422230) [0x10532ec96] (running) 11\r\n'''"}}