After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 704506 - Connection loss to mysql after resume from hibernation
Connection loss to mysql after resume from hibernation
Status: RESOLVED FIXED
Product: GnuCash
Classification: Other
Component: Backend - SQL
2.4.x
Other Windows
: Normal normal
: ---
Assigned To: gnucash-core-maint
gnucash-core-maint
Depends on:
Blocks:
 
 
Reported: 2013-07-18 21:56 UTC by yenidai
Modified: 2018-06-29 23:17 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description yenidai 2013-07-18 21:56:47 UTC 
I open Gnucash in Windows with a Mysql as a backend database. Then I hibernate system (with MySQL and GnuCash)
After resume a system from hibernation, a GnuCash  shows a window and asks for a password for MySQL database.

I think, MySQL needs more time to return from hibernation, Gnucash thinks in this situation, that the database password is incorrect.


I wish that in this situation, Gnucash retry connection after a few seconds.
Comment 1 John Ralls 2013-11-28 03:46:52 UTC 
Gnucash already retries 5 times, but that would happen in a pretty tight loop, so I've added to trunk a 2^n backoff in milliseconds. The first retry will wait 2 ms, the second 4, the third 8, etc. r23452.

I don't know that that will necessarily fix the problem, though: It's possible that MySQL is logging out all sessions when it hibernates, in which case I don't think there's anything GnuCash can do about keeping the connection open. You can see if there's an administrative way to get around it or you could use the SQLite3 backend, which doesn't use a server and therefore won't have any synchronization issues.

Closing the bug because I don't think that there's anything else that we can do here.
Comment 2 John Ralls 2017-09-24 22:46:11 UTC 
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
Comment 3 John Ralls 2018-06-29 23:17:33 UTC 
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=704506. Please update any external references or bookmarks.