I have now found a working libdbi version plus another bug

[Geert Janssens]

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
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel