Bug 55558

Summary:	hang closing SQL query window
Product:	LibreOffice	Reporter:	Terrence Enger <lo_bugs>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	dr
Priority:	medium
Version:	4.0.0.0.alpha0+ Master
Hardware:	x86 (IA32)
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	typescript of gdb session with `thread apply all backtrace full` terminal output corresponding to the backtrace screenshots of the hung LibreOffice

Description Terrence Enger 2012-10-03 00:21:10 UTC

Created attachment 68015 [details]
typescript of gdb session with `thread apply all backtrace full`

Alas, I cannot give a good description of what I was doing, but
perhaps you will forgive me in light of the attached backtrace and
console output.

When I closed the SQL Query window by clicking on the "X" in the title
bar, LibreOffice became unresponsive without using much CPU, and
Metacity displayed a message box

    IT-0-0-2f.odb : Query1 - LibreOffice Base: Query Design [OOO370]
    is not responding.

    You may choose to wait a short while for it to continue or force
    the application to quit entirely.

The file I had open is the attachment to bug 37641.  I was stepping
through macro "main", and the generated spreadsheet was open.  While
the macro was stopped, I ran a couple of SQL queries.  I had run the
macro several times since opening the file.


Yesterday, working with the same .odb file, I saw the same hang when I
tried to close the window showing the Basic souce code.  Earlier
today, running under gdb, the problem refused to happen.


LibreOffice is commit cc1a112, pulled 20121001, built and executed
under ubuntu natty (11.04) with desktop "Ububntu Classic (no
effects)".  In particular ..,

    $ uname -a
    Linux cougar-natty 2.6.38-16-generic #67-Ubuntu SMP Thu Sep 6 18:00:43 UTC 2012 i686 athlon i386 GNU/Linux
    $ gcc --version
    gcc (Ubuntu/Linaro 4.5.2-8ubuntu4) 4.5.2
    Copyright (C) 2010 Free Software Foundation, Inc.
    This is free software; see the source for copying conditions.  There is NO
    warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
    
and the configuration options are ...

    $ cat autogen.lastrun
    --enable-symbols
    --enable-dbgutil
    --enable-crashdump
    --disable-build-mozilla
    --without-system-postgresql
    --enable-debug
    --enable-werror


I apologize for this poor bug report.  Suggestions for collecting more
information are welcome.


For comparison, note bug reports ...

(*) bug 38177 "Closing parent Base window leaves wizard generated
    table, query, report or form window in orphaned state" is
    different in that (a) the window on which the user clicks the "X"
    icon actually does close, and (b) the bug is fixed.

(*) bug 40730 "UI. hang closing application with the close-X-icon of
    the window." is similar in that (a) the user had many windows open
    and closed one of them with the "X" icon, and (b) the problem is
    not consistently reproducible, but different in that (a) the
    application is Calc, and (b) the platform is Windows.


Terry.

Comment 1 Terrence Enger 2012-10-03 00:22:32 UTC

Created attachment 68016 [details]
terminal output corresponding to the backtrace

Comment 2 Terrence Enger 2012-10-03 00:25:50 UTC

Created attachment 68017 [details]
screenshots of the hung LibreOffice

The message box shown with the Basic code comes from my own addition to the Basic code.

Comment 3 Terrence Enger 2012-10-13 14:17:07 UTC

Despite a fair amount of playing around with this, I have not been
able to pin this one down.  Along the way, I noticed ...

(a) very long response time, accompanied by high CPU.  Yes, that is
    different from my original description, but at this distance, well
    uh, ... enough said.  There are, of course, several bugs reporting
    bad performance with hsqldb.

(b) at least one case where I had managed to bury a dialog box below
    other LO windows.


So, setting status WORKSFORME.

Terry.