Bug 434722

Summary: AppImage (5.1.1-5ea8730) crashes when saving on SQL database
Product: [Applications] kmymoney Reporter: lp.allard.1
Component: generalAssignee: KMyMoney Devel Mailing List <kmymoney-devel>
Status: REPORTED ---    
Severity: critical CC: me
Priority: NOR    
Version: 5.1.1   
Target Milestone: ---   
Platform: Mint (Ubuntu based)   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:

Description lp.allard.1 2021-03-21 14:56:13 UTC
SUMMARY

Opening a SQL dataset, when I hit "SAVE", the application crashes.  I started the AppImage from the terminal to see what happens.  The following is seen in the terminal when KMM crashes:


WebConnect: Try to connect to WebConnect server
WebConnect: Connect to server failed
WebConnect: Starting server failed. Try to remove stale socket.
WebConnect: Running in server mode
System icon theme as reported by QT:  "Adwaita"
QFSFileEngine::open: No file name specified
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/budgetview.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/checkprinting.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/csvexporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/csvimporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/forecastview.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/gncimporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/icalendarexporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kbanking.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kcm_checkprinting.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kcm_csvimporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kcm_forecastview.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kcm_icalendarexporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kcm_qif.so" Validity false
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kcm_reportsview.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/kcm_xmlstorage.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/konlinetasks_sepa.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/ofximporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/onlinejoboutboxview.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/qifexporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/qifimporter.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/reconciliationreport.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/reportsview.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/sqlstorage.so" Validity true
Located plugin "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/xmlstorage.so" Validity true
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/budgetview.so"
Plugins: budgetview loaded
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/checkprinting.so"
Plugins: checkprinting loaded
QIODevice::read (QFile, "/usr/share/checkprinting/check_template.html"): device not open
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/csvexporter.so"
Plugins: csvexporter loaded
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/csvimporter.so"
Plugins: csvimporter loaded
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/forecastview.so"
Plugins: forecastview loaded
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/reconciliationreport.so"
Plugins: reconciliation report loaded
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/reportsview.so"
Plugins: reportsview loaded
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/sqlstorage.so"
Plugins: sqlstorage loaded
Loading "/tmp/.mount_kmymonY2NJOP/usr/plugins/kmymoney/xmlstorage.so"
Plugins: xmlstorage loaded
testing fileFixVersion 4 < 5
Cost center model created with items 0
Payees model created with items 0
[0321/104256.990221:WARNING:stack_trace_posix.cc(699)] Failed to open file: /memfd:/.glXXXXXX (deleted)
  Error: No such file or directory
Received signal 11 SEGV_MAPERR 000000000008
#0 0x7fa69f10b1ae <unknown>
#1 0x7fa69db03648 <unknown>
#2 0x7fa69f10b6de <unknown>
#3 0x7fa6a4103040 <unknown>
#4 0x7fa67cbcf4b7 <unknown>
#5 0x7fa67cbcf6df <unknown>
#6 0x7fa67cbcf811 <unknown>
#7 0x7fa67cbcf895 <unknown>
#8 0x7fa67cbcf92a <unknown>
#9 0x7fa67cb81672 <unknown>
#10 0x7fa67cb85bbc mysql_real_connect
#11 0x7fa68406897a <unknown>
#12 0x7fa684089990 QSqlDatabase::open()
#13 0x7fa67de3e893 MyMoneyStorageSql::open()
#14 0x7fa67de2cbf5 SQLStorage::save()
#15 0x0000004917c5 KMyMoneyApp::slotFileSave()
#16 0x7fa6a53bb4fb QMetaObject::activate()
#17 0x7fa6a6a60812 QAction::triggered()
#18 0x7fa6a6a62e10 QAction::activate()
#19 0x7fa6a6b5119d <unknown>
#20 0x7fa6a6b513cd QAbstractButton::mouseReleaseEvent()
#21 0x7fa6a6c3ce3a QToolButton::mouseReleaseEvent()
#22 0x7fa6a6aa66c0 QWidget::event()
#23 0x7fa6a6c3cf19 QToolButton::event()
#24 0x7fa6a6a66e1c QApplicationPrivate::notify_helper()
#25 0x7fa6a6a6f4f8 QApplication::notify()
#26 0x7fa6a538dc20 QCoreApplication::notifyInternal2()
#27 0x7fa6a6a6d9bd QApplicationPrivate::sendMouseEvent()
#28 0x7fa6a6ac07f2 <unknown>
#29 0x7fa6a6ac318b <unknown>
#30 0x7fa6a6a66e1c QApplicationPrivate::notify_helper()
#31 0x7fa6a6a6e4d6 QApplication::notify()
#32 0x7fa6a538dc20 QCoreApplication::notifyInternal2()
#33 0x7fa6a6425069 QGuiApplicationPrivate::processMouseEvent()
#34 0x7fa6a6426ea5 QGuiApplicationPrivate::processWindowSystemEvent()
#35 0x7fa6a6401f1b QWindowSystemInterface::sendWindowSystemEvents()
#36 0x7fa68d6d01cb <unknown>
#37 0x7fa6a538bfaa QEventLoop::exec()
#38 0x7fa6a5395074 QCoreApplication::exec()
#39 0x00000047c5c8 runKMyMoney()
#40 0x000000479ff6 main
#41 0x7fa6a40e5bf7 __libc_start_main
#42 0x00000047ad39 _start
  r8: 000000000000000a  r9: 00007ffd1ceef130 r10: 000000000403dc5f r11: 0000000000000052
 r12: 00007ffd1ceef120 r13: 0000000000000007 r14: 0000000000000020 r15: 0000000000000000
  di: 0000000000000000  si: 0000000000000075  bp: 00007ffd1ceef100  bx: 0000000000000000
  dx: 0000000000000000  ax: 5f2d228e16c49d29  cx: 5f2d228e16c49d29  sp: 00007ffd1ceef0f0
  ip: 00007fa67cbcf4b7 efl: 0000000000010246 cgf: 002b000000000033 erf: 0000000000000004
 trp: 000000000000000e msk: 0000000000000000 cr2: 0000000000000008
