Bug 294046

Summary:	Kmymoney SQL Crashes Out of Hibernation
Product:	[Applications] kmymoney	Reporter:	michael papet <mpapet>
Component:	general	Assignee:	KMyMoney Devel Mailing List <kmymoney-devel>
Status:	RESOLVED FIXED
Severity:	crash	CC:	farkmischer
Priority:	NOR
Version:	4.5.3
Target Milestone:	---
Platform:	Debian testing
OS:	Linux
Latest Commit:		Version Fixed In:

Description michael papet 2012-02-14 06:12:26 UTC

Application: kmymoney (4.5.3)
KDE Platform Version: 4.6.5 (4.6.5)
Qt Version: 4.7.3
Operating System: Linux 2.6.39-2-686-pae i686
Distribution: Debian GNU/Linux testing (wheezy)

-- Information about the crash:
- What I was doing when the application crashed:

I'm using Kmymoney in SQL mode.  The MySQL server is on the LAN, but a different machine.   

It seems to me the connection to the remote SQL database goes down when the network connectivity shuts off in sleep mode.  When the laptop is brought out of  sleep, kmymoney isn't currently capable of re-initializing the dropped connection to the mysql server.

Keep up the great work!

This is what popped up after bringing the laptop out of sleep mode. 
Error in function void MyMoneyStorageSql::close(bool) : starting commit unit Driver = QMYSQL, Host = 192.168.15.33, User = mythtv, Database = kmymoney Driver Error: QMYSQL: Unable to begin transaction Database Error No 2013: Lost connection to MySQL server during query Text: Lost connection to MySQL server during query QMYSQL: Unable to begin transaction Error type 2 Executed: Query error No -1: Driver not loaded Driver not loaded Error type 1 void MyMoneyStorageSql::close(bool) in file /build/buildd-kmymoney_4.5.3-2-i386-37gWtq/kmymoney-4.5.3/kmymoney/mymoney/storage/mymoneystoragesql.cpp line 870

-- Backtrace:
Application: KMyMoney (kmymoney), signal: Aborted
[KCrash Handler]
#7  0xb7762424 in __kernel_vsyscall ()
#8  0xb51ec8f1 in raise () from /lib/i386-linux-gnu/i686/cmov/libc.so.6
#9  0xb51efd22 in abort () from /lib/i386-linux-gnu/i686/cmov/libc.so.6
#10 0xb541045d in __gnu_cxx::__verbose_terminate_handler() () from /usr/lib/i386-linux-gnu/libstdc++.so.6
#11 0xb540e1f3 in ?? () from /usr/lib/i386-linux-gnu/libstdc++.so.6
#12 0xb540e22f in std::terminate() () from /usr/lib/i386-linux-gnu/libstdc++.so.6
#13 0xb540e37e in __cxa_throw () from /usr/lib/i386-linux-gnu/libstdc++.so.6
#14 0x0808cac6 in main (argc=1, argv=0xbfefcc34) at /build/buildd-kmymoney_4.5.3-2-i386-37gWtq/kmymoney-4.5.3/kmymoney/main.cpp:266

Possible duplicates by query: bug 294040, bug 294039, bug 294033, bug 294024, bug 294023.

Reported using DrKonqi

Comment 1 Fernando Vilas 2012-03-03 16:03:25 UTC

Git commit 4da92dfa03209670bddb7801926a25741c0ad6ec by Fernando Vilas.
Committed on 03/03/2012 at 16:58.
Pushed by fvilas into branch 'master'.
Related: bug 286503

Attempt to reconnect to the database (once) on accidental disconnects. If this still throws, we need to notify the user and reset the UI to the same state as "kmymoney -n".

Add a test case to reproduce the problem in the storage layer.

M  +53   -9    kmymoney/mymoney/storage/mymoneydatabasemgr.cpp
M  +16   -0    kmymoney/mymoney/storage/mymoneydatabasemgrtest.cpp
M  +1    -0    kmymoney/mymoney/storage/mymoneydatabasemgrtest.h

http://commits.kde.org/kmymoney/4da92dfa03209670bddb7801926a25741c0ad6ec

Comment 2 Fernando Vilas 2012-03-03 16:14:18 UTC

Git commit bbc4a66601127374787457fbf9a38fa43ac094d5 by Fernando Vilas.
Committed on 03/03/2012 at 16:58.
Pushed by fvilas into branch '4.6'.
Related: bug 286503

Attempt to reconnect to the database (once) on accidental disconnects. If this still throws, we need to notify the user and reset the UI to the same state as "kmymoney -n".

Add a test case to reproduce the problem in the storage layer.
(cherry picked from commit 4da92dfa03209670bddb7801926a25741c0ad6ec)

M  +53   -9    kmymoney/mymoney/storage/mymoneydatabasemgr.cpp
M  +16   -0    kmymoney/mymoney/storage/mymoneydatabasemgrtest.cpp
M  +1    -0    kmymoney/mymoney/storage/mymoneydatabasemgrtest.h

http://commits.kde.org/kmymoney/bbc4a66601127374787457fbf9a38fa43ac094d5

Comment 3 Alvaro Soliverez 2012-04-28 23:06:25 UTC

*** Bug 297702 has been marked as a duplicate of this bug. ***

Comment 4 Fernando Vilas 2013-01-07 00:19:27 UTC

*** Bug 312587 has been marked as a duplicate of this bug. ***