Gnucash crashes when loading user data from mysql

[John Ralls]

On Apr 25, 2012, at 9:09 AM, smartinez wrote:

> Hi John,
> 
> I can give more light to the issue. I've created again the SX using the
> mortgage wizard, after creation I've closed Gnucash and open it again, and
> again, it crashes. So, I can confirm that the new SX is causing this crash.
> In this version though the decimal separator in the Mortgage Wizard appears
> to be ',', so I didn't changed the formulas since the separators were
> already ','.
> 
> The log is exactly the same:
> 18:07:12  INFO <gnc.account> [xaccAccountRecomputeBalance] acct=IRPF
> starting baln=0/1
> * 18:07:12  INFO <gnc.account> [xaccAccountRecomputeBalance] acct=La Caixa
> starting baln=0/1
> * 18:07:14  WARN <gnc.backend.sql> No recurrences found
> * 18:07:14  WARN <gnc.backend.sql> No recurrences found
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=914ec5d6cf7703b565cb56b93ec23f22 starting baln=0/1
> * 18:07:26  INFO <gnc.account> [xaccAccountCommitEdit] freeing splits for
> account 099723A0 (914ec5d6cf7703b565cb56b93ec23f22)
> * 18:07:26  INFO <gnc.engine> [xaccTransSetDateInternal] addr=0397BCC0 set
> date to 1284317843.000000000 Sun Sep 12 20:57:23 2010
> * 18:07:26  INFO <gnc.engine> [xaccTransSetDateInternal] addr=0397BCC0 set
> date to 1284317843.000000000 Sun Sep 12 20:57:23 2010
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=0a3a12eb4a134162de99b9b87c2d758a starting baln=0/1
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=0a3a12eb4a134162de99b9b87c2d758a starting baln=0/1
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=0a3a12eb4a134162de99b9b87c2d758a starting baln=0/1
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=0a3a12eb4a134162de99b9b87c2d758a starting baln=0/1
> * 18:07:26  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
> trans=0397BD58
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=254fee65fdc38168ab1221b4f6c20551 starting baln=0/1
> * 18:07:26  INFO <gnc.account> [xaccAccountCommitEdit] freeing splits for
> account 099723A0 (254fee65fdc38168ab1221b4f6c20551)
> * 18:07:26  INFO <gnc.engine> [xaccTransSetDateInternal] addr=0397BD58 set
> date to 1286391404.000000000 Wed Oct 06 20:56:44 2010
> * 18:07:26  INFO <gnc.engine> [xaccTransSetDateInternal] addr=0397BD58 set
> date to 1286391404.000000000 Wed Oct 06 20:56:44 2010
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=65c13cc57240172fb10e94c838faca6d starting baln=0/1
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=65c13cc57240172fb10e94c838faca6d starting baln=0/1
> * 18:07:26  INFO <gnc.engine> [trans_cleanup_commit] get rid of rollback
> trans=0397BB90
> * 18:07:26  INFO <gnc.account> [xaccAccountRecomputeBalance]
> acct=4ff48c157d8b56cdf7e134de3c7a97e3 starting baln=0/1
> * 18:07:26  CRIT <GLib> g_date_new_dmy: assertion `g_date_valid_dmy (day, m,
> y)' failed
> * 18:07:26  CRIT <GLib> g_date_valid: assertion `d != NULL' failed
> 
> Any idea, should we open a bug?
> 

Yes, please open a bug. If you can create a small test file that demonstrates the problem it would help a lot, especially if it works with the XML backend and crashes with SQL.

Regards,
John Ralls