GDA testing

[Phil Longstaff]

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).
>   
>> 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.
>   
>> 4. I tried to save to a database using the File menu Database Connection 
>> option.
>> 5. I chose an existing connection (mergeant was happy with this 
>> connection, so I believe it was valid).  I had previously created an 
>> empty database in postgresql and a user to own it.  These were as 
>> specified and tested in the connection.
>> 6. At this point, tables were created.  No data were entered in to the 
>> tables.  Possibly this is connected with #3 above.
>> 7. I noticed that a file .gnucash/data/xxx.xac.db was created, where xxx 
>> was the name (not the actual:) of my xml file.  I had not select 
>> anything to cause it to use SQLite.  I did not investigate the contents 
>> of this file.  However, it was less than one tenth the size of the 
>> compressed xml file.  I do not believe that this file should have been 
>> created.
>>     

If you start gnucash with --debug --nofile, what does /tmp/gnucash.trace 
contain?  Look for a line with 'qof_session_load_backend' and please 
cut/paste 10 lines on either side of this.

Phil