Gnucash segmentation fault - Postgresql

[h0l0fernes]

> 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