Hi guys,
I am one of the developpers of Skrooge, an Open Source application for
personal finances management (http://skrooge.org). After upgrading SQLite to
3.7.12, our users report crashes upon starting the application :
https://bugs.kde.org/show_bug.cgi?id=300183
Apparently, switching back to 3.7.11 solves the issue. I could confirm the
crash, and generated the attached backtrace. Can you please help us understand
what is going on, and advise us on steps to take to solve the issue ?
Thanks in advance :)
Guillaume
--
Skrooge, a free, Open Source, personal finances software for linux, Mac OS,
Windows
http://skrooge.org
Application: Skrooge (skrooge), signal: Segmentation fault
Using host libthread_db library "/lib/libthread_db.so.1".
[Current thread is 1 (Thread 0x7f09aaba1780 (LWP 30797))]
Thread 3 (Thread 0x7f0994fa6700 (LWP 30798)):
#0 0x00007f09a7c0d8f4 in pthread_cond_wait@@GLIBC_2.3.2 () from
/lib/libpthread.so.0
#1 0x00007f09a38c824c in ?? () from /usr/lib/libQtWebKit.so.4
#2 0x00007f09a38c8379 in ?? () from /usr/lib/libQtWebKit.so.4
#3 0x00007f09a7c09e0e in start_thread () from /lib/libpthread.so.0
#4 0x00007f09a71371ed in clone () from /lib/libc.so.6
Thread 2 (Thread 0x7f09946a5700 (LWP 30799)):
#0 0x00007f09a712f06f in poll () from /lib/libc.so.6
#1 0x00007f09a1c14774 in ?? () from /usr/lib/libglib-2.0.so.0
#2 0x00007f09a1c14894 in g_main_context_iteration () from
/usr/lib/libglib-2.0.so.0
#3 0x00007f09a7fc11b6 in
QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) ()
from /usr/lib/libQtCore.so.4
#4 0x00007f09a7f91f8f in
QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib/libQtCore.so.4
#5 0x00007f09a7f92218 in
QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib/libQtCore.so.4
#6 0x00007f09a7e966f0 in QThread::exec() () from /usr/lib/libQtCore.so.4
#7 0x00007f09a7e9968b in ?? () from /usr/lib/libQtCore.so.4
#8 0x00007f09a7c09e0e in start_thread () from /lib/libpthread.so.0
#9 0x00007f09a71371ed in clone () from /lib/libc.so.6
Thread 1 (Thread 0x7f09aaba1780 (LWP 30797)):
[KCrash Handler]
#5 sqlite3ExprCodeTarget (pParse=pParse@entry=0x1f9a948, pExpr=0x10d2e80,
target=target@entry=19) at sqlite3.c:77533
#6 0x00007f099e9450c7 in sqlite3ExprCodeTemp (pParse=pParse@entry=0x1f9a948,
pExpr=<optimized out>, pReg=pReg@entry=0x7fff42621d68) at sqlite3.c:77625
#7 0x00007f099e9441b3 in sqlite3ExprCodeTarget (pParse=pParse@entry=0x1f9a948,
pExpr=0x7f09a73ee6a8, target=target@entry=57) at sqlite3.c:77540
#8 0x00007f099e944ff6 in sqlite3ExprCodeExprList
(pParse=pParse@entry=0x1f9a948, target=target@entry=57,
doHardCopy=doHardCopy@entry=1, pList=<error reading variable: Unhandled dwarf
expression opcode 0xfa>, pList=<error reading variable: Unhandled dwarf
expression opcode 0xfa>) at sqlite3.c:78099
#9 0x00007f099e9061e2 in updateAccumulator (pParse=pParse@entry=0x1f9a948,
pAggInfo=pAggInfo@entry=0x7fff42622050) at sqlite3.c:98535
#10 0x00007f099e942512 in sqlite3Select (pParse=pParse@entry=0x1f9a948,
p=p@entry=0x1517b58, pDest=pDest@entry=0x7fff42622150) at sqlite3.c:99380
#11 0x00007f099e943bb7 in sqlite3CodeSubselect (pParse=0x1f9a948,
pExpr=0x1e2a3f8, rMayHaveNull=rMayHaveNull@entry=0, isRowid=isRowid@entry=0) at
sqlite3.c:76496
#12 0x00007f099e944b93 in sqlite3ExprCodeTarget (pParse=pParse@entry=0x1f9a948,
pExpr=0x1e2a3f8, target=target@entry=10) at sqlite3.c:77384
#13 0x00007f099e944ff6 in sqlite3ExprCodeExprList
(pParse=pParse@entry=0x1f9a948, target=target@entry=4,
doHardCopy=doHardCopy@entry=0, pList=<error reading variable: Unhandled dwarf
expression opcode 0xfa>, pList=<error reading variable: Unhandled dwarf
expression opcode 0xfa>) at sqlite3.c:78099
#14 0x00007f099e905d6c in selectInnerLoop (pParse=0x1f9a948, p=0x1e74ef8,
pEList=0x10bf688, srcTab=0, nColumn=0, pOrderBy=0x0, distinct=-1,
pDest=0x7fff42622670, iContinue=-4, iBreak=-2) at sqlite3.c:95500
#15 0x00007f099e94136c in sqlite3Select (pParse=pParse@entry=0x1f9a948,
p=p@entry=0x1e74ef8, pDest=pDest@entry=0x7fff42622670) at sqlite3.c:98993
#16 0x00007f099e95ddbe in sqlite3EndTable (pParse=pParse@entry=0x1f9a948,
pCons=pCons@entry=0x0, pEnd=pEnd@entry=0x0, pSelect=0x1e74ef8) at
sqlite3.c:83138
#17 0x00007f099e95a7d6 in yy_reduce (yyruleno=33, yypParser=0x15ea458) at
sqlite3.c:110405
#18 sqlite3Parser (yyp=yyp@entry=0x15ea458, yymajor=yymajor@entry=1,
yyminor=..., pParse=pParse@entry=0x1f9a948) at sqlite3.c:46063
#19 0x00007f099e95d1a2 in sqlite3RunParser (pParse=pParse@entry=0x1f9a948,
zSql=zSql@entry=0x1e85188 "CREATE TABLE vm_category_display_tmp AS SELECT *
FROM v_category_display_tmp", pzErrMsg=pzErrMsg@entry=0x7fff426229f8) at
sqlite3.c:112436
#20 0x00007f099e95ecf2 in sqlite3Prepare (db=db@entry=0x14cdf68,
zSql=zSql@entry=0x1e85188 "CREATE TABLE vm_category_display_tmp AS SELECT *
FROM v_category_display_tmp", nBytes=nBytes@entry=-1,
saveSqlFlag=saveSqlFlag@entry=1, pReprepare=pReprepare@entry=0x0,
ppStmt=ppStmt@entry=0x1e30090, pzTail=pzTail@entry=0x7fff42622ac8) at
sqlite3.c:94657
#21 0x00007f099e95ef79 in sqlite3LockAndPrepare (pzTail=0x7fff42622ac8,
ppStmt=0x1e30090, pOld=0x0, saveSqlFlag=1, nBytes=-1, zSql=0x1e85188 "CREATE
TABLE vm_category_display_tmp AS SELECT * FROM v_category_display_tmp",
db=0x14cdf68) at sqlite3.c:94749
#22 sqlite3LockAndPrepare (db=0x14cdf68, zSql=0x1e85188 "CREATE TABLE
vm_category_display_tmp AS SELECT * FROM v_category_display_tmp", nBytes=-1,
saveSqlFlag=1, pOld=0x0, ppStmt=0x1e30090, pzTail=0x7fff42622ac8) at
sqlite3.c:29196
#23 0x00007f099e95f0b7 in sqlite3Prepare16 (db=0x14cdf68, zSql=0x1e3960a,
nBytes=<optimized out>, saveSqlFlag=1, ppStmt=0x1e30090, pzTail=0x7fff42622b28)
at sqlite3.c:94858
#24 0x00007f094703b77e in ?? () from
/usr/lib/qt/plugins/sqldrivers/libqsqlite.so
#25 0x00007f094703a5da in ?? () from
/usr/lib/qt/plugins/sqldrivers/libqsqlite.so
#26 0x00007f09a4f410ae in QSqlQuery::exec(QString const&) () from
/usr/lib/libQtSql.so.4
#27 0x00007f09aa13232e in SKGServices::executeSqliteOrder (iDb=<optimized out>,
iSqlOrder=..., iLastId=0x0) at
/home/guillaume/Developpement/git/skrooge/skgbasemodeler/skgservices.cpp:862
#28 0x00007f09aa104c07 in SKGDocument::executeSqliteOrder
(this=this@entry=0x7fff42624a90, iSqlOrder=..., iLastId=iLastId@entry=0x0) at
/home/guillaume/Developpement/git/skrooge/skgbasemodeler/skgdocument.cpp:2415
#29 0x00007f09aa10c705 in SKGDocument::computeMaterializedViews
(this=0x7fff42624a90, iTable=...) at
/home/guillaume/Developpement/git/skrooge/skgbasemodeler/skgdocument.cpp:447
#30 0x00007f09aa10eb45 in SKGDocument::endTransaction (this=0x7fff42624a90,
succeedded=<optimized out>) at
/home/guillaume/Developpement/git/skrooge/skgbasemodeler/skgdocument.cpp:357
#31 0x00007f09a9babd0c in SKGDocumentBank::endTransaction (this=0x7fff42624a90,
succeedded=true) at
/home/guillaume/Developpement/git/skrooge/skgbankmodeler/skgdocumentbank.cpp:160
#32 0x00007f09aa1310a5 in SKGTransactionMng::~SKGTransactionMng
(this=0x7fff42623480, __in_chrg=<optimized out>) at
/home/guillaume/Developpement/git/skrooge/skgbasemodeler/skgtransactionmng.cpp:48
#33 0x00007f0948ea3bb4 in SKGScheduledPlugin::refresh (this=0x138c8b0) at
/home/guillaume/Developpement/git/skrooge/plugins/skrooge/skrooge_scheduled/skgscheduledplugin.cpp:104
#34 0x00007f09a9e6284d in SKGMainPanel::refresh (this=0xfbc940) at
/home/guillaume/Developpement/git/skrooge/skgbasegui/skgmainpanel.cpp:1262
#35 0x00007f09a9e64cc2 in SKGMainPanel::qt_static_metacall (_o=0xfbc940,
_c=<optimized out>, _id=<optimized out>, _a=0x7fff426237c0) at
/home/guillaume/Developpement/git/skrooge/build/skgbasegui/skgmainpanel.moc:247
#36 0x00007f09a7fa83ff in QMetaObject::activate(QObject*, QMetaObject const*,
int, void**) () from /usr/lib/libQtCore.so.4
#37 0x00007f09a9e5ecb8 in SKGMainPanel::closeAllPages (this=0xfbc940,
iForce=false) at
/home/guillaume/Developpement/git/skrooge/skgbasegui/skgmainpanel.cpp:1524
#38 0x00007f0948c8574f in SKGBookmarkPlugin::goHome (this=this@entry=0x13916d0)
at
/home/guillaume/Developpement/git/skrooge/plugins/generic/skg_bookmark/skgbookmarkplugin.cpp:241
#39 0x00007f0948c85a81 in SKGBookmarkPlugin::refresh (this=0x13916d0) at
/home/guillaume/Developpement/git/skrooge/plugins/generic/skg_bookmark/skgbookmarkplugin.cpp:161
#40 0x00007f09a9e6284d in SKGMainPanel::refresh (this=0xfbc940) at
/home/guillaume/Developpement/git/skrooge/skgbasegui/skgmainpanel.cpp:1262
#41 0x00007f09a9e64cc2 in SKGMainPanel::qt_static_metacall (_o=0xfbc940,
_c=<optimized out>, _id=<optimized out>, _a=0x12679a0) at
/home/guillaume/Developpement/git/skrooge/build/skgbasegui/skgmainpanel.moc:247
#42 0x00007f09a7fa78de in QObject::event(QEvent*) () from
/usr/lib/libQtCore.so.4
#43 0x00007f09a8e9a0ba in QWidget::event(QEvent*) () from /usr/lib/libQtGui.so.4
#44 0x00007f09a925e2db in QMainWindow::event(QEvent*) () from
/usr/lib/libQtGui.so.4
#45 0x00007f09aa69e398 in KXmlGuiWindow::event(QEvent*) () from
/usr/lib/libkdeui.so.5
#46 0x00007f09a8e4b06c in QApplicationPrivate::notify_helper(QObject*, QEvent*)
() from /usr/lib/libQtGui.so.4
#47 0x00007f09a8e4f59a in QApplication::notify(QObject*, QEvent*) () from
/usr/lib/libQtGui.so.4
#48 0x00007f09aa5acf86 in KApplication::notify(QObject*, QEvent*) () from
/usr/lib/libkdeui.so.5
#49 0x00007f09a7f92f8e in QCoreApplication::notifyInternal(QObject*, QEvent*)
() from /usr/lib/libQtCore.so.4
#50 0x00007f09a7f968e1 in QCoreApplicationPrivate::sendPostedEvents(QObject*,
int, QThreadData*) () from /usr/lib/libQtCore.so.4
#51 0x00007f09a7fc1003 in ?? () from /usr/lib/libQtCore.so.4
#52 0x00007f09a1c144a5 in g_main_context_dispatch () from
/usr/lib/libglib-2.0.so.0
#53 0x00007f09a1c147d8 in ?? () from /usr/lib/libglib-2.0.so.0
#54 0x00007f09a1c14894 in g_main_context_iteration () from
/usr/lib/libglib-2.0.so.0
#55 0x00007f09a7fc1196 in
QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) ()
from /usr/lib/libQtCore.so.4
#56 0x00007f09a8eeb42e in ?? () from /usr/lib/libQtGui.so.4
#57 0x00007f09a7f91f8f in
QEventLoop::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib/libQtCore.so.4
#58 0x00007f09a7f92218 in
QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from
/usr/lib/libQtCore.so.4
#59 0x00007f09a7f96bf8 in QCoreApplication::exec() () from
/usr/lib/libQtCore.so.4
#60 0x0000000000401a60 in main (argc=1, argv=0x7fff42624c88) at
/home/guillaume/Developpement/git/skrooge/skrooge/main.cpp:99
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
