Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

2019-10-20 Thread John Ralls



> On Oct 20, 2019, at 12:32 PM, andrewTE  wrote:
> 
> Okay thanks. Reading on it, seems like it's caused by library and compiler
> compatibility issues with no current way forward. Worse yet it may be caused
> by threading issues. And it's intermittent to reproduce for some people to
> boot. Being a SW developer myself, this does not look promising for a fix
> any time soon. I guess my best bet is to use 3.5 or stick to 2.6 then?

Unfortunately that seems like a correct assessment. Unless you need FinTS I 
think 3.5 is your best bet.

Unless, of course, you have some skill in working with pthreads on Windows and 
can figure out what's going astray...

Regards,
John Ralls
___
gnucash-user mailing list
gnucash-user@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.


Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

2019-10-20 Thread andrewTE
Okay thanks. Reading on it, seems like it's caused by library and compiler
compatibility issues with no current way forward. Worse yet it may be caused
by threading issues. And it's intermittent to reproduce for some people to
boot. Being a SW developer myself, this does not look promising for a fix
any time soon. I guess my best bet is to use 3.5 or stick to 2.6 then?



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.


Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

2019-10-20 Thread John Ralls



> On Oct 20, 2019, at 12:08 PM, andrewTE  wrote:
> 
> I am able to run Income Statement, Balance Sheet and Cash Flow.
> 

OK, that plus the tracefile output indicating that javascript has left the 
building means that it's bug 797293.

Regards,
John Ralls

___
gnucash-user mailing list
gnucash-user@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.


Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

2019-10-20 Thread andrewTE
I am able to run Income Statement, Balance Sheet and Cash Flow.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@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.


Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

2019-10-20 Thread andrewTE
I've run it with debug. No messages showing on the console, and in the
tracefile I get something like this:

* 11:57:01  INFO  [gnc_plugin_page_report_setup] report-id: 11
* 11:57:01  INFO  [gnc_plugin_page_report_setup] set needs save
* 11:57:02  INFO  [gnc_html_webkit_init] webkit_settings: Set
default font to [[gnc_html_w]
* 11:57:02  INFO  [gnc_gsettings_register_cb]
schema: general.report, key: default-zoom, settings_ptr: 0b6a7f40,
handler_id: 20891
* 11:57:02  INFO  [gnc_plugin_page_report_realize_uri] Realized
Container size is 1w x 1h
* 11:57:02  INFO  [qof_object_foreach] type=Split
* 11:57:02  INFO  [qof_collection_foreach] Hash Table size of
Split before is 50912
* 11:57:02  INFO  [qof_collection_foreach] Hash Table size of
Split after is 50912
* 11:57:02  INFO  [qof_query_run_internal] matching
objects=1d3f count=50504
* 11:57:03  INFO  [qof_object_foreach] type=Split
* 11:57:03  INFO  [qof_collection_foreach] Hash Table size of
Split before is 50912
* 11:57:03  INFO  [qof_collection_foreach] Hash Table size of
Split after is 50912
* 11:57:03  INFO  [qof_query_run_internal] matching
objects=14af9a60 count=1284
* 11:57:03 MESSG  










Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

2019-10-20 Thread Adrien Monteleone
Andrew,

See the wiki about obtaining a tracefile on Windows. Make sure to check the 
tracefile before re-starting GnuCash after a freeze. (it gets overwritten on 
subsequent runs)

Also, check the wiki for running GnuCash from the command line. (cmd.exe) Some 
errors or warnings are sent back to the command window that way.

You might not get anything of use, but both are worth checking out.

In the meantime...

Can you run other reports, such as P (Income Statement), Balance Sheet, 
Cash-Flow, et cetera?

Can you try running the offending reports and narrow down the expense accounts? 
Perhaps one or more has some sort of bad transaction info or is corrupted.

Try the Transaction Report on those (or various) expense accounts and see if it 
freezes as well.

The goal here is to narrow down which (or if all) reports choke, and then 
trying to find out what they are choking on.

Of course, make a backup of your datafile before proceeding.

You shouldn’t have to stay on 2.6 forever, and you shouldn’t need to make a new 
file. But this might take some sleuthing.

Regards,
Adrien

> On Oct 20, 2019 w43d293, at 12:51 PM, andrewTE  
> wrote:
> 
> I have just upgraded my 2.6 installation to 3.7 (Windows 10) and the gnucash
> would freeze immediately if I click on any report (there were 2 opened tabs
> by default as carried over from how I had it on 2.6). Thinking this was
> caused by incompatible reports, I managed to close them with "X" while they
> were not yet active, saved, reopened gnucash. Then I created brand new
> report. First time it worked but then as soon as I changed report to show 15
> items versus default, was it 8?, it froze. Second and subsequent time,
> trying to create ANY report immediately freezes the gnucash. Basically it is
> impossible to create any reports, at least not expense reports. I did wait a
> number of minutes (10+) but it just doesn't come back from complete freeze.
> 
> Is there a way around this? Or are my only options to either stick to 2.6
> forever or start a completely new file at the beginning of next year for new
> data and keep 2.6 installed on another PC (as they cannot coexist on
> windows?)? Keep in my that my existing file has more than 10 years of
> history of daily transactions so it's pretty large.
> 
> Thanks for any suggestions.

___
gnucash-user mailing list
gnucash-user@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.


Re: [GNC] Gnucash 3.7 freezes on any report after update from 2.6

2019-10-20 Thread John Ralls



> On Oct 20, 2019, at 10:51 AM, andrewTE  wrote:
> 
> I have just upgraded my 2.6 installation to 3.7 (Windows 10) and the gnucash
> would freeze immediately if I click on any report (there were 2 opened tabs
> by default as carried over from how I had it on 2.6). Thinking this was
> caused by incompatible reports, I managed to close them with "X" while they
> were not yet active, saved, reopened gnucash. Then I created brand new
> report. First time it worked but then as soon as I changed report to show 15
> items versus default, was it 8?, it froze. Second and subsequent time,
> trying to create ANY report immediately freezes the gnucash. Basically it is
> impossible to create any reports, at least not expense reports. I did wait a
> number of minutes (10+) but it just doesn't come back from complete freeze.
> 
> Is there a way around this? Or are my only options to either stick to 2.6
> forever or start a completely new file at the beginning of next year for new
> data and keep 2.6 installed on another PC (as they cannot coexist on
> windows?)? Keep in my that my existing file has more than 10 years of
> history of daily transactions so it's pretty large.
> 
> Thanks for any suggestions.

This might be be https://bugs.gnucash.org/show_bug.cgi?id=797283. Does it 
really freeze on any report at all  or just on graphical reports?
Is GnuCash completely hung so that if you click one of the other tabs it 
doesn't switch after a few minutes?
Are there any unusual messages in the trace file 
(https://wiki.gnucash.org/wiki/Tracefile)? Try starting 

GnuCash from a CMD prompt with the debug option:
  "c:\Program Files (x86)\gnucash\bin\gnucash" --debug
Then look at the end of the new tracefile to see what was the last message 
GnuCash printed before it hung.

Please start Task Manager, switch to the Details tab, and find the gnucash 
entry. Does it show 0 CPU?

Regards,
John Ralls


___
gnucash-user mailing list
gnucash-user@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.