gnucash doesn't load data file

Family fastsnip-family1 at yahoo.com
Sun Dec 30 15:37:15 EST 2007


Josh Sled wrote:
> Family <fastsnip-family1 at yahoo.com> writes:
>   
>> Have used gnucash for many years - even donated the loan s/w to the effort.
>>
>>
>> Computer died unexpectedly on Wed last. I had made a habit of saving all 
>> financial information to 2 separate USB drives and so thought I was home 
>> free. 2 separate copies of all information!!!
>>
>> It would appear that I was terribly wrong.
>>
>> I had been using FC 5
>>
>> The new computer is using Kubuntu 7.10 with  gnucash 2.2.x (not sure of 
>> last digit.) - do not know previous version of gnucash - whatever is 
>> current under FC 5 I think.
>>
>> Copied all of the financial directories from a USB drive to the new hard 
>> drive. Set up the home directory for gnucash and booted gnucash.
>>
>> Went through the business of creating a new account, then canceled that 
>> and instructed to open an existing account file. Everything was okay 
>> until I attempted to open the old data file.
>>
>> Nothing happens.
>>
>> gnucash just hangs.
>>
>> Thought maybe it was taking a Looooooong time to read the file.
>>
>> Let it run for about 10 minutes - no change. The gnucash window is just 
>> vacant and the running icon just goes like the energizer bunny - never 
>> stops. Finally clicked the  terminate symbol in the upper right corner - 
>> nothing. gnucash is truly hung. Finally KDE informs me that gnucash is 
>> not rtesponding and lets me terminate.
>>
>> Repeated the above sereval times, even after refreshing the data file 
>> from the USB drive each time and deleteing the lock file, etc.
>>
>> I have several years of data locked up in that old data file, including 
>> the current financial status.
>>
>> Is it truly lost?
>>
>> Do I really have to start from scratch and count the old information as 
>> lost?
>>
>> That will lose a lot of information that cannot be regained.
>>
>> Tell me that the gnucash devlopers have a solution - please.
>>
>> Thanks for any help.
>>     
>
> What are the datafile(s) that you copied?
>   

The guncash bzipped data file for the account. The account was named 
originally Accounts-QT, the data file name is just that:

Accounts-QT

There are 2 additional files:
Accounts-QT.20071212193010.xac
Accounts-QT.20071212192713.log


> Do you recall what the files/directories they were originally?
>   

The directory structure was copied directly to the USB drives and then 
copied back from there to the new hard drive. The directory was created 
originally by simply dragging and dropping. Then copied from the USB 
drive to the new hard drive in the same manner.
> What's the path/name of the datafile you're opening?
>   

/home/terry/Financial/Accounts-QT

exactly the same as on the original hard drive. All updated with the 'cp 
-u' command.
>
> If you run gnucash from a terminal like such:
>
>     $ gnucash --debug --logto stderr
>
> What – if anything – is printed when you open the old datafile and it hangs?
>   

The following line was always output to stdout (the display):

gnc.bin-Message: main: binreloc relocation support was disabled at 
configure time.

remaining output too voluminous to copy all here. Changed command line 
slightly to:

gnucash --debug --logto debug

here is the file with many, many similar lines deleted. If the deleted 
lines are important and pertinent, I can post those also:

* 15:05:29  INFO <gnc.engine> [gnc_hook_lookup] no hook lists
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 512 bytes 
from /dev/urandom
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 1366 bytes 
from /etc/passwd
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 26 bytes 
from /proc/loadavg
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 728 bytes 
from /proc/meminfo
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 694 bytes 
from /proc/net/dev
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 1929 bytes 
from /proc/self/environ
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 199 bytes 
from /proc/self/stat
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 739 bytes 
from /proc/stat
* 15:05:29  INFO <qof.engine> [init_from_file] guid_init got 14 bytes 
from /proc/uptime
* 15:05:29  INFO <qof.engine> [guid_init] got 21427 bytes
* 15:05:34 MESSG <gnc.bin> loading system configuration
* 15:05:34 MESSG <gnc.bin> loading user configuration
* 15:05:34 MESSG <gnc.bin> loading auto configuration
* 15:05:34 MESSG <gnc.bin> loading saved reports
* 15:05:34 MESSG <gnc.bin> loading stylesheets
* 15:05:34 MESSG <gnc.scm> Found Finance::Quote version 1.13
* 15:05:44  INFO <gnc.account> [xaccAccountRecomputeBalance] acct= 
starting baln=0/1
* 15:05:44  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8626e68 AFA into nsp=0x863a500 CURRENCY
.
.
.
deleted many, many similar lines --- lines 20 to 209 in file
.
.
.
* 15:05:44  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x86676e0 XAG into nsp=0x863a500 CURRENCY
* 15:05:44  INFO <qof.engine> [qof_event_generate_internal] id=3 
hi=0x85a2730 han=0xb737422f data=(nil)
* 15:05:44  INFO <qof.engine> [qof_event_generate_internal] id=2 
hi=0x840ce78 han=0xb724ef4d data=(nil)
* 15:05:44  INFO <qof.engine> [qof_event_generate_internal] id=1 
hi=0x820c8b8 han=0xb72def22 data=(nil)
* 15:05:44  INFO <gnc.account> [xaccAccountCommitEdit] freeing splits 
for account 0x864f800 ()
* 15:05:44  INFO <gnc.account> [xaccAccountRecomputeBalance] acct= 
starting baln=0/1
* 15:05:44  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8656f50 AFA into nsp=0x863d3a0 CURRENCY
.
.
.
deleted many, many similar lines --- lines 217 to 406 in file
.
.
.
* 15:05:44  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x864efb0 XAG into nsp=0x863d3a0 CURRENCY
* 15:05:44  INFO <qof.session> [qof_session_load_backend]  selected 
GnuCash File Backend Version 2
* 15:05:44  INFO <qof.session> [qof_session_begin] Done running 
session_begin on backend
* 15:05:44  INFO <gnc.gui> [gnc_post_file_open] 
logpath=/home/terry/financial/Accounts-QT
* 15:05:44  INFO <gnc.account> [xaccAccountRecomputeBalance] acct= 
starting baln=0/1
* 15:05:44  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x8656f50 AFA into nsp=0x865ec00 CURRENCY
.
.
.
deleted many, many similar lines --- lines 413 to 602 in file
.
.
.
* 15:05:44  INFO <gnc.commodity> [gnc_commodity_table_insert] insert 
0x864efb0 XAG into nsp=0x865ec00 CURRENCY
* 15:05:44  INFO <qof.session> [qof_session_load] new book=0x865d310
* 15:05:44  INFO <qof.engine> [qof_event_generate_internal] id=3 
hi=0x85a2730 han=0xb737422f data=(nil)
* 15:05:44  INFO <qof.engine> [qof_event_generate_internal] id=2 
hi=0x840ce78 han=0xb724ef4d data=(nil)
* 15:05:44  INFO <qof.engine> [qof_event_generate_internal] id=1 
hi=0x820c8b8 han=0xb72def22 data=(nil)
* 15:05:44  INFO <gnc.account> [xaccAccountCommitEdit] freeing splits 
for account 0x864f8f8 ()


and that is all of the output either to stderr or the redirected debug file.


Can you tell what the problem is from that??????

I sincerely hope so and that problem can be fixed !!!

Thanks,
Terry

>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>   


-- 
++++++++++++++++++++++++++++++++++++++++++++++++++++++
======================================================
******************************************************
If you are always rushing towards the future,
Then you never have any past.

Terry Boldt
******************************************************
Paraphrasing Ben Franklin:

Those who sacrifice freedom for safety, have neither.

The exact quote:

They that can give up essential liberty to obtain a little
temporary safety deserve neither liberty nor safety.
  Benjamin Franklin (1706 - 1790),
  US author, diplomat, inventor, physicist, politician, & printer
  Historical Review of Pennsylvania, 1759

******************************************************



More information about the gnucash-devel mailing list