[GNC] GNU crashes when any Report is selected

[David Carlson]

I have been living with report building times in that range for most of the
time that I have been using releases newer than about 2.6.4 or so.  It
varies depending on which report I am opening, tho.

I think it is still much faster with a tiny data file.

David C



On Mon, Dec 10, 2018 at 9:08 AM Arnie Reeves <karndale at blueyonder.co.uk>
wrote:

> 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>
> 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>
> *Sent:* 10 December 2018 01:17
> *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
>
>
>
> 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 <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 <david.carlson.417 at gmail.com>
> *Sent:* 09 December 2018 18:34
> *To:* John Ralls <jralls at ceridwen.us>
> *Cc:* Arnie Reeves <karndale at blueyonder.co.uk>; Gnucash Users <
> 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 <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) 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) 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 <
> 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: karndale at blueyonder.co.uk <karndale at blueyonder.co.uk>
> > Sent: 08 December 2018 21:37
> > To: David Carlson <david.carlson.417 at gmail.com>
> > Cc: Gnucash Users <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 <david.carlson.417 at gmail.com
> <mailto: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 <david.carlson.417 at gmail.com
> <mailto: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 <
> gnucash-user at gnucash.org<mailto: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
> > gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> 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
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> 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.
>
>
>