Bug 104316 - FIREBIRD 3 : attempting to open a Firebird 3 embedded ODB database file fails to draw all UI elements, causes general LibreOffice UI malfunction
Summary: FIREBIRD 3 : attempting to open a Firebird 3 embedded ODB database file fails...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: All macOS (All)
: highest critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
 
Reported: 2016-12-01 09:05 UTC by Alex Thurgood
Modified: 2017-06-27 08:56 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
UI on ODB file load (28.67 KB, image/png)
2016-12-01 09:06 UTC, Alex Thurgood
Details
Screenshot when running Lodev under lldb (94.05 KB, image/png)
2016-12-21 11:58 UTC, Alex Thurgood
Details
lldb session output with bt (45.53 KB, text/plain)
2016-12-21 12:00 UTC, Alex Thurgood
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alex Thurgood 2016-12-01 09:05:25 UTC
Description:
I attempted to open the ODB file mentioned in bug 104227 :

https://bugs.documentfoundation.org/attachment.cgi?id=129051

Upon loading of the file, the test file fails to draw any UI elements other than a grey application window and the two white background window frames, per attached screenshot...

In addition, the remaining UI of the application becomes unresponsive to mouse clicks or keyboard activation. The only way to regain control is to force kill the application.

Steps to Reproduce:
1. Open ODB file indicated in description


Actual Results:  
See description

Expected Results:
Access and functionality to all usual UI objects should be possible. Currently, no work is possible with the embedded Firebird 3 ODB


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:50.0) Gecko/20100101 Firefox/50.0
Comment 1 Alex Thurgood 2016-12-01 09:06:15 UTC
Created attachment 129179 [details]
UI on ODB file load
Comment 2 Julien Nabet 2016-12-01 09:09:54 UTC
Just for information, I can't test anything about Base because of tdf#103667
I can't open or create Base file (Hsqldb or Firebird).
Comment 3 m_a_riosv 2016-12-01 23:25:53 UTC
I can open and edit tables, but not create a new one, all task are greyed out for tables, queries, forms and reports.

Version: 5.3.0.0.alpha1+
Build ID: 172325bedf69bbc162f3c1948264451c90c105a3
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-11-21_05:26:40
Locale: es-ES (es_ES); Calc: group
Comment 4 Robert Großkopf 2016-12-03 07:55:51 UTC
Tested this with
Version: 5.4.0.0.alpha0+
Build ID: 150afc29c951d5fc9c40ff8a72f5178c32383f8c
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-12-03_01:02:49
Locale: de-DE (de_DE.UTF-8); Calc: group