[end of stack trace]
Calling _exit(1). Core file will not be generated.


SOFTWARE/OS VERSIONS
Linux/KDE Plasma: AppImage (KMyMoney-5.1.1-5ea8730-x86_64.AppImage) on Mint 19.3
KDE Plasma Version: AppImage (KMyMoney-5.1.1-5ea8730-x86_64.AppImage) on Mint 19.3
KDE Frameworks Version: AppImage (KMyMoney-5.1.1-5ea8730-x86_64.AppImage) on Mint 19.3
Qt Version: AppImage (KMyMoney-5.1.1-5ea8730-x86_64.AppImage) on Mint 19.3

ADDITIONAL INFORMATION
Dataset is stored on a remote MySQL server.  Database connectivity works with static 5.0.5 (distro package)
Comment 1 lp.allard.1 2021-03-21 15:03:15 UTC
In contrast, saving on the same SQL dataset with static 5.0.5 (installed via distro package manager):

qt5ct: using qt5ct plugin
WebConnect: Try to connect to WebConnect server
WebConnect: Server connected
WebConnect: Connect to server is ok
WebConnect: Running in client mode
WebConnect: Server disconnected
Custom icons were not found in any of the following QStandardPaths::AppDataLocation:
"/home/workstation/.local/share/kmymoney"
"/usr/share/xfce4/kmymoney"
"/home/workstation/.local/share/flatpak/exports/share/kmymoney"
"/var/lib/flatpak/exports/share/kmymoney"
"/usr/local/share/kmymoney"
"/usr/share/kmymoney"
qt5ct: D-Bus global menu: no
QFSFileEngine::open: No file name specified
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_xmlstorage.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_qif.so" Validity false
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/sqlstorage.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/ofximporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/forecastview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/budgetview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/icalendarexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/checkprinting.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reconciliationreport.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_reportsview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_checkprinting.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kbanking.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_csvimporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/gncimporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvimporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_icalendarexporter.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/konlinetasks_sepa.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/onlinejoboutboxview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/xmlstorage.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/weboob.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reportsview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/kcm_forecastview.so" Validity true
Located plugin "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/qifimporter.so" Validity true
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/budgetview.so"
Plugins: budgetview loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/checkprinting.so"
kf5.kxmlgui: cannot find .rc file "checkprinting.rc" for component "checkprinting"
Plugins: checkprinting loaded
QIODevice::read (QFile, "/usr/share/checkprinting/check_template.html"): device not open
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvexporter.so"
kf5.kxmlgui: cannot find .rc file "csvexporter.rc" for component "csvexporter"
Plugins: csvexporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/csvimporter.so"
kf5.kxmlgui: cannot find .rc file "csvimporter.rc" for component "csvimporter"
Plugins: csvimporter loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/forecastview.so"
Plugins: forecastview loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reconciliationreport.so"
Plugins: reconciliation report loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/reportsview.so"
Plugins: reportsview loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/sqlstorage.so"
Plugins: sqlstorage loaded
Loading "/usr/lib/x86_64-linux-gnu/qt5/plugins/kmymoney/xmlstorage.so"
Plugins: xmlstorage loaded
testing fileFixVersion 4 < 5
Cost center model created with items 0
Payees model created with items 0
QXcbConnection: XCB error: 3 (BadWindow), sequence: 769, resource id: 8927901, major code: 40 (TranslateCoords), minor code: 0
libpng warning: iCCP: known incorrect sRGB profile
libpng warning: iCCP: known incorrect sRGB profile
qt5ct: D-Bus system tray: no
No text-to-speech plug-ins were found.
Plugins: budgetview unloaded
Plugins: checkprinting unloaded
Plugins: csvexporter unloaded
Plugins: csvimporter unloaded
Plugins: forecastview unloaded
Plugins: reconciliation report unloaded
Plugins: reportsview unloaded
Plugins: sqlstorage unloaded
Plugins: xmlstorage unloaded
Comment 2 Jack 2022-08-24 22:58:57 UTC
Does this still happen with a more recent appimage?   I know there are currently problems building new appimage files, but there are certainly more recent versions available, although you don't report which exact version you used.
Comment 3 lp.allard.1 2022-08-24 23:47:11 UTC
Jack,

The appimage 5.1.179 (latest successful built) doesnt offer me with more connectors than "SQLCipher Version 3 (encrypted SQLite)) and I do not see MySQL or something else allowing to connect to MySQL DB server.

Am I missing something?  If I can connect with a recent appimage (or ideally the same version as my daily driver) I will be happy to test the MySQL connection.
Comment 4 Bug Janitor Service 2022-09-08 04:36:08 UTC
Dear Bug Submitter,

This bug has been in NEEDSINFO status with no change for at least
15 days. Please provide the requested information as soon as
possible and set the bug status as REPORTED. Due to regular bug
tracker maintenance, if the bug is still in NEEDSINFO status with
no change in 30 days the bug will be closed as RESOLVED > WORKSFORME
due to lack of needed information.

For more information about our bug triaging procedures please read the
wiki located here:
https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging

If you have already provided the requested information, please
mark the bug as REPORTED so that the KDE team knows that the bug is
ready to be confirmed.

Thank you for helping us make KDE software even better for everyone!
Comment 5 lp.allard.1 2022-09-08 15:59:00 UTC
I cannot answer because latest AppImage doesnt seem to support MySQL connection.