Bug 147982 - macOS: Monterey + Ventura 13.1 + LibreOffice 7.3 frequent crashes
Summary: macOS: Monterey + Ventura 13.1 + LibreOffice 7.3 frequent crashes
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-03-14 09:46 UTC by Alexander Van den Panhuysen
Modified: 2023-03-09 13:48 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
This screen appears when I want to reopen an closed and save Calc. (97.62 KB, image/png)
2022-03-14 09:50 UTC, Alexander Van den Panhuysen
Details
created file after crash of LibreOffice 7.5 dev (26.26 KB, text/plain)
2022-12-09 18:01 UTC, Alexander Van den Panhuysen
Details
Report of entrechek. (313.42 KB, image/png)
2022-12-13 11:58 UTC, Alexander Van den Panhuysen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Alexander Van den Panhuysen 2022-03-14 09:46:28 UTC
Description:
Every day I save and close a Calc, the next day when I want to open that same Calc, LibreOffice crashes. It is not better than with previous versions of LibreOffice.

Steps to Reproduce:
1. Work in a Calc workbook, save it and close it.
2. About a day later, double-click on that Calc workbook.
3. A screen appears saying that LibreOffice 7.3 crashes.

Actual Results:
A screen appears saying that LibreOffice 7.3 crashes, I have to click on the OK button to recover my Calc workbook.

