GDA testing

[Phil Longstaff]

Mark Johnson wrote:
> I have upgraded gnucash to svn 16866, gda-dev2 branch.  I remade a 
> blank db for gnucash in Postgesql and removed the sqlite .db file that 
> had been created before.
>
> As before, I started gnucash with the --nofile option.
>
> Simply opening my old xml file has recreated the sqlite .db file in 
> ~/.gnucash/data.
>
> No accounts are displayed.  There is an accounts tab open, but it is 
> empty.  In 2.2.3, this would be displaying my accounts.
>
> No progress feedback is displayed in the status bar while opening the 
> xml file.  There was no feedback before; I had neglected to mention this.
>
> Note: today, I have not tried to save with the GDA backend.  I'm just 
> loading my old XML datafile.
>
> This is the content of the gnucash.trace file:
> * 22:54:50  CRIT <Gtk> gtk_file_system_unix_get_info: assertion 
> `g_path_is_absolute (filename)' failed
> * 22:55:16  WARN <Gtk> file_system_unix=0x80e48e0 still has 
> handle=0x8431868 at finalization which is NOT CANCELLED!
>
>
> I re-did the above and started gnucash as:
> $ gnucash --debug --nofile
>
> Here is an excerpt (including the qof_session_load_backend) from the 
> resulting gnucash.trace:
> * 23:11:30  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x84856e0 XAG into nsp=0x84567c0 CURRENCY
> * 23:11:30  INFO <gnc.backend> [gnc_gda_check_sqlite_file] No '.db', 
> doesn't exist (errno=2) -> GDA
> * 23:11:30  INFO <qof.session> [qof_session_load_backend]  selected 
> GnuCash LibGDA Backend
> * 23:11:50  INFO <qof.session> [qof_session_begin] Done running 
> session_begin on backend
> * 23:11:50  INFO <gnc.gui> [gnc_post_file_open] 
> logpath=/mnt/raid/home/mj/.gnucash/data/books_copy_2008-01-14.xac
> * 23:11:50  INFO <gnc.account> [xaccAccountRecomputeBalance] acct= 
> starting baln=0/1
> * 23:11:50  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
> 0x847eb10 AFA into nsp=0x8543f20 CURRENCY
>
>

errno=2 is ENOENT which indicates file or directory not found.

> To test if this is simply a problem with the display of the accounts 
> tab, I tried a cash flow report.  Its options dialog (accounts tab) 
> also showed an empty display of accounts.
>
> To summarize, I am experiencing two problems:
> 1. Reading an xml file automatically creates a sqlite file.  If I 
> wanted to use the xml backend, this file should not be created.
> 2. Reading an xml file fails to read (create in memory? / display) any 
> accounts.
except it's not finding your xml file.  Therefore, it's creating a blank 
sqlite file with no accounts.  They are both from the same basic problem.

When you normally start gnucash, do you start with --nofile and open 
it?  Can you run another version of gnucash and open this file?  What is 
/mnt/raid?  g_fopen() is not finding whatever file you are trying to 
load, and I'm trying to figure out why.  Can you run gnucash-gda and 
replace --nofile with the actual file, or with xml://<filename>?

Phil