Bug 98079 - FILESAVE CALC crashes sporadically when saving multiple sheet workbook (Win x64)
Summary: FILESAVE CALC crashes sporadically when saving multiple sheet workbook (Win x64)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.4.2 release
Hardware: x86-64 (AMD64) Windows (All)
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, haveBacktrace, regression
Depends on:
Blocks:
 
Reported: 2016-02-22 13:30 UTC by Michael Amaral
Modified: 2018-02-13 19:51 UTC (History)
8 users (show)

See Also:
Crash report or crash signature:


Attachments
Debug output backtrace after crash (10.70 KB, text/plain)
2016-02-29 00:41 UTC, Michael Amaral
Details
testcase for showing CALC crashing (576.64 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-03-03 06:28 UTC, Michael Amaral
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Amaral 2016-02-22 13:30:31 UTC
Applies to Win 7 Pro and Win 10 pro
Also applies to latest 5.1.0.3, 5.0.5 releases

After making a few edits (sometimes only 1 or 2), then saving the workbook,
LibreOffice crashes

Upon restart file recovery has been working all the time, but the crashes affect productivity a lot.  

My application: I'm using a large Calc worksheet to track investments for numerous assets organized with one sheet for each asset.   Also, I have multiple summary sheets that tabulate the performance of several asset classes using the LOOKUP function and off sheet references.

I didn't have this problem running older versions of LibreOffice which I've been using for years, but unfortunately I can't recall which version last worked OK, but I think a 4.4 release was OK.   I haven't found a place on the web where I can SAFELY download this, or other older releases.  If I had that, I might be able to determine with which release I started having this problem.

Please help!
Michael J. Amaral
Comment 1 Michael Amaral 2016-02-22 13:35:33 UTC
I've tried renaming the LibreOffice user profile to force the application to establish a new one when it is restarted, but this does not help fix the problem.
Comment 2 Buovjaga 2016-02-28 15:29:00 UTC
Here is a safe place for oldies: http://downloadarchive.documentfoundation.org/libreoffice/old/

Or better yet: https://wiki.documentfoundation.org/SI-GUI

So this only happens with one of your files?
How can we test or will you debug it yourself? https://wiki.documentfoundation.org/How_to_get_a_backtrace_with_WinDbg
Comment 3 Michael Amaral 2016-02-29 00:41:20 UTC
Created attachment 123063 [details]
Debug output backtrace after crash
Comment 4 Joel Madero 2016-03-02 19:06:38 UTC
We need said "large spreadsheet" - marking as NEEDINFO. I understand it probably is confidential, you'll need to anonymize it (search/replace).

We can't move this forward without being able to reproduce it, we can't reproduce it without a test case. Once test case is provided please set to UNCONFIRMED. Thanks!
Comment 5 Michael Amaral 2016-03-03 06:28:00 UTC
Created attachment 123177 [details]
testcase for showing CALC crashing

Try using the attached file.

If you open the file.... then

select sheet 1.5, and select the first row of the file...

If you then insert rows, followed by <ctrl> S, insert rows, <ctrl> S.....
(repeat above 3 or 4 times)

You should observe CALC crashing.

Please let me know if that works.
Comment 6 Buovjaga 2016-03-03 13:21:37 UTC
I was able to crash it with 5.1.0 (4 rows), but not with 5.2 (2 tries, 7 rows).

Let's re-test soon.

Win 7 Pro 64-bit, Version: 5.1.0.3 (x64)
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
Locale: fi-FI (fi_FI)

Version: 5.2.0.0.alpha0+
Build ID: 85fcf15ff41ceb95f46dee586ff7187551be4955
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-27_09:23:38
Locale: fi-FI (fi_FI)
Comment 7 Michael Amaral 2016-03-09 21:19:14 UTC
More testing with testcase file showed crashing using versions 5.1.0.3 and 5.1.1.3 using the same actions already documented when the testcase was uploaded.

I haven't been able to crash 4.4.7.2 x86 on the same testcase file, at least yet.

I don't know how to get a copy of 5.2.x yet.
Comment 8 Michael Amaral 2016-03-09 21:27:07 UTC
I haven't been able to crash v4.4.7.2 x86 version using the testcase file, but
v5.1.0.3 Win64 & v5.1.1.3 Win64 both crash using the same test sequence already described herein.
Comment 9 Joel Madero 2016-03-09 22:39:49 UTC
5.2: http://dev-builds.libreoffice.org/daily/master/
Comment 10 raal 2016-03-16 11:41:15 UTC
No repro with Version: 5.2.0.0.alpha0+, win7

Michael, please could you test it with dev version?  You can download it here: http://dev-builds.libreoffice.org/daily/master/
Thanks
Comment 11 Michael Amaral 2016-03-16 13:15:36 UTC
I could not reproduce the crash using v5.2.0.0.alpha0+ running under win10 pro.  v5.2.0.0.alpha0+ exhibits another problem making it not usable for my on going work.   For now, I'll stick with 4.4.7.2 x86 for that purpose.  I'll generate a separate bug report for what I found wrong with v5.2.0.0.alpha0+, to help the dev team if they are not already aware of the particular problem.
Comment 12 Buovjaga 2016-03-16 13:19:03 UTC
Ok, I believe you guys and set to WFM.
Comment 13 Michael Amaral 2016-03-16 15:51:10 UTC
Still testing with W10 Pro x64

Testing up to when this bug report was first submitted was done with
master-2016-03-07_03.36.17_LibreOfficeDev_5.2.0.0.alpha0_Win_x86.

Testing done today with
master-2016-03-16_10.03.38_LibreOfficeDev_5.2.0.0.alpha0_Win_x64_en-US_de_ar_ja_ru_qtz

crashes when attempting to open testcase file.
Comment 14 raal 2016-03-16 16:20:17 UTC
(In reply to Michael Amaral from comment #13)
> Still testing with W10 Pro x64
> 
> Testing up to when this bug report was first submitted was done with
> master-2016-03-07_03.36.17_LibreOfficeDev_5.2.0.0.alpha0_Win_x86.
> 
> Testing done today with
> master-2016-03-16_10.03.38_LibreOfficeDev_5.2.0.0.alpha0_Win_x64_en-
> US_de_ar_ja_ru_qtz
> 
> crashes when attempting to open testcase file.

Is it another bug then "FILESAVE CALC crashes sporadically when saving multiple sheet workbook (Win x64)" ?  If yes, close this bug as resolved worksforme and open new one for crash when openning the file.
Comment 15 Buovjaga 2016-03-16 16:41:52 UTC
Michael: did you by any chance try to open via drag and drop? Bug 98607 was just fixed..
Comment 16 Buovjaga 2016-03-17 10:52:05 UTC
No crashes here.

Win 7 Pro 64-bit Version: 5.2.0.0.alpha0+
Build ID: 6eb7cd38e348e8a9d6498bfc2d41e91725eb34aa
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-03-16_12:53:35
Locale: fi-FI (fi_FI)
Comment 17 Michael Amaral 2016-03-17 15:00:57 UTC
Testing with
Version: 5.2.0.0.alpha0+ (x64) W10 Pro
Build ID: 042f16a19e3d5f884759dae71264433b988df0e6
crashes when opening test case file whether opening the file by using Open File Icon on LO menu or instead by drag and drop... same result.

I don't agree that this particular build Works For Me.

At this point the following build is the only one I've found that works for me.

Version: 4.4.7.2
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale: en_US

I believe this to be a x86 version
Comment 18 Buovjaga 2016-03-17 15:06:22 UTC
Does Tools - Options - OpenCL affect it?
Comment 19 Michael Amaral 2016-03-17 15:22:06 UTC
I don't know yet whether 

"Does Tools - Options - OpenCL affect it?"

I'll try and make another comment.

I could not get test case to crash on FILESAVE using

Version: 5.2.0.0.alpha0+
Build ID: 6eb7cd38e348e8a9d6498bfc2d41e91725eb34aa
CPU Threads: 8; OS Version: Windows 6.19; UI Render: GL; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-03-16_12:53:35
Locale: en-US (en_US)

.... however another serious bug still remains with this version making it unusable to me please refer to bug 98707, which I will also update with this info
Comment 20 Michael Amaral 2016-03-17 15:31:23 UTC
Version: 5.2.0.0.alpha0+
Build ID: 6eb7cd38e348e8a9d6498bfc2d41e91725eb34aa
CPU Threads: 8; OS Version: Windows 6.19; UI Render: GL; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-03-16_12:53:35
Locale: en-US (en_US)

"Does Tools - Options - OpenCL affect it?"

I unchecked use of Open CL.

No. Previous comment still holds for this bug (no crash), but bug 98707 still applies.  I'll make a separate comment on that one for this info.
Comment 21 Michael Amaral 2016-05-14 01:56:06 UTC
Retested using testcase with latest available release:
Version: 5.1.3.2 (x64)
Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b
CPU Threads: 8; OS Version: Windows 6.19; UI Render: GL; 
Locale: en-US (en_US)
Bug has not been fixed.  Still crashes after a few edits & file saves

I'm still using 
Version: 4.4.7.2
Build ID: f3153a8b245191196a4b6b9abd1d0da16eead600
Locale: en_US which works OK but I'd be happier if I could make use of any available x64 version which I have not been able to find, nor the latest version.
Comment 22 Buovjaga 2016-05-14 19:22:36 UTC
I can't get it to crash on Linux.

64-bit, KDE Plasma 5
Build ID: 5.1.2.2 Arch Linux build-1
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)

Arch Linux 64-bit, KDE Plasma 5
Version: 5.2.0.0.alpha1+
Build ID: 1dbdc947fcc9d843764731e6dae7ce60082576e0
CPU Threads: 8; OS Version: Linux 4.5; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8)
Built on May 14th 2016
Comment 23 Buovjaga 2016-05-17 09:56:20 UTC
I can get it to crash on 5.1.3 on Win.

