On Sunday 30 January 2011, Christoph Holtermann wrote: > Hello ! > > 1) I made my suggestion for change of conn_test_dbi_library() a patch [1]. > I have now switched back to libdbi rpms from OpenSuSe which seem to work > fine for me now. > > 2) After being able to use GnuCash with my SQL-Data again. I went back to > where it all started for me which was a data loss in invoices[2]. This > /still/ happened. I found another problem and have attached a patch which > fixes it for me [3]. > > The problem is: > > I saw in the logfile : > > * 12:54:17 DEBUG <gnc.backend.dbi> [conn_execute_select_statement] > SQL: SELECT * FROM entries ... > * 12:54:17 WARN <gnc.backend.sql> [load_invoice_guid()] Invoice > ref 'da696198453447bf281addbda5aaecdb' not found > > These WARNs appeared several times. > > The data loss was actually that when i tried to restore an invoice it all > entries missing. Here it seemed to me that maybe the entries couldn't be > loaded correctly because the invoices couldn't be accessed. Manually > looking at the Mysql database i found the entries in a correct way. > > Because the data from the MySql database is loaded into memory at the > startup and accessed there, i guessed that they were not found because > they hadn't been loaded. I found that forcing the invoices to be loaded > before the entries fixes the problem. I get no WARNs anymore and i can > access the entries in the gui. > > This was actually the only data loss that had occured to me and i think > that the bugreport [2] i posted is misclassified as a duplicate of the > fastmath bug. > > It may even be that i never had a problem with that fastmath-bug but only > suffered from the protection against it ;-) > > regards, > > Christoph Holtermann > Christoph, thanks for your research and patch. It does seem to fix the problem for me as well. I have applied a slightly modified version of it, to align better with the existing code logic.
Geert > [1] Patch for locale-bug: > https://bugzilla.gnome.org/attachment.cgi?id=179633&action=diff > <https://bugzilla.gnome.org/attachment.cgi?id=179633&action=diff> [2] My > original bugreport: https://bugzilla.gnome.org/show_bug.cgi?id=640061 [3] > Patch for missing invoice-entries: > https://bugzilla.gnome.org/attachment.cgi?id=179632&action=diff > <https://bugzilla.gnome.org/attachment.cgi?id=179632&action=diff> > _______________________________________________ > gnucash-devel mailing list > [email protected] > https://lists.gnucash.org/mailman/listinfo/gnucash-devel _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
