[GNC] GNU crashes when any Report is selected

John Ralls jralls at ceridwen.us
Mon Dec 10 16:45:37 EST 2018


We suspect that the hang on the first report has to do with WebKit initializing rather than loading GnuCash data.

Regards,
John Ralls


> On Dec 10, 2018, at 8:07 AM, Arnie Reeves <karndale at blueyonder.co.uk> wrote:
> 
> Thanks David, I’ll try to do that, but note that I have only small household transactions, so the full transaction report of all account only run to three pages each month. Also puzzled that after the first hang waiting for any report – even a small cash flow – all subsequent reports open instantly. I was thinking of closing out the books this month and taking asset values only into a new set of accounts for next year. Do I simply open up a new folder with a new name and start again? Should I download a more recent update or stick with the 2.6.19?
> Arnie
>  
> From: David Carlson <david.carlson.417 at gmail.com> 
> Sent: 10 December 2018 15:32
> 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
>  
> Still, if GnuCash started hanging recently even with very old backups, something odd is happening.  Granted, old backups of my data would  have a rough time with Since Last Run slowing it down until it got through the scheduled transactions...  Arnie's setup is still different than mine, as my data doesn't hang any longer than usual when GnuCash 2.6.19 is building reports in Windows 10.
>  
> Since my data takes two or three minutes for every full file save, I do not notice slow report building.
>  
> Arnie, have you tried building a new data file with a very small number of transactions and a new name to test your system?
>  
> David C
>  
> On Mon, Dec 10, 2018 at 8:28 AM John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us>> wrote:
>> 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 <karndale at blueyonder.co.uk <mailto: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 <mailto:david.carlson.417 at gmail.com>> 
>>>> Sent: 09 December 2018 18:34
>>>> To: John Ralls <jralls at ceridwen.us <mailto:jralls at ceridwen.us>>
>>>> Cc: Arnie Reeves <karndale at blueyonder.co.uk <mailto:karndale at blueyonder.co.uk>>; Gnucash Users <gnucash-user at gnucash.org <mailto: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 <mailto: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 <gnucash-user at gnucash.org <mailto: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 <mailto:karndale at blueyonder.co.uk> <karndale at blueyonder.co.uk <mailto:karndale at blueyonder.co.uk>> 
>>>>> > Sent: 08 December 2018 21:37
>>>>> > To: David Carlson <david.carlson.417 at gmail.com <mailto:david.carlson.417 at gmail.com>>
>>>>> > Cc: Gnucash Users <gnucash-user at gnucash.org <mailto: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><mailto: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><mailto: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><mailto: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> <mailto: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 <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
>>>>> > 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 <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.
>>>>> 



More information about the gnucash-user mailing list