Expected Results:
LibreOffice 7.3 should open my Calc workbook without any problem.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Mac OS X (All)
OS is 64bit: yes
Comment 1 Alexander Van den Panhuysen 2022-03-14 09:50:18 UTC
Created attachment 178874 [details]
This screen appears when I want to reopen an closed and save Calc.
Comment 2 m_a_riosv 2022-03-14 22:24:43 UTC
Please test with a clean profile, Menu/Help/Restart in Safe Mode
Comment 3 Alexander Van den Panhuysen 2022-03-15 06:47:06 UTC
I'm sorry, I do not understand:
1. What do you (and LibreOffice) mean by 'Profile'? Is that something I have to fill in when I launch LibreOffice for the first time?
2. When I click in the menu -> help on 'Restart in safe mode', a screen with many option-buttons appears, what is that all about? The first one: 'Restart from backup': what backup?... I choose the second one, the result: again recovering the file, but then LibreOffice was completely hanging! I needed to 'Force stop'.
Comment 4 m_a_riosv 2022-03-15 10:23:44 UTC
The profile, it's where LibreOffice saves your options.
In that menu follow in safe mode to verify if it works fine, if so, it's something with your configuration. Better restart it.
https://help.libreoffice.org/latest/en-US/text/shared/01/profile_safe_mode.html?DbPAR=SHARED#bm_id281120160951421436
Comment 5 Alexander Van den Panhuysen 2022-03-15 12:50:14 UTC
Unfortunately restarting via Safe Mode didn't solve a thing, I tried all possibilities, but my Calc workbook does not open without a recovery.
At last I did the following: instead of closing the Calc, I quit LibreOffice entirely (to do that on macOS it is needed to do command+Q Twice !).
A bit later launching LibreOffice, I can open my Calc workbook in a normal way.
Comment 6 QA Administrators 2022-03-16 03:59:01 UTC Comment hidden (obsolete)
Comment 7 Julien Nabet 2022-03-19 22:42:42 UTC
Do you use a Mac with Intel or Arm processor?
If you use Arm processor, you can try "Apple Silicon" version on https://www.libreoffice.org/download/download/ if it's not already the case.
Comment 8 Alexander Van den Panhuysen 2022-03-20 06:45:32 UTC
I am using using a MacBook Air form 2018, 1,6 GHz Dual-Core Intel Core i5.
Alexander
Comment 9 Alexander Van den Panhuysen 2022-03-20 06:54:29 UTC
Be aware too that the newest models of Apple computer do have the M1 Ultra processor, that is even something else and they will come to the market at the end of this month.
Alexander
Comment 10 Julien Nabet 2022-03-20 08:21:47 UTC
(In reply to Alexander Van den Panhuysen from comment #8)
> I am using using a MacBook Air form 2018, 1,6 GHz Dual-Core Intel Core i5.
> Alexander

Ok so I suppose you downloaded the by default version for macOS so Intel.
Comment 11 Julien Nabet 2022-03-20 08:22:47 UTC
(In reply to Alexander Van den Panhuysen from comment #9)
> Be aware too that the newest models of Apple computer do have the M1 Ultra
> processor, that is even something else and they will come to the market at
> the end of this month.
> Alexander

I know this and I suppose the situation is going to be worse since LO Apple Silicon version is not a stable one I think (I may be wrong).
Comment 12 Alex Thurgood 2022-03-28 10:07:57 UTC
@Alexander : if you are using 7.2.x or 7.3.0, turn off the Skia rendering options under Preferences > LibreOffice > General > View.


If you are using 7.3.1.x, these options should be turned off by default.
Comment 13 Alexander Van den Panhuysen 2022-03-28 10:20:58 UTC
The Skin rendering option is in the off state, I did not set it to on.
Comment 14 QA Administrators 2022-03-29 04:00:37 UTC Comment hidden (obsolete)
Comment 15 Alex Thurgood 2022-04-01 10:08:56 UTC
This seems to be yet another Macbook Air crasher bug.

@Alexander : I have a Macbook Pro Arm M1 and can't reproduce. At work, we also have an Intel macMini, and we have several Calc files that we open pretty much every day, make changes to it, save, and then re-open regularly. I'm not seeing the same amount of crashing as you are.

Is there anything particular about your Calc file ?

Do you have LO automatic file backup switched on (Preferences > Load/Save > Save Autorecovery information) ?

Do you have LO automatic upgrade version checking switched on (Preferences > Online Update)?
Comment 16 Alexander Van den Panhuysen 2022-04-01 10:46:10 UTC
Strange, it happens to me the hole time, with every Calc and now I checked a few .ODT file -> same problem :(
There is nothing special in my files, there is only data (tekst, numbers and dates) in it.
Automatic file backup is switched on, and automatic upgrade version checking is also switched on (ones a week).
Some weeks ago I copied my files to an other computer with Ubuntu 20.04 LTS native installed, that works so much better.
Question: is there a detailed procedure to remove LibreOffice entirely from my MacBook Air so I can try to install LibreOffice again from zero?
Comment 17 Julien Nabet 2022-04-01 11:17:34 UTC
Just to be sure, your files are on hard disk/SSD local and not on a network or on USB device?
Comment 18 Alexander Van den Panhuysen 2022-04-01 11:21:54 UTC
Yes, they are on the internal SSD, not outside the MacBook Air.
Comment 19 Alex Thurgood 2022-04-01 15:23:59 UTC
@Alexander : try switching off both automatic document saving and update verification and restart LO.
Comment 20 Alexander Van den Panhuysen 2022-04-01 16:43:20 UTC
I switched both off, quit LO and started up again, then when I opened an existing Calc, it opens without a problem, but then after having closed that Calc, again crashing.
Comment 21 QA Administrators 2022-04-02 04:50:34 UTC Comment hidden (obsolete)
Comment 22 Alex Thurgood 2022-04-02 11:59:54 UTC
Well some progress at least. 

Any accessibility tools running, eg, Voiceover ?
Comment 23 Francesc Rosés 2022-08-28 16:22:38 UTC
Hi, 

I have the same problem with Monterey (latest version) and Ventura (public beta 4).

I tried all possible solutions commented here without success.

I can reproduce the error doing a vertical scroll with the mouse wheel on an open document. The error does not appear if I use keyboard shortcuts to scroll.

Actually, LibreOffice is unusable in a Mac.

Best regards,

Francesc
Comment 24 Alexander Van den Panhuysen 2022-12-07 07:01:02 UTC
Excuse me, do you still need more info? I'm sure everything is explained in detail, I can not imagine what can be explained more.
Meanwhile I'm using fore some months LibreOffice 7.4, stil not working properly.
When will this be solved?
Comment 25 Alex Thurgood 2022-12-07 07:14:16 UTC
(In reply to Alexander Van den Panhuysen from comment #24)
> Excuse me, do you still need more info? I'm sure everything is explained in
> detail, I can not imagine what can be explained more.
> Meanwhile I'm using fore some months LibreOffice 7.4, stil not working
> properly.
> When will this be solved?

As we don't have a crash trace, we still don't know what is happening when it crashes. 

That said, a possibly similar problem was recently fixed in master branch 7.5 alpha, and this seems to have removed most of the deadlocking issues that were being seen. 

You could try a daily developer build, and report back.
Comment 26 steve 2022-12-07 21:47:03 UTC
Dev builds are here:
https://dev-builds.libreoffice.org/daily/master/current.html

Wondering if that still crashes for you.
Comment 27 Alexander Van den Panhuysen 2022-12-09 17:56:18 UTC
Now that I have installed LibreOffice 7.5 Dev, I expected it will work without a crash, but when I was doing 'Page down' by doing fn+downArrow in a Writer document, LibreOffice 7.5 suddenly crashed.
About two minutes later (after recovery), I could find a file newly created. I hope it is the report log.
Alexander
Comment 28 Alexander Van den Panhuysen 2022-12-09 18:01:59 UTC
Created attachment 184068 [details]
created file after crash of LibreOffice 7.5 dev
Comment 29 Alex Thurgood 2022-12-12 06:02:41 UTC
@Alexander : if you remove Yara, does it still crash ?

The crash log seems to show that Yara is being invoked, but I don't know whether that is because Yara interferes with LibreOffice, or whether Yara is flagging something that LibreOffice does as suspicious and then terminating the LO process.

I don't know how Yara works, and it is my understanding that this is not installed by default in macOS, but via HomeBrew ?
Comment 30 Alexander Van den Panhuysen 2022-12-12 07:03:38 UTC
Excuse me, "Yara"? Strange word! I searched on my computer but could not find a thing with that word. Then I searched the internet and apparently YaraScanService is part of the MRT.app (Malware Removal Tool), so perhaps this is the bad one.
I did do the following:
sudo launchctl stop com.apple.mrt
and
sudo launchctl remove com.apple.mrt
I let u know there is a change in how LibreOffice behave the next days.
Comment 31 steve 2022-12-12 14:41:46 UTC
Curious where this rabbit hole will take us and please do test with MRT disabled. Not sure about removing MRT as it is an important component of macOS which you certainly want running:
https://eclecticlight.co/2022/11/01/everything-you-need-to-know-about-xprotects-malware-protection/
Comment 32 Alexander Van den Panhuysen 2022-12-12 16:25:46 UTC
Grr!, even when i removed MRT, I opened an existing Calc, typed for 4 minutes 7 formulas in cells -> crashed again while I was typing the 8 formula.
Something is really ??? grr, I have no words for this! This time there is no crash log either.
The macOS version is Ventura 13.0.1.
Comment 33 Alex Thurgood 2022-12-12 22:39:26 UTC
Maybe try running etrecheck to see if that pinpoints any particular problems:

https://www.etrecheck.com/en/details.html

I notice from the previous trace that the processor seems to get overwhelmed. This seems to happen fairly frequently in low specced MacBook Air, and not just with LibreOffice, but LO isn't known for its particular performance efficiency on Mac, or memory management, so it could be any of these things, or a combination of them.
Comment 34 Alexander Van den Panhuysen 2022-12-13 11:58:48 UTC
Created attachment 184127 [details]
Report of entrechek.

This is a report of downloaded app entrecheck.
Comment 35 Alex Thurgood 2022-12-13 14:50:58 UTC
(In reply to Alexander Van den Panhuysen from comment #34)
> Created attachment 184127 [details]
> Report of entrechek.
> 
> This is a report of downloaded app entrecheck.


@Alexander : which kernel extensions has entrecheck identified as potentially obsolete ?

I'm still a bit confused about the previous crash report and all of the libcorecrypto calls involved - is FileVault enabled ?


There is a new protection mode available in Ventura, called Isolation mode - presumably, you have not activated this mode ?
Comment 36 Alex Thurgood 2022-12-13 14:53:53 UTC
One idea that might be worth a try would be to create a new user account on the Mac, just for testing purposes, and see whether you can still reproduce the crash described in comment 32, and whether or not you can get an Apple trace when that happens.
Comment 37 Alexander Van den Panhuysen 2022-12-14 18:10:34 UTC
Sorry responding a bit late, did have an illness, could not read much.
This afternoon, I noticed there was an update available for my MacBook Air (macOS 13.1), I installed it, started working again with a Calc, no crash (working half an our). Then i started with a new Writer document, everything fine the first 5 minutes, then in 4 minutes the Writer document crashed 5 times!
This is the end for me, I lost already to much time, way to much time, I make a copy of all my LibreOffice documents, my macro's etc... and work further with my Ubuntu computer.
Thanks for all your help, support and so on, but I don't try anymore in the next year.
Comment 38 QA Administrators 2022-12-15 03:21:14 UTC Comment hidden (noise)
Comment 39 Buovjaga 2022-12-15 13:10:43 UTC
Ok, then we have to close this.
Comment 40 adsloredanaricci 2023-02-28 11:51:49 UTC
buongiorno, ho un Arbook 2023 con Mac ventur. Ho installato LibreOffice 7.4 e 7.5 ma l'app va in CRASH dopo 3 minuti. Non salva i documenti (writer e calc) e devo fare uscita forzat. E' possibile risolvere?
Comment 41 Alex Thurgood 2023-02-28 12:28:17 UTC
adsloredanaricci

Please do not reopen this bug, which has been marked as fixed.

Please file a new bug report in English, detailing how to reproduce the crash, your hardware details, the macOS version, and provide any crash report.
Comment 42 Alexander Van den Panhuysen 2023-02-28 14:45:48 UTC
This goes on and on and on ...
It is already a few years that Calc and Writer crashes to a lot of people, and still: insufficient data.
I come to the question: Is it impossible to let LibreOffice make a detailed report when Calc, Writer or whatever crashes?

Regards, Alexander
Comment 43 Buovjaga 2023-02-28 14:51:22 UTC
(In reply to Alexander Van den Panhuysen from comment #42)
> This goes on and on and on ...
> It is already a few years that Calc and Writer crashes to a lot of people,
> and still: insufficient data.
> I come to the question: Is it impossible to let LibreOffice make a detailed
> report when Calc, Writer or whatever crashes?

It is not impossible. Users do it with the click of a button and the report is sent to: https://crashreport.libreoffice.org/
Then, many crashes are actually fixed just by analysing the crash backtraces.
Comment 44 Alexander Van den Panhuysen 2023-02-28 14:57:31 UTC
Hell yeah! I did sent months ago a crashreport, but it is still insufficient data.

Alexander
Comment 45 Alex Thurgood 2023-03-01 08:39:15 UTC
(In reply to Buovjaga from comment #43)


> It is not impossible. Users do it with the click of a button and the report
> is sent to: https://crashreport.libreoffice.org/
> Then, many crashes are actually fixed just by analysing the crash backtraces.

Actually, this is unfortunately not true on macOS. The crashreporter tool is not built into the LO release for macOS, or else it is deactivated.

This means that when LO crashes suddenly, on macOS the user is reliant on the Apple crash log manager producing a crash trace. Unfortunately, this crash trace isn't systematically produced or else retrievable.

If it does produce a crash trace, sending that trace to Apple is of no practical use to the bugzilla tracking, as these reports are not forwarded to bugzilla (I'm not even sure that Apple passes them on to the LibreOffice release maintainer).

When people encounter a sudden crash on macOS withLO, if the Apple Crash Reporter doesn't display a dialog with a trace, they should look into their system logs. Often, but not always, the crash log for the LO process can be found there. It does also seem to depend on the version of macOS you are running, as to what actually gets recorded, and this is down to Apple tweaking the log system with each release.
Comment 46 Alex Thurgood 2023-03-01 08:53:49 UTC
(In reply to Alexander Van den Panhuysen from comment #44)
> Hell yeah! I did sent months ago a crashreport, but it is still insufficient
> data.
> 
> Alexander

@Alexander : the previous crash log trace you provided pointed to a callout to Yara, which appears to implement some kind of cryptographic or privacy library.

https://apps.apple.com/fr/developer/yara-technologies-private-limited/id1451413420

Could you provide a current crash log when LO crashes, so that we can compare it with the previous one ?
Comment 47 Alex Thurgood 2023-03-01 09:07:24 UTC
Unfortunately for us, the XProtect application is not a trivial system tool to get anything useful from, for example, see this blog post :

https://eclecticlight.co/2023/02/25/what-are-those-xprotects/

This article indicates that a yara file is to be found in the XProtect bundle, along with a database and some property list files, which Gatekeeper uses to determine whether an application is entitled to pass the security check.

Perhaps then, the crashing is related to Gatekeeper thinking that LO contains malware, or is improperly authenticated / verified ?

One way to test this is with the xattr command.

From a terminal, type:

xattr -d com.apple.quarantine /Applications/LibreOffice.app

and see if that then makes any difference to subsequent launches of LO with respect to any crashing.

Additionally, you might want to change your Gatekeeper settings to allow non-appstore software installations (AppStore and identified developers), if you haven't done so already.
Comment 48 Alexander Van den Panhuysen 2023-03-01 09:31:11 UTC
I installed and launched now LibreOffice 7.4.4.2 (one of the latest stable versions in Belgium) and started to work further on a Calc document, this far no crash.
In Terminal I entered the command 'xattr -d com.apple.quarantine /Applications/LibreOffice.app' and this is the respons:
xattr: /Applications/LibreOffice.app: No such xattr: com.apple.quarantine
It is very possible that I reduced some security in the past already (I don't remember what and how), but I'm not happy reducing some security to make an app working.
Comment 49 QA Administrators 2023-03-02 03:25:32 UTC Comment hidden (noise)
Comment 50 steve 2023-03-04 08:31:01 UTC
@Aelxander: please update macOS to 13.2.1 and LibreOffice to 7.5.1 (https://www.libreoffice.org/download/download-libreoffice/).

Test that setup for a few days and do let us know how things go. Should you still encounter crashes, please attach another crash log as a lot of things have changed both in macOS as well as LibreOffice.
Comment 51 Alexander Van den Panhuysen 2023-03-07 12:34:10 UTC
Excellent work! In the last 3 days with LibreOffice 7.5.1.2 I had no more crashes, not with Calc and not with Writer. If that's thanks to Patrick Luby's tweaks, give him a gold trophy!
Comment 52 steve 2023-03-09 13:48:53 UTC
Fantastic. If you encounter more trouble with the latest version, please file a new bug.