Gnucash crashing on startup

[ppssupport at hotmail.com]

On 03/01/2017 10:12 PM, John Ralls wrote:
>> On Mar 1, 2017, at 12:12 PM, Sahib Jakhar <sahib.jakhar at gmail.com> wrote:
>>
>> Hi,
>>
>> I was entering data into gnucash, and suddenly it crashed. Ever since
>> its crashing, it is crashing on startup. I am using mysql to store
>> data on Linux.
>>
>> I also deleted manually the entries in splits and transactions table
>> corresponding to the last transaction I was entering, but to no avail.
>>
>> The following gets printed on the command prompt:
>>
>> libsqlite.so.0: cannot open shared object file: No such file or directory
>> libdbi: Failed to load driver: /usr/lib/dbd/libdbdsqlite.so
>> Found Finance::Quote version 1.38
>> **
>> qof:ERROR:gnc-date.c:1669:timespec_to_gdate: assertion failed:
>> (g_date_valid (&result))
>> Aborted (core dumped)
>>
>>
>> Also, some (possibly relevant) stuff from /tmp/gnucash.trace is as follows:
>>
>> 9104 * 01:16:12  INFO <gnc.engine> [xaccTransSetDateInternal]
>> addr=0x35f5a30 set date to 1422815400.000000000 Mon Feb  2 00:00:00
>> 2015
>> 9105 * 01:16:12  INFO <gnc.engine> [xaccTransSetDateInternal]
>> addr=0x35f5a30 set date to 1422895503.000000000 Mon Feb  2 22:15:03
>> 2015
>> 9106 * 01:16:12  INFO <gnc.engine> [xaccTransSetDateInternal]
>> addr=0x35f5a30 set date to 1422874740.000000000 Mon Feb  2 16:29:00
>> 2015
>> 9107 * 01:16:12  INFO <gnc.translog> [xaccOpenLog] Attempt to open
>> disabled transaction log
>> 9108 * 01:16:12  INFO <gnc.translog> [xaccTransWriteLog] Attempt to
>> write disabled transaction log
>> 9109 * 01:16:12  CRIT <GLib> g_date_time_format: assertion 'datetime
>> != NULL' failed
>> 9110 * 01:16:12  CRIT <GLib> g_date_time_unref: assertion 'datetime !=
>> NULL' failed
>> 9111 * 01:16:12  INFO <gnc.engine> [xaccTransSetDateInternal]
>> addr=0x35f5bd0 set date to 18446744011539567616.000000000 (null)
>> 9112 * 01:16:12  INFO <gnc.engine> [xaccTransSetDateInternal]
>> addr=0x35f5bd0 set date to 1488395668.000000000 Thu Mar  2 00:44:28
>> 2017
>> 9113 * 01:16:12  CRIT <qof> gnc_localtime_r: assertion 'gdt != NULL' failed
>> 9114 * 01:16:12  CRIT <GLib> g_date_set_dmy: assertion
>> 'g_date_valid_dmy (day, m, y)' failed
>>
>>
>> Can somebody kindly help me, as I use gnucash for storing all my
>> financial transactions and it has 5+ years of data?
> Please get a stack trace (http://wiki.gnucash.org/wiki/Stack_Trace <http://wiki.gnucash.org/wiki/Stack_Trace>) of the crash and file a bug report with the stack trace attached.
>
> Regards,
> John Ralls
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at 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.
> .
>
Try a system reboot first

Jeffrey