Win 7 Pro 64-bit, Version: 5.1.3.2 (x64)
Build ID: 644e4637d1d8544fd9f56425bd6cec110e49301b
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
Locale: fi-FI (fi_FI)
Comment 24 marcos 2016-06-24 12:17:37 UTC
I get this crash when saving any type o sheet. Is occurs with large one but also with small one.
I can`t see, until now, any common cause.
Comment 25 n.b 2016-07-14 21:42:49 UTC
I can see this bug occurring in LibreOffice 5.1.3 and 5.1.4 (x86 and x64) on Win10 64bits.

It wasn't my document, but it's a large Calc with +60 tabs for financial usage.

Calc crash also sporadically with the 10min autosaving default.
Comment 26 Xisco Faulí 2016-09-13 10:26:53 UTC
Since we have a bibisect repository for windows covering the branch where this regression was introduced, adding keyword 'bibisectRequest'.
More info: https://wiki.documentfoundation.org/QA/Bibisect/Windows
Comment 27 Juergen 2017-01-23 12:01:27 UTC
I have a similar problem:

If i open several (2 or more) Calc files at the same time - then work / edit on one file. After i save this file for more than 3 to 5 times LibreOffice crashes when saving. 
File recovery works in most of all cases. Sometimes after crash the pc gets very slow and i have to restart. 
 
I used always the lates LibreOffice version and Win10. Problem occurs first time when i changed to Win10.

Up to now i already even change the complete PC and install every thing new - the problem is still there.
Comment 28 marcos 2017-01-23 12:32:45 UTC
(In reply to Juergen from comment #27)
> I have a similar problem:
> 
> If i open several (2 or more) Calc files at the same time - then work / edit
> on one file. After i save this file for more than 3 to 5 times LibreOffice
> crashes when saving. 
> File recovery works in most of all cases. Sometimes after crash the pc gets
> very slow and i have to restart. 
>  
> I used always the lates LibreOffice version and Win10. Problem occurs first
> time when i changed to Win10.
> 
> Up to now i already even change the complete PC and install every thing new
> - the problem is still there.

In fact for me it happens editing 2 or more files.

After some time opening, editing and saving, for unknow reason it crashes. I can`t fix what is the trigger.

