[GNC] GNU crashes when any Report is selected

Mon Dec 10 10:08:12 EST 2018

You’re dead right John. It’s a hang. I’m all red faced, but the text “GNUCash is not responding” is more than a little indicative of a cash to this newbie, sorry to have wasted so many folk’s time. It is taking 1 to 2 minutes to clear at which the reports appear and any subsequent report selection are instantly screened. I’ve now tested this by program close/restarts and it’s always 1 to 2 minutes for the first report, then instant response. In the past there has never been a delay. The only “out of routine” entry was the very last entry in which I entered a transaction in an account, then typed in a new “Transfer” account name and allowed GNUCash to make a new account for me. On checking now, I find the new account correctly detailed except for a blank Description field which I have now corrected. However I have the same excessive delay waiting for Reports to open. Do you have any thoughts to correct this please.
Best Regards
Arnie

From: John Ralls <jralls at ceridwen.us> 
Sent: 10 December 2018 14:26
To: Arnie Reeves <karndale at blueyonder.co.uk>
Cc: David Carlson <david.carlson.417 at gmail.com>; Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] GNU crashes when any Report is selected

Arnie,

That’s not a crash, it’s a hang. How long are you waiting to kill it?

Regards,
John Ralls

On Dec 10, 2018, at 2:12 AM, Arnie Reeves <karndale at blueyonder.co.uk <mailto:karndale at blueyonder.co.uk> > wrote:

That’s bad news John, I hoped the trace would help. A crash results from selecting any report within the Report menu. After selection by clicking the report then the green “play” type button at the right, the main screen under the current open tabs goes blank. That is the open account tabs, panel and menu tabs remain at the top of the screen, but all open account data is replaced by a blank white screen. Just as if the report had opened without any data. Any further mouse selections produce a warning text that GNUCash is not responding. I use Task Manager to close the program. My customised reports are simple changes from the Options button to provide a new title, change the report Start Date and change the report End Date. These changes are saved using Save Configuration As…. I have a report for each month for Transactions and Cash Flow. These have worked perfectly for 11 months.
Best Regards
Arnie

From: John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us> > 
Sent: 10 December 2018 01:17
To: Arnie Reeves <karndale at blueyonder.co.uk <mailto:karndale at blueyonder.co.uk> >
Cc: David Carlson <david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com> >; Gnucash Users <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> >
Subject: Re: [GNC] GNU crashes when any Report is selected

Unfortunately there are no useful clues in the trace file. You might try opening a powershell window and starting GnuCash from the prompt (“C:\Program Files (x86)\gnucash\bin\gnucash”) to see if guile is writing anything that isn’t getting captured by the logging facility.

Do not-customized reports (e.g. Reports>Assets>Balance Sheet) crash or just the customized ones? Does “customized” mean that you’ve changed some report options and saved the configuration or reports with custom Scheme code?

Regards,
John Ralls

On Dec 9, 2018, at 12:42 PM, Arnie Reeves < <mailto:karndale at blueyonder.co.uk> karndale at blueyonder.co.uk> wrote:

John and David. Thank you for your time. Following Johns suggestion I have located the latest gnu.trace file which is copied below. Could you help please with identifying errors: It also seems that all data entries covering the month of Nov2018 have been deleted from the lists of accounts (ie latest entries before problems with crash). I’ve retrieved and opened two backup files from several months ago, these also show all up to date custom report file names, but selecting any of these causes a crash.

* 19:55:12  WARN <gnc.app-utils> Could not spawn perl: Failed to execute child process (No such file or directory)
* 19:55:12  CRIT <GLib> g_key_file_free: assertion 'key_file != NULL' failed
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account
* 19:57:18  WARN <gnc.query> [xaccQueryAddAccountMatch()] acct_list has NULL account

Best Regards
Arnie

From: David Carlson < <mailto:david.carlson.417 at gmail.com> david.carlson.417 at gmail.com> 
Sent: 09 December 2018 18:34
To: John Ralls < <mailto:jralls at ceridwen.us> jralls at ceridwen.us>
Cc: Arnie Reeves < <mailto:karndale at blueyonder.co.uk> karndale at blueyonder.co.uk>; Gnucash Users < <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org>
Subject: Re: [GNC] GNU crashes when any Report is selected

Arnie,

I just fired up GnuCash release 2.6.19 on Windows 10 Version    10.0.17134 Build 17134and I produced and printed a couple of reports without a crash, so if you have a comparable build, that would probably not be your problem.

Try John's suggestions if possible.

