Replaying log files doesn't seem to restore entries

Wed Jan 23 14:29:20 EST 2008

On Wed, 23 Jan 2008, Derek Atkins wrote:

> andy thomas <andy at netstat-a.net> writes:
>
>> I left gnucash 1.8.9 running on a system for almost a year, with an
>> account open that had not been saved since January 2007 (my default - I
>> somehow thought it autosaved at regular intervals). During this period, 3
>> entries were made into this account and 3 log files exist, the most recent
>> being in November, 2007. After the system eventually went down owing to
>> disk failure last month, I restored the account and the log files from
>> backups to another system but on replaying the 3 log files in sequence
>> using 'File... Import... Replay GnuCash .log file', a lot of output
>> appears in the debug terminal but nothing is actually changed in any of
>> the accounts. On saving the account, it's exactly the same file length as
>> it was a year ago and diff reports no differences between this and the
>> original file from last January.
>
> What appears in the debug output?

Below is what I get if I try to replay a log file from March last year:

Debug: gnc_file_log_replay: gnc_file_log_replay(): Begin...

Debug: gnc_file_log_replay: Filename found: /home/netstat/accounts-test/2005-200
6/accounts3.20070326093422.log
Debug: gnc_file_log_replay: Opening selected file
Debug: process_trans_record: process_trans_record(): Begin...

Debug: process_trans_record: process_trans_record(): Record ended

Debug: process_trans_record: process_trans_record(): Begin...

Debug: interpret_split_record: interpret_split_record(): Start...
Debug: interpret_split_record: interpret_split_record(): End
Debug: dump_split_record: dump_split_record(): Start...
Debug: dump_split_record: Log action: LOG_COMMIT
Debug: dump_split_record: Transaction GUID: 08404d9dbae531d621673e62dbd8f6a9
Debug: dump_split_record: Split GUID: a01b97208f105ccd6c4dbe6f3889e1d8
Debug: dump_split_record: Log entry date: 2007-03-26 09:34:22.000000 +0100
Debug: dump_split_record: Date entered: 2007-03-26 09:34:22.000000 +0100
Debug: dump_split_record: Date posted: 2007-03-26 00:00:00.000000 +0100
Debug: dump_split_record: Split reconcile: n
Debug: dump_split_record: Record amount: 0/1
Debug: dump_split_record: Record value: 0/100
Debug: dump_split_record: Reconciled date: 1970-01-01 01:00:00.000000 +0100
Debug: process_trans_record: process_trans_record(): Playing back LOG_COMMIT
Debug: process_trans_record: process_trans_record(): Creating the new transactio
n
Debug: process_trans_record: process_trans_record(): Record ended

Debug: process_trans_record: process_trans_record(): Begin...

Debug: process_trans_record: process_trans_record(): Record ended

>> What am I doing wrong? Incidentally, the whole of the user home directory
>> was restored including the user's .gnucash folder. The other thing I have
>> noticed is that after the last of the 3 log files was replayed, they all
>> disappeared and were replaced by a new one with today's date.
>
> Well, you're using a VERY old release..  I mean, 2.0 was released
> two years ago!  Even 1.8.12 is more recent that what you've got.
> Version 1.8.9 was released over four years ago, so so it's quite
> possible this bug was fixed in the intervening time.

I'm only using 1.8.9 because it happened to be bundled with SuSE Linux 
9.3; it works and does what I want to do which is to maintain a small set 
of accounts. It wasn't a conscious decision on my part to use this old 
version - it was just "there" on a spare server so I decided to use it 
remotely from my desktop. I suppose if I was an accountant (which I most 
certainly am not), I'd probably be using the latest & greatest version!

>> This is not a disaster as the number of transactions involved is small and
>> there is other paperwork, accounting reports and text notes from which it
>> can be re-entered. But with the UK self assessment tax deadline just over
>> a week away, it's something I'd rather not waste time on.
>
> Save Early, Save Often.

Very true.

> PS: Autosave is in 2.2

I'll install this when I can - I'm currently running 1.8.9 under SuSE 9.3 
on a laptop to complete these accounts.

Andy