To avoid this  I have to close all and open LI again frequently, it prevent me to lose too much wokk

I use W7.
Comment 29 Juergen 2017-01-24 06:56:24 UTC
(In reply to marcos from comment #28)

> 
> I use W7.

So one step forward - we know it's not about Win10. I was not sure if the problem occours with Win10 or with a new Libre Version.
Comment 30 marcos 2017-01-24 07:24:55 UTC
What is new?  I am using 5.1.6.2 and this problem occurs at least since the last 4 updates which I have downloaded
Comment 31 Telesto 2017-07-08 12:42:03 UTC
There is a crash potential for x86 builds with 100 undo steps (bug 108637). Memory usage will increase pretty fast and crash LibO at some point.

Version: 6.0.0.0.alpha0+
Build ID: cac5c9f6081590b0548d3116bc4cd4a2509ec576
CPU threads: 4; OS: Windows 6.19; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-07-01_00:41:48
Locale: it-IT (nl_NL); Calc: CL
Comment 32 Kevin Suo 2018-02-13 02:29:37 UTC
No crash for me in:

Version: 6.0.0.3 (x64)
Build ID:64a0f66915f38c6217de274f0aa8e15618924765
CPU 线程:4; 操作系统:Windows 10.0; UI 渲染:默认; 
区域语言:zh-CN (zh_CN); Calc: group
Comment 33 Michael Amaral 2018-02-13 19:41:18 UTC
I haven't seen this problem in over a year.   Today I retested with the same test case file I submitted in an earlier comment.   I could not reproduce the problem.   Today's test was run using the following version:

Version: 5.4.3.2 (x64)
Build ID: 92a7159f7e4af62137622921e809f8546db437e5
CPU threads: 8; OS: Windows 6.19; UI render: GL; 
Locale: en-US (en_US); Calc: group
Comment 34 Xisco Faulí 2018-02-13 19:51:48 UTC
Closing as RESOLVED WORKSFORME then.
Thanks for retesting!!