David C

On Sun, Dec 9, 2018 at 11:29 AM John Ralls < <mailto:jralls at ceridwen.us> jralls at ceridwen.us> wrote:
Reinstalling GnuCash isn't likely to accomplish anything, and it's very unlikely that updating Microsoft Access has anything to do with the problem. A bit more troubleshooting is in order.

First, look at a tracefile ( <https://wiki.gnucash.org/wiki/Tracefile> https://wiki.gnucash.org/wiki/Tracefile) from a crashed session to see if there's an error at the end of it that might indicate the cause of the crash. A stack trace ( <https://wiki.gnucash.org/wiki/Stack_Trace> https://wiki.gnucash.org/wiki/Stack_Trace) is the best diagnostic but they're hard to get on Windows.

Try opening a backup file from a month ago if you have one available: Perhaps there's a data problem in the current file that's causing the crash. You can also try creating a new user and running GnuCash while logged in as that user to see if there's something in your environment that's causing the crash.

Regards,
John Ralls

> On Dec 9, 2018, at 8:27 AM, Arnie Reeves via gnucash-user < <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org> wrote:
> 
> Thank you for your response David, suggesting “other” program updates on my Windows 10 set up, including a recent upgrade to MS Office 2019 which includes Access, may be responsible for causing my GNUCash 2.6.19 to crash every time I select a report. That being the only suggestion (so far), I believe my only option is to reinstall the GNUCash program, and keep fingers crossed. I understand any reinstallation will be able to use the 11 months existing data without any further actions from me.(?). For a simple home accounts use, please could some-one explain the differences of the available versions – such as 2.6.19 (Currently used and previously found fine) and 3.3 etc. Which is best, and bug free, for my simple home accounts.
> Arnie
> 
> 
> From:  <mailto:karndale at blueyonder.co.uk> karndale at blueyonder.co.uk < <mailto:karndale at blueyonder.co.uk> karndale at blueyonder.co.uk> 
> Sent: 08 December 2018 21:37
> To: David Carlson < <mailto:david.carlson.417 at gmail.com> david.carlson.417 at gmail.com>
> Cc: Gnucash Users < <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org>
> Subject: Re: [GNC] GNU crashes when any Report is selected
> 
> Only change other than routine updates was an upgrade from MS Office 2010 to Office 2019. This of course includes Access. 
> 
> 
> Sent from my iPhone.
> 
> On 8 Dec 2018, at 9:25 pm, David Carlson < <mailto:david.carlson.417 at gmail.com> david.carlson.417 at gmail.com<mailto: <mailto:david.carlson.417 at gmail.com> david.carlson.417 at gmail.com> > wrote:
> I did forget to mention that I use Gnucash mostly in Ubuntu 16.04 with occasional forays into Windows 7 and rare forays into Windows 10.
> 
> David C 
> 
> On Sat, Dec 8, 2018, 3:21 PM David Carlson < <mailto:david.carlson.417 at gmail.com> david.carlson.417 at gmail.com<mailto: <mailto:david.carlson.417 at gmail.com> david.carlson.417 at gmail.com>  wrote:
> Arnie,
> 
> Did you get a Windows update or have any other significant change to your computer?
> 
> Release 2.6.19 itself has not changed, and various 2.6.x releases are still working for me.
> 
> David C 
> 
> On Sat, Dec 8, 2018, 12:10 PM Arnie Reeves via gnucash-user < <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org<mailto: <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org>  wrote:
> I use Windows 10 with GNUCash 2.6.19 for home accounting. After 11 months of
> perfect use, all reports suddenly fail to open and selecting any report,
> including samples or one of my many customised reports (new one for each
> month) causes the program to crash. Anyone aware of a fix, or maybe an
> upgrade to version 3.3 will solve the problem? I've resisted the update due
> to reading many reports of problems with 3.3 and so far 2.2.19 has been
> fine. All reports worked fine at last month's home accounting. I only update
> at the end of each month.
> Thanks, Arnie.
> _______________________________________________
> gnucash-user mailing list
>  <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org <mailto: <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org> 
> To update your subscription preferences or to unsubscribe:
>  <https://lists.gnucash.org/mailman/listinfo/gnucash-user> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see  <https://wiki.gnucash.org/wiki/Mailing_Lists> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
>  <mailto:gnucash-user at gnucash.org> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
>  <https://lists.gnucash.org/mailman/listinfo/gnucash-user> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see  <https://wiki.gnucash.org/wiki/Mailing_Lists> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.