GDA testing

Mark Johnson mrj001 at shaw.ca
Tue Jan 15 02:06:15 EST 2008 

Mark Johnson wrote:
> In response to your latest e-mail, here is the excerpt from 
> /tmp/gnucash.trace:
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8452c70 VND into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8452d88 YER into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8452d28 YUM into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8451b20 ZMK into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8451be0 ZWD into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8451b58 XDR into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x844e620 XXX into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8451d78 XAU into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8451e90 XPD into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8451e40 XPT into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8451f48 XAG into nsp=0x8260fa0 CURRENCY
> * 22:17:29  INFO <qof.session> [qof_session_load_backend]  selected 
> GnuCash LibGDA Backend
> * 22:17:50  INFO <qof.session> [qof_session_begin] Done running 
> session_begin on backend
> * 22:17:50  INFO <gnc.gui> [gnc_post_file_open] 
> logpath=/mnt/raid/home/mj/.gnucash/data/books_copy_2008-01-14.xac
> * 22:17:50  INFO <gnc.account> [xaccAccountRecomputeBalance] acct= 
> starting baln=0/1
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x845d2d0 AFA into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8458468 AFN into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x84561e8 ALL into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x844d028 DZD into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x845b160 ADF into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x84460b0 ADP into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x843f490 AON into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x845b3e8 ARA into nsp=0x8649440 CURRENCY
> * 22:17:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x8444098 ARS into nsp=0x8649440 CURRENCY
>
> The qof_session_load_backend did not appear in the file until after I 
> tried to open the xml file (using File->Open).  The lines before and 
> after this excerpt seem to be much more of the same - loading commodities.
>
> Mark
>
>   
Apologies for replying to myself.  Why does the above say 
"selectedGnuCash LibGDA Backend" when I simply loaded an xml file?

It occurred to me that saving to the GDA backend might produce another 
call to qof_session_load_backend.  Since I am not sure which one would 
be of interest, I ran it again.  This time, there was a second call to 
qof_session_load_backend.  Here is the context of the second call from 
the second run (presumably when I selected File ->@gnucashpgsql82x to 
save to GDA).  (The Postgresql database was freshly created without 
tables prior to the run.)
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x85b70c0 YUM into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x85bd640 ZMK into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x84a5ec8 ZWD into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x85687d0 XDR into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8442600 XXX into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x845e3d0 XAU into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x846aee8 XPD into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8473458 XPT into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8562d18 XAG into nsp=0x85a4320 CURRENCY
* 23:49:39  INFO <qof.session> [qof_session_load_backend]  selected 
GnuCash LibGDA Backend
* 23:49:53  INFO <qof.session> [qof_session_begin] Done running 
session_begin on backend
* 23:49:53  INFO <gnc.gui> [gnc_post_file_open] 
logpath=/mnt/raid/home/mj/.gnucash/data/gda:,, at gnucashpgsql82x
* 23:49:53  INFO <gnc.account> [xaccAccountRecomputeBalance] acct= 
starting baln=0/1
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8464680 AFA into nsp=0x86fde40 CURRENCY
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x854c538 AFN into nsp=0x86fde40 CURRENCY
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x848a758 ALL into nsp=0x86fde40 CURRENCY
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x854c0e8 DZD into nsp=0x86fde40 CURRENCY
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x855e270 ADF into nsp=0x86fde40 CURRENCY
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x84f3f00 ADP into nsp=0x86fde40 CURRENCY
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8569298 AON into nsp=0x86fde40 CURRENCY
* 23:49:53  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x84a86e8 ARA into nsp=0x86fde40 CURRENCY


Again, tables were created in the Postgresql db, but no data were 
saved.  I checked the accounts table, and it had zero rows.

Here's something else I noticed:
1. One still gets the modal dialog asking about auto-saving the data 
every few minutes.  I expect that the GDA backend saves the data as it 
is entered, and that this dialog should not appear.
2. This modal dialog appeared beneath other windows including the 
gnucash main window.  That made me think, for a moment, that gnucash had 
locked up.  A quick alt-tab through the windows revealed the modal dialog.

Mark

More information about the gnucash-devel mailing list