Save As MySQL is crashing gnucash

[John Ralls]

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