Application: skrooge (1.3.0) KDE Platform Version: 4.8.3 (4.8.3) Qt Version: 4.8.1 Operating System: Linux 3.3.4-gentoo x86_64 Distribution: "Gentoo Base System release 2.1" -- Information about the crash: - What I was doing when the application crashed: Each time the application is launched, it crashes. Maybe the account file is corrupted but in this case, how can I retrieve my data ? The crash can be reproduced every time. -- Backtrace: Application: Skrooge (skrooge), signal: Segmentation fault Using host libthread_db library "/lib64/libthread_db.so.1". [Current thread is 1 (Thread 0x7fa623f30780 (LWP 20253))] Thread 3 (Thread 0x7fa61e69e700 (LWP 20254)): #0 pthread_cond_wait () at ../nptl/sysdeps/unix/sysv/linux/x86_64/pthread_cond_wait.S:162 #1 0x0000003ae4774e54 in ?? () from /usr/lib64/qt4/libQtWebKit.so.4 #2 0x0000003ac5e07d96 in start_thread (arg=0x7fa61e69e700) at pthread_create.c:305 #3 0x0000003ac52eaa1d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 2 (Thread 0x7fa61dd85700 (LWP 20255)): #0 0x0000003ac52e1c33 in *__GI___poll (fds=<optimized out>, nfds=<optimized out>, timeout=<optimized out>) at ../sysdeps/unix/sysv/linux/poll.c:87 #1 0x0000003ac8e4a4e6 in ?? () from /usr/lib64/libglib-2.0.so.0 #2 0x0000003ac8e4a604 in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0 #3 0x0000003acf7b02b6 in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4 #4 0x0000003acf780192 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4 #5 0x0000003acf780445 in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4 #6 0x0000003acf67d098 in QThread::exec() () from /usr/lib64/qt4/libQtCore.so.4 #7 0x0000003acf67f70b in ?? () from /usr/lib64/qt4/libQtCore.so.4 #8 0x0000003ac5e07d96 in start_thread (arg=0x7fa61dd85700) at pthread_create.c:305 #9 0x0000003ac52eaa1d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115 Thread 1 (Thread 0x7fa623f30780 (LWP 20253)): [KCrash Handler] #6 sqlite3ExprCodeTarget (pParse=0x145a348, pExpr=0x696e755f64722e32, target=53) at sqlite3.c:77013 #7 0x00007fa623f888fe in sqlite3ExprCodeExprList (pParse=0x145a348, target=50, doHardCopy=1, pList=<optimized out>) at sqlite3.c:78099 #8 0x00007fa623f89e88 in updateAccumulator (pParse=0x145a348, pAggInfo=0x7fffb3ebfd00) at sqlite3.c:98535 #9 0x00007fa623f8660a in sqlite3Select (pParse=<optimized out>, p=<optimized out>, pDest=<optimized out>) at sqlite3.c:99380 #10 0x00007fa623f87409 in sqlite3CodeSubselect (pParse=0x145a348, pExpr=0xa572d8, rMayHaveNull=<optimized out>, isRowid=0) at sqlite3.c:76496 #11 0x00007fa623f88001 in sqlite3ExprCodeTarget (pParse=0x145a348, pExpr=0xa572d8, target=3) at sqlite3.c:77384 #12 0x00007fa623f890f8 in sqlite3ExprCodeTemp (pParse=0x145a348, pExpr=<optimized out>, pReg=0x7fffb3ec000c) at sqlite3.c:77625 #13 0x00007fa623f89576 in sqlite3ExprIfFalse (pParse=0x145a348, pExpr=0xa4f458, dest=-4, jumpIfNull=8) at sqlite3.c:78375 #14 0x00007fa623f83783 in codeOneLoopStart (notReady=18446744073709551614, wctrlFlags=<optimized out>, iLevel=0, pWInfo=<optimized out>) at sqlite3.c:107425 #15 sqlite3WhereBegin (pParse=0x145a348, pTabList=0xa553d8, pWhere=<optimized out>, ppOrderBy=0x7fff00000083, pDistinct=0x0, wctrlFlags=0) at sqlite3.c:42497 #16 0x00007fa623f85930 in sqlite3Select (pParse=<optimized out>, p=<optimized out>, pDest=<optimized out>) at sqlite3.c:98935 #17 0x00007fa623f9ec1e in yy_reduce (yyruleno=112, yypParser=0x15e3128) at sqlite3.c:110607 #18 sqlite3Parser (yyp=<optimized out>, yymajor=1, yyminor=..., pParse=<optimized out>) at sqlite3.c:46063 #19 0x00007fa623fa01b2 in sqlite3RunParser (pParse=0x145a348, zSql=<optimized out>, pzErrMsg=0x7fffb3ec0680) at sqlite3.c:112436 #20 0x00007fa623fa2532 in sqlite3Prepare (db=0xa4c518, zSql=0x145a218 "SELECT t_name FROM v_account WHERE f_CURRENTAMOUNT>0.1 AND t_close='Y'", nBytes=-1, saveSqlFlag=1, pReprepare=<optimized out>, ppStmt=0x1458d90, pzTail=0x7fffb3ec0758) at sqlite3.c:94657 #21 0x00007fa623fa2679 in sqlite3LockAndPrepare (db=0xa4c518, zSql=0x145a218 "SELECT t_name FROM v_account WHERE f_CURRENTAMOUNT>0.1 AND t_close='Y'", nBytes=-1, saveSqlFlag=1, pOld=0x0, ppStmt=0x1458d90, pzTail=0x7fffb3ec0758) at sqlite3.c:94749 #22 0x00007fa623fa27b8 in sqlite3Prepare16 (db=0xa4c518, zSql=0x145a0da, nBytes=<optimized out>, saveSqlFlag=1, ppStmt=0x1458d90, pzTail=0x7fffb3ec0818) at sqlite3.c:94858 #23 0x00007fa5d18c5fb6 in QSQLiteResult::prepare (this=0x1458670, query=...) at ../../../sql/drivers/sqlite/qsql_sqlite.cpp:330 #24 0x00007fa5d18c4d3a in QSQLiteResult::reset (this=0x1458670, query=...) at ../../../sql/drivers/sqlite/qsql_sqlite.cpp:312 #25 0x00007fa624207816 in QSqlQuery::exec (this=0x7fffb3ec0a70, query=...) at kernel/qsqlquery.cpp:378 #26 0x00007fa6249f4a49 in SKGServices::executeSelectSqliteOrder (iDb=<optimized out>, iSqlOrder=..., oResult=...) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/skgbasemodeler/skgservices.cpp:948 #27 0x00007fa6249e543f in SKGDocument::executeSelectSqliteOrder (this=0x7fffb3ec2fc0, iSqlOrder=..., oResult=...) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/skgbasemodeler/skgdocument.cpp:2456 #28 0x00007fa5d4350688 in SKGBankPlugin::advices (this=0xd5e450) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/skrooge/skrooge_bank/skgbankplugin.cpp:204 #29 0x00007fa62474349d in SKGMainPanel::getAdvices (this=<optimized out>) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/skgbasegui/skgmainpanel.cpp:1074 #30 0x00007fa61c5fa4c2 in SKGAdviceBoardWidget::dataModified (this=0xedba30, iForce=<optimized out>) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/generic/skg_advice/skgadviceboardwidget.cpp:109 #31 0x00007fa61c5fb346 in SKGAdviceBoardWidget::setState (this=0xedba30, iState=...) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/generic/skg_advice/skgadviceboardwidget.cpp:81 #32 0x00007fa5d32912da in SKGDashboardPluginWidget::addItem (this=0xdbc610, iDashboard=0xcdefd0, iIndex=0, iZoom=0, iState=...) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/generic/skg_dashboard/skgdashboardpluginwidget.cpp:610 #33 0x00007fa5d3292c58 in SKGDashboardPluginWidget::setState (this=0xdbc610, iState=...) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/generic/skg_dashboard/skgdashboardpluginwidget.cpp:253 #34 0x00007fa62473a44d in SKGMainPanel::openPage (this=0xb9c4e0, plugin=0xdd91a0, index=-1, parameters=..., title=..., iID=..., iSetCurrent=true) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/skgbasegui/skgmainpanel.cpp:1393 #35 0x00007fa5d38ea62a in SKGBookmarkPluginDockWidget::openBookmark (iNode=..., iFirstInNewPage=<optimized out>, iPin=224) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/generic/skg_bookmark/skgbookmarkplugindockwidget.cpp:213 #36 0x00007fa5d38e476d in SKGBookmarkPlugin::goHome (this=<optimized out>) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/generic/skg_bookmark/skgbookmarkplugin.cpp:248 #37 0x00007fa5d38e63a9 in SKGBookmarkPlugin::refresh (this=0xdde180) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/plugins/generic/skg_bookmark/skgbookmarkplugin.cpp:159 #38 0x00007fa62473ab04 in SKGMainPanel::refresh (this=0xb9c4e0) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/skgbasegui/skgmainpanel.cpp:1260 #39 0x00007fa624744787 in SKGMainPanel::qt_static_metacall (_o=0xb9c4e0, _c=<optimized out>, _id=<optimized out>, _a=0xdea9e0) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0_build/skgbasegui/skgmainpanel.moc:247 #40 0x0000003acf795d86 in QObject::event(QEvent*) () from /usr/lib64/qt4/libQtCore.so.4 #41 0x0000003ad1e287bd in QWidget::event(QEvent*) () from /usr/lib64/qt4/libQtGui.so.4 #42 0x0000003ad21e540b in QMainWindow::event(QEvent*) () from /usr/lib64/qt4/libQtGui.so.4 #43 0x0000003ad5758e50 in KXmlGuiWindow::event(QEvent*) () from /usr/lib64/libkdeui.so.5 #44 0x0000003ad1dd7404 in QApplicationPrivate::notify_helper(QObject*, QEvent*) () from /usr/lib64/qt4/libQtGui.so.4 #45 0x0000003ad1ddbfff in QApplication::notify(QObject*, QEvent*) () from /usr/lib64/qt4/libQtGui.so.4 #46 0x0000003ad565bb76 in KApplication::notify(QObject*, QEvent*) () from /usr/lib64/libkdeui.so.5 #47 0x0000003acf78116b in QCoreApplication::notifyInternal(QObject*, QEvent*) () from /usr/lib64/qt4/libQtCore.so.4 #48 0x0000003acf784727 in QCoreApplicationPrivate::sendPostedEvents(QObject*, int, QThreadData*) () from /usr/lib64/qt4/libQtCore.so.4 #49 0x0000003acf7b00c3 in ?? () from /usr/lib64/qt4/libQtCore.so.4 #50 0x0000003ac8e4a202 in g_main_context_dispatch () from /usr/lib64/libglib-2.0.so.0 #51 0x0000003ac8e4a548 in ?? () from /usr/lib64/libglib-2.0.so.0 #52 0x0000003ac8e4a604 in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0 #53 0x0000003acf7b025f in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4 #54 0x0000003ad1e7c80e in ?? () from /usr/lib64/qt4/libQtGui.so.4 #55 0x0000003acf780192 in QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4 #56 0x0000003acf780445 in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/qt4/libQtCore.so.4 #57 0x0000003acf784bcb in QCoreApplication::exec() () from /usr/lib64/qt4/libQtCore.so.4 #58 0x0000000000401fce in main (argc=1, argv=0x7fffb3ec34b8) at /hdf/tmp/portage/app-office/skrooge-1.3.0/work/skrooge-1.3.0/skrooge/main.cpp:99 Reported using DrKonqi
The problem was due to sqlite-3.7.12 : Using sqlite-3.7.11 solves the problem.
Downgrading is not a solution, more a workaround... And a temporary one, since sqlite 3.7.11 is not here forever, we have to maintain compatibility with latest version. Leaving it as resolved, but only because this is a duplicate. Thanks for the report, though :) *** This bug has been marked as a duplicate of bug 300183 ***