GDA testing

Mark Johnson mrj001 at shaw.ca
Tue Jan 15 00:22:26 EST 2008


Phil Longstaff wrote:
> Mark Johnson wrote:
>   
>> Using:  SVN 16836 gda-dev2 branch.
>> Postgresql 8.2.6
>>
>> 1. start gnucash with --nofile option
>> 2. open read-only copy of existing xml file.
>>   
>>     
> I assume you mean this was with the "Open file" dialog.  Hmmm...  I'll 
> look at this (see below).
>   
Yes.
>> 3. At this point, the accounts window opens and NO accounts are 
>> displayed.  If I understand Phil's post correctly, I should have had 
>> accounts here, but with unreliable balance information.
>>   
>>     
> The fact that there were no accounts combined with #7 below seem to 
> indicate that it didn't load your existing xml file, but instead created 
> a new sqlite file.
>
> For clarifications, if you load from an xml file, the account balances 
> should be correct.  If you load from a db, the balances may be 0.00.
>   
It seems to have created both the SQLite file and the Postgresql db.  
Perhaps, this is related to the performance issue you had mentioned when 
saving.

I am also using the latest (unstable) version of libgda (3.1.2).

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


More information about the gnucash-devel mailing list