Couldn't reproduce with OpenSUSE 42.1 64bit rpm Linux.
Comment 5 Julien Nabet 2016-12-04 11:13:11 UTC
On macOS 10.12.1 with master sources updated yesterday, I could give a try after having disabled autorecovery (which makes LO crash)
I don't reproduce the problem.
Comment 6 Alex Thurgood 2016-12-05 10:00:12 UTC
(In reply to Julien Nabet from comment #5)
> On macOS 10.12.1 with master sources updated yesterday, I could give a try
> after having disabled autorecovery (which makes LO crash)
> I don't reproduce the problem.

Hi Julien,

Yes, disabling the autosave feature enabled me to open the file and tables. So, this behaviour is linked to bug 104227, in which case, I shall try it again (with autosave re-activated, after I have rebuilt from master.
Comment 7 Julien Nabet 2016-12-20 19:16:57 UTC
Alex: any update about this tracker?
I think that if it works with autorecovery disabled, it means that the pb is only tdf#103515.
Comment 8 m_a_riosv 2016-12-20 23:21:01 UTC
Comment#3 issue doesn't happen now with:
Version: 5.4.0.0.alpha0+
Build ID: 2e9c02feca732f6dd012ccbe5d7c6853c64075a5
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-12-20_00:19:54
Locale: es-ES (es_ES); Calc: CL
Comment 9 Alex Thurgood 2016-12-21 11:38:51 UTC
@Julien : still a problem for me on OSX when I re-activate autosave on

LibreOfficeDev 5400alpha0+
BuildID: e34cf2adc385d1b04e36e1fdb80cfaced1b7dee5
CPU Threads: 2; OS Version: Mac OSX 10.12.1; UI Render: default; Locale: fr-FR (fr_FR.UTF-8); Calc: group

If the StartCenter is already open and displaying on screen and I try to open a FB3 file from the recent file list, nothing happens - no ODB file is loaded, the StartCenter dialog becomes unresponsive.

I can however force reload or refresh the app by opening the same file via the LibreOffice File > Recent menu - this then swaps the StartCenter window for the Base window, however, that window is now non-responsive to mouse clicks or key strokes.

Attempting to quit LibreOffice via the menu fails, nothing happens.
Comment 10 Alex Thurgood 2016-12-21 11:41:14 UTC
If I drag and drop the ODB file directly onto the LO app icon in the OSX Dock, the Base window frame gets drawn incompletely, the same as in the attached file I had already posted.
Comment 11 Alex Thurgood 2016-12-21 11:43:04 UTC
De-activating autosave again, and restarting LO allows me to open the FB3 ODB file correctly once more.
Comment 12 Alex Thurgood 2016-12-21 11:51:08 UTC
Note that I'm using a debug-enabled build
Comment 13 Alex Thurgood 2016-12-21 11:58:07 UTC
Created attachment 129842 [details]
Screenshot when running Lodev under lldb
Comment 14 Alex Thurgood 2016-12-21 11:59:04 UTC
I took a screenshot of what the app looks like when running under lldb when it attempts to draw various UI elements of the FB3 ODB file with autosave turned off.
Comment 15 Alex Thurgood 2016-12-21 12:00:49 UTC
Created attachment 129843 [details]
lldb session output with bt
Comment 16 Alex Thurgood 2016-12-21 12:01:44 UTC
Also enclosed a bt of the lldb session - the mutex yield dbg assert is there, but there appear to be other problems.
Comment 17 Julien Nabet 2017-01-25 09:44:35 UTC
Alex: could you give an update with autosave enabled?
The daily build you use must contain https://cgit.freedesktop.org/libreoffice/core/commit/?id=b2c467e47f438b2011aa304cca9bf403eaa1c8e2
Comment 18 Alex Thurgood 2017-01-25 16:22:49 UTC
With 

Version: 5.4.0.0.alpha0+
Build ID: 40fb49446b456459a4cdfa6fff0013b7ffef82e8
CPU Threads: 2; OS Version: Mac OS X 10.12.2; UI Render: default; 
Locale: fr-FR (fr_FR.UTF-8); Calc: group

debug build,

the test file doesn't even load any more, when AutoSave is turned on, I just see the StartCenter with the grey background indicating that I've clicked the file to load it. I have to force quit the application, none of the menus respond.

If I ignore the StartCenter (e.g. close it) and then drag and drop the test file onto the LO icon in the Dock, again, nothing happens, the file doesn't load, and I'm left with a running LO application in an indeterminate state. If I then repeat the drag and drop maneuver, I get the same incomplete UI of the main Base app window as obtained previously and shown with my screenshot.
Comment 19 Julien Nabet 2017-01-25 16:40:03 UTC
(In reply to Alex Thurgood from comment #18)
>... 
> the test file doesn't even load any more, when AutoSave is turned on, I just
> see the StartCenter with the grey background indicating that I've clicked
> the file to load it. I have to force quit the application, none of the menus
> respond.
>...
Ouch!

Any chance for a new stacktrace to see if it's still the same.
Comment 20 Julien Nabet 2017-01-29 10:28:15 UTC
On MacOs 10.12.2, with master sources updated 2 days ago and autorecovery enabled, I could open the file and opened the tables.

My autogen.input contains this:
--enable-debug
--enable-werror
--enable-dbgutil
--with-lang=en-US it fr de es pt ru cs hu pl nl
Comment 21 Alex Thurgood 2017-06-27 08:56:34 UTC
Confirmed working correctly for me in

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

Closing