Bug 91338 - Base hangs before exit
Summary: Base hangs before exit
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.3.7.2 release
Hardware: x86-64 (AMD64) All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace
: 92020 (view as bug list)
Depends on:
Blocks:
 
Reported: 2015-05-17 00:14 UTC by christian_kuhn
Modified: 2017-04-10 07:17 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Backtrace for Hang (26.13 KB, text/plain)
2015-05-19 18:27 UTC, christian_kuhn
Details
... without SQLite (36.14 KB, text/plain)
2015-05-20 12:46 UTC, christian_kuhn
Details
visual artifact (30.03 KB, image/png)
2015-05-29 22:10 UTC, christian_kuhn
Details

Note You need to log in before you can comment on or make changes to this bug.
Description christian_kuhn 2015-05-17 00:14:17 UTC
Hi,

I have tried to copy a table from a LibreOffice Base with internal HyperSQL to a LibreOffice which is connected with an external SQLite database (via ODBC driver). The copy process is successful, but when I want to close Base, it hangs after the confirmation window (to save the database). If I save the database before I close Base, it terminates normally.

Greetings,
Christian
Comment 1 Julien Nabet 2015-05-17 08:00:01 UTC
Just for the test, do you reproduce this with LO 4.4.3?
Indeed 4.3 branch is EOL so even if it's confirmed in 4.3.7, there won't be any official 4.3.8
Comment 2 christian_kuhn 2015-05-17 19:00:40 UTC
Yes, I can reproduce it with LibreOffice 4.4.3.
Comment 3 Julien Nabet 2015-05-17 20:08:12 UTC
Thank you for your feedback, I put this one back to UNCONFIRMED.
Comment 4 christian_kuhn 2015-05-18 12:28:00 UTC
I have tried this again with LibreOffice 4.4.3. Now I can close LibreOffice, but if I copy a table from another HyperSQL database and after this I insert some data via a form into the SQLite database, it hangs, if I close it and do not save it before closing database.
Comment 5 Buovjaga 2015-05-19 09:56:57 UTC
Perhaps a backtrace could shed more light on the hang: https://wiki.documentfoundation.org/How_to_get_a_backtrace_with_WinDbg
Comment 6 christian_kuhn 2015-05-19 18:27:42 UTC
Created attachment 115730 [details]
Backtrace for Hang

Hello,

I have made a backtrace to report this fault. 
I hope, it helps,

Christian
Comment 7 christian_kuhn 2015-05-20 12:46:08 UTC
Created attachment 115749 [details]
... without SQLite

Hi,

this is just another crash without using SQLite. It is happened while closing Base.

Christian
Comment 8 christian_kuhn 2015-05-29 22:10:54 UTC
Created attachment 116158 [details]
visual artifact

If Base hangs, a visual artifact appears on the right side of the main window.
Comment 9 Doug 2015-06-12 02:16:47 UTC
*** Bug 92020 has been marked as a duplicate of this bug. ***
Comment 10 Doug 2015-06-12 02:22:22 UTC
I encounter this problem on all platforms and backends (Windows 7 & OpenSuse 13.2, HSQLDB and MySQL).  

The workaround is to always close Base with a particular combination of commands:  1.  save  2. use the file 'close' option to exit into the LibreOffice common splash page  3. exit from the common LibreOffice splash page.

Exiting from the common LO splash page avoids the error.  The error seems to be triggered by editing forms and maybe editing macros, and aggravated by omitting to 'save' the Base document before pressing the X in the window or exit.

See duplicate bug report for strace.  Backtrace unsuccessful, as this is hang not crash.
Comment 11 Alex Thurgood 2015-07-12 10:29:59 UTC
Confirming also on

Version: 5.0.0.2
Build ID: a26d58f11b99b6aeddf7f7884effea188cc6e512
Locale: fr-FR (fr.UTF-8)

How to reproduce

1) Open an ODB file

2) Open a Calc file or another ODB file

3) Copy data from the Calc table, via the wizard, or copy an existing table from the other ODB file, into the first opened ODB file. Accept the defaults suggested by the wizard.

4) A new table is created.

5) Shut down LibreOffice directly via the Quit command - accept saving the document when the message appears.

6) LibreOffice hangs until it is force killed (on Mac the app goes into spinning beachball mode)
Comment 12 Alex Thurgood 2015-07-12 10:30:52 UTC
I reproduced on Mac OSX 10.10.4
Comment 13 Alex Thurgood 2015-07-12 10:34:22 UTC
Confirmed also in LO master 5.1alpha
Comment 14 Alex Thurgood 2015-07-12 10:38:19 UTC
On OSX, the application is clearly in some kind of limbo state. If you click on the app icon in the dock, a new blank application window with grey backgoudn, no toolbars or any other window dressing is initially diplayed, and after a while the StartCenter gets drawn. The main app menu shows a greyed out Quit entry.
Comment 15 Alex Thurgood 2015-07-12 10:43:15 UTC
Force quitting from the dock leaves the application window displayed and an overlaid File menu until OSX can effect total clean up.

Looks like some kind of race condition - mutex not releasing ?
Comment 16 QA Administrators 2016-11-08 12:08:25 UTC Comment hidden (obsolete)
Comment 17 Alex Thurgood 2017-04-10 07:17:52 UTC
No repro with

Version: 5.3.0.3
Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.3; UI Render : par défaut; Moteur de mise en page : nouveau; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group