Page 1 of 1

Unstable LibreOffice under Ubuntu and Windows 7 Pro

PostPosted: Mon Feb 04, 2019 4:09 am
by dreamquartz
Hello All,

I am experiencing problems with HSQLDB, being unstable.
Working with a DataBase, LO suddenly and with no reason, freezes, and I can only kill the process.
This happens while doing anything with the DataBase, either running/writing a Query, entering data, or even opening/viewing a table.

This happens way more with Windows 7 Pro than with Ubuntu 16.04.

Does anyone know more about this?

Thanks in advance,

Dream

Re: Unstable LibreOffice under Ubuntu and Windows 7 Pro

PostPosted: Sun Jun 23, 2019 6:41 am
by Zizi64
And what about the other applications. Can they run stable on your PC?

We (at my workplace) are using the Calc, Writer, Draw and sometimes the Impress of the LO 4.4.7 x86 and LO 6.1.6 x64, but we never use the Base.
All of the installed and used LibreOffice applications are very stable on our Win7 Pro x64 and Win 10 Pro x64. We have not any Linux PC.

Re: Unstable LibreOffice under Ubuntu and Windows 7 Pro

PostPosted: Sun Jun 23, 2019 8:35 am
by RoryOF
OO 4 is stable on my computers running 64 bit Xubuntu 18.04.2 (and earlier versions of Xubuntu); I do not run Base or an OO related database.

Re: Unstable LibreOffice under Ubuntu and Windows 7 Pro

PostPosted: Sun Jun 23, 2019 6:05 pm
by UnklDonald418
In my experience on computers running both Windows 10 Pro and Home versions, the Base and Impress modules experience far fewer "unexplained" crashes when using OO 4 than using LO.
I suppose it is up to us to identify what conditions lead up to those "unexplained" crashes before we can expect the developers to look for a solution.

Re: Unstable LibreOffice under Ubuntu and Windows 7 Pro

PostPosted: Sun Jun 23, 2019 6:21 pm
by Villeroy
AOO crashes and freezes every time I focus a form's grid control until I switch from X11 display server to the new (and still experimental) Wayland display server. But then AOO crashes because of issues with floating toolbars. I stopped using AOO on LInux because its Base component is not usable.
https://bz.apache.org/ooo/show_bug.cgi?id=127710

I have no issues with LO 6.x on Ubuntu 16.4 nor 18.4.
16.4. came with LiberOffice 5.x which should be the one to use by default. Nothing wrong with that version.

The main problem with Base and HSQL is that HSQL is embedded. Same problem with embedded Firebird or embedded anything. If you want a stable database setup, you should use the distributors office suite and convert your embedded database to external HSQL2 when the tables, relations and indices are production ready.
[Python] Macro to extract and reconnect embedded HSQLDB

Re: Unstable LibreOffice under Ubuntu and Windows 7 Pro

PostPosted: Wed Jul 24, 2019 7:01 pm
by dreamquartz
Zizi64 wrote:And what about the other applications. Can they run stable on your PC?

We (at my workplace) are using the Calc, Writer, Draw and sometimes the Impress of the LO 4.4.7 x86 and LO 6.1.6 x64, but we never use the Base.
All of the installed and used LibreOffice applications are very stable on our Win7 Pro x64 and Win 10 Pro x64. We have not any Linux PC.


Yes I can.
All of the LO programs will freeze. That means the suite is frozen when it happens.

Kill the suite is the only remedy for me.

Dream

Re: Unstable LibreOffice under Ubuntu and Windows 7 Pro

PostPosted: Wed Jul 24, 2019 7:05 pm
by dreamquartz
Villeroy wrote:AOO crashes and freezes every time I focus a form's grid control until I switch from X11 display server to the new (and still experimental) Wayland display server. But then AOO crashes because of issues with floating toolbars. I stopped using AOO on LInux because its Base component is not usable.
https://bz.apache.org/ooo/show_bug.cgi?id=127710

I have no issues with LO 6.x on Ubuntu 16.4 nor 18.4.
16.4. came with LiberOffice 5.x which should be the one to use by default. Nothing wrong with that version.

The main problem with Base and HSQL is that HSQL is embedded. Same problem with embedded Firebird or embedded anything. If you want a stable database setup, you should use the distributors office suite and convert your embedded database to external HSQL2 when the tables, relations and indices are production ready.
[Python] Macro to extract and reconnect embedded HSQLDB

I changed to split a long time ago thanks to your Python.

I use it all the time.

I am using the LO versions directly from LO.

The issues are there.

I can live with it.
Have build in security guards in the user policies.
A little cumbersome, but manageable.
There are less issues with Ubuntu 18.04 though.
Did have to move forward to Windows 10 Pro as well. Do not know what problems will arise, if any.

Dream