Bug 130401 - Calc periodically causes high CPU load, even when window is minified
Summary: Calc periodically causes high CPU load, even when window is minified
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf
Depends on:
Blocks: Performance
  Show dependency treegraph
 
Reported: 2020-02-03 18:26 UTC by ChrisK
Modified: 2022-05-24 07:35 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Just a sample file which shows the described behaviour. I don't believe, it's data-driven, though. (120.04 KB, image/png)
2020-02-03 18:32 UTC, ChrisK
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ChrisK 2020-02-03 18:26:46 UTC
Description:
Calc periodically causes high CPU load (1 core @100%), even when its window was minified and there was no user interaction.
Load goes away as soon as document is "Save"d again, even though there were no changes/edits since last saving.

Steps to Reproduce:
1. Open attached Calc spreadsheet. It's fairly small, 700 rows by 2 columns, and around 20kBytes.
2.Minify the Calc window
3.Wait indefinitely ;-)
4 . On my machine, an 8 core Intel NUC, eventually the CPU fan revs up, and the xfce tas monitor indicates a 100% CPU load of one core, caused by LibreOffice, giving an average CPU load of between 12% and 13%.
5. Restoring the LibreOffice Calc window and hitting the "Save" button makes the CPU load go away, until the next time this happens. Which may be 30 (or more) minutes later.

Actual Results:
High CPU load, as shown in attached screenshot.

Expected Results:
If application is idle, like when window is minified and no user interaction taking place, it should remain at miniscule CPU load.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
OS is Debian stable, fully updated as of today. Synaptic does not indicate any updatable packages, even after reloading the packages list from the download sources.

LibreOffice version is as follows:

Version: 6.1.5.2
Build-ID: 1:6.1.5-3+deb10u5
CPU-Threads: 8; BS: Linux 4.19; UI-Render: Standard; VCL: gtk2; 
Gebietsschema: de-CH (de_CH.UTF-8); Calc: group threaded

After restarting LibreOffice in Safe Mode, pretty exactly 30 minutes later the CPU fan started revving up, with CPU load at 13% average, one core at 100%.
Comment 1 ChrisK 2020-02-03 18:32:11 UTC
Created attachment 157623 [details]
Just a sample file which shows the described behaviour. I don't believe, it's data-driven, though.

The file contains "tag" names as logged from a wordpress site during page build, mildly edited and split into two "passes" next to each other in the two columns.. There is no private information included.
Comment 2 Xisco Faulí 2020-02-18 16:25:54 UTC
Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 3 ChrisK 2020-02-23 15:51:19 UTC
Hi Xisco Fauli (couldn't determine which is your first name),

I installed one of the latest releases of LibreOffice on my previous Debian "Buster" system and hope, I didn't ruin too much of my system along the way.

Current LibreOffice version is now:

Version: 6.4.1.1
Build-ID: 1:6.4.1~rc1-2
CPU-Threads: 8; BS: Linux 4.19; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-CH (de_CH.UTF-8); UI-Sprache: de-DE
Calc: threaded

Using the same data file as originally attached, the error is still present.
Actually I would even say, that the error has become slightly more serious along the way: now the high CPU load, which still occurs about 30 minutes after minification of the Calc window, does  _NOT_  go away after the first click on "Save". Now it akes about 4 or 5 clicks on "Save" before the high CPU load goes away, according to the taskmanager, sorted by CPU-load.
Comment 4 Buovjaga 2020-05-10 14:25:06 UTC
Could it be related to Tools - Options - Load/Save - General: Save autorecovery info every x minutes? Try changing it to 1 and monitor the cpu.
Comment 5 Xisco Faulí 2020-05-11 09:56:12 UTC
(In reply to Buovjaga from comment #4)
> Could it be related to Tools - Options - Load/Save - General: Save
> autorecovery info every x minutes? Try changing it to 1 and monitor the cpu.

Setting to NEEDINFO.
@Chris, Please, try what Buovjaga suggested and give us feedback.
BTW, my name is Xisco, my surname is Fauli :)
Comment 6 ChrisK 2020-05-14 08:08:54 UTC
I updated my system and am now reporting the behavior of LibreOffice 6.4.4.1 :

The setting as proposed in Comment4 was initially set to "10".
I set it to "1" and monitored CPU-load for 30+ minutes, without the bug re-occurring.

I then reverted the setting as proposed in Comment4 to "10", and monitored for another 30+ minutes. The bug then re-appeared after approx. 30 minutes, may have been slightly less. The CPU-load returned to normal idle value of 2% after "Saving" the calc file.
Comment 7 Xisco Faulí 2021-11-23 11:08:18 UTC
Hello ChrisK,
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 8 QA Administrators 2022-05-23 03:38:27 UTC Comment hidden (obsolete)
Comment 9 ChrisK 2022-05-24 07:32:17 UTC
Gentlemen,

I'm not going to provide any additional info an this. I've done so twice and yet to keep resetting this bug to NEEDINFO over and over again.

Proceed with this bug as you please - I've lost any interest in it.

Regards,

Chris