Re: Gnucash crashing on startup

2017-06-09 Thread Okkie 
On 06/09/2017 01:50 AM, John Ralls wrote:
>> On Jun 8, 2017, at 7:56 AM, Okkie <gnuc...@okkie.nu> 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

2017-06-08 Thread 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.