Gnucash segmentation fault - Postgresql
John Ralls
jralls at ceridwen.us
Sat May 5 11:46:52 EDT 2012
On May 5, 2012, at 7:42 AM, h0l0fernes wrote:
>
> > On May 4, 2012, at 4:56 PM, h0l0fernes wrote:
> >
> To who-ever can offer assistance:
>
> I am using Gnucash and Postgresql to track my personal finances for years.
>
> Recently during startup I got message:
> "GnuCash could not obtain the lock for postgres://krzys@localhost/gnucash."
> I choose "Open Anyway" and then Gnucash is crashing:
>
> gnc.bin-Message: main: binreloc relocation support was disabled at configure time.
>
> Found Finance::Quote version 1.17
> Segmentation fault (core dumped)
>
> The error is reproducible. I could connect to database via psql, therefore I think that data was not corrupted. I tried to obtain stacktrace by gdb, but it tells me nothing. Attached below.
> I have also tried to delete and create Postgresql database again but without success.
> Could someone give me any hints/ideas how to recover from this situation?
>
> Best Regards,
>
>
>
> ########################stacktrace########################
>
> (gdb) continue
> Continuing.
> [New Thread 0x7f6f72ba3700 (LWP 11731)]
>
> Program received signal SIGSEGV, Segmentation fault.
> 0x00007f6f8c05f3fc in xaccSchedXactionSetStartDate (sx=0x1826d20, newStart=0x0) at SchedXaction.c:591
> 591 SchedXaction.c: No such file or directory.
> >
> > Hmm. Smells like bug 675862[1].
> > Could you install the source package for Gnucash (so that gdb can find SchedXaction.c), re-crash it, and then after it crashes say "bt" to gdb and post the results (everything from the SIGSEGV through the end of the stack trace) onto that bug?
> >
> > Regards,
> > John Ralls
>
> Thank You John for hint! My problem seems to be indeed very similar to bug https://bugzilla.gnome.org/show_bug.cgi?id=674862 , I played a little with Mortgage Wizard, but this is quite a long ago if I recall correctly. I have posted comment in this bug thread with gdb stacktrace from my case, as you suggested.
>
> Actually, in my case, I could try to remove mortgage wizard transactions from psql, if you could direct me where to search for such transactions? Gnucash schema tables looks very complicated for me, and I couldn't find clear description of how this tables are organized in Postgresql.
>
> Thank you for help!
> Krzysiek
>
>
>
>
> [1] https://bugzilla.gnome.org/show_bug.cgi?id=674862
The guy who found this problem originally did manage to fix his database [1], but it apparently wasn't easy. If you look at the end of your trace file (should be /tmp/gnucash.trace on Linux) you'll see the offending account numbers to try to find and remove from your database.
Regards,
John Ralls
[1] http://gnucash.1415818.n4.nabble.com/Gnucash-crashes-when-loading-user-data-from-mysql-tp4584032p4586884.html
More information about the gnucash-user
mailing list