[SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

alexkemp · 2024-11-04 13:40:53

Somehow, I've created a feral beast that does not like Devuan.

Program bugs are one thing, but finding that your desktop freezes & nothing will work, just because you have loaded up an .odt is another experience. I'm used to this from 15 years ago with Windows, of course.

I'm perfectly serious. Is there anyone out there with the tools to be able to analyse a LO file to discover how on earth it is causing the entire desktop to freeze up?

The one clue that I have is that it may involve Frames, which seemed to be involved in every bug that I came across as I tried to add page-links into this document.

All the raw files have been placed into a GitHub repository:

https://github.com/alexkemp9/Python3docs

TIA

delgado · 2024-11-04 20:57:13

Not sure whether the following is connected... .
Today, I had a uniq experience with 'LibreOfiice Calc' on a remote mashine. It killed the whole vnc-server-session when opening a document - three times in a row, then I gave up.
server: debian bookworm, running tightvncserver and libreoffice calc
client: devuan excalibur, running xtightvncviewer

At least there are similarities.
And the supplied document from github does not freeze my desktop.

alexkemp · 2024-11-04 22:19:02

delgado wrote:

the supplied document from github does not freeze my desktop

We are talking 3_new.odt, yes?

Argh!! I'm going to wait until the morning before I retry that. I could not stand my system freezing up again.

stargate-sg1-cheyenne-mtn · 2024-11-05 07:25:31

did a DDG search for "libre office" calc maximum file size and looked at a few.

https://superuser.com/questions/1560674/the-maximum-number-of-columns-per-sheet-was-exceeded

https://www.linuxquestions.org/questions/linux-newbie-8/libre-calc-exceeding-limit-4175533609/

https://forums.linuxmint.com/viewtopic.php?t=341762

did an additional DDG search for "libre office" writer maximum file size

https://ask.libreoffice.org/t/is-there-a-maximum-number-of-pages-in-libre-office-writer-also-is-there-a-limit-in-the-number-of-rows-and-columns-when-inserting-a-table-in-lo-writer/8750

don't know how "writer" differs from "calc" in LibreOffice, not to mention all the other variables with version(s) number(s) as well as dependencies and such(can be a deep hole excavating to find the bug and/or limitations).

alexkemp · 2024-11-05 12:11:29

delgado wrote:

the supplied document from github does not freeze my desktop
alexkemp wrote:
I'm going to wait until the morning before I retry that.

Well, good news/bad news.

This morning I …

Restarted my computer
Checked that there were no lock-files in the ~/Python directory
Took a deep breath
Opened ~/Python/3_new.odt as only app

… and the computer did not freeze.

I kept watching for ~2 seconds, then realised that LibreOffice (LO) had frozen. I could move the mouse, but LO did not respond to any actions (no page movement, no scroll).

I tried closing LO from the desktop screen & got the "This program is not responding" message & asked for it to be closed down.

This is almost the identical behaviour that I experienced with 2_scratch.odt that caused me to try to reformat it as 3_new.odt. There is clearly some kind of issue inside the 2nd + 3rd ODT causing them to freeze. I wish that I knew where to start to find out precisely what.

The kernel has upgraded from 6.1.0-26 to 6.1.0-27 since I had the System freeze with 3_new.odt. Maybe that is a reason that my system is now safe from LO attack!

Well, many thanks to delgado for testing it out. I have a horrible feeling that I am now stuck with an untenable ODT.

In response to stargate: there are a number of Tables in this Writer document, but each is very small. There should not be any problem with a 700-page document (I sincerely hope).

The physical machine has 8 GiB of physical memory. That was a lot when I bought it, and is trivial now, of course, but together with swap-space on the HDD should be enough:

$ sudo lshw -C memory -short
[sudo] password for alexk: 
H/W path       Device      Class       Description
==================================================
/0/0                       memory      64KiB BIOS
/0/14                      memory      8GiB System Memory
/0/14/0                    memory      SODIMM DDR3 [empty]
/0/14/1                    memory      8GiB DIMM DDR3 Synchronous Unbuffered (Unregistered) 800 MHz (1.2 ns)
/0/1a                      memory      256KiB L1 cache
/0/1b                      memory      2MiB L2 cache

stargate-sg1-cheyenne-mtn · 2024-11-05 15:15:33

this post(from within one of the earlier mentioned threads) describes a file taking 8 minutes to load initially.

https://forums.linuxmint.com/viewtopic.php?p=1965711&#p1965711

alexkemp · 2024-11-05 15:57:45

Thanks stargate, I'll pay attention to that & discover whether it will become responsive again (if so, perhaps the no-Contents production was an identical issue).

However, all that will have to take a back-seat. I've got pressing issues coming up shortly, and will have to attend to those first.

alexkemp · 2024-11-05 19:30:11

I couldn't wait, so asked LO to start 3_new.odt, started my smartphone stopwatch & waited.

There are 4 cores in my Desktop machine, and I noted that one of them was 100% occupied all the time. Just once across the next 25 minutes I noted that processing had switched to a different core.

I had decided that I was willing to give it 25 minutes.

Too often I've been in situations where a process has gotten stuck & I could have waited for eternity & never had obtained satisfaction. This seemed like one of those.

After 25 minutes I force-closed it.

Thanks stargate, but I do not think that waiting for startup is any fix for this one.

Ron · 2024-11-05 21:13:31

I seem to recall that when I had funky files like this in Windows, what I would do was open it up, then do a copy/paste, and paste it into a new document and save. Then discard the original. Not sure it would work for your problem or not, or if you would even have time to do it before it freezes.

Last edited by Ron (2024-11-05 21:18:48)

alexkemp · Yesterday 00:34:40

Hi Ron.

Couple of things:

No time to do the copy/paste before LO freezes
One of the bugs I found (listed at the bottom of GitHub) is that Tables encapsulated in a Frame are missed on a Copy. So it wouldn't even transfer accurately if I could copy/paste.

prospero · Yesterday 01:26:24

The LO window also freezes here after 5-10 seconds when I try to open 3_new.odt. Older kernel (5.15) and later LO (24.8), same system memory (8 GiO). So the devil really is in the details of the odt.

If you could overcome the Table-in-a-Frame copying bug, you may still have a chance to recover its content: if I keep scrolling along for about 20+ seconds, the beast eventually get tamed and I am able to get a reasonably pliant document. I also get one core running at 100% once the window has frozen, but the situation is not much better after taming the beast. It is still a wild beast after all, even if a tamed one.

zapper · Yesterday 02:38:03

I have only had maybe one time where ODT crashed in libreoffice writer or focuswriter.

I had formatted it in one of those and then made edits in abiword.

Big mistake...

PedroReina · Yesterday 10:01:04

Out of curiosity, I opened the file https://github.com/alexkemp9/Python3doc … /3_new.odt in my oooold Debian 7 (32 bits) box:

LibreOffice: 5.0.0.5
cat /etc/debian_version => 7.11
uname -srm => Linux 3.2.0-6-686-pae i686

It worked: no freezzes, no problems, fast loading times.

Babarosa · Yesterday 11:09:42

Hi there!

Here on Devuan 5 Xfce 64 bit with Libre Office 7.6.7.2 there are no problems with this document so far.
LO 7.6.7.2 is the latest version which doesn't need to install additionally python.

EDIT: typed wrong version of LO

Last edited by Babarosa (Yesterday 12:03:20)

alexkemp · Yesterday 14:53:13

Hi Babarosa.

Your post is the most hopeful for me so far.

I've tried "apt search libreoffice" & absolutely everything that came up is 7.4.7 (same as I currently have).

How did you install 7.6.7? Is it installed concurrent with 7.4.7 or instead of?

It sounds crazily ironic that v5.0.0 & v7.6.7 both can open this ODT yet v7.4.7 freezes solid.

rolfie · Yesterday 15:17:09

Well, 7.4.7 is what is available in Daedalus main/security. Daedalus backports has 24.8.2. You might give that a try.

7.6.7 only is available as direct download from https://downloadarchive.documentfoundat … ffice/old/. If you do not trust the backports version, that would be an alternative. If you want I can describe what you need to do to remove 7.4.7 and to install 7.6.7.

Last edited by rolfie (Yesterday 15:17:23)

alexkemp · Yesterday 15:40:21

rolfie wrote:

Daedalus backports has 24.8.2

OK, now I'm confused.

That is why I did an 'apt search', so that I could get advised of the range of different LO versions available. And it only offered me 7.4.7. Yet I've already got backports in my listing:

$ grep ^[^#] /etc/apt/sources.list /etc/apt/sources.list.d/*
/etc/apt/sources.list:deb http://deb.devuan.org/merged daedalus                  main non-free-firmware non-free contrib
/etc/apt/sources.list:deb http://deb.devuan.org/merged daedalus-updates          main non-free-firmware non-free contrib
/etc/apt/sources.list:deb http://deb.devuan.org/merged daedalus-security         main non-free-firmware non-free contrib
/etc/apt/sources.list:deb http://deb.devuan.org/merged daedalus-proposed-updates main non-free-firmware non-free contrib
/etc/apt/sources.list:deb http://deb.devuan.org/merged daedalus-backports        main non-free-firmware non-free contrib
/etc/apt/sources.list.d/josm.list:deb https://josm.openstreetmap.de/apt/ alldist universe

I run an update every day, but I've never been offered 24.8.2.

So, how would I tell it to update from backports (or have I pinned it somehow)?

Added later:

I've looked at the search listing (which is huge) more closely & have discovered a number of bpo, but the main element appears missing. Here is the closest:

libreoffice-uiconfig-writer/stable-backports 4:24.8.2-1~bpo12+1 all
UI data ("config") for LibreOffice Writer

What I mean by 'main element' is a straightforward "libreoffice-writer" etc, which is present for 7.4.7 but not 24.8.2. I think that an error has been made.

I think that I shall try to install an AppImage & pray that there are no systemD viruses tucked in there.

Last edited by alexkemp (Yesterday 15:53:05)

rolfie · Yesterday 16:32:50

I use

# apt list libreoffice*

There the backports packages are present. The solution for the complete package is e.g. libreoffice-gtk4 or libreoffice-qt6. There are no single packages for writer.

Anyhow: nothing from backports is installed automagically. Pinning makes sure backports doesn't have highest prio. If you want to install something from backports, you need to specify that by using:

# apt -t daedalus-backports install $Packagename

Babarosa · Yesterday 19:23:57

Hi alexkemp!

I download LO 7.6.7.2 from here:
https://downloadarchive.documentfoundat … 6.7.2/deb/

Decide if you need x86 or x64 (the latest working version for x86 is 6.2.8.2).
You need the main package and the language file, maybe you also like the help file.

First unpack the main package to your home folder.
In a terminal enter:
cd Libre*
cd DEBS
sudo dpkg -i *.deb
delete the folder Libre... (because the other packages also start with the name Libre...)

Next unpack the language package to your home folder.
Repeat the former commands by using your keyboard's up cursor.
cd Libre*
cd DEBS
sudo dpkg -i *.deb
delete the folder Libre... (because the other packages also start with the name Libre...)

Finally unpack the help package to your home folder.
In a terminal enter:
cd Libre*
cd DEBS
sudo dpkg -i *.deb
delete the last final folder Libre...

Then LO should appear as several starters in your menu bar.

Last edited by Babarosa (Yesterday 19:30:03)

alexkemp · Yesterday 22:37:02

Thanks to rolfie & Babarosa for your responses.

I decided to go with an AppImage since that offered the opportunity to use a later version without changing any of the currently installed LO elements. It turned out to be not so much of a success (and then more of a success, see below).

I went through the following steps:

cd /usr/local/bin
sudo wget https://appimages.libreitalia.org/Libre … 4.AppImage
sudo mv LibreOffice-fresh.standard-x86_64.AppImage LibreOffice-24.8.AppImage
sudo chmod a+x LibreOffice-24.8.AppImage
LibreOffice-24.8.AppImage --help
LibreOffice 24.8.2.1 0f794b6e29741098670a3b95d60478a65d05ef13
sudo cp /usr/share/applications/libreoffice-startcenter.desktop /usr/share/applications/loappimage-startcenter.desktop
sudo nano /usr/share/applications/loappimage-startcenter.desktop
(I changed the .desktop name + all Exec lines to begin /usr/local/bin/LibreOffice-24.8.AppImage, but pretty much every else was left unchanged)

The new launch link was immediately within menu:Office | LO AppImage Start Centre & showed the correct LO version.

I launched 3_new.odt and GOOD LORD yes! I was able to navigate around the file & travel from top to bottom.

It was still troubling. LO was having problems with the page display at the bottom of the file. The number of pages showing in the Status Bar at bottom left, and also on each page, kept changing. In addition, Figure 15.1 (it is an image & can be viewed safely in the PDF) kept appearing at the top of the bibliography & also other pages, each one well out of place.

Since it seemed stable I asked for the file to be saved. Everything seemed fine & at a normal speed until almost at the very end, when LO & the screen froze. It stayed like that for some time & I had to force-close it. So, no change.

I did not make any changes to the file before saving.

2nd try:

Ran the whole thing again as to be able to discover the name of the image that kept appearing out of order near the bottom of the file (Fig 15.1) (it kept shifting in the display from page-to-page from moment to moment). I noticed that a single core (1 of 4) was active all the time. Also, that the LO version was GTK.

Then I noticed that the usage had dropped from 30% to a more-normal figure. I tried Save again & this time LO both saved it & also completed. I was able to shut the program down normally.

Whoo-hah! This version of LO is hardly working the way that it is supposed to with an ODT, but it seems that I may have use of the file back again, so many thanks to all who responded.

The following pages were also of assistance:

Last edited by alexkemp (Yesterday 22:40:33)

The officially official Devuan Forum!

#1 2024-11-04 13:40:53

[SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#2 2024-11-04 20:57:13

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#3 2024-11-04 22:19:02

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#4 2024-11-05 07:25:31

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#5 2024-11-05 12:11:29

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#6 2024-11-05 15:15:33

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#7 2024-11-05 15:57:45

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#8 2024-11-05 19:30:11

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#9 2024-11-05 21:13:31

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#10 Yesterday 00:34:40

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#11 Yesterday 01:26:24

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#12 Yesterday 02:38:03

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#13 Yesterday 10:01:04

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#14 Yesterday 11:09:42

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#15 Yesterday 14:53:13

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#16 Yesterday 15:17:09

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#17 Yesterday 15:40:21

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#18 Yesterday 16:32:50

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#19 Yesterday 19:23:57

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

#20 Yesterday 22:37:02

Re: [SOLVED] A Libreoffice Writer ODT that Crashes the Devuan Desktop

2nd try:

Board footer