GDA save missing records

Mark Johnson mrj001 at shaw.ca
Fri Feb 15 23:05:16 EST 2008


Configuration:
libgda 3.1.2
gnucash-gda SVN16943
PostgreSQL 8.2.6
MySql 5.0.51
Sqlite 3.3.7

Today, I deleted all the gnucash databases (Well, I just started a new 
file for SQLite:-).  I made three copies of my current gnucash XML data, 
and loaded them into three instances of gnucash SVN (running 
concurrently).  In one, I select File -> Save As and saved to a file 
with .db extension to get a SQLite file.  In another, I selected File -> 
Database Connection and saved to a MySql connection.  In the last, I 
selected File -> Database Connection and saved to a PostgreSQL 
connection.  (Then I walked away from the computer for about 5 hours,  
which is why I wanted them running concurrently.)

Here are excerpts from connecting to the various DBs with their 
respective clients:
sqlite> select count(*) from transactions;
3354
sqlite> select count(*) from splits;
11469
sqlite> select count(*) from accounts;
515
mysql> select count(*) from transactions;
+----------+
| count(*) |
+----------+
|     3662 |
+----------+
1 row in set (0.02 sec)

mysql> select count(*) from splits;
+----------+
| count(*) |
+----------+
|    11487 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from accounts;
+----------+
| count(*) |
+----------+
|      522 |
+----------+
1 row in set (0.00 sec)

And PostgreSQL:
gnucash_db=# select count(*) from transactions;
 count
-------
  3662
(1 row)

gnucash_db=# select count(*) from splits;
 count
-------
 11484
(1 row)

gnucash_db=# select count(*) from accounts;
 count
-------
   522
(1 row)

None of the instances of gnucash-gda informed me that they were creating 
scheduled transactions (and if one did, they all should have, anyway).  
Therefore, the number of splits, transactions, and accounts MUST be 
identical in all cases.

Anybody know of a quick and easy way to count these in my XML file so 
that I know what these numbers should actually be?

Next, I'm going to track down which are missing.  I'll be checking log 
files (not for SQLite of course) and comparing the DB contents to each 
other, but it would be ideal to be able to compare them to the "gold 
standard" XML source file.

This appears to be separate from the SERIAL problem of libgda's 
PostgreSQL provider as PostgreSQL has the highest number of splits.  
(Most complete?  Are there duplicates?)

Mark



More information about the gnucash-devel mailing list