Bug 105759 - Hangs: When closing with a save, after a table design change has been made to HSQLDB.
Summary: Hangs: When closing with a save, after a table design change has been made to...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
5.3.0.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-02-05 04:04 UTC by Howard Johnson
Modified: 2017-07-12 20:28 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Howard Johnson 2017-02-05 04:04:37 UTC
Version: 5.3.0.3
Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
CPU Threads: 2; OS Version: Linux 3.16; UI Render: default; VCL: gtk2; Layout Engine: new; 
Locale: en-US (en_US.UTF-8); Calc: group

(I didn't choose a version# because 5.3.0.3 was not in the list here, but this is the latest "fresh" download from http://www.libreoffice.org/download/download/?type=deb-x86_64&version=5.2.5&lang=en-US )


NOTE: This does not happen with 5.2.3.3 or 5.2.5.1.  (I had 5.2.3.3 installed for several months. Then recently upgraded to 5.3. Then once saw this bug installed (rolled back to) 5.2.5.1 to test and confirmed that this does not happen in 5.2.5.1).


How to demonstrate:

1) Open LO
2)   Select Base Database

3)     Create a new Database: Embedded database - HSQLDB Embedded
       (yes register, x open for editing, Finish)
       (save with a new name on Desktop)

4)       Create table in design view...
5)         Add `ID`, type: Integer (len 10), AutoValue=yes, Set Primary Key 
6)         Add `txt`, type: Text (Len 100, varchar)

7)       Close & Save 
*)     (Note: if I enter some data, it tests ok at this point.)

8)     Close (inner "x"), and select "Save"
       "New Database.odb" on Desktop, Ok
HANGS.


Note, two processes show in my task bar.  If I click on the other one I can see the screen where I selected Create a new database.  It is also frozen.

* Can click the outer "X" and after a moment select "Force Close".  This closes both tasks in my task bar.


System Monitor shows soffice.bin ???

==================================================
As near as I can tell I have the following installed:

Linux Kernel:	3.16.0-4-amd64

glibc2: 		2.19-18+deb8u7	(GNU C Library Shared libraries)
freetype:		2.5.2.3			(libfreetype6)
gtk:			3.14.5.1		(libgtk-3-0 GTK+ graphical user interface library)
Gnome:			2.32.1-5 		(libgnome-2-0 - runtime files)
Comment 1 Howard Johnson 2017-02-08 00:41:43 UTC
a) Set LO version for this bug, (now that it's version has been added to the Bugzilla version pulldown).

b) Possibly this bug is related to this other new 5.3.0.3 bug: https://bugs.documentfoundation.org/show_bug.cgi?id=105845

I just tested saving before closing, and this works ok.
But closing with changes, but without first saving hangs.
Comment 2 Robert Großkopf 2017-02-08 15:22:02 UTC
Could confirm this buggy behavior for internal HSQLDB. 
Created a table, saved. 
Saved database. 
Added a new field to the table, saved.
Close the database and answer to the appearing dialog: Yes, please save.

LO hangs.
Tested with LO 5.3.0.3, 64bit rpm Linux (OpenSUSE 42.1)
Comment 3 Howard Johnson 2017-05-24 16:11:19 UTC
I retested on 5.3.3.2 and this bug is gone.