MySQL timeout and no attempt reconnect.

[Phil Longstaff]

Gnucash might have attempted to reconnect if I had been aware of this.  Please log a bug in bugzilla.

 Phil
---------
I used to be a hypochondriac AND a kleptomaniac. So I took something for it.




________________________________
From: Mike Evans <mikee at saxicola.idps.co.uk>
To: gnucash-devel at gnucash.org
Sent: Mon, January 25, 2010 8:36:21 AM
Subject: MySQL timeout and no attempt reconnect.

Gnucash SVN r18580 on Fedora 11.

If I leave Gnucash open and I'm using MySQL dbi the connection eventually 
times out, 8 hours is default for MySQL I think.  If I make any changes to an 
account I get a message box "Unable to save to database" (twice).  I would 
have thought that the Gnucash should attempt a reconnect rather than give up 
and warn the user.  Confusingly though the account change is shown in the 
account which may lead to people thinking that the change has been recorded 
when in fact it hasn't.   Of course on closing, Gnucash again warns that it 
was unable to save to database.  On re-starting Gnucash the new or changed 
entry is, of course, missing.

Last entries in gnucash.trace...

* 00:26:04 DEBUG <gnc.backend.dbi> [conn_commit_transaction] COMMIT
* 00:26:04 DEBUG <gnc.backend.dbi> [enter gnc-backend-
dbi.c:gnc_dbi_session_end()]
* 00:26:04 DEBUG <gnc.backend.dbi> [leave gnc_dbi_session_end()]

As you can see session end occurred in the night when Gnucash was not being 
used.  Nothing was logged on attempting to change and account. 


-- 
GPG Key: 1024D/050895C2
Keyserver: http://pgp.mit.edu/          
Search String: 0x050895C2
_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel