When trying to save entries made back to my DB backend it crashes everytime. kmymoney[2637]: segfault at 30 ip 00007ff24a708fa0 sp 00007ffd6d54b3a8 error 4 in libpthread-2.27.so[7ff24a6ff000+1a000] OS: KUbuntu 18.04.1 KDE: 5.44.0 KDE Plasma: 5.12.6 Qt: 5.9.5 Kernel: 4.15.0-33-generic KMM: 5.0.80-00d52935b (Debug build off master with code pulled on 09/08/2018)
I attempted to recreate the error and got prompted with consistency issues which I manually corrected them and tried to save again. KMM crashed again so I am providing the two core dumps for comparison to see if the cause is the same or if a different reason. Could not attach core dump file due to its size so I uploaded them. Links below https://drive.google.com/open?id=1bXUjh8WGjpOdHNc6SwfoKGN4HgvlP7po https://drive.google.com/open?id=1d0woZHSZq73yL5DZ7L3KUJiKbrnoXAlo Let me know if you need any more info from me.
Part of the 'core dump' is a backtrace. It shows the following, but I have no idea what is going on. Why would KMyMoney call 'slotFileSave' on a DB backend? That does not make sense to me at all. #0 0x00007f3f0380ffa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 type = <optimized out> __PRETTY_FUNCTION__ = "__pthread_mutex_lock" id = <optimized out> #1 0x00007f3e6fa7526a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007f3e6fa4cad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007f3e6fa20abb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007f3e743f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007f3eba846f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007f3ebaaa8db5 in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=this@entry=0x55f72e8092e0, url=..., openMode=openMode@entry=2, clear=clear@entry=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:161 isSQLiteAutocreated = false isSuccessfullyOpened = <optimized out> rc = 0 options = {<QList<QString>> = {<QListSpecialMethods<QString>> = {<No data fields>}, {p = {static shared_null = {ref = {atomic = {_q_value = {<std::__atomic_base<int>> = {static _S_alignment = 4, _M_i = -1}, <No data fields>}}}, alloc = 0, begin = 0, end = 0, array = {0x0}}, d = 0x55f72da9d630}, d = 0x55f72da9d630}}, <No data fields>} dbName = {static null = {<No data fields>}, d = 0x55f72dbc4a60} query = {d = 0x55f72ea67340} d = 0x55f72e8e0330 __PRETTY_FUNCTION__ = "int MyMoneyStorageSql::open(const QUrl&, int, bool)" #7 0x00007f3ebaa97655 in SQLStorage::save(QUrl const&) (this=<optimized out>, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:143 rc = false writer = 0x55f72e8092e0 #8 0x000055f72b508785 in KMyMoneyApp::slotFileSave() (this=0x55f72cff5820) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3496 plugin = @0x55f72d484710: 0x55f72d4d26b0 __for_range = @0x7f3f0a0db240: {d = 0x55f72d475250} __for_begin = {i = 0x55f72d4846f0} __for_end = {i = 0x55f72d475258} _thisStatus = {m_prevText = {static null = {<No data fields>}, d = 0x55f72e670710}} #9 0x000055f72b528340 in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55f72b50866a <KMyMoneyApp::slotFileSave()>, o=0x55f72cff5820, arg=0x7ffef139be80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #10 0x000055f72b528009 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55f72b50866a <KMyMoneyApp::slotFileSave()>, o=0x55f72cff5820, arg=0x7ffef139be80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #11 0x000055f72b527438 in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x55f72d187e00, r=0x55f72cff5820, a=0x7ffef139be80, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #12 0x00007f3f050b46cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #13 0x00007f3f0723e122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #14 0x00007f3f0724080c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #15 0x00007f3f0733710b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #16 0x00007f3f0733736d in QAbstractButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5
Was the logic changed in the way interaction with a DB is done in KMM5? In KMM 4.8 any entry made it sends it straight to the DB where as in KMM5 it seems to be stored locally until I push the save button. I am wondering if it creates a temporary file and the file is deleted by the system and KMM is not aware of it which is why it crashes when I hit the save button.
*** Bug 398939 has been marked as a duplicate of this bug. ***
Moving comment from 393839 to here as instructed by Jack. Since I was having trouble saving entries to my Database I figured I would save my DB to a File and then try to save it as SQL back into my Database Server under a different Database. It crashed everytime tried to save it to the Database Server STEPS TO REPRODUCE 1. Save Database Entries to file (via File -> Save As) 2. Close KMM 3. Open KMM and Load saved file 4. Save File to Database (via File -> Save As "SQL") EXPECTED RESULT New Database get populated with current File ACTUAL RESULT KMM Crashes ADDITIONAL INFORMATION OS: KUbuntu 18.04.1 Kernel: 4.15.0-34-generic Build from source Branch 5.0 (pulled on 09/21/2018 @ 20:43 MDT) KMM Version 5.0.2-cc670b1a Core Dump/Backtrace: https://drive.google.com/open?id=1bulb9NpxXpKYpfOiliJeLH-tlHv3mtXV
MySQL storage does not crash for me with a simple test case. Please do these roughly described steps and report if they work for you: 1) create new basic (one account, one transaction, one payee, one category) XML storage 2) save it as SQL (MySQL) storage 3) close KMyMoney 4) open KMyMoney (MySQL storage should be loaded automatically) 5) add one more transaction and hit save button Following snippet from your dump looks suspicious: "Title: kmymoney crashed with SIGSEGV in __GI___pthread_mutex_lock() UnreportableReason: This package does not seem to be installed correctly UpgradeStatus: Upgraded to bionic on 2018-05-26 (119 days ago)" I suspect that something may be not right either with your system (maybe you could provide us with some info) or with your specific payload to MySQL (you should follow the steps from the top) (In reply to Eleazar from comment #3) > Was the logic changed in the way interaction with a DB is done in KMM5? > > In KMM 4.8 any entry made it sends it straight to the DB where as in KMM5 it > seems to be stored locally until I push the save button. Yes it has been changed. SQL now works just as XML. The approach from KMM 4.8 was slow, required duplicate code and in my opinion offered no benefits. > I am wondering if it creates a temporary file and the file is deleted by the > system and KMM is not aware of it which is why it crashes when I hit the > save button. AFAIK MySQL isn't file based database as it is in case of SQLite. MySQL and SQL roughly follow the same code paths and in case of SQLite no temporary file is created to save database. A database is open and stays open till its close or KMM close.
Created attachment 115190 [details] Test File Test file created to be saved as SQL
I followed the steps indicated and KMM crashed on step 2. stdout: libEGL warning: DRI2: failed to authenticate WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile org.kde.pim.kidentitymanagement: IdentityManager: There was no default identity. Marking first one as default. '/usr/share/kmymoney/templates/dk' not scanned testing fileFixVersion 0 < 4 testing fileFixVersion 1 < 4 testing fileFixVersion 2 < 4 0 transactions fixed in fixFile_2 testing fileFixVersion 3 < 4 Cost center model created with items 0 Payees model created with items 0 kf5.kio.core: Refilling KProtocolInfoFactory cache in the hope to find "" kf5.kio.core: KSambaShare: Could not find smb.conf! Segmentation fault (core dumped) Is there a reason that Samba is being invoked? coredump/backtrace: https://drive.google.com/open?id=1w1D9OHeQiZ_Mh1rcjY3X8cJygVRG5G46
(In reply to Eleazar from comment #8) > I followed the steps indicated and KMM crashed on step 2. So that's not an issue with your data. > kf5.kio.core: Refilling KProtocolInfoFactory cache in the hope to find "" > kf5.kio.core: KSambaShare: Could not find smb.conf! > Segmentation fault (core dumped) > > Is there a reason that Samba is being invoked? It's not invoked in my case. I know nothing about Samba support in KMyMoney. I wonder if it's a coincidence that it crashes for you just after not finding smb.conf. Where is your mysql server located? Is that not a localhost?
My server is located on my local network (MySQL server on a FreeBSD server) on the same switch. Also I checked my DB and all the tables were created but the tables were empty.
Created attachment 115193 [details] Don't open already opened database (In reply to Eleazar from comment #10) > My server is located on my local network (MySQL server on a FreeBSD server) > on the same switch. That makes a difference here. I did my testing on a localhost. > Also I checked my DB and all the tables were created but the tables were > empty. I'm not sure that I can help you here. We open SQL in a lot of places and in a very unordered manner. That probably causes errors in your case and a fix might be not an easy task. Could you check if the attached patch takes you any further? Just put it in the top dir of your kmymoney source tree and apply it by calling patch -p1 < patch.diff
Did a git pull and applied the patch. It crashed when I tried to save the test file to the DB. stdout: libEGL warning: DRI2: failed to authenticate 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 Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile kf5.kio.core: KSambaShare: Could not find smb.conf! QXcbConnection: XCB error: 3 (BadWindow), sequence: 2141, resource id: 46170457, major code: 40 (TranslateCoords), minor code: 0 reading file start parsing file startDocument reading securities endDocument Cost center model created with items 0 Payees model created with items 0 Segmentation fault (core dumped) Core Dump/backtrace: https://drive.google.com/open?id=1EHPk1B_5S2M2jC2mwQTsNrnRtpghQogH
Forgot to include KMM version: Version 5.0.2-5c8cbc29
It goes further but your dump doesn't contain anything readable and I don't see where KMM crashes now.
I tried everything from scratch again and it crashed again on step 2. Hopefully this dump has more info. stdout libEGL warning: DRI2: failed to authenticate WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile org.kde.pim.kidentitymanagement: IdentityManager: There was no default identity. Marking first one as default. '/usr/share/kmymoney/templates/dk' not scanned testing fileFixVersion 0 < 4 testing fileFixVersion 1 < 4 testing fileFixVersion 2 < 4 0 transactions fixed in fixFile_2 testing fileFixVersion 3 < 4 Cost center model created with items 0 Payees model created with items 0 kf5.kio.core: Refilling KProtocolInfoFactory cache in the hope to find "" kf5.kio.core: KSambaShare: Could not find smb.conf! kf5.kio.core: Invalid URL: QUrl("test.kmy") QXcbConnection: XCB error: 3 (BadWindow), sequence: 4452, resource id: 44043949, major code: 40 (TranslateCoords), minor code: 0 Segmentation fault (core dumped) core dump/backtrace: https://drive.google.com/open?id=1qz0qJCZ0_84HFZvfrtL1OJlYX13z8n_c
(In reply to Eleazar from comment #15) > I tried everything from scratch again and it crashed again on step 2. > > Hopefully this dump has more info. No, it's useless. > kf5.kio.core: Invalid URL: QUrl("test.kmy") Do you have your test.kmy in local or remote location?
> > kf5.kio.core: Invalid URL: QUrl("test.kmy") > > Do you have your test.kmy in local or remote location? Local. ~/test.kmy
Git commit f7602b3540a1518e82ec311f23313958f4cb5cb7 by Thomas Baumgart. Committed on 30/09/2018 at 17:20. Pushed by tbaumgart into branch '5.0'. Don't use default for text field in MySQL DB during table creation >From the MySQL documentation: BLOB and TEXT columns cannot have DEFAULT values. M +6 -2 kmymoney/plugins/sql/mymoneystoragesql_p.h https://commits.kde.org/kmymoney/f7602b3540a1518e82ec311f23313958f4cb5cb7
I pulled the latest code. Uninstall installed version and rebuild with today's commit (Version 5.0.2-73dc6c0e) I opened the test file and tried to save it to the DB and it crashed again. Std out: libEGL warning: DRI2: failed to authenticate WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile kf5.kio.core: KSambaShare: Could not find smb.conf! reading file start parsing file startDocument reading securities endDocument Cost center model created with items 0 Payees model created with items 0 Segmentation fault (core dumped) Backtrack/Core Dump: https://drive.google.com/open?id=1axWP2OqRGjOvk38UeEJuyyV2YPFVSug0
I open my current DB and tried to save an entry and it crashed again. Std Out: Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile Cost center model created with items 0 Payees model created with items 0 Segmentation fault (core dumped) Backtrace/core dump: https://drive.google.com/open?id=1ijcwkXhSpxImLoikhCc5SyCj8kdqOgR4
Sorry, but your files contain a lot of info but no backtrace. Can you try to run KMyMoney under control of gdb instead of producing a core dump?
I ran kmm with gdb and tried to save the file as SQL. I got prompted about how it was going to delete the existing data in the DB if I continued. I clicked on ok and it crashed. Std Out: Starting program: /usr/bin/kmymoney [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa81700 (LWP 13197)] [New Thread 0x7fffd6cb0700 (LWP 13198)] libEGL warning: DRI2: failed to authenticate [New Thread 0x7fffca1a8700 (LWP 13200)] [New Thread 0x7fffc99a7700 (LWP 13201)] [New Thread 0x7fffc91a6700 (LWP 13202)] [New Thread 0x7fffc89a5700 (LWP 13203)] [New Thread 0x7fffba4f2700 (LWP 13204)] 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 Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded reading file start parsing file startDocument reading securities endDocument Cost center model created with items 0 Payees model created with items 0 libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff633ff700 (LWP 13206)] [New Thread 0x7fff61b95700 (LWP 13207)] [New Thread 0x7fff59d3a700 (LWP 13216)] [Thread 0x7fff59d3a700 (LWP 13216) exited] [New Thread 0x7fff59d3a700 (LWP 13217)] [Thread 0x7fff59d3a700 (LWP 13217) exited] [New Thread 0x7fff59d3a700 (LWP 13218)] [New Thread 0x7fff3bd73700 (LWP 13219)] [New Thread 0x7fff3af13700 (LWP 13220)] [New Thread 0x7fff3a712700 (LWP 13221)] [New Thread 0x7fff39d03700 (LWP 13222)] [New Thread 0x7fff39502700 (LWP 13223)] [New Thread 0x7fff38d01700 (LWP 13224)] [New Thread 0x7fff17fff700 (LWP 13225)] [Thread 0x7fff59d3a700 (LWP 13218) exited] [Thread 0x7fff39502700 (LWP 13223) exited] [Thread 0x7fff39d03700 (LWP 13222) exited] [Thread 0x7fff38d01700 (LWP 13224) exited] [Thread 0x7fff3a712700 (LWP 13221) exited] [Thread 0x7fff3af13700 (LWP 13220) exited] [Thread 0x7fff3bd73700 (LWP 13219) exited] Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. I ran "generate-core-file" so hopefully this file has more helpful information. https://drive.google.com/open?id=1_Y3n8fc8o8RD91D4hOj3lKD0pA5ZtRo-
Instead of generating a 2.5GB core dump using 'generate-core-file' the output of a simple 'bt' would probably give more information. The core dump w/o the actual binary application does not really help. Sorry. Can you provide that backtrace instead (bt)? TIA.
Sorry for the big file as this is the first time I have used gdb and did not know I could just get the backtrace. Std Out: Starting program: /usr/bin/kmymoney [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa81700 (LWP 12068)] [New Thread 0x7fffd6cb0700 (LWP 12069)] libEGL warning: DRI2: failed to authenticate [New Thread 0x7fffca1a8700 (LWP 12070)] [New Thread 0x7fffc99a7700 (LWP 12071)] [New Thread 0x7fffc91a6700 (LWP 12072)] [New Thread 0x7fffc89a5700 (LWP 12073)] [New Thread 0x7fffba4f2700 (LWP 12074)] WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded reading file start parsing file startDocument reading securities endDocument Cost center model created with items 0 Payees model created with items 0 libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff633ff700 (LWP 12077)] [New Thread 0x7fff61b95700 (LWP 12078)] [New Thread 0x7fff59d3a700 (LWP 12495)] [Thread 0x7fff59d3a700 (LWP 12495) exited] [New Thread 0x7fff59d3a700 (LWP 12496)] [Thread 0x7fff59d3a700 (LWP 12496) exited] [New Thread 0x7fff59d3a700 (LWP 12497)] [New Thread 0x7fff3bd73700 (LWP 12498)] [New Thread 0x7fff3af13700 (LWP 12499)] [New Thread 0x7fff3a712700 (LWP 12500)] [New Thread 0x7fff39d03700 (LWP 12501)] [New Thread 0x7fff39502700 (LWP 12502)] [New Thread 0x7fff38d01700 (LWP 12503)] [New Thread 0x7fff17fff700 (LWP 12504)] Aborting aboutToFinish handling. [Thread 0x7fff59d3a700 (LWP 12497) exited] Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. Backtrace: #0 0x00007fffef593fa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5a49626a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff5a46dad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff5a441abb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff603f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa65f2f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa684fccb in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x555556f55e70, url=..., openMode=2, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:161 #7 0x00007fffa684b086 in SQLStorage::save(QUrl const&) (this=0x55555623baa0, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:188 #8 0x00007fffa684cc7f in SQLStorage::saveAsDatabase(QUrl const&) (this=0x55555623baa0, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:344 #9 0x00007fffa684bab8 in SQLStorage::saveAs() (this=0x55555623baa0) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:231 #10 0x000055555560deae in KMyMoneyApp::slotFileSaveAs() (this=0x555555e6cc20) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3557 #11 0x000055555562dc3a in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560db04 <KMyMoneyApp::slotFileSaveAs()>, o=0x555555e6cc20, arg=0x7fffffffcca0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #12 0x000055555562d903 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560db04 <KMyMoneyApp::slotFileSaveAs()>, o=0x555555e6cc20, arg=0x7fffffffcca0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #13 0x000055555562cc7a in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555f31d60, r=0x555555e6cc20, a=0x7fffffffcca0, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #14 0x00007ffff0e336cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #15 0x00007ffff2db0122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #16 0x00007ffff2db280c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2f2f0bc in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2f3656b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2f37393 in QMenu::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2df5038 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2f396bb in QMenu::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #23 0x00007ffff2dbe64f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #25 0x00007ffff2dbd622 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #26 0x00007ffff2e0fe85 in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2e127ba in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #29 0x00007ffff2dbe0f4 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #30 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #31 0x00007ffff25fa523 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #32 0x00007ffff25fbff5 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #33 0x00007ffff25d32eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #34 0x00007fffd98b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 #35 0x00007fffe67f2287 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #36 0x00007fffe67f24c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #37 0x00007fffe67f254c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #38 0x00007ffff0e5d8ef in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #39 0x00007ffff0e029ea in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #40 0x00007ffff0e0ba84 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #41 0x00005555555f2fbb in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=false) at /home/eagleboy/kmymoney/kmymoney/main.cpp:312 #42 0x00005555555f26cc in main(int, char**) (argc=1, argv=0x7fffffffdd38) at /home/eagleboy/kmymoney/kmymoney/main.cpp:231
The crash happens inside the mysql client code (#0). Very strange. #6 below is the last part of KMyMoney code. #0 0x00007fffef593fa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5a49626a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff5a46dad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff5a441abb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff603f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa65f2f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa684fccb in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x555556f55e70, url=..., openMode=2, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:161 Can you attach a screenshot of the "Select database" dialog with the database parameters filled in just before you press "OK"?
Created attachment 115375 [details] Select Databse Screenshot Here is the requested Screenshot
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!
I tried to change it to reported but it says I do not have permission to do so.
Disregard it changed it when I commented on not being able to change.
Did you try again with the latest version from git? There have been some more changes on the DB code during the last two weeks or so. Please check the following cases: a) create new file (and specify to write as a DB) b) use existing .kmy file and save it as DB c) use an existing DB and save it All these cases work for me here on a MySQL server in a different network.
I'm out of town this. I will try everything you requested next week and report in.
(In reply to Eleazar from comment #31) > I'm out of town this. I will try everything you requested next week and > report in. You could try AppImage from https://binary-factory.kde.org/job/KMyMoney_Nightly_Appimage_Build/ It contains latest Qt and MySQL. Those components take part in communication between KMyMoney and your SQL server. If it works for Thomas and me but not for you, then the bug could be somewhere in third party components. By using AppImage you have the means to test it.
I pulled the latest code (10/27/2018 @ 11:30 MDT) and built it same as before (cmake .. -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_BUILD_TYPE=Debugfull -DKDE_INSTALL_PLUGINDIR=/usr/lib/x86_64-linux-gnu/qt5/plugins). This built version is 5.0.2-cf0ead3c I performed the requested items and as you can see from below it crashed when performing them. I did notice that it was able to create the DB and the needed tables for the new instances but it always crashed when trying to save the data. Is it using a different method to create the tables then the one used to store the data? > a) create new file (and specify to write as a DB) Created All the needed tables and then crashed. Std Out (gdb) run -n Starting program: /usr/bin/kmymoney -n [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa81700 (LWP 9402)] [New Thread 0x7fffd6cb0700 (LWP 9403)] [New Thread 0x7fffcfb68700 (LWP 9404)] [New Thread 0x7fffbf846700 (LWP 9405)] [New Thread 0x7fffbf045700 (LWP 9406)] [New Thread 0x7fffbe844700 (LWP 9407)] [New Thread 0x7fffbe043700 (LWP 9408)] WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff63fff700 (LWP 9409)] org.kde.pim.kidentitymanagement: IdentityManager: There was no default identity. Marking first one as default. [New Thread 0x7fff5a0ce700 (LWP 9415)] '/usr/share/kmymoney/templates/dk' not scanned [New Thread 0x7fff5bfff700 (LWP 9416)] testing fileFixVersion 0 < 4 testing fileFixVersion 1 < 4 testing fileFixVersion 2 < 4 0 transactions fixed in fixFile_2 testing fileFixVersion 3 < 4 Cost center model created with items 0 Payees model created with items 0 QXcbConnection: XCB error: 3 (BadWindow), sequence: 1304, resource id: 46143950, major code: 40 (TranslateCoords), minor code: 0 QXcbConnection: XCB error: 3 (BadWindow), sequence: 1706, resource id: 46144029, major code: 40 (TranslateCoords), minor code: 0 [New Thread 0x7fff5b7fe700 (LWP 9419)] [New Thread 0x7fff598cd700 (LWP 9420)] [New Thread 0x7fff590cc700 (LWP 9421)] Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. Backtrace: (gdb) bt #0 0x00007fffef593fa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5834126a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff58318ad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff582ecabb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff5adf41b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa6fc2f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa721f78d in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x55555699b970, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa721b0d6 in SQLStorage::save(QUrl const&) (this=0x5555562697e0, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:188 #8 0x00007fffa721cccf in SQLStorage::saveAsDatabase(QUrl const&) (this=0x5555562697e0, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:344 #9 0x00007fffa721bb08 in SQLStorage::saveAs() (this=0x5555562697e0) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:231 #10 0x000055555560df2a in KMyMoneyApp::slotFileSaveAs() (this=0x555555d17780) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3554 #11 0x000055555560c492 in KMyMoneyApp::slotFileNew() (this=0x555555d17780) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3390 #12 0x000055555562dc0e in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560bf1a <KMyMoneyApp::slotFileNew()>, o=0x555555d17780, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #13 0x000055555562d8d7 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560bf1a <KMyMoneyApp::slotFileNew()>, o=0x555555d17780, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #14 0x000055555562cc4e in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555f543e0, r=0x555555d17780, a=0x7fffffffcdc0, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #15 0x00007ffff0e336cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #16 0x00007ffff2db0122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2db280c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2ea910b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2ea936d in QAbstractButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2f87fea in QToolButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2df5038 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff2f88084 in QToolButton::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #23 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff2dbe64f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #25 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #26 0x00007ffff2dbd622 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2e1014b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff2e127ba in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #29 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #30 0x00007ffff2dbe0f4 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #31 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #32 0x00007ffff25fa523 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 ---Type <return> to continue, or q <return> to quit--- #33 0x00007ffff25fbff5 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #34 0x00007ffff25d32eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #35 0x00007fffd98b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 #36 0x00007fffe67f2287 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #37 0x00007fffe67f24c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #38 0x00007fffe67f254c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #39 0x00007ffff0e5d8ef in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #40 0x00007ffff0e029ea in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #41 0x00007ffff0e0ba84 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #42 0x00005555555f3037 in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=true) at /home/eagleboy/kmymoney/kmymoney/main.cpp:335 #43 0x00005555555f2716 in main(int, char**) (argc=2, argv=0x7fffffffdd18) at /home/eagleboy/kmymoney/kmymoney/main.cpp:243 > b) use existing .kmy file and save it as DB Dropped all the tables from the previous run. And tried it again. It created all the required tables and crashed Std Out: (gdb) run -n Starting program: /usr/bin/kmymoney -n [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa81700 (LWP 9537)] [New Thread 0x7fffd6cb0700 (LWP 9538)] [New Thread 0x7fffcfb68700 (LWP 9539)] [New Thread 0x7fffbf846700 (LWP 9540)] [New Thread 0x7fffbf045700 (LWP 9541)] [New Thread 0x7fffbe844700 (LWP 9542)] [New Thread 0x7fffbe043700 (LWP 9543)] 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 Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff63fff700 (LWP 9544)] reading file start parsing file startDocument reading securities endDocument [New Thread 0x7fff5bfff700 (LWP 9548)] Cost center model created with items 0 Payees model created with items 0 QXcbConnection: XCB error: 3 (BadWindow), sequence: 2805, resource id: 46146018, major code: 40 (TranslateCoords), minor code: 0 Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. Backtrace: (gdb) bt #0 0x00007fffef593fa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5b27426a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff5b24bad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff5b21fabb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff605f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa6fc2f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa721f78d in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x555556059b10, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa721b0d6 in SQLStorage::save(QUrl const&) (this=0x555556269570, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:188 #8 0x00007fffa721cccf in SQLStorage::saveAsDatabase(QUrl const&) (this=0x555556269570, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:344 #9 0x00007fffa721bb08 in SQLStorage::saveAs() (this=0x555556269570) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:231 #10 0x000055555560df2a in KMyMoneyApp::slotFileSaveAs() (this=0x555555d17bb0) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3554 #11 0x000055555562dc0e in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560db80 <KMyMoneyApp::slotFileSaveAs()>, o=0x555555d17bb0, arg=0x7fffffffcc80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #12 0x000055555562d8d7 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560db80 <KMyMoneyApp::slotFileSaveAs()>, o=0x555555d17bb0, arg=0x7fffffffcc80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #13 0x000055555562cc4e in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555f19120, r=0x555555d17bb0, a=0x7fffffffcc80, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #14 0x00007ffff0e336cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #15 0x00007ffff2db0122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #16 0x00007ffff2db280c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2f2f0bc in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2f3656b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2f37393 in QMenu::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2df5038 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2f396bb in QMenu::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #23 0x00007ffff2dbe64f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #25 0x00007ffff2dbd622 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #26 0x00007ffff2e0fe85 in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2e127ba in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #29 0x00007ffff2dbe0f4 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #30 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #31 0x00007ffff25fa523 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 ---Type <return> to continue, or q <return> to quit--- #32 0x00007ffff25fbff5 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #33 0x00007ffff25d32eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #34 0x00007fffd98b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 #35 0x00007fffe67f2287 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #36 0x00007fffe67f24c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #37 0x00007fffe67f254c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #38 0x00007ffff0e5d8ef in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #39 0x00007ffff0e029ea in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #40 0x00007ffff0e0ba84 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #41 0x00005555555f3037 in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=true) at /home/eagleboy/kmymoney/kmymoney/main.cpp:335 #42 0x00005555555f2716 in main(int, char**) (argc=2, argv=0x7fffffffdd18) at /home/eagleboy/kmymoney/kmymoney/main.cpp:243 > c) use an existing DB and save it I cloned my existing DB and was able to load all entries with "Open Database". When I tried to save it Prompted me of some inconsistency issues and crashed after I acknowledged them. Std Out (gdb) run -n Starting program: /usr/bin/kmymoney -n [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa81700 (LWP 9750)] [New Thread 0x7fffd6cb0700 (LWP 9751)] [New Thread 0x7fffcfb68700 (LWP 9752)] [New Thread 0x7fffbf846700 (LWP 9753)] [New Thread 0x7fffbf045700 (LWP 9754)] [New Thread 0x7fffbe844700 (LWP 9755)] [New Thread 0x7fffbe043700 (LWP 9756)] 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 Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff63fff700 (LWP 9757)] [New Thread 0x7fff5bfff700 (LWP 9826)] Cost center model created with items 0 Payees model created with items 0 QXcbConnection: XCB error: 3 (BadWindow), sequence: 2687, resource id: 46148477, major code: 40 (TranslateCoords), minor code: 0 [New Thread 0x7fff5a00a700 (LWP 9838)] [Thread 0x7fff5a00a700 (LWP 9838) exited] [New Thread 0x7fff5a00a700 (LWP 9840)] [Thread 0x7fff5a00a700 (LWP 9840) exited] [New Thread 0x7fff5a00a700 (LWP 9841)] [Thread 0x7fff5a00a700 (LWP 9841) exited] [New Thread 0x7fff5a00a700 (LWP 9842)] [New Thread 0x7fff3b90b700 (LWP 9843)] [New Thread 0x7fff3aaab700 (LWP 9844)] [New Thread 0x7fff3a2aa700 (LWP 9845)] [New Thread 0x7fff3989b700 (LWP 9846)] [New Thread 0x7fff3909a700 (LWP 9847)] [New Thread 0x7fff38899700 (LWP 9848)] [New Thread 0x7fff23fff700 (LWP 9849)] [Thread 0x7fff5a00a700 (LWP 9842) exited] [Thread 0x7fff38899700 (LWP 9848) exited] [Thread 0x7fff3909a700 (LWP 9847) exited] [Thread 0x7fff3989b700 (LWP 9846) exited] [Thread 0x7fff3a2aa700 (LWP 9845) exited] [Thread 0x7fff3aaab700 (LWP 9844) exited] [Thread 0x7fff3b90b700 (LWP 9843) exited] Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. Backtrace: (gdb) bt #0 0x00007fffef593fa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5a85626a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff5a82dad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff5a801abb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff605f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa6fc2f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa721f78d in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x55555724ff00, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa721b0d6 in SQLStorage::save(QUrl const&) (this=0x555556268680, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:188 #8 0x000055555560d95f in KMyMoneyApp::slotFileSave() (this=0x555555e70db0) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3497 #9 0x000055555562dc0e in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560d844 <KMyMoneyApp::slotFileSave()>, o=0x555555e70db0, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #10 0x000055555562d8d7 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560d844 <KMyMoneyApp::slotFileSave()>, o=0x555555e70db0, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #11 0x000055555562cc4e in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555f3bd40, r=0x555555e70db0, a=0x7fffffffcdc0, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #12 0x00007ffff0e336cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #13 0x00007ffff2db0122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #14 0x00007ffff2db280c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #15 0x00007ffff2ea910b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #16 0x00007ffff2ea936d in QAbstractButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2f87fea in QToolButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2df5038 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2f88084 in QToolButton::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2dbe64f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #23 0x00007ffff2dbd622 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff2e1014b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #25 0x00007ffff2e127ba in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #26 0x00007ffff2db682c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2dbe0f4 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff0e049a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #29 0x00007ffff25fa523 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #30 0x00007ffff25fbff5 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #31 0x00007ffff25d32eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #32 0x00007fffd98b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 ---Type <return> to continue, or q <return> to quit--- #33 0x00007fffe67f2287 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #34 0x00007fffe67f24c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #35 0x00007fffe67f254c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #36 0x00007ffff0e5d8ef in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #37 0x00007ffff0e029ea in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #38 0x00007ffff0e0ba84 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #39 0x00005555555f3037 in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=true) at /home/eagleboy/kmymoney/kmymoney/main.cpp:335 #40 0x00005555555f2716 in main(int, char**) (argc=2, argv=0x7fffffffdd18) at /home/eagleboy/kmymoney/kmymoney/main.cpp:243
> You could try AppImage from > https://binary-factory.kde.org/job/KMyMoney_Nightly_Appimage_Build/ > It contains latest Qt and MySQL. Those components take part in communication > between KMyMoney and your SQL server. How do I pull the files? I looked at the jenkins console output and all I see is where files are being stored locally but I don't see a remote path to them.
Disregard. I found it on the home page.
Using the App Image I got the same results. Let me know if there is anything else you guys want me to try. > a) create new file (and specify to write as a DB) It created the tables but crashed saving the data eagleboy@MobileThingy:~/Downloads$ ./kmymoney--d0e7eea-x86_64.appimage -n QPainter::begin: Paint device returned engine == 0, type: 2 WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode QFSFileEngine::open: No file name specified Plugins: budgetview loaded Plugins: checkprinting loaded QIODevice::read (QFile, "/usr/share/checkprinting/check_template.html"): device not open Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded 3:2018/10/27 12-14-07:gwen(14159):/home/appimage/appimage-workspace/deps-build/ext_gwenhywfar/ext_gwenhywfar-prefix/src/ext_gwenhywfar/src/base/plugin.c: 379: Plugin "dir" not found. 3:2018/10/27 12-14-07:(null)(14159):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 77: Could not create ConfigMgr[dir:///home/eagleboy/.aqbanking/settings]. Maybe the gwenhywfar plugins are not installed 3:2018/10/27 12-14-07:(null)(14159):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 100: No config manager. Maybe the gwenhywfar plugins are not installed correctly? KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. 3:2018/10/27 12-14-07:aqbanking(14159):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 712: No config manager. Maybe the gwenhywfar plugins are not installed correctly? Error on online init (-1). Could not initialize KBanking online banking interface Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded No such XML file "/tmp/.mount_kmymon3Why0D/usr/bin/../share/kxmlgui5/csvexporter/qifimporter.rc" Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: xmlstorage loaded Unknown view '' in slotOpenURL() QFSFileEngine::open: No file name specified org.kde.pim.kidentitymanagement: IdentityManager: There was no default identity. Marking first one as default. '/usr/share/kmymoney/templates/dk' not scanned testing fileFixVersion 0 < 4 testing fileFixVersion 1 < 4 testing fileFixVersion 2 < 4 0 transactions fixed in fixFile_2 testing fileFixVersion 3 < 4 Cost center model created with items 0 Payees model created with items 0 qt.qpa.xcb: QXcbConnection: XCB error: 3 (BadWindow), sequence: 1789, resource id: 46158956, major code: 40 (TranslateCoords), minor code: 0 qt.qpa.xcb: QXcbConnection: XCB error: 3 (BadWindow), sequence: 2259, resource id: 46159044, major code: 40 (TranslateCoords), minor code: 0 Received signal 11 SEGV_MAPERR 000000000008 #0 0x7f58c70eedce <unknown> #1 0x7f58c5b59fc0 <unknown> #2 0x7f58c70ef2ee <unknown> #3 0x7f58ccb72f20 <unknown> #4 0x7f580f942456 <unknown> #5 0x7f580f942573 <unknown> #6 0x7f580f942641 <unknown> #7 0x7f580f9426c5 <unknown> #8 0x7f580f94275a <unknown> #9 0x7f580f8f5cc2 <unknown> #10 0x7f580f8fa17c <unknown> #11 0x7f585c1cc73a <unknown> #12 0x7f58a0188530 QSqlDatabase::open() #13 0x7f5898cfbd5b MyMoneyStorageSql::open() #14 0x7f5898cea745 SQLStorage::save() #15 0x7f5898ceb03d SQLStorage::saveAsDatabase() #16 0x7f5898cec895 SQLStorage::saveAs() #17 0x0000004667e8 KMyMoneyApp::slotFileSaveAs() #18 0x000000468326 KMyMoneyApp::slotFileNew() #19 0x7f58cdafcb4b QMetaObject::activate() #20 0x7f58cf1eea02 QAction::triggered() #21 0x7f58cf1f0de0 QAction::activate() #22 0x7f58cf2d880d <unknown> #23 0x7f58cf2d8a15 QAbstractButton::mouseReleaseEvent() #24 0x7f58cf3b869a QToolButton::mouseReleaseEvent() #25 0x7f58cf2318a8 QWidget::event() #26 0x7f58cf3b876c QToolButton::event() #27 0x7f58cf1f4afc QApplicationPrivate::notify_helper() #28 0x7f58cf1fce50 QApplication::notify() #29 0x7f58cdad09c8 QCoreApplication::notifyInternal2() #30 0x7f58cf1fb1cd QApplicationPrivate::sendMouseEvent() #31 0x7f58cf24af4d <unknown> #32 0x7f58cf24d7d3 <unknown> #33 0x7f58cf1f4afc QApplicationPrivate::notify_helper() #34 0x7f58cf1fbc66 QApplication::notify() #35 0x7f58cdad09c8 QCoreApplication::notifyInternal2() #36 0x7f58cec200b9 QGuiApplicationPrivate::processMouseEvent() #37 0x7f58cec21da5 QGuiApplicationPrivate::processWindowSystemEvent() #38 0x7f58cebfe5cb QWindowSystemInterface::sendWindowSystemEvents() #39 0x7f58b62e9a7b <unknown> #40 0x7f58cdaceeca QEventLoop::exec() #41 0x7f58cdad7a90 QCoreApplication::exec() #42 0x0000004505f5 runKMyMoney() #43 0x00000044f499 main #44 0x7f58ccb55b97 __libc_start_main #45 0x0000004502a1 <unknown> r8: 0000000000000000 r9: 0000000003803ee8 r10: 00000000020b6010 r11: 0000000000000000 r12: 00007fff6eb6eca8 r13: 0000000003803ec0 r14: 0000000000000020 r15: 0000000000000000 di: 0000000000000000 si: 0000000000000075 bp: 00007fff6eb6ec80 bx: 0000000000000000 dx: 0000000000000000 ax: 5f2d228e16c49d29 cx: 5f2d228e16c49d29 sp: 00007fff6eb6ec70 ip: 00007f580f942456 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. > b) use existing .kmy file and save it as DB It created the tables and crashed saving the data. eagleboy@MobileThingy:~/Downloads$ ./kmymoney--d0e7eea-x86_64.appimage -n QPainter::begin: Paint device returned engine == 0, type: 2 WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode QFSFileEngine::open: No file name specified Plugins: budgetview loaded Plugins: checkprinting loaded QIODevice::read (QFile, "/usr/share/checkprinting/check_template.html"): device not open Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded 3:2018/10/27 12-18-51:gwen(14487):/home/appimage/appimage-workspace/deps-build/ext_gwenhywfar/ext_gwenhywfar-prefix/src/ext_gwenhywfar/src/base/plugin.c: 379: Plugin "dir" not found. 3:2018/10/27 12-18-51:(null)(14487):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 77: Could not create ConfigMgr[dir:///home/eagleboy/.aqbanking/settings]. Maybe the gwenhywfar plugins are not installed 3:2018/10/27 12-18-51:(null)(14487):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 100: No config manager. Maybe the gwenhywfar plugins are not installed correctly? KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. 3:2018/10/27 12-18-51:aqbanking(14487):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 712: No config manager. Maybe the gwenhywfar plugins are not installed correctly? Error on online init (-1). Could not initialize KBanking online banking interface Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded No such XML file "/tmp/.mount_kmymonCfb4qr/usr/bin/../share/kxmlgui5/csvexporter/qifimporter.rc" Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: xmlstorage loaded Unknown view '' in slotOpenURL() qt.qpa.xcb: QXcbConnection: XCB error: 3 (BadWindow), sequence: 1204, resource id: 46160835, major code: 40 (TranslateCoords), minor code: 0 reading file start parsing file startDocument reading securities endDocument Cost center model created with items 0 Payees model created with items 0 qt.qpa.xcb: QXcbConnection: XCB error: 3 (BadWindow), sequence: 3896, resource id: 46161082, major code: 40 (TranslateCoords), minor code: 0 Received signal 11 SEGV_MAPERR 000000000008 #0 0x7f0b1a852dce <unknown> #1 0x7f0b192bdfc0 <unknown> #2 0x7f0b1a8532ee <unknown> #3 0x7f0b202d6f20 <unknown> #4 0x7f0a63942456 <unknown> #5 0x7f0a63942573 <unknown> #6 0x7f0a63942641 <unknown> #7 0x7f0a639426c5 <unknown> #8 0x7f0a6394275a <unknown> #9 0x7f0a638f5cc2 <unknown> #10 0x7f0a638fa17c <unknown> #11 0x7f0acc1ca73a <unknown> #12 0x7f0af40c2530 QSqlDatabase::open() #13 0x7f0ae4507d5b MyMoneyStorageSql::open() #14 0x7f0ae44f6745 SQLStorage::save() #15 0x7f0ae44f703d SQLStorage::saveAsDatabase() #16 0x7f0ae44f8895 SQLStorage::saveAs() #17 0x0000004667e8 KMyMoneyApp::slotFileSaveAs() #18 0x7f0b21260b4b QMetaObject::activate() #19 0x7f0b22952a02 QAction::triggered() #20 0x7f0b22954de0 QAction::activate() #21 0x7f0b22abb2fa <unknown> #22 0x7f0b22ac247c <unknown> #23 0x7f0b22ac3536 QMenu::mouseReleaseEvent() #24 0x7f0b229958a8 QWidget::event() #25 0x7f0b22ac594b QMenu::event() #26 0x7f0b22958afc QApplicationPrivate::notify_helper() #27 0x7f0b22960e50 QApplication::notify() #28 0x7f0b212349c8 QCoreApplication::notifyInternal2() #29 0x7f0b22ac3090 <unknown> #30 0x7f0b22ac330e QMenu::mouseReleaseEvent() #31 0x7f0b229958a8 QWidget::event() #32 0x7f0b22ac594b QMenu::event() #33 0x7f0b22958afc QApplicationPrivate::notify_helper() #34 0x7f0b22960e50 QApplication::notify() #35 0x7f0b212349c8 QCoreApplication::notifyInternal2() #36 0x7f0b2295f1cd QApplicationPrivate::sendMouseEvent() #37 0x7f0b229af350 <unknown> #38 0x7f0b229b17d3 <unknown> #39 0x7f0b22958afc QApplicationPrivate::notify_helper() #40 0x7f0b2295fc66 QApplication::notify() #41 0x7f0b212349c8 QCoreApplication::notifyInternal2() #42 0x7f0b223840b9 QGuiApplicationPrivate::processMouseEvent() #43 0x7f0b22385da5 QGuiApplicationPrivate::processWindowSystemEvent() #44 0x7f0b223625cb QWindowSystemInterface::sendWindowSystemEvents() #45 0x7f0b09a4da7b <unknown> #46 0x7f0b21232eca QEventLoop::exec() #47 0x7f0b2123ba90 QCoreApplication::exec() #48 0x0000004505f5 runKMyMoney() #49 0x00000044f499 main #50 0x7f0b202b9b97 __libc_start_main #51 0x0000004502a1 <unknown> r8: 0000000000000000 r9: 000000000294ac68 r10: 0000000001218010 r11: 0000000000000001 r12: 00007ffec7afb528 r13: 000000000294ac40 r14: 0000000000000020 r15: 0000000000000000 di: 0000000000000000 si: 0000000000000075 bp: 00007ffec7afb500 bx: 0000000000000000 dx: 0000000000000000 ax: 5f2d228e16c49d29 cx: 5f2d228e16c49d29 sp: 00007ffec7afb4f0 ip: 00007f0a63942456 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. > c) use an existing DB and save it I was able to load the data but it crashed when it tried to save changes. eagleboy@MobileThingy:~/Downloads$ ./kmymoney--d0e7eea-x86_64.appimage -n QPainter::begin: Paint device returned engine == 0, type: 2 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 QFSFileEngine::open: No file name specified Plugins: budgetview loaded Plugins: checkprinting loaded QIODevice::read (QFile, "/usr/share/checkprinting/check_template.html"): device not open Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded 3:2018/10/27 12-23-40:gwen(15397):/home/appimage/appimage-workspace/deps-build/ext_gwenhywfar/ext_gwenhywfar-prefix/src/ext_gwenhywfar/src/base/plugin.c: 379: Plugin "dir" not found. 3:2018/10/27 12-23-40:(null)(15397):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 77: Could not create ConfigMgr[dir:///home/eagleboy/.aqbanking/settings]. Maybe the gwenhywfar plugins are not installed 3:2018/10/27 12-23-40:(null)(15397):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 100: No config manager. Maybe the gwenhywfar plugins are not installed correctly? KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. 3:2018/10/27 12-23-40:aqbanking(15397):/home/appimage/appimage-workspace/deps-build/ext_aqbanking/ext_aqbanking-prefix/src/ext_aqbanking/src/libs/aqbanking/banking_cfg.c: 712: No config manager. Maybe the gwenhywfar plugins are not installed correctly? Error on online init (-1). Could not initialize KBanking online banking interface Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded No such XML file "/tmp/.mount_kmymon7P4wl9/usr/bin/../share/kxmlgui5/csvexporter/qifimporter.rc" Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: xmlstorage loaded Unknown view '' in slotOpenURL() Database apparently in use Opened by kmymoney@192.168.0.4 on 2018-10-27 at 12.21.47. Open anyway? Cost center model created with items 0 Payees model created with items 0 Received signal 11 SEGV_MAPERR 000000000008 #0 0x7ff4c434adce <unknown> #1 0x7ff4c2db5fc0 <unknown> #2 0x7ff4c434b2ee <unknown> #3 0x7ff4c9dcef20 <unknown> #4 0x7ff41693f456 <unknown> #5 0x7ff41693f573 <unknown> #6 0x7ff41693f641 <unknown> #7 0x7ff41693f6c5 <unknown> #8 0x7ff41693f75a <unknown> #9 0x7ff4168f2cc2 <unknown> #10 0x7ff4168f717c <unknown> #11 0x7ff48009273a <unknown> #12 0x7ff49c0cd530 QSqlDatabase::open() #13 0x7ff48e032d5b MyMoneyStorageSql::open() #14 0x7ff48e021745 SQLStorage::save() #15 0x000000465df5 KMyMoneyApp::slotFileSave() #16 0x7ff4cad58b4b QMetaObject::activate() #17 0x7ff4cc44aa02 QAction::triggered() #18 0x7ff4cc44cde0 QAction::activate() #19 0x7ff4cc53480d <unknown> #20 0x7ff4cc534a15 QAbstractButton::mouseReleaseEvent() #21 0x7ff4cc61469a QToolButton::mouseReleaseEvent() #22 0x7ff4cc48d8a8 QWidget::event() #23 0x7ff4cc61476c QToolButton::event() #24 0x7ff4cc450afc QApplicationPrivate::notify_helper() #25 0x7ff4cc458e50 QApplication::notify() #26 0x7ff4cad2c9c8 QCoreApplication::notifyInternal2() #27 0x7ff4cc4571cd QApplicationPrivate::sendMouseEvent() #28 0x7ff4cc4a6f4d <unknown> #29 0x7ff4cc4a97d3 <unknown> #30 0x7ff4cc450afc QApplicationPrivate::notify_helper() #31 0x7ff4cc457c66 QApplication::notify() #32 0x7ff4cad2c9c8 QCoreApplication::notifyInternal2() #33 0x7ff4cbe7c0b9 QGuiApplicationPrivate::processMouseEvent() #34 0x7ff4cbe7dda5 QGuiApplicationPrivate::processWindowSystemEvent() #35 0x7ff4cbe5a5cb QWindowSystemInterface::sendWindowSystemEvents() #36 0x7ff4b3545a7b <unknown> #37 0x7ff4cad2aeca QEventLoop::exec() #38 0x7ff4cad33a90 QCoreApplication::exec() #39 0x0000004505f5 runKMyMoney() #40 0x00000044f499 main #41 0x7ff4c9db1b97 __libc_start_main #42 0x0000004502a1 <unknown> r8: 000000000000000a r9: 0000000008013698 r10: 0000000008c4828b r11: 000000000000004e r12: 00007fff5dee5828 r13: 0000000008019b90 r14: 0000000000000020 r15: 0000000000000000 di: 0000000000000000 si: 0000000000000075 bp: 00007fff5dee5800 bx: 0000000000000000 dx: 0000000000000000 ax: 5f2d228e16c49d29 cx: 5f2d228e16c49d29 sp: 00007fff5dee57f0 ip: 00007ff41693f456 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.
Any update on this issue? I tried the same process as before using the latest code in branch 5.0 (01/04/2019 @ 08:30 MST Build version 5.0.2-6ae4b64a) Outcome below > a) create new file (and specify to write as a DB) It created the tables and populated a few tables and then crashed. ** kmmfileinfo has one row. version created lastModified baseCurrency institutions accounts payees tags transactions splits securities prices currencies schedules reports kvps dateRangeStart dateRangeEnd hiInstitutionId hiPayeeId hiTagId hiAccountId hiTransactionId hiScheduleId hiSecurityId hiReportId encryptData updateInProgress budgets hiBudgetId hiOnlineJobId hiPayeeIdentifierId logonUser logonAt fixLevel 12 2019-01-04 2019-01-04 USD 0 0 0 0 0 0 0 0 0 0 0 2 NULL NULL 1 1 1 1 1 1 1 1 NULL N 0 1 1 1 NULL NULL 4 ** kmmkeyvaluepairs has two rows kvpType kvpId kvpKey kvpData STORAGE kmm-baseCurrency USD STORAGE kmm-id {261431e2-9248-4080-acbf-a35fac414c67} stOut: Starting program: /usr/bin/kmymoney -n [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa7f700 (LWP 6740)] [New Thread 0x7fffd6cb0700 (LWP 6741)] [New Thread 0x7fffcfb68700 (LWP 6743)] [New Thread 0x7fffbf846700 (LWP 6744)] [New Thread 0x7fffbf045700 (LWP 6745)] [New Thread 0x7fffbe844700 (LWP 6746)] [New Thread 0x7fffbe043700 (LWP 6747)] WebConnect: Try to connect to WebConnect server WebConnect: Connect to server failed WebConnect: Running in server mode Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff63fff700 (LWP 6748)] org.kde.pim.kidentitymanagement: IdentityManager: There was no default identity. Marking first one as default. [New Thread 0x7fff5b2ed700 (LWP 6803)] '/usr/share/kmymoney/templates/dk' not scanned [New Thread 0x7fff5aaec700 (LWP 6810)] testing fileFixVersion 0 < 4 testing fileFixVersion 1 < 4 testing fileFixVersion 2 < 4 0 transactions fixed in fixFile_2 testing fileFixVersion 3 < 4 Cost center model created with items 0 Payees model created with items 0 QXcbConnection: XCB error: 3 (BadWindow), sequence: 4320, resource id: 46146712, major code: 40 (TranslateCoords), minor code: 0 [New Thread 0x7fff5a2eb700 (LWP 6813)] [New Thread 0x7fff59aea700 (LWP 6814)] [New Thread 0x7fff592e9700 (LWP 6815)] Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. BT: (gdb) bt #0 0x00007fffef36ffa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5834b26a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff58322ad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff582f6abb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff588df1b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa6fc1f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa721e87f in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x55555788fdf0, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa721a1c8 in SQLStorage::save(QUrl const&) (this=0x5555562789c0, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:198 #8 0x00007fffa721bdc1 in SQLStorage::saveAsDatabase(QUrl const&) (this=0x5555562789c0, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:354 #9 0x00007fffa721abfa in SQLStorage::saveAs() (this=0x5555562789c0) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:241 #10 0x000055555560e39e in KMyMoneyApp::slotFileSaveAs() (this=0x555555d18e60) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3554 #11 0x000055555560c8da in KMyMoneyApp::slotFileNew() (this=0x555555d18e60) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3390 #12 0x000055555562e4be in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560c362 <KMyMoneyApp::slotFileNew()>, o=0x555555d18e60, arg=0x7fffffffcc80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #13 0x000055555562e187 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560c362 <KMyMoneyApp::slotFileNew()>, o=0x555555d18e60, arg=0x7fffffffcc80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #14 0x000055555562d4ce in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555f5a600, r=0x555555d18e60, a=0x7fffffffcc80, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #15 0x00007ffff0c0f6cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #16 0x00007ffff2b8c122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2b8e80c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2d0b0bc in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2d1256b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2d13393 in QMenu::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2bd1038 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff2d156bb in QMenu::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #23 0x00007ffff2b9282c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff2b9a64f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #25 0x00007ffff0be09a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #26 0x00007ffff2b99622 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2bebe85 in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff2bee7ba in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #29 0x00007ffff2b9282c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #30 0x00007ffff2b9a0f4 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #31 0x00007ffff0be09a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #32 0x00007ffff23d6523 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 ---Type <return> to continue, or q <return> to quit--- #33 0x00007ffff23d7ff5 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #34 0x00007ffff23af2eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #35 0x00007fffd98b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 #36 0x00007fffe67f0387 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #37 0x00007fffe67f05c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #38 0x00007fffe67f064c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #39 0x00007ffff0c398ef in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #40 0x00007ffff0bde9ea in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #41 0x00007ffff0be7a84 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #42 0x00005555555f3377 in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=true) at /home/eagleboy/kmymoney/kmymoney/main.cpp:335 #43 0x00005555555f2a56 in main(int, char**) (argc=2, argv=0x7fffffffdd18) at /home/eagleboy/kmymoney/kmymoney/main.cpp:243 > b) use existing .kmy file and save it as DB It created the tables and populated a few tables and then crashed. ** kmmfileinfo has one row. version created lastModified baseCurrency institutions accounts payees tags transactions splits securities prices currencies schedules reports kvps dateRangeStart dateRangeEnd hiInstitutionId hiPayeeId hiTagId hiAccountId hiTransactionId hiScheduleId hiSecurityId hiReportId encryptData updateInProgress budgets hiBudgetId hiOnlineJobId hiPayeeIdentifierId logonUser logonAt fixLevel 12 2018-09-23 2019-01-04 USD 0 0 0 0 0 0 0 0 0 0 0 2 NULL NULL 1 1 1 1 1 1 1 1 NULL N 0 1 1 1 NULL NULL 4 ** kmmkeyvaluepairs has two rows kvpType kvpId kvpKey kvpData STORAGE kmm-baseCurrency USD STORAGE kmm-id {d734eeee-a2e0-4880-a218-74df12dafa68} std out: Starting program: /usr/bin/kmymoney -n [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa7f700 (LWP 7436)] [New Thread 0x7fffd6cb0700 (LWP 7437)] [New Thread 0x7fffcfb68700 (LWP 7438)] [New Thread 0x7fffbf846700 (LWP 7439)] [New Thread 0x7fffbf045700 (LWP 7440)] [New Thread 0x7fffbe844700 (LWP 7441)] [New Thread 0x7fffbe043700 (LWP 7442)] 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 Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff63fff700 (LWP 7444)] kf5.kio.core: KSambaShare: Could not find smb.conf! reading file start parsing file startDocument reading securities endDocument [New Thread 0x7fff5bfff700 (LWP 7449)] Cost center model created with items 0 Payees model created with items 0 Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. BT: #0 0x00007fffef36ffa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5b27426a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff5b24bad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff5b21fabb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff605f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa6fc1f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa721e87f in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x5555568e4480, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa721a1c8 in SQLStorage::save(QUrl const&) (this=0x55555626ba60, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:198 #8 0x00007fffa721bdc1 in SQLStorage::saveAsDatabase(QUrl const&) (this=0x55555626ba60, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:354 #9 0x00007fffa721abfa in SQLStorage::saveAs() (this=0x55555626ba60) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:241 #10 0x000055555560e39e in KMyMoneyApp::slotFileSaveAs() (this=0x555555e75430) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3554 #11 0x000055555562e4be in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560dff4 <KMyMoneyApp::slotFileSaveAs()>, o=0x555555e75430, arg=0x7fffffffcc80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #12 0x000055555562e187 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560dff4 <KMyMoneyApp::slotFileSaveAs()>, o=0x555555e75430, arg=0x7fffffffcc80) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #13 0x000055555562d4ce in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555d75e40, r=0x555555e75430, a=0x7fffffffcc80, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #14 0x00007ffff0c0f6cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #15 0x00007ffff2b8c122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #16 0x00007ffff2b8e80c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2d0b0bc in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2d1256b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2d13393 in QMenu::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2bd1038 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2d156bb in QMenu::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff2b9282c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #23 0x00007ffff2b9a64f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff0be09a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #25 0x00007ffff2b99622 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #26 0x00007ffff2bebe85 in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2bee7ba in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff2b9282c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #29 0x00007ffff2b9a0f4 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #30 0x00007ffff0be09a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #31 0x00007ffff23d6523 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 ---Type <return> to continue, or q <return> to quit--- #32 0x00007ffff23d7ff5 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #33 0x00007ffff23af2eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #34 0x00007fffd98b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 #35 0x00007fffe67f0387 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #36 0x00007fffe67f05c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #37 0x00007fffe67f064c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #38 0x00007ffff0c398ef in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #39 0x00007ffff0bde9ea in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #40 0x00007ffff0be7a84 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #41 0x00005555555f3377 in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=true) at /home/eagleboy/kmymoney/kmymoney/main.cpp:335 #42 0x00005555555f2a56 in main(int, char**) (argc=2, argv=0x7fffffffdd18) at /home/eagleboy/kmymoney/kmymoney/main.cpp:243 c) use an existing DB and save it I got prompted for a Consistency Issue I clicked on accept and it crashed Std Out: Starting program: /usr/bin/kmymoney -n [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1". [New Thread 0x7fffdaa7f700 (LWP 8489)] [New Thread 0x7fffd6cb0700 (LWP 8490)] [New Thread 0x7fffcfb68700 (LWP 8491)] [New Thread 0x7fffbf846700 (LWP 8492)] [New Thread 0x7fffb7045700 (LWP 8493)] [New Thread 0x7fffbf045700 (LWP 8494)] [New Thread 0x7fffbe844700 (LWP 8495)] 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 Plugins: budgetview loaded Plugins: checkprinting loaded Plugins: csvexporter loaded Plugins: csvimporter loaded Plugins: forecastview loaded Plugins: gncimporter loaded Plugins: icalendarexporter loaded Plugins: kbanking loaded KBankingPlugin: No AqB4 config found. KBankingPlugin: No AqB3 config found. Plugins: kbanking pluged Plugins: ofximporter loaded Plugins: onlinejoboutboxview loaded Plugins: qifexporter loaded Plugins: qifimporter loaded Plugins: reconciliation report loaded Plugins: reportsview loaded Plugins: sqlstorage loaded Plugins: weboob loaded Plugins: xmlstorage loaded libpng warning: iCCP: known incorrect sRGB profile libpng warning: iCCP: known incorrect sRGB profile [New Thread 0x7fff63fff700 (LWP 8496)] [New Thread 0x7fff5b9ed700 (LWP 8513)] Cost center model created with items 0 Payees model created with items 0 QXcbConnection: XCB error: 3 (BadWindow), sequence: 2255, resource id: 46163649, major code: 40 (TranslateCoords), minor code: 0 [New Thread 0x7fff5a13a700 (LWP 8792)] [Thread 0x7fff5a13a700 (LWP 8792) exited] [New Thread 0x7fff5a13a700 (LWP 8795)] [Thread 0x7fff5a13a700 (LWP 8795) exited] [New Thread 0x7fff5a13a700 (LWP 8796)] [New Thread 0x7fff5a13a700 (LWP 8797)] [Thread 0x7fff5a13a700 (LWP 8796) exited] [New Thread 0x7fff3b90b700 (LWP 8798)] [New Thread 0x7fff3aaab700 (LWP 8799)] [New Thread 0x7fff3a2aa700 (LWP 8800)] [New Thread 0x7fff3989b700 (LWP 8801)] [New Thread 0x7fff3909a700 (LWP 8802)] [New Thread 0x7fff38899700 (LWP 8803)] [New Thread 0x7fff23fff700 (LWP 8804)] [Thread 0x7fff5a13a700 (LWP 8797) exited] [Thread 0x7fff3909a700 (LWP 8802) exited] [Thread 0x7fff38899700 (LWP 8803) exited] [Thread 0x7fff3989b700 (LWP 8801) exited] [Thread 0x7fff3a2aa700 (LWP 8800) exited] [Thread 0x7fff3aaab700 (LWP 8799) exited] [Thread 0x7fff3b90b700 (LWP 8798) exited] Thread 1 "kmymoney" received signal SIGSEGV, Segmentation fault. __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 65 ../nptl/pthread_mutex_lock.c: No such file or directory. BT: #0 0x00007fffef36ffa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff5ba7526a in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff5ba4cad1 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff5ba20abb in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff605f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa6fc1f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa721e87f in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x55555c1d8e20, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa721a1c8 in SQLStorage::save(QUrl const&) (this=0x55555626e290, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:198 #8 0x000055555560ddd3 in KMyMoneyApp::slotFileSave() (this=0x555555d1a7c0) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3497 #9 0x000055555562e4be in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560dcb8 <KMyMoneyApp::slotFileSave()>, o=0x555555d1a7c0, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #10 0x000055555562e187 in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560dcb8 <KMyMoneyApp::slotFileSave()>, o=0x555555d1a7c0, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #11 0x000055555562d4ce in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555f1c2d0, r=0x555555d1a7c0, a=0x7fffffffcdc0, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #12 0x00007ffff0c0f6cf in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #13 0x00007ffff2b8c122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #14 0x00007ffff2b8e80c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #15 0x00007ffff2c8510b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #16 0x00007ffff2c8536d in QAbstractButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2d63fea in QToolButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2bd1038 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2d64084 in QToolButton::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2b9282c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2b9a64f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff0be09a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #23 0x00007ffff2b99622 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff2bec14b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #25 0x00007ffff2bee7ba in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #26 0x00007ffff2b9282c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2b9a0f4 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff0be09a8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #29 0x00007ffff23d6523 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #30 0x00007ffff23d7ff5 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #31 0x00007ffff23af2eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #32 0x00007fffd98b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 ---Type <return> to continue, or q <return> to quit--- #33 0x00007fffe67f0387 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #34 0x00007fffe67f05c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #35 0x00007fffe67f064c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #36 0x00007ffff0c398ef in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #37 0x00007ffff0bde9ea in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #38 0x00007ffff0be7a84 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #39 0x00005555555f3377 in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=true) at /home/eagleboy/kmymoney/kmymoney/main.cpp:335 #40 0x00005555555f2a56 in main(int, char**) (argc=2, argv=0x7fffffffdd18) at /home/eagleboy/kmymoney/kmymoney/main.cpp:243
This seems extremely weird. Looking at the following #6 0x00007fffa721e87f in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x5555568e4480, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa721a1c8 in SQLStorage::save(QUrl const&) (this=0x55555626ba60, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:198 #8 0x00007fffa721bdc1 in SQLStorage::saveAsDatabase(QUrl const&) (this=0x55555626ba60, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:354 #9 0x00007fffa721abfa in SQLStorage::saveAs() (this=0x55555626ba60) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:241 #10 0x000055555560e39e in KMyMoneyApp::slotFileSaveAs() (this=0x555555e75430) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3554 and at the involved code itself, one can see that apparently opening the database fails. What astonishes me is, that to get to that point, the DB was opened in SQLStorage::saveAsDatabase() w/o problems. If one compares the two affecting lines of code, we see in bool SQLStorage::saveAsDatabase(const QUrl &url) auto writer = new MyMoneyStorageSql(MyMoneyFile::instance()->storage(), url); auto canWrite = false; switch (writer->open(url, QIODevice::WriteOnly)) { and in SQLStorage::save() auto writer = new MyMoneyStorageSql(MyMoneyFile::instance()->storage(), url); writer->open(url, QIODevice::ReadWrite); We can assume, that url is the same as it is passed as a const ref. The second parameter is used to control the internals of MyMoneyStorageSql::writer() and do not have an influence on the call to QDatabase::open() which is identical in both cases. So the question is, why does it work the first time but not the second and why does this only happen in Eleazar's installation and not on other people's? One more difference I found here: my libmysqlclient.so is actually a symlink to libmariadb.so. My Qt-Version is 5.9.4 and my glibc version is 2.26 in case that plays a role. BTW, I tested this against a MySQL database at my provider (so I had a WAN connection in between). It would be cool if we can solve this mystery.
Any update on this issue? I tried the same process as before using the latest code in branch 5.0 (04/04/2019 @ 21:43 MDT Build version 5.0.3-a4a39821b) #0 0x00007fffef3dbfa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff604622da in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #2 0x00007fff60439b41 in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #3 0x00007fff6040db2b in mysql_real_connect () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 #4 0x00007fff609f61b9 in () at /usr/lib/x86_64-linux-gnu/qt5/plugins/sqldrivers/libqsqlmysql.so #5 0x00007fffa6168f50 in QSqlDatabase::open() () at /usr/lib/x86_64-linux-gnu/libQt5Sql.so.5 #6 0x00007fffa63c5dff in MyMoneyStorageSql::open(QUrl const&, int, bool) (this=0x555555de4b70, url=..., openMode=3, clear=false) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/mymoneystoragesql.cpp:114 #7 0x00007fffa63c1748 in SQLStorage::save(QUrl const&) (this=0x555556262cc0, url=...) at /home/eagleboy/kmymoney/kmymoney/plugins/sql/sqlstorage.cpp:198 #8 0x000055555560d2b3 in KMyMoneyApp::slotFileSave() (this=0x555555d68790) at /home/eagleboy/kmymoney/kmymoney/kmymoney.cpp:3411 #9 0x000055555562a21d in QtPrivate::FunctorCall<QtPrivate::IndexesList<>, QtPrivate::List<>, void, bool (KMyMoneyApp::*)()>::call(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560d198 <KMyMoneyApp::slotFileSave()>, o=0x555555d68790, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:136 #10 0x0000555555629f9d in QtPrivate::FunctionPointer<bool (KMyMoneyApp::*)()>::call<QtPrivate::List<>, void>(bool (KMyMoneyApp::*)(), KMyMoneyApp*, void**) (f=(bool (KMyMoneyApp::*)(KMyMoneyApp * const)) 0x55555560d198 <KMyMoneyApp::slotFileSave()>, o=0x555555d68790, arg=0x7fffffffcdc0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobjectdefs_impl.h:169 #11 0x00005555556295b8 in QtPrivate::QSlotObject<bool (KMyMoneyApp::*)(), QtPrivate::List<>, void>::impl(int, QtPrivate::QSlotObjectBase*, QObject*, void**, bool*) (which=1, this_=0x555555edef30, r=0x555555d68790, a=0x7fffffffcdc0, ret=0x0) at /usr/include/x86_64-linux-gnu/qt5/QtCore/qobject_impl.h:120 #12 0x00007ffff0c7b77f in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #13 0x00007ffff2bf8122 in QAction::triggered(bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #14 0x00007ffff2bfa80c in QAction::activate(QAction::ActionEvent) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #15 0x00007ffff2cf112b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #16 0x00007ffff2cf138d in QAbstractButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #17 0x00007ffff2dd001a in QToolButton::mouseReleaseEvent(QMouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #18 0x00007ffff2c3d048 in QWidget::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #19 0x00007ffff2dd00b4 in QToolButton::event(QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #20 0x00007ffff2bfe83c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #21 0x00007ffff2c0665f in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #22 0x00007ffff0c4c9e8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #23 0x00007ffff2c05632 in QApplicationPrivate::sendMouseEvent(QWidget*, QMouseEvent*, QWidget*, QWidget*, QWidget**, QPointer<QWidget>&, bool) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #24 0x00007ffff2c5816b in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #25 0x00007ffff2c5a7da in () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #26 0x00007ffff2bfe83c in QApplicationPrivate::notify_helper(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #27 0x00007ffff2c06104 in QApplication::notify(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Widgets.so.5 #28 0x00007ffff0c4c9e8 in QCoreApplication::notifyInternal2(QObject*, QEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #29 0x00007ffff2442583 in QGuiApplicationPrivate::processMouseEvent(QWindowSystemInterfacePrivate::MouseEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #30 0x00007ffff2444055 in QGuiApplicationPrivate::processWindowSystemEvent(QWindowSystemInterfacePrivate::WindowSystemEvent*) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #31 0x00007ffff241b2eb in QWindowSystemInterface::sendWindowSystemEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Gui.so.5 #32 0x00007fffd96b91c0 in () at /usr/lib/x86_64-linux-gnu/libQt5XcbQpa.so.5 ---Type <return> to continue, or q <return> to quit--- #33 0x00007fffe65ed387 in g_main_context_dispatch () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #34 0x00007fffe65ed5c0 in () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #35 0x00007fffe65ed64c in g_main_context_iteration () at /usr/lib/x86_64-linux-gnu/libglib-2.0.so.0 #36 0x00007ffff0ca599f in QEventDispatcherGlib::processEvents(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #37 0x00007ffff0c4aa1a in QEventLoop::exec(QFlags<QEventLoop::ProcessEventsFlag>) () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #38 0x00007ffff0c53ac4 in QCoreApplication::exec() () at /usr/lib/x86_64-linux-gnu/libQt5Core.so.5 #39 0x00005555555f3817 in runKMyMoney(QApplication&, std::unique_ptr<QSplashScreen, std::default_delete<QSplashScreen> >, QUrl const&, bool) (a=..., splash=std::unique_ptr<QSplashScreen> = {...}, file=..., noFile=true) at /home/eagleboy/kmymoney/kmymoney/main.cpp:335 #40 0x00005555555f2ef6 in main(int, char**) (argc=2, argv=0x7fffffffdd18) at /home/eagleboy/kmymoney/kmymoney/main.cpp:243
No, no update. This is something out of the scope of KMyMoney. It works for at least two more installations (and I bet there are more). I expect an upstream problem (maybe even only on your installation). Looking at the first frames of the BT we see #0 0x00007fffef3dbfa0 in __GI___pthread_mutex_lock (mutex=0x20) at ../nptl/pthread_mutex_lock.c:65 #1 0x00007fff604622da in () at /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20 and the code to that seems straight forward: int __pthread_mutex_lock (pthread_mutex_t *mutex) { unsigned int type = PTHREAD_MUTEX_TYPE_ELISION (mutex); with the assignment of type being the statement on line 65. A pointer of value 0x20 seems a bit odd and is causing the trouble. This pointer is not provided by KMyMoney, so nothing we can do about. Did you ever updated any of Qt, libmysql? Sorry, but this is out of reach for me. Do we have anyone else running on Kubuntu 18.04.1 with SQL backend?
I have the most up-to-date (per Kubuntu Repo) I am using 5.9.5-0ubuntu0
Bonjour, J'utilise KMyMoney-5.0.8-feb8f9e-x86_64.AppImage sous Linux Mint 19.3 Tricia avec MySQL Version 5.7.29-0ubuntu0.18.04.1 L'application fonctionne bien et je souhaiterais sauvegarder mon fichier sous MYSQL. 1- J'ai créé la base de données KMyMoney vide, j'ai donné les privilèges à l'utilisateur henry sur cette base Quand je fais enregistrer sous, je choisis SQL et je valide, ensuite je choisis MYSQL , base KMyMoney, utilisateur henry, serveur 127.0.0.1 et mot de passe et je valide Voila ce que j'obtiens : (L'opération conduit à la création des tables mais donne le message suivant) : Impossible d'enregistrer la base de données actuelle : Error in function void MyMoneyStorageSqlPrivate::writeCurrency(const MyMoneySecurity&, QSqlQuery&) : writing Currencies Driver = QMYSQL, Host = 127.0.0.1, User = henry, Database = KMyMoney Driver Error: Database Error No -1: Text: Error type 0 Executed: INSERT INTO kmmCurrencies (ISOcode, name, type, typeString, symbol1, symbol2, symbol3, symbolString, smallestCashFraction, smallestAccountFraction, pricePrecision) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?); Query error No 1366: Incorrect string value: '\xE2\x82\xA1 ' for column 'symbolString' at row 1 QMYSQL3: Impossible d'exécuter la requête Error type 2 /home/appimage/workspace/KMyMoney_Stable_Appimage_Build/kmymoney/kmymoney/plugins/sql/mymoneystoragesql_p.h:1471 2-Comme la base est créée j'essaie de l'ouvrir et j'obtiens le résultat suiant : Base de données apparemment en cours d'utilisation Ouvert par henry@127.0.0.1 sur 2020-04-20 à 10.57.42. Ouvrir quand même ? Je réponds oui et : Une fenêtre Devises s'ouvre : je fais ajouter, je sélectionne Euro et je clique sur Fermer : Erreur non interceptée. Merci de rapporter les détails aux développeurs: Unknown account id 'AStd::Asset' /home/appimage/workspace/KMyMoney_Stable_Appimage_Build/kmymoney/kmymoney/mymoney/storage/mymoneystoragemgr.cpp:142 Merci pour votre aide Cordialement Htitus
Quand j'essaie d'utiliser Postgresql, après avoir créé une base kmymoney: Je clique sur Outils/Générer le sql de la base de données: Je choisis QPSQL puis Base kmymoney, 127.0.0.1, postgres, mot de passe et j'obtiens : La création a échoué lors de l'exécution de la requête Exécuté : CREATE TABLE kmmAccounts (id varchar(32) NOT NULL, institutionId varchar(32), parentId varchar(32), lastReconciled timestamp, lastModified timestamp, openingDate date, accountNumber text, accountType varchar(16) NOT NULL, accountTypeString text, isStockAccount char(1), accountName text, description text, currencyId varchar(32), balance text, balanceFormatted text, transactionCount int8 check(transactionCount >= 0), PRIMARY KEY (id)); Erreur numéro 42601 : ERROR: syntax error at end of input LINE 1: EXECUTE ^ (42601) QPSQL: Impossible de créer la requête Aucune table n'est crée Merci pour votre aide Cordialement Htitus
Quand je sauvegarde le fichier SQL de création des tables et que je l'exécute, tout se passe normalement et les tables sont bien créées Htitus
quand j'essaie de sauvegarde sous une base PGSQL: Impossible d'enregistrer la base de données actuelle : Error in function void MyMoneyStorageSqlPrivate::deleteKeyValuePairs(const QString&, const QVariantList&) : deleting kvp for STORAGE Driver = QPSQL, Host = localhost, User = postgres, Database = kmymoney Driver Error: Database Error No -1: Text: Error type 0 Executed: DELETE FROM kmmKeyValuePairs WHERE kvpType = ? AND kvpId = ?; Query error No 42601: ERROR: syntax error at or near "(" LINE 1: EXECUTE ('STORAGE', '') ^ (42601) QPSQL: Impossible de créer la requête Error type 2 /home/appimage/workspace/KMyMoney_Stable_Appimage_Build/kmymoney/kmymoney/plugins/sql/mymoneystoragesql_p.h:1927 Htitus
J'ai installé le paquet : libqt5sql5-mysql A partir de cette installation, j'ai résussi à faire sauvegarder sous dans une base vierge. Au lancement de kmymoney il m'est demandé le mot de passe de la base, mais la fenêtre de lancement de l'application me masque la fenêtre de demande du mot de passe. Par contre si je fais enregistrer après une modif, ajout d'un compte par exemple, si je clique sur enregistrer, l'application plante! Htitus
Updated to the latest version of Kubuntu and tested again. Problem still present.
htitushg: I believe your problem with postgresql is different from this bug, and I am working on that one separately. If I find a solution, I will mention it here. Eleazar: Are you able to try saving to Postgresql instead of Mysql, or even switching between MySql and MariaDB? It might help narrow down where the problem is. (When you update, please change back to REPORTED. REOPENED would only be used if it had been CLOSED. Thanks)
Will try to install mariadb and postgressql and see if I can save
Still working on installing MariaDB and MySQL. Had to updated my FreeBSD server and I'm still trying to get it configured correctly to create the jails to run the sql servers.