The officially official Devuan Forum!

You are not logged in.

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

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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:

TIA

Offline

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

delgado
Member
Registered: 2022-07-14
Posts: 210  

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

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.

Offline

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

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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.

Offline

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

stargate-sg1-cheyenne-mtn
Member
Registered: 2023-11-27
Posts: 172  

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

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).


Be Excellent to each other and Party On!
https://www.youtube.com/watch?v=rph_1DODXDU
https://en.wikipedia.org/wiki/Bill_%26_Ted%27s_Excellent_Adventure
Do unto others as you would have them do instantaneously back to you!

Offline

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

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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 …

  1. Restarted my computer

  2. Checked that there were no lock-files in the ~/Python directory

  3. Took a deep breath

  4. 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

Offline

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

stargate-sg1-cheyenne-mtn
Member
Registered: 2023-11-27
Posts: 172  

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

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


Be Excellent to each other and Party On!
https://www.youtube.com/watch?v=rph_1DODXDU
https://en.wikipedia.org/wiki/Bill_%26_Ted%27s_Excellent_Adventure
Do unto others as you would have them do instantaneously back to you!

Offline

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

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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.

Offline

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

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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.

Offline

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

Ron
Member
Registered: 2018-04-22
Posts: 523  

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

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)

Offline

#10 Yesterday 00:34:40

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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.

Offline

#11 Yesterday 01:26:24

prospero
Member
Registered: 2023-03-26
Posts: 38  

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

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.

Offline

#12 Yesterday 02:38:03

zapper
Member
Registered: 2017-05-29
Posts: 967  

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

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...

tongue


Freedom is never more than one generation away from extinction. Feelings are not facts
If you wish to be humbled, try to exalt yourself long term  If you wish to be exalted, try to humble yourself long term
Favourite operating systems: Hyperbola Devuan OpenBSD
Peace Be With us All!

Offline

#13 Yesterday 10:01:04

PedroReina
Member
From: Madrid, Spain
Registered: 2019-01-13
Posts: 269  
Website

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

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.

Offline

#14 Yesterday 11:09:42

Babarosa
Member
Registered: 2024-09-14
Posts: 3  

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

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)


Ad aspera ad astra

Offline

#15 Yesterday 14:53:13

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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.

Offline

#16 Yesterday 15:17:09

rolfie
Member
Registered: 2017-11-25
Posts: 1,166  

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

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)

Offline

#17 Yesterday 15:40:21

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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)

Offline

#18 Yesterday 16:32:50

rolfie
Member
Registered: 2017-11-25
Posts: 1,166  

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

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

Offline

#19 Yesterday 19:23:57

Babarosa
Member
Registered: 2024-09-14
Posts: 3  

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

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)


Ad aspera ad astra

Offline

#20 Yesterday 22:37:02

alexkemp
Member
Registered: 2018-05-14
Posts: 347  

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

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:

  1. cd /usr/local/bin

  2. sudo wget https://appimages.libreitalia.org/Libre … 4.AppImage

  3. sudo mv LibreOffice-fresh.standard-x86_64.AppImage LibreOffice-24.8.AppImage

  4. sudo chmod a+x LibreOffice-24.8.AppImage

  5. LibreOffice-24.8.AppImage --help
    LibreOffice 24.8.2.1 0f794b6e29741098670a3b95d60478a65d05ef13

  6. sudo cp /usr/share/applications/libreoffice-startcenter.desktop /usr/share/applications/loappimage-startcenter.desktop

  7. 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)

Offline

Board footer