Gnucash segmentation fault - Postgresql

[John Ralls]

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