GNOME Bugzilla – Bug 704506
Connection loss to mysql after resume from hibernation
Last modified: 2018-06-29 23:17:33 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.
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.
Reassign version to 2.4.x so that individual 2.4 versions can be retired.
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.