Bug 294046 - Kmymoney SQL Crashes Out of Hibernation
Summary: Kmymoney SQL Crashes Out of Hibernation
Status: RESOLVED FIXED
Alias: None
Product: kmymoney
Classification: Applications
Component: general (show other bugs)
Version: 4.5.3
Platform: Debian testing Linux
: NOR crash
Target Milestone: ---
Assignee: KMyMoney Devel Mailing List
URL:
Keywords:
: 297702 312587 (view as bug list)
Depends on:
Blocks:
 
Reported: 2012-02-14 06:12 UTC by michael papet
Modified: 2013-01-07 00:19 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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. ***