Bug 139520 - LO base (HSQLDB & FIREBIRD): crashes frequently during creation and editing a report design
Summary: LO base (HSQLDB & FIREBIRD): crashes frequently during creation and editing a...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.0.3.1 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-09 20:37 UTC by Richard Demattio
Modified: 2021-07-07 11:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature: 06329a44-d60b-477e-be25-497149ad079b


Attachments
the database producing the crashes (11.36 KB, application/vnd.oasis.opendocument.database)
2021-01-09 20:39 UTC, Richard Demattio
Details
The database to the comment 5 (I discarded the recovery) (7.46 KB, application/vnd.oasis.opendocument.database)
2021-01-30 22:05 UTC, Richard Demattio
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Richard Demattio 2021-01-09 20:37:48 UTC
Description:
not really reproducable! 06329a44-d60b-477e-be25-497149ad079b
but very unstable! 
it crashes very often also with simple design steps

when doing the design steps, described below - no matter in which sequence - 
it needs only some minutes until to the crash


Steps to Reproduce:

open Report builder in design view
open report navigator
open properties
add a field
select a field and its label
move them left and right and resize or change other attributes
select another field and change something too
jump out to somewhere in the area of the report design window
save and close 


resize and reposition it more often than once

Actual Results:
after crash everything is lost back to the last save operation
No impact to data, Tables, queries and forms

Expected Results:
stable report design mode


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.0.3.1
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: de-AT (en_US.UTF-8); UI: en-US
Calc: threaded
=========================================================
System:    Kernel: 5.8.0-36-generic x86_64 bits: 64 compiler: N/A Desktop: Cinnamon 4.6.7 
           wm: muffin dm: LightDM Distro: Linux Mint 20 Ulyana base: Ubuntu 20.04 focal 

Machine:   Type: Virtualbox System: innotek product: VirtualBox v: 1.2 serial: <filter> 
           Chassis: Oracle Corporation type: 1 serial: <filter> 
           Mobo: Oracle model: VirtualBox v: 1.2 serial: <filter> BIOS: innotek v: VirtualBox 
           date: 12/01/2006 

CPU:       Topology: Quad Core model: Intel Core i5-4570S bits: 64 type: MCP arch: Haswell rev: 3 
           L2 cache: 6144 KiB 
           flags: avx avx2 lm nx pae sse sse2 sse3 sse4_1 sse4_2 ssse3 bogomips: 23199 
           Speed: 2900 MHz min/max: N/A Core speeds (MHz): 1: 2900 2: 2900 3: 2900 4: 2900 

Graphics:  Device-1: VMware SVGA II Adapter driver: vmwgfx v: 2.18.0.0 bus ID: 00:02.0 
           chip ID: 15ad:0405 
           Display: x11 server: X.Org 1.20.9 driver: vmware unloaded: fbdev,modesetting,vesa 
           resolution: 1920x1014~60Hz 
           OpenGL: renderer: SVGA3D; build v: 2.1 Mesa 20.2.6 direct render: Yes
Comment 1 Richard Demattio 2021-01-09 20:39:52 UTC
Created attachment 168804 [details]
the database producing the crashes
Comment 2 Richard Demattio 2021-01-12 21:06:52 UTC
The bugs "Bug 138108" and "Bug 137016" are coming into my mind.

-> exiting the report design without saving the whole database makes the crash happen more often than saving all before exiting

--> selecting both Label field and value field and moving them makes the crash happen more often too

--> but nevertheless: the crashes are coming accitdntally too
Comment 3 Richard Demattio 2021-01-13 09:21:29 UTC
new finding:
the instability comes from working with mouse!

Manipulating the attributes by entering values into the properties dialog is stable.

Nevertheless: saving the report changes and then the whole database is necessary.
Otherwise there is again the risk of a crash.

Also when klicking from the properties dialog to somewhere outside produces crashes very often.
Comment 4 Richard Demattio 2021-01-30 21:39:31 UTC
I continue producing crashes when moving fields in reports with mouse.

It happens more frequently when I select two fields and try to move them with mouse
The report: a981da97-b521-4fa8-b823-67f99f74aafe
Comment 5 Richard Demattio 2021-01-30 22:01:30 UTC
I created a HSQLDB from scratch (I will send it as attachment)
I created the table from the suggestion
I created the report with the wizard
After saving I entered editing mode again and only resized two fields and moved them back and forward, up and down for a few minutes.

I also moved them over the borders between for example header and details

Here is the crash. 	8a513d7d-0c7c-47be-96cf-79ce25753a15
Comment 6 Richard Demattio 2021-01-30 22:05:05 UTC
Created attachment 169314 [details]
The database to the comment 5 (I discarded the recovery)
Comment 7 Xisco Faulí 2021-02-05 10:11:44 UTC
Hello Richard,
Thanks for reporting this issue. it might be a duplicate of bug 138108.
Could you please try again with LibreOffice 7.0.4.2 ?
Comment 8 Richard Demattio 2021-02-05 11:05:31 UTC
(In reply to Xisco Faulí from comment #7)
Maybe, but Bug 138108 happened during Forms design and this Bug happens during Reports design.

The good news: After crash, nothing is destroyed what I did before last saved.

I tried with 7.1 and 7.2 and I am already working with
Version: 7.0.4.2
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: de-AT (en_US.UTF-8); UI: en-US
Calc: threaded

I succeeded again, producing the crash.

In report design mode 
I had the navigator popup open and also the properties window open.
The I resized a field and moved it back and forth.

After this I klicked the close icon (the X)" in the right corner of the design window.
Now the popup asked me, If I want to save or cancel or close.
I selected "save"
--> and crash

crashreport.libreoffice.org/stats/crash_details/0da90c9c-3472-41b6-98f6-5bdcc672a510

A question: can this be related to the Java Version I am using?
I have selected in options / advanced:
 .> use java runtime environment enabled
 -> /usr/lib/jvm/java-14-openjdk-amd64 (OS: Linux Mint)
 -> experimental features enabled
 -> macro recording enabled
Comment 9 Alex Thurgood 2021-02-05 11:33:18 UTC
For what its worth, testing with 

Version: 7.0.3.1
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

I can not reproduce a crash.
Comment 10 Richard Demattio 2021-03-08 18:57:14 UTC
I changed the the JRE from 14.0.2 to 11.0.10.
I can no longer force the frequent crashes.

Now I upgraded LO to 7.1 and also in this release I can not force the crashes.

So I suggest to close this Bug report
--------------------------------------

and I will open a new one as soon as I am able to find reproducable sequences leading to a crash.
Comment 11 QA Administrators 2021-03-09 03:44:50 UTC Comment hidden (obsolete)
Comment 12 Xisco Faulí 2021-07-07 11:09:54 UTC
(In reply to Richard Demattio from comment #10)
> I changed the the JRE from 14.0.2 to 11.0.10.
> I can no longer force the frequent crashes.
> 
> Now I upgraded LO to 7.1 and also in this release I can not force the
> crashes.
> 
> So I suggest to close this Bug report
> --------------------------------------
> 
> and I will open a new one as soon as I am able to find reproducable
> sequences leading to a crash.

Thanks for the feedback.
Closing as RESOLVED WORKSFORME