Bug 46598 - Form wizard data sheet style form locks and crashes LibreOffice on OSX Lion
Summary: Form wizard data sheet style form locks and crashes LibreOffice on OSX Lion
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.5.0 release
Hardware: x86-64 (AMD64) other
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-24 19:16 UTC by Dan Gildea
Modified: 2012-09-02 14:41 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Apple crash report after LibreOffice Base crash (77.32 KB, text/plain)
2012-02-24 19:16 UTC, Dan Gildea
Details
Screen shot of Form Wizard creating Data Sheet style form layout. (120.05 KB, image/png)
2012-02-25 14:57 UTC, Dan Gildea
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Dan Gildea 2012-02-24 19:16:48 UTC
Created attachment 57615 [details]
Apple crash report after LibreOffice Base crash

Mac OS 10.7.3
LibreOffice 3.5.0 
Base component
using form wizard to create "data sheet" style form.
When form opens LibreOffice locks up and crashes.

Apple crash report attached.
Comment 1 Alex Thurgood 2012-02-25 05:30:59 UTC
Hi,

This is not a meaningful report, sorry.
What do you mean by "data sheet" style form ?
Are you creating the form in Writer or in Calc ?

Please produce a bug report with detailed steps that can be reproduced, and a sample document, otherwise this bug report will be closed as invalid.

Alex
Comment 2 Alex Thurgood 2012-02-25 05:33:30 UTC
Oh, do you have the Accessibility options turned on in your Mac (VoiceOver, keyboard navigation, etc) ? If so, turn them off and see if the crash still happens.


Alex
Comment 3 Dan Gildea 2012-02-25 10:38:03 UTC
Let me check into this. I'll reply soon.

On Sat, Feb 25, 2012 at 7:33 AM, <bugzilla-daemon@freedesktop.org> wrote:

> https://bugs.freedesktop.org/show_bug.cgi?id=46598
>
> --- Comment #2 from Alex Thurgood <iplaw67@yahoo.co.uk> 2012-02-25
> 05:33:30 PST ---
> Oh, do you have the Accessibility options turned on in your Mac (VoiceOver,
> keyboard navigation, etc) ? If so, turn them off and see if the crash still
> happens.
>
>
> Alex
>
> --
> Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 4 Dan Gildea 2012-02-25 14:57:54 UTC
Created attachment 57644 [details]
Screen shot of Form Wizard creating Data Sheet style form layout.
Comment 5 Dan Gildea 2012-02-25 15:02:14 UTC
(In reply to comment #1)
> Hi,
> 
> This is not a meaningful report, sorry.
> What do you mean by "data sheet" style form ?
> Are you creating the form in Writer or in Calc ?
> 
> Please produce a bug report with detailed steps that can be reproduced, and a
> sample document, otherwise this bug report will be closed as invalid.
> 
> Alex

Hi Alex,

The subject of the report included the keywords; "Base", "form" and "wizard."
If you are unfamiliar with the database component of LibreOffice (called Base) please pass this bug report on to another who is.

My report is concise and describes the issue exactly:

Mac OS 10.7.3
This is the platform and operating system version.

LibreOffice 3.5.0
This is the software title and version.

Base component
This is the software component used (i.e. Not Calc or Writer.)

Using form wizard to create "data sheet" style form.
This is what I was doing preceding the crash. (i.e. do this procedure to re-create the crash.)
(See attached screen shot. Note highlighted areas.)

When form opens LibreOffice locks up and crashes.
This is the result of the above procedure.

Apple crash report attached.
This indicates that a complete crash report is attached if you need more detailed information about the crash.
Comment 6 Dan Gildea 2012-02-25 19:26:28 UTC
(In reply to comment #2)
> Oh, do you have the Accessibility options turned on in your Mac (VoiceOver,
> keyboard navigation, etc) ? If so, turn them off and see if the crash still
> happens.
> 
> 
> Alex

Hi Alex,
I do not have any accessibility options turned on.
I do use a dvorak keyboard layout, however.

I can't imagine this would be the cause of the crash as the form wizard uses mouse clicks to select options throughout until the last step when you type in the name of the new form.

I've been using the dvorak keyboard layout for many years, and for about two years now working with OpenOffice/LibreOffice without issue.
Comment 7 Alex Thurgood 2012-02-26 03:03:36 UTC
Hi Dan,

Thanks for providing the screenshot, that helped. As I mostly work with French language versions of LO and LO Base in particular, I am not always aware of the English equivalents. I feel you may have misunderstood how bug handling is managed within this project : most of us are volunteers (myself included), and anyone can take an interest in any bug report, comment on it, etc. There is no hierarchy of responsibility, as one might find in a typical commercial organisation. This is why those volunteers who do work on the bugs ask reporters to provide a report according to recommendations made here :

http://wiki.documentfoundation.org/BugReport#What_to_include_in_bug_reports

"Steps to reproduce the problem, please mention that every little detail might be important. Describe 1 simple way how to reproduce your problem in a step by step instruction; numbered items will ease to reference to your observations for other users. Be very exact,
do not write: "Open document"
but: "In new empty LibO Spreadsheet document, use menu 'File -> Open (LibO dialog) - file type "Text documents" -> select attached sample document -> double click'
Provide an exact description of your problem
Not: "Formatting not correct"
But like: "I expect xxx because of yyy, but I see zzz"


The reason I mentioned accessibility is because your Apple Crash trace contains several calls to a11y functions, which is indicative of usage of the accessibility features. The activation of accessibility features in Mac OSX has been a known source of instability and crashes in previous versions of LibreOffice (but hard to pin down).

As you state that you don't have any of those features activated, then the problem must lie elsewhere.

I have just tried this on my Linux box with LO 3.4.5 and my latest build from the master source tree (post 3.5 release). I can not reproduce the crash on that OS with either of those versions.

I will try and reproduce it on my Snow Leopard Macbook later.

Alex
Comment 8 Alex Thurgood 2012-02-26 06:17:03 UTC
Can not reproduce crash on Mac OSX 10.6.8 Snow Leopard with release LO 3.5

I managed to create three different forms with the default Data Sheet formatting provided by the wizard and using all the other default options.

DB server : postgres 9.1
Connector : JDBC 8.4

Seems to be Lion specific, and thus would need someone with else Lion running to confirm.

Can Lion be run in 32bit mode by default ? Just wondering ?

Alex
Comment 9 Alex Thurgood 2012-02-26 06:43:57 UTC
Hi Dan,

I see you have this haxie running :

+com.rogueamoeba.audio_hijack_server.hermes (4.1.0 - 4.1.0) <36C4E178-B697-9643-724B-5F3C222D5E27> /usr/local/hermes/modules/Instant Hijack Server.hermesmodule/Contents/MacOS/Instant Hijack Server


I'm wondering whether that hasn't interfered (or vice-versa isn't supported by LO, which wouldn't surprise me) in some unexpected way ?


Alex
Comment 10 Alex Thurgood 2012-02-26 06:49:32 UTC
Not a definitive source, but cited from Wikipedia :

http://en.wikipedia.org/wiki/Haxie

"According to a post by an Apple employee on an Apple mailing list, Apple ignores all crash reports submitted by users if they show that APE is installed."

If Apple doesn't, or won't, what reason might there be for the LO community to investigate crashes on systems where haxies are installed ? It certainly wouldn't reflect common use case scenarii.

Alex
Comment 11 Dan Gildea 2012-02-26 07:52:01 UTC
Hi Alex,
I have run Audio Hijack before, but I'm not running the app while working
with LibreOffice.
Could you give me a hint how to disable it completely and I'll test again.

I have some other info that might help. I talked someone through the
process on an OS X Snow Leopard machine with LibreOffice 3.4.4 and they
didn't seem to have the problem.
This leads me to believe it's an issue between LibreOffice and Lion.

I have run some other tests this morning and have some more info.
Since you mentioned Accessibility preferences might be a cause, I was
concerned about my use of the Dvorak keyboard layout which is available in
OS X. I shut that layout off and used the standard english keyboard for my
test this morning.

I installed LO 3.4.4 on my machine this morning and all test I did gave the
same result with LO 3.4.4 and LO 3.5.0.

What I discovered is that this all has something to do with changing the
name of the form during or after the wizard creation process.

For example:

If I create a form, using the wizard, and at the last step I DO NOT CHANGE
the default name for the form,(The wizard will use the name of the first
table the form connects to.) the form works and does not crash LibreOffice.

If at the last step in the wizard, I change the form name to something more
appropriate, when the form opens and I click on any record that is
displayed, LibreOffice crashes.

I even created a form leaving the default name, made sure it was working,
then went back and right clicked on the form's name in the Base control
panel and changed it's name. When I went to open the form again,
LibreOffice crashed.


So, in brief.
Use Mac OS 10.7 (Lion)
Build a small database (My test only had two fields and two records.)
Build a form using the Data Sheet style (It seems like the other layouts
work fine.)
Try one with and without changing the default name of the form and you'll
see that any time the name get changed when you try to use the form,
LibreOffice crashes.

I hope this help.

I'm a big proponent of Open Source software.

I appreciate your effort, Alex.

On Sun, Feb 26, 2012 at 8:49 AM, <bugzilla-daemon@freedesktop.org> wrote:

> https://bugs.freedesktop.org/show_bug.cgi?id=46598
>
> --- Comment #10 from Alex Thurgood <iplaw67@yahoo.co.uk> 2012-02-26
> 06:49:32 PST ---
> Not a definitive source, but cited from Wikipedia :
>
> http://en.wikipedia.org/wiki/Haxie
>
> "According to a post by an Apple employee on an Apple mailing list, Apple
> ignores all crash reports submitted by users if they show that APE is
> installed."
>
> If Apple doesn't, or won't, what reason might there be for the LO
> community to
> investigate crashes on systems where haxies are installed ? It certainly
> wouldn't reflect common use case scenarii.
>
> Alex
>
> --
> Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
>
Comment 12 Alex Thurgood 2012-02-26 08:32:17 UTC
Hi Dan,

I'm afraid I can't help you with uninstalling the Audio Hack server unfortunately, you might be able to turn it off selectively when you run LO, but I wouldn't know how to do that either.

I'll test again with the more detailed description you give about changing form names from the default, but I don't have an OSX Lion platform to test on.

The autosave function built in to Lion OSX sometimes seems to cause problems and crashing with LO, or to be more precise, the fact that LO doesn't yet support that mechanism. I have seen reports of file corruption where the autosave function has saved the state of the file at some stage, and then when changes intervene, it tries to reinstate the old state of the file, causing LO to lose its way and crash, sometimes corrupting the file in the process. I don't know whether that is the cause here. It is difficult to nail down because so few of us have a copy of Lion to work with and test things out on.

Alex
Comment 13 Alex Thurgood 2012-02-26 08:39:57 UTC
Tried changing the default form name at the end of the wizard as you suggested, but still no crash.

So still a Lion specific bug to me.


Alex
Comment 14 Alex Thurgood 2012-02-26 08:42:24 UTC
(In reply to comment #13)
> Tried changing the default form name at the end of the wizard as you suggested,
> but still no crash.
> 
> So still a Lion specific bug to me.
> 
> 
> Alex

Changed title to reflect this. If someone else can confirm the behaviour elsewhere, then they can correct the title (and OS/platform).

Until it can be confirmed by someone else with Lion, the bug will have to remain in the unconfirmed state.

Alex
Comment 15 Julien Nabet 2012-03-17 11:22:20 UTC
Was there a previous install of LO or OOo (ie Openoffice) ?
If yes, could you remove/backup your LO/OOo profile ?
I ask this because I noticed quite often in IRC that some problems are caused by things present from former profiles.

Any extension installed ? If yes, could you disable them and test again ?
In the last bugs I checked someone had a problem which was in fact due to a corrector extension.
Comment 16 Jochen 2012-07-27 16:06:09 UTC
(In reply to comment #15)
> Was there a previous install of LO or OOo (ie Openoffice) ?
> If yes, could you remove/backup your LO/OOo profile ?
> I ask this because I noticed quite often in IRC that some problems are caused
> by things present from former profiles.
> 
> Any extension installed ? If yes, could you disable them and test again ?
> In the last bugs I checked someone had a problem which was in fact due to a
> corrector extension.

Hi *,

"long-winded" thread.
Status is "NEEDINFO" again.
Does anyone have time to answer the questions?
Comment 17 Julien Nabet 2012-08-23 21:42:25 UTC
Dan: do you reproduce this same behaviour with newer LO version (3.5.6 or 3.6.0)?
If yes, could you try with a brand new LO profile (see http://wiki.documentfoundation.org/UserProfile)
Comment 18 Jochen 2012-09-02 10:18:02 UTC
(In reply to comment #17)
> Dan: do you reproduce this same behaviour with newer LO version

Hi Dan,

exits bug still?
Comment 19 Alex Thurgood 2012-09-02 14:19:01 UTC
(In reply to comment #16)

> 
> Hi *,
> 
> "long-winded" thread.
> Status is "NEEDINFO" again.
> Does anyone have time to answer the questions?

IMHO we should close this as WFM. The initial reporter was running a haxie, whether he had activated it or not, it was running in the background when LO crashed. As even Apple do not condone/guarantee smooth running of the OS with such things installed, there is no reason why we should be worrying about them.

However, this might be a question of one of those apps, like the zoom feature program, which causes LO to freak and bomb out with some kind of memory corruption, i.e. similar to all those reports about Accessibility.

No one else has reported such an issue, so personally, I would put it down to the haxie, and set this bug as WFM, particularly since we've had no feedback from the initial reporter since 26/02/2012.

Alex
Comment 20 Jochen 2012-09-02 14:41:23 UTC
@reporter:
please feel free to reopen this bug if you find out that the problem still exists with the current stable LibreOffice version and if you can contribute requested additional information due to (especially BugReport Details)!
Set status to "RESOLVED -> WORKSFORME"