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