I have now found a working libdbi version plus another bug

Christoph Holtermann c.holtermann at gmx.de
Sun Jan 30 09:52:08 EST 2011


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

[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>


More information about the gnucash-devel mailing list