Re: Gnucash Crashing

[John Ralls]

> On Feb 28, 2018, at 11:05 AM, J.L. Sundstrom  wrote:
> 
> Recently upgraded to 10.13.3 and had to upgrade Gnucash (GC 2.6.19) to work 
> with it.  All was well until installing “recommended” update to 10.13.3 
> (character sequence can cause crash) on 2/22/18.  After that, opening and 
> closing GC and then trying subsequent opening GC crashes (Apple info 
> available if wanted).  Discovered work-around of reinstalling GC which opens 
> the app and I can use it without problem.  But, close it and try to open 
> again… it crashes.  Any ideas why this would be the case?  It appears that 
> Apple’s update broke 2.6.19.

Sorry, the first one went from the wrong email account for the list.

Please open a bug and attach the crash report to it.

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: Gnucash Crashing

[Adrien Monteleone]

I was using .19 before I moved to High Sierra and I just applied the .3 update 
two days ago. Normally, I just leave GC running 24/7, but I just tested closing 
and re-opening several times successfully.

Sounds like you’ve got something amiss with your system or profile.

Does a new user profile on the mac have the same issues?


Regards,
Adrien

> On Feb 28, 2018, at 12:05 PM, J.L. Sundstrom  wrote:
> 
> Recently upgraded to 10.13.3 and had to upgrade Gnucash (GC 2.6.19) to work 
> with it.  All was well until installing “recommended” update to 10.13.3 
> (character sequence can cause crash) on 2/22/18.  After that, opening and 
> closing GC and then trying subsequent opening GC crashes (Apple info 
> available if wanted).  Discovered work-around of reinstalling GC which opens 
> the app and I can use it without problem.  But, close it and try to open 
> again… it crashes.  Any ideas why this would be the case?  It appears that 
> Apple’s update broke 2.6.19.
> ___
> 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.

___
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: Gnucash crashing on startup

[Okkie]

On 06/09/2017 01:50 AM, John Ralls wrote:
>> On Jun 8, 2017, at 7:56 AM, Okkie  wrote:
>>
>> [...]
>>
>> The difference / extra info here is:
>>
>> * gnucash did not crash. I shut down the previous version gracefully.
>> * This particulair transaction has been there for almost 12 years now.
>> * It is the very first transaction in this particular account.
>> * A quick look in a backup from 6 month's ago also shows: post_date:
>> -00-00 00:00:00
>> * This never caused trouble while starting up before.
>>
>> So.. maybe it is a regression issue that may bite others too?
> Not exactly a regression. GnuCash should never have accepted a transaction 
> with a post date from the reign of Octavian, though crashing isn’t an 
> acceptable response either. 

Hehe. Maybe I shouldn't call it a regression, but none of the previous
versions dumped core on this entry. What makes matters worse is that it
needs a start from the command line to see if there's a useful error. A
GUI-only user only sees a splash screen that disappears after a while. And
even with the error, you need to have quite some skills to find the cause.
Thank you, Sahib Jakhar for finding it and posting it to this list! Saved me
a lot of time!

Maybe Sahib's first crash was not in any way related to this entry, but just
a trigger to start up into the new version. Sahib, are you also running
Ubuntu? Can you check in /var/log/apt/ if gnucash got upgraded during the
uptime of the session that eventually crashed?

From my history I found the following updates:

2017-01-30  gnucash 1:2.6.12-1
2017-05-29  gnucash 1:2.6.16-1~getdeb1

The .12 version was restarted a few times and was still running for a few
weeks when I restarted the computer and started .16 for the very first time.



> How long ago did you switch to the SQL backend? That wasn’t available in 
> 2005. I don’t suppose you have any of the old XML files around to see if the 
> transaction was actually created with no post date.

Well, sometimes not cleaning up can be a good thing. Apparantly I still have
the backup from before the conversion hanging around in a subdirectory.

I migrated in december 2013, and in the last XML I see this next to the same
guid:

  
1970-01-01 00:00:00 +0100
  
  
2005-09-09 16:21:36 +0200
  

So even then, there was already a zero date (0s since the epoch) in this
transaction.

Does this help in any way?

Regards,
Oscar
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Re: Gnucash crashing on startup

[Okkie]

Hello,

I just subscribed to this list, after finding the solution to my crashing
gnucash in this thread. I think my additional information may be of value,
so excuse my barging in without proper introduction etc.

Okay. I shut down gnucash. Rebooted my Ubuntu 16.04 for a kernel upgrade and
started gnucash again. A side note: It may be important to know that gnucash
got upgraded automatically since the previous start. It is now at
1:2.6.16-1~getdeb1. 

So, gnucash dumped core and googling on the error lead me to this thread.
And of course the cause was quickly found:

mysql> select * from transactions where guid='84f8'\G
*** 1. row ***
 guid: 84f8
currency_guid: 83a4
  num: 
post_date: -00-00 00:00:00
   enter_date: 2005-09-09 14:21:36
  description: 
1 row in set (0.00 sec)

I fixed this by issuing this SQL command instead of deleting the
transaction:
mysql> update transactions set post_date = '2005-09-09 00:00:00' where
guid='84f8';

.. and gnucash started up very well after this.

The difference / extra info here is:

* gnucash did not crash. I shut down the previous version gracefully.
* This particulair transaction has been there for almost 12 years now.
* It is the very first transaction in this particular account.
* A quick look in a backup from 6 month's ago also shows: post_date:
-00-00 00:00:00
* This never caused trouble while starting up before.

So.. maybe it is a regression issue that may bite others too?



--
View this message in context: 
http://gnucash.1415818.n4.nabble.com/Gnucash-crashing-on-startup-tp4690116p4692101.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
___
gnucash-user mailing list
gnucash-user@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.