Bug 102250 - FILESAVE: slow save with dump (see Comment 10)
Summary: FILESAVE: slow save with dump (see Comment 10)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.4.2 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-09-18 02:39 UTC by Greg Miller
Modified: 2018-12-17 10:36 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Libreoffice Calc file which will not save in 5.1.4.2 (575.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-09-18 02:39 UTC, Greg Miller
Details
backtrace - hang with 5.4.0 (15.28 KB, text/plain)
2016-12-11 05:49 UTC, fiftyigfuci_f_mi
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Greg Miller 2016-09-18 02:39:37 UTC
Created attachment 127392 [details]
Libreoffice Calc file which will not save in 5.1.4.2

1. Open file (offending file is attached).
2. Change anything and SAVE. Does not save.
3. soffice.bin process goes to 100% CPU nd stays there.
4. Nothing more happens, process seems deadlocked or like a race condition
5. Come back hours later, no change. Must kill process.
6. shell output is 2 lines of the following per second: 

** (soffice:14186): WARNING **: Invalidate all children called


Nota Bene: Same file under Linux Mint 17.3 and whichever Libreoffice ships with it works fine.


System:
Release Linux Mint 18 Sarah 64-bit
Kernel Linux 4.4.0-31-generic x86_64
MATE 1.14.1
Comment 1 Jean-Baptiste Faure 2016-09-18 06:01:24 UTC
Annoying indeed :-(
Reproducible with both 5.2.3.0+ and current master under Ubuntu 16.04 x86-64.

What is the history of this file ? Has it been converted from an ancestor in xls or xlsx format ?

What is the LibreOffice version provided by Linux Mint 17.3 ?

Set status to NEEDINFO, please set it back to UNCONFIRMED once requested informations are provided.

Best regards. JBF
Comment 2 m_a_riosv 2016-09-18 13:37:09 UTC
There are a lot of comments, those on AQ AS AY BA BC, are repeated on any column.
Clearing that comments seems to works better for save.
Comment 3 Greg Miller 2016-09-24 16:52:53 UTC
"What is the history of this file ? Has it been converted from an ancestor in xls or xlsx format ?"

-- the file has always been in Libreoffice .ods format within Linux Mint. It was created 5 or 6 years ago, and has been in continuous edit at least once a week over that duration. I have been using Mint since about version 9, and have upgraded to each new Linux Mint 64 bit Mate as it came out, and used the version of Libreoffice that shipped with that version of Mint.The failure came with an upgrade of one of my computers to Mint 18.

"What is the LibreOffice version provided by Linux Mint 17.3 ?"

-- I don't have access to my 17.3 box but will in a few days. I know 17.3 included a 5.x.x version of Libreoffice.

Thanks for any help.
Comment 4 Greg Miller 2016-09-25 00:16:04 UTC
(In reply to m.a.riosv from comment #2)
> There are a lot of comments, those on AQ AS AY BA BC, are repeated on any
> column.
> Clearing that comments seems to works better for save.

I deleted all the comments in the columns you listed, and now the file does save, but it takes about 3 minutes to do so.
Comment 5 m_a_riosv 2016-09-25 11:34:26 UTC
The crash report was successfully uploaded.
You can soon find the report at:
crashreport.libreoffice.org/stats/crash_details/b02e9674-4ac0-4149-94c2-68b7a942de57
Comment 6 Greg Miller 2016-09-29 21:19:14 UTC
(In reply to Jean-Baptiste Faure from comment #1)

> 
> What is the LibreOffice version provided by Linux Mint 17.3 ?
> 

Ok, the version of Libreoffice which does save the file as expected is 5.0.3.2

Cheers
Comment 7 fiftyigfuci_f_mi 2016-12-11 05:49:12 UTC
Created attachment 129481 [details]
backtrace - hang with 5.4.0

I could reproduce the hang.
Calc constantly eats memory at about 1MB/sec.

My debug dev build:
Version: 5.4.0.0.alpha0+
Build ID: f35d29c8388744be1f95ec4acfca12eec706911a
CPU Threads: 2; OS Version: Linux 4.9; UI Render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 8 QA Administrators 2017-12-13 09:29:47 UTC Comment hidden (obsolete)
Comment 9 Xavier Van Wijmeersch 2017-12-13 17:08:14 UTC
did some test with attachment and its saving in 27 seconds

Version: 5.3.1.2
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

even with 5.4.5 and 6.1.0, so i think with comment it will need some more time to save but it will not need 3 minutes.
Comment 10 Timur 2017-12-14 17:55:01 UTC
Bug was changed. 
Now with 6.1+ save is slow with dump that can be seen with procdump.
Comment 11 QA Administrators 2018-12-15 03:56:38 UTC Comment hidden (obsolete)
Comment 12 Timur 2018-12-17 10:36:13 UTC
Reporter closed as WFM. 
I confirm reasonable open with 6.3+ without dump.
Note: dump there with 6.1.3.