Application: skrooge (2.3.0) Qt Version: 5.7.0 Frameworks Version: 5.24.0 Operating System: Linux 4.1.15-8-default x86_64 Distribution: "openSUSE Leap 42.1 (x86_64)" -- Information about the crash: - What I was doing when the application crashed: i open bash and write skrooge and result error: $:>skrooge ##WARNING: QSqlDatabase: SKGSQLCIPHER driver not loaded ##WARNING: QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL QMYSQL3 SKGSQLCIPHER ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT * FROM parameters WHERE t_name='SKG_SQLITE_LAST_VERSION' AND t_uuid_parent='document' ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT t_name, t_symbol, i_nbdecimal FROM unit WHERE t_type='1' ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT t_name, t_symbol, f_CURRENTAMOUNT, i_nbdecimal FROM v_unit WHERE t_type='2' ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT DISTINCT t_name FROM parameters WHERE ((t_uuid_parent like '%-parameters' OR t_uuid_parent like '%-subparameters') AND t_name NOT LIKE 'SKG_%') ORDER BY t_name COLLATE NOCASE ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT DISTINCT name FROM sqlite_master WHERE (type='table' AND name NOT LIKE 'doctransaction%') ORDER BY name COLLATE NOCASE ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: QSqlDatabase: SKGSQLCIPHER driver not loaded ##WARNING: QSqlDatabase: available drivers: QSQLITE QSQLITE3 QMYSQL QMYSQL3 SKGSQLCIPHER ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT * FROM parameters WHERE t_name='SKG_SQLITE_LAST_VERSION' AND t_uuid_parent='document' ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT t_name, t_symbol, i_nbdecimal FROM unit WHERE t_type='1' ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: SELECT t_name, t_symbol, f_CURRENTAMOUNT, i_nbdecimal FROM v_unit WHERE t_type='2' ## returns :Driver not loaded Driver not loaded ##WARNING: QSqlQuery::exec: database not open ##WARNING: PRAGMA table_info( parameters ); ## returns :Driver not loaded Driver not loaded KCrash: Application 'skrooge' crashing... KCrash: Attempting to start /usr/lib64/libexec/drkonqi from kdeinit sock_file=/run/user/1000/kdeinit5__0 [2]+ Stopped skrooge 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 0x7f1301cda800 (LWP 28566))] Thread 4 (Thread 0x7f12e4bd5700 (LWP 28567)): #0 0x00007f12fed11bfd in poll () at /lib64/libc.so.6 #1 0x00007f12efada422 in () at /usr/lib64/libxcb.so.1 #2 0x00007f12efadc00f in xcb_wait_for_event () at /usr/lib64/libxcb.so.1 #3 0x00007f12e6b053e9 in () at /usr/lib64/libQt5XcbQpa.so.5 #4 0x00007f12ff411899 in () at /usr/lib64/libQt5Core.so.5 #5 0x00007f12f96e60a4 in start_thread () at /lib64/libpthread.so.0 #6 0x00007f12fed1a02d in clone () at /lib64/libc.so.6 Thread 3 (Thread 0x7f12df096700 (LWP 28568)): #0 0x00007f1301b3e979 in _dl_update_slotinfo () at /lib64/ld-linux-x86-64.so.2 #1 0x00007f1301b2e15f in update_get_addr () at /lib64/ld-linux-x86-64.so.2 #2 0x00007f12ff4108b6 in () at /usr/lib64/libQt5Core.so.5 #3 0x00007f12ff616e8a in () at /usr/lib64/libQt5Core.so.5 #4 0x00007f12f7aba4ad in g_main_context_prepare () at /usr/lib64/libglib-2.0.so.0 #5 0x00007f12f7abad80 in () at /usr/lib64/libglib-2.0.so.0 #6 0x00007f12f7abaf7c in g_main_context_iteration () at /usr/lib64/libglib-2.0.so.0 #7 0x00007f12ff616f7b in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib64/libQt5Core.so.5 #8 0x00007f12ff5c68cb in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib64/libQt5Core.so.5 #9 0x00007f12ff40d06a in QThread::exec() () at /usr/lib64/libQt5Core.so.5 #10 0x00007f12fab464b5 in () at /usr/lib64/libQt5DBus.so.5 #11 0x00007f12ff411899 in () at /usr/lib64/libQt5Core.so.5 #12 0x00007f12f96e60a4 in start_thread () at /lib64/libpthread.so.0 #13 0x00007f12fed1a02d in clone () at /lib64/libc.so.6 Thread 2 (Thread 0x7f12ce89b700 (LWP 28570)): #0 0x00007f12f96ea03f in pthread_cond_wait@@GLIBC_2.3.2 () at /lib64/libpthread.so.0 #1 0x00007f12d52f1aa3 in () at /usr/lib64/dri/r600_dri.so #2 0x00007f12d52f1227 in () at /usr/lib64/dri/r600_dri.so #3 0x00007f12f96e60a4 in start_thread () at /lib64/libpthread.so.0 #4 0x00007f12fed1a02d in clone () at /lib64/libc.so.6 Thread 1 (Thread 0x7f1301cda800 (LWP 28566)): [KCrash Handler] #6 0x00007f13002aceb0 in QWidget::layout() const () at /usr/lib64/libQt5Widgets.so.5 #7 0x00007f130187ed73 in SKGMainPanel::displayMessage(QString const&, SKGDocument::MessageType, QString const&) () at /usr/lib64/libskgbasegui.so.2 #8 0x00007f130188aaa3 in SKGMainPanel::displayErrorMessage(SKGError const&, QAction*) () at /usr/lib64/libskgbasegui.so.2 #9 0x00007f12cc8ec2f2 in () at /usr/lib64/qt5/plugins/skg_file.so #10 0x00007f12cc8ee13c in () at /usr/lib64/qt5/plugins/skg_file.so #11 0x00007f130188fca6 in SKGMainPanel::SKGMainPanel(QSplashScreen*, SKGDocument*, QStringList const&) () at /usr/lib64/libskgbasegui.so.2 #12 0x00000000004045dd in main () Possible duplicates by query: bug 348116, bug 348030. Reported using DrKonqi
Could you confirm it's OK with this build? https://build.opensuse.org/package/show/home:miraks/skrooge
Do you have an answer?
*** Bug 368666 has been marked as a duplicate of this bug. ***
hi Stephane MANKOWSKI sorry sorry sorry super delays , time I'm doing my moving house and my family, so my computer is inside packed, i dont open my pack pc because i have stuff of time for work in new home.. i will back and i dont will forget it ..sorry sorry i will back force because i need this skrooge for my financial personal ok?
I installed 2.4.92 from your repo and it still crashes on startup. Backtrace: Application: Skrooge (skrooge), signal: Segmentation fault Using host libthread_db library "/lib64/libthread_db.so.1". [Current thread is 1 (Thread 0x7f107b781800 (LWP 2059))] Thread 9 (Thread 0x7f1008dab700 (LWP 2069)): #0 0x00007f10787b3bfd in poll () from /lib64/libc.so.6 #1 0x00007f1071555e64 in ?? () from /usr/lib64/libglib-2.0.so.0 #2 0x00007f1071555f7c in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0 #3 0x00007f10790b8f7b in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5 #4 0x00007f10790688cb in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5 #5 0x00007f1078eaf06a in QThread::exec() () from /usr/lib64/libQt5Core.so.5 #6 0x00007f1078eb3899 in ?? () from /usr/lib64/libQt5Core.so.5 #7 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #8 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 8 (Thread 0x7f1009a09700 (LWP 2068)): #0 0x00007f107318603f in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f106ff68443 in ?? () from /usr/lib64/libQt5WebKit.so.5 #2 0x00007f107028a0a1 in ?? () from /usr/lib64/libQt5WebKit.so.5 #3 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7f100a20a700 (LWP 2067)): #0 0x00007f107318603f in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f106ff68443 in ?? () from /usr/lib64/libQt5WebKit.so.5 #2 0x00007f107028a0a1 in ?? () from /usr/lib64/libQt5WebKit.so.5 #3 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7f100aa0b700 (LWP 2066)): #0 0x00007f107318603f in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f106ff68443 in ?? () from /usr/lib64/libQt5WebKit.so.5 #2 0x00007f107028a0a1 in ?? () from /usr/lib64/libQt5WebKit.so.5 #3 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7f100b20c700 (LWP 2065)): #0 0x00007f107318603f in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f106ff6746d in ?? () from /usr/lib64/libQt5WebKit.so.5 #2 0x00007f107028a0a1 in ?? () from /usr/lib64/libQt5WebKit.so.5 #3 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7f104c9ad700 (LWP 2064)): #0 0x00007f107318603f in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00007f107025b5d3 in ?? () from /usr/lib64/libQt5WebKit.so.5 #2 0x00007f107025b5f9 in ?? () from /usr/lib64/libQt5WebKit.so.5 #3 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #4 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7f105cc99700 (LWP 2061)): #0 0x00007f10787b3bfd in poll () from /lib64/libc.so.6 #1 0x00007f1071555e64 in ?? () from /usr/lib64/libglib-2.0.so.0 #2 0x00007f1071555f7c in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0 #3 0x00007f10790b8f7b in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5 #4 0x00007f10790688cb in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5 #5 0x00007f1078eaf06a in QThread::exec() () from /usr/lib64/libQt5Core.so.5 #6 0x00007f10745e54b5 in ?? () from /usr/lib64/libQt5DBus.so.5 #7 0x00007f1078eb3899 in ?? () from /usr/lib64/libQt5Core.so.5 #8 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #9 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7f105e61a700 (LWP 2060)): #0 0x00007f10787b3bfd in poll () from /lib64/libc.so.6 #1 0x00007f106956c422 in ?? () from /usr/lib64/libxcb.so.1 #2 0x00007f106956e00f in xcb_wait_for_event () from /usr/lib64/libxcb.so.1 #3 0x00007f106054a3e9 in ?? () from /usr/lib64/libQt5XcbQpa.so.5 #4 0x00007f1078eb3899 in ?? () from /usr/lib64/libQt5Core.so.5 #5 0x00007f10731820a4 in start_thread () from /lib64/libpthread.so.0 #6 0x00007f10787bc02d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7f107b781800 (LWP 2059)): [KCrash Handler] #6 QWidget::layout (this=0x0) at kernel/qwidget.cpp:10059 #7 0x00007f107b31d9e3 in SKGMainPanel::displayMessage(QString const&, SKGDocument::MessageType, QString const&) () from /usr/lib64/libskgbasegui.so.2 #8 0x00007f107b31e009 in SKGMainPanel::displayErrorMessage(SKGError const&, QAction*) () from /usr/lib64/libskgbasegui.so.2 #9 0x00007f100224cca5 in SKGFilePlugin::onNew() () from /usr/lib64/qt5/plugins/skg_file.so #10 0x00007f100224d6ac in SKGFilePlugin::setupActions(SKGDocument*, QStringList const&) () from /usr/lib64/qt5/plugins/skg_file.so #11 0x00007f107b32ef93 in SKGMainPanel::SKGMainPanel(QSplashScreen*, SKGDocument*, QStringList const&) () from /usr/lib64/libskgbasegui.so.2 #12 0x0000000000404461 in main ()
Hi, I understand where is the crash but I don't understand why this occurs. Could you generate traces by doing this from the console? 1- export SKGTRACE=20 2- skrooge > traces.txt 2>&1 3- attach the traces here. Regards.
Created attachment 101136 [details] traces requested in comment #7
Thank you. What is the result of the following command on your system? find /usr -name "libskgsqlcipher*"
/usr/lib/debug/usr/lib64/qt5/plugins/sqldrivers/libskgsqlcipher.so.debug /usr/lib64/qt5/plugins/sqldrivers/libskgsqlcipher.so
And now: ls -artl /usr/lib64/qt5/plugins/sqldrivers/libskgsqlcipher.so
-rwxr-xr-x 1 root root 83864 Aug 9 08:07 /usr/lib64/qt5/plugins/sqldrivers/libskgsqlcipher.so
Hi, Just to explain my analysis: 1- the sqlcipher plugin seems to be well installed 2- but skrooge is not able to load it. I don't know why. 3- skrooge would like to display the error message but because the gui is not fully created... 4- ... the application crashes ! I did a modification to avoid the crash but this won't solve your issue because the driver will not be loaded. Another question: What is the result of this command? ls /usr/lib64/qt5/plugins/sqldrivers/
libqsqlite.so libskgsqlcipher.so
Hi, Could you confirm that sqlcipher is well installed by doing this from the console? sqlcipher --version
That package was not installed on my system, so I went ahead and manually installed it. sqlcipher --version 3.8.10.2 2015-05-20 18:17:19 2ef4f3a5b1d1d0c4338f8243d40a2452cc1f7fe4 I ran skrooge again after installation of sqlcipher and it crashed again. Backtrace: Application: Skrooge (skrooge), signal: Segmentation fault Using host libthread_db library "/lib64/libthread_db.so.1". [Current thread is 1 (Thread 0x7fb30c7db800 (LWP 2026))] Thread 3 (Thread 0x7fb2edcf3700 (LWP 2028)): #0 0x00007fb30980dbfd in poll () from /lib64/libc.so.6 #1 0x00007fb3025afe64 in ?? () from /usr/lib64/libglib-2.0.so.0 #2 0x00007fb3025aff7c in g_main_context_iteration () from /usr/lib64/libglib-2.0.so.0 #3 0x00007fb30a112f7b in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5 #4 0x00007fb30a0c28cb in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () from /usr/lib64/libQt5Core.so.5 #5 0x00007fb309f0906a in QThread::exec() () from /usr/lib64/libQt5Core.so.5 #6 0x00007fb30563f4b5 in ?? () from /usr/lib64/libQt5DBus.so.5 #7 0x00007fb309f0d899 in ?? () from /usr/lib64/libQt5Core.so.5 #8 0x00007fb3041dc0a4 in start_thread () from /lib64/libpthread.so.0 #9 0x00007fb30981602d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fb2ef674700 (LWP 2027)): #0 0x00007fb30980dbfd in poll () from /lib64/libc.so.6 #1 0x00007fb2fa5c6422 in ?? () from /usr/lib64/libxcb.so.1 #2 0x00007fb2fa5c800f in xcb_wait_for_event () from /usr/lib64/libxcb.so.1 #3 0x00007fb2f15a43e9 in ?? () from /usr/lib64/libQt5XcbQpa.so.5 #4 0x00007fb309f0d899 in ?? () from /usr/lib64/libQt5Core.so.5 #5 0x00007fb3041dc0a4 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fb30981602d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fb30c7db800 (LWP 2026)): [KCrash Handler] #6 QWidget::layout (this=0x0) at kernel/qwidget.cpp:10059 #7 0x00007fb30c3779e3 in SKGMainPanel::displayMessage(QString const&, SKGDocument::MessageType, QString const&) () from /usr/lib64/libskgbasegui.so.2 #8 0x00007fb30c378009 in SKGMainPanel::displayErrorMessage(SKGError const&, QAction*) () from /usr/lib64/libskgbasegui.so.2 #9 0x00007fb2dcdd8ca5 in SKGFilePlugin::onNew() () from /usr/lib64/qt5/plugins/skg_file.so #10 0x00007fb2dcdd96ac in SKGFilePlugin::setupActions(SKGDocument*, QStringList const&) () from /usr/lib64/qt5/plugins/skg_file.so #11 0x00007fb30c388f93 in SKGMainPanel::SKGMainPanel(QSplashScreen*, SKGDocument*, QStringList const&) () from /usr/lib64/libskgbasegui.so.2 #12 0x0000000000404461 in main ()
Hi, Sorry for the very slow progress but this issue is not really in Skrooge, this is a packaging issue and I don't know well opensuse. The version of your sqlcipher library is may be not the expected one. If you have installed Skrooge from here (my packaging): https://build.opensuse.org/package/show/home:miraks/skrooge You must installed sqkcipher from here too: https://build.opensuse.org/package/show/home:miraks/sqlcipher The sqlcipher version must be 3.3.1. Regards.
Hi, Do you have an answer? Regards.
Sorry for the delay. When I installed from your repo, I did install all the available depends you provided, but still got the crash on startup.
Created attachment 101363 [details] Opensuse installation Hi, As you can see in the screen capture: 1-I installed opensuse Leap 42.1 in virtual box 2-I installed skrooge from here http://download.opensuse.org/repositories/home:/miraks/openSUSE_Leap_42.1/ 3-Skrooge is executed correctly I don't know why you have this issue but I 99% sure that is not due to Skrooge. Could you try to uninstall it and reinstall?
I'm running the KDE:Frameworks 5 and KDE:Applications repositories on top of 42.1, so maybe the problem is with those repos. At this point, I'll just assume it's my machine and try again when 42.2 comes out. Thanks for your help.