Save As MySQL is crashing gnucash

[Keith Bellairs]

I installed an rpm from this site:
https://admin.fedoraproject.org/pkgdb/applications/Gnucash%20Finance%20Management?_csrf_token=55485385082aa7367a12c90ca01e9878e469fb86
<https://admin.fedoraproject.org/pkgdb/applications/Gnucash%20Finance%20Management?_csrf_token=55485385082aa7367a12c90ca01e9878e469fb86>which
has a link to an rpm for 2.3.17-1.fc14-x86_64 at
https://admin.fedoraproject.org/pkgdb/builds/show/F-14-x86_64-tu/gnucash/0/2.3.17/1.fc14/x86_64?_csrf_token=55485385082aa7367a12c90ca01e9878e469fb86

So I was not running my own build and did not control the compile options.

Backtrace shows it blew up in load_all_accounts. It did the select OK.

 kvp_frame_replace_slot_nc tries to do a hash table lookup, which then tries
an illegal memory access.


On Fri, Nov 26, 2010 at 10:23 AM, John Ralls <jralls at ceridwen.us> wrote:

>
> On Nov 26, 2010, at 5:33 AM, Keith Bellairs wrote:
>
> > Here's the backtrace on my crashing gnc file.
> >
> > On Fri, Nov 26, 2010 at 8:23 AM, Keith Bellairs <keith at bellairs.org>
> wrote:
> >
> >> Just did a save as into mysql with 2.3.17 on f14. that worked fine until
> I
> >> closed gnc and then tried to open it again. it now crashes every time
> with a
> >> seg fault i try to start gnc . It did tell me it could not get the lock
> and
> >> i told it to start anyway. crash comes before gui opens. downloading the
> >> abrt tools to see if i can see what is happening.
> >>
> >>
> >> On Fri, Nov 26, 2010 at 5:59 AM, Ian X Waddington <iwaddox at gmail.com
> >wrote:
> >>
> >>> Sorry didn't read the question, it is Windows 7 32 bit.
> >>>
> >>> -----Original Message-----
> >>> From: Geert Janssens [mailto:janssens-geert at telenet.be]
> >>> Sent: 26 November 2010 10:56
> >>> To: Ian X Waddington
> >>> Cc: gnucash-user at gnucash.org; 'jh'; 'gnucash-devel'
> >>> Subject: Re: Save As MySQL is crashing gnucash
> >>>
> >>> On Friday 26 November 2010, Ian X Waddington wrote:
> >>>> I'm using Windows 7.
> >>>>
> >>>> It is definitely crashing :-) Not sure if the below helps anyone.
> >>>>
> >>>>
> >>>> Problem signature:
> >>>>  Problem Event Name: APPCRASH
> >>>>  Application Name:   gnucash.exe
> >>>>  Application Version:        0.0.0.0
> >>>>  Application Timestamp:      4ce8fdc5
> >>>>  Fault Module Name:  libgncmod-backend-dbi.dll
> >>>>  Fault Module Version:       0.0.0.0
> >>>>  Fault Module Timestamp:     4ce8f78b
> >>>>  Exception Code:     c0000005
> >>>>  Exception Offset:   00001bee
> >>>>  OS Version: 6.1.7600.2.0.0.768.3
> >>>>  Locale ID:  2057
> >>>>  Additional Information 1:   0a9e
> >>>>  Additional Information 2:   0a9e372d3b4ad19135b953a78882e789
> >>>>  Additional Information 3:   0a9e
> >>>>  Additional Information 4:   0a9e372d3b4ad19135b953a78882e789
> >>>>
> >>>>
> >>> Thanks for this information, but is doesn't answer either of my
> questions:
> >>> * Is your windows 7 32bit or 64bit ?
> >>> * Can you post the information in your gnucash trace file:
> >>> see http://wiki.gnucash.org/wiki/Windows#Error_messages.2C_Trace_file
> >>> to learn about the trace file.
> >>>
> >>> Geert
> >>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> -----Original Message-----
> >>>> From: Geert Janssens [mailto:janssens-geert at telenet.be]
> >>>> Sent: 26 November 2010 10:42
> >>>> To: gnucash-user at gnucash.org
> >>>> Cc: Ian X Waddington; 'jh'; 'gnucash-devel'
> >>>> Subject: Re: Save As MySQL is crashing gnucash
> >>>>
> >>>> On Friday 26 November 2010, Ian X Waddington wrote:
> >>>>> Thank you for your input.
> >>>>>
> >>>>> Ok I now have a user with privileges but it still crashes instantly.
> >>>>
> >>>> Can you post the contents of the gnucash trace file [0].
> >>>>
> >>>>> I could be wrong but I'm inclined to think this problem is more
> >>>>> fundamental to the application than MySQL.
> >>>>>
> >>>>> Any additional thoughts would be ideal  - a step-by-step idiot proof
> >>>>> guide to installing MySQL onto a Windows 7 PC and setting everything
> >>>>> up to work with Gnucash would be even better :-)
> >>>>>
> >>>>> Regards
> >>>>
> >>>> Is that Windows 7 - 64bit or 32 bit ?
> >>>>
> >>>> There are a couple of bugs in bugzilla already regarding 64-bit
> >>>> Windows 7, and at least one related to the mysql backend as well [1].
> >>>> That bug doesn't report a crash though.
> >>>>
> >>>> Geert
> >>>>
> >>>> [0] see
> >>>> http://wiki.gnucash.org/wiki/Windows#Error_messages.2C_Trace_file
> >>>> to learn about the trace file.
> >>>> [1] https://bugzilla.gnome.org/show_bug.cgi?id=624465
>
> Excellent, thanks.
> Since it's not clear yet that it's the same crasher as 624465, I've opened
> a new bug, https://bugzilla.gnome.org/show_bug.cgi?id=635859, and marked
> it critical and for 2.4.0.
>
> Does your gnucash.trace contain anything enlightening?
>
> (A suggestion to make your life easier: When doing a debug build, turn off
> all optimization (-O0). Dealing with "optimized out" makes debugging much
> harder.)
>
> Regards,
> John Ralls
>
>
>