Save As MySQL is crashing gnucash

John Ralls jralls at ceridwen.us
Fri Nov 26 18:56:58 EST 2010


On Nov 26, 2010, at 3:01 PM, Keith Bellairs wrote:

> John,
> 
> Um, I am not a developer so I will stay out of bugzilla. 
> 
> But I just did a saveas with sqlite and got exactly the same failure when trying to reopen a successfully created db. So I suspect the issue may be in packaging on my f14. Since my f14 is an "upgrade" from f12, it is not exactly pristine. I also was running gnc 2.2.9 and did not uninstall it. So my crash may not be duplicated in a clean f14 install. If it runs in a clean f14 then you may not want to mark the "bug" as critical.
> 
> Keith
> 
> 
> 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.)
> 

There's no reason to stay out of Bugzilla because you're not a developer. It's a good place to work on bugs with users, because it keeps the discussion focussed in one place and provides a convenient place to attach log files and so forth.

If you don't want to deal with it, though, that's OK too. I would like a copy of gnucash.trace from a crash, because it might tell me what exactly gnucash was trying to extract that caused the crash. 

Regards,
John Ralls




More information about the gnucash-devel mailing list