[GNC] Crash - advice please!

[Michael Hendry]

> On 24 Nov 2018, at 23:31, John Ralls <jralls at ceridwen.fremont.ca.us> wrote:
> 
> 
> 
>> On Nov 25, 2018, at 1:38 AM, Michael Hendry <hendry.michael at gmail.com> wrote:
>> 
>>> On 24 Nov 2018, at 12:17, John Ralls <jralls at ceridwen.fremont.ca.us> wrote:
>>> 
>>> 
>>> 
>>>> On Nov 24, 2018, at 7:20 PM, Michael Hendry <hendry.michael at gmail.com> wrote:
>>>> 
>>>> Following reconciliation of recent bank statements, I had prepared several income and expense reports for the year ending 31/10/2018.
>>>> The crash occurred when I requested a Balance Sheet for the same period.
>>> 
>> 
>> Thanks, John.
>> 
>>> There’s no reason to reboot your computer. You’re running a real operating system, not Microsoft.
>> 
>> That’s the theory, anyway...
>> 
>>> 
>>> ESJE.gnucash was the previous saved file, the autosave didn’t get far enough to rename it, so that’s OK. You can go ahead and open it without any worries. As long as the changes between 17:51 and 18:08 were transaction edits/additions only and didn’t use the business features then replaying the log file should recover your work in the 18 minutes. There’s no risk in trying it, GnuCash always renames the old file before trying to save a new one... but you can check the results in memory first as long as you get it done in less than 15 minutes (or you turn off autosave in Preferences until you’re happy with the results).
>> 
>> OK, I loaded the ESJE.gnucash file, and recovered any subsequent changes from the .log file, and all seems OK.
>> 
>> I subsequently ran the Balance Sheet and Profit & Loss reports without trouble, and exported them to PDF.
>> 
>>> 
>>> The crash is kind of interesting. It appears to be while processing a list of top-level windows. I guess the invalid one is the just-dismissed reconcile window, but do you have your reports going to tabs or to new windows?
>> 
>> This morning's work had involved:
>> 
>> 1. Reconciling a bank account (which involved making a few additional entries).
>> 2. Preparing reports on various asset, liability, income and expense accounts for the financial year (1st November 2017 to 31st October 2018) and exporting them to PDF.
>> 3. Requesting a Balance Sheet for 31st October 2018 - which is the point at which the crash occurred.
>> 
>> I have the reports going to tabs, not new windows. In this context, I generally close the tabs involved in each report before moving on to the next, but I can’t swear that this was done before the Balance Sheet request; there would have been a maximum of 3 tabs open at that stage.
>> 
>> I’m sure I had completed the reconciliation some time before the crash, because I needed to reconcile before preparing the report on the bank account.
>> 
>> Here’s a directory listing for the PDF files in reverse chronological order.
>> 
>> | => ls -l -t
>> total 1848
>> -rw-r--r--@ 1 michaelhendry  staff   53878 24 Nov 16:10 Profit & Loss-Year to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   48158 24 Nov 16:08 Balance Sheeet at 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   42343 24 Nov 08:08 Liabilities-Loan from Ruth Irons to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   43701 24 Nov 08:07 Income-Work for Third Parties to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   47074 24 Nov 08:07 Income-Shawbrook Interest to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   40246 24 Nov 08:05 Income-Donation to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff  252042 24 Nov 08:05 Income-Course Fees to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   44620 24 Nov 08:04 Expenses-Venue to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   56610 24 Nov 08:04 Expenses-Tuition to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   52697 24 Nov 08:03 Expenses-Travel to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   41479 24 Nov 08:02 Expenses-Sound and Lighting to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   73336 24 Nov 08:01 Expenses-Houseparent to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   52530 24 Nov 08:01 Expenses-Bank Service Charge to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   41175 24 Nov 08:00 Expenses-Audit and Accountancy to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   55383 24 Nov 08:00 Expenses-Administration to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   52882 24 Nov 07:59 Assets-Current Assets-Shawbrook Charity Savings Account to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff   57312 24 Nov 07:57 Assets-Current Assets-Petty Cash to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff  302646 24 Nov 07:56 Assets-Current Assets-Clydesdale Bank to 2018-10-31.pdf
>> -rw-r--r--@ 1 michaelhendry  staff  507400 17 Nov 18:42 General Ledger to 2018-10-31.pdf
>> 
>> The Clydesdale Bank account was reconciled before the associated report was created at 07:56 today, and the crash occurred at 08:08:42.302 +0000, just after the creation of the “Liabilities-Loan…” PDF report.
>> 
>> You’ll see that the Balance Sheet and P&L reports were created this afternoon.
> 
> The crash wasn’t in the report generation, it was getting ready to do the next auto-save at 08:08; your activity at the moment was coincidental. I asked about tabs-vs-windows because it was processing a list of the open GnuCash windows to set the boundaries for the “busy” cursor and one of them was invalid. Your workflow doesn’t mention prices or securities, so If you were sending the reports to tabs then I suppose that the only open window was the main window and the only closed one was the reconcile window.
> 
> Regards,
> John Ralls

Correct, no prices or securities were involved, and the work I’d done involved deletion of the Closure of Books transactions I’d previously created, reconciliation of the Clydesdale Bank statement (including the entry of a few missing transactions) then a series of:

open_account->filter_by_dates->save_the_date_range->transaction_report->export_to_PDF->close_tabs.

Michael