Description: I have a 2.5MB spreadsheet with which uses lots of INDEX(range,MATCH(1, ("X"=range) * ("Y"=range), 0),1) formulas (to do a lookup based on two criteria). If you open this spreadsheet, or randomly afterwards LibreOffice hangs and starts using experiential amounts of RAM. I have 8GM ram and if I don't force quite before it gets to 5/6GB just for libreoffice the whole complete locks up. Open with autocalculate off isn't possible (and having auto calculate on/off doesn't seem to matter). If you open the same file in MS Excel 2011 it opens fine. I've created a simplified version of this spreadsheet which is smaller, and only contains the formulas above (see attached). Although this doesn't crash at open very often. It does fairly regularly exhibit the same behaviour where it hangs and start using ever more RAM as the bigger spreadsheet does. I've not been able to deduce what causes this. There is also performance issue with calculating spreadsheet with such formulas. A sheet with 400 such formulas (with Multithreading enabler take a good few minutes too calculate (even with multithreading on it still only seems to use one core's worth of CPU). And odd other performances issues, like it taking 10 seconds to add a new sheet (which is doesn't happen on other spreadsheets). Saving taking 30secs sometimes, but weirdly not always (that's on MATCH()_CRASH_DEMO.xlsx with files size of 200Kb or bigger). OS Version: Mac OS X 10.14.6 (Build 18G9323) Architecture: x86_64 Command: soffice Path: /Applications/Downloaded/LibreOffice.app/Contents/MacOS/soffice Identifier: org.libreoffice.script Version: 7.1.8.1 (7.1.8.1) PID: 60566 Event: hang Hardware model: MacBookPro9,2 Active cpus: 4 RAM: 8GB Hard Drive: 960GB ScanDisk Pro SSD (SanDisk SDSSDXPS960G) Graphics: Intel HD Graphics 4000 Tried turning on OpenCL --> Doesn't seem to be available with computer hardware. Tried turning off Multithreading --> Doesn't seem to make any difference I've run out of time to keep compiling this bug report. I think I've produced replicable example I could upload, and then I re-open libreoffice in safe mode and struggled to repeat the expolnencail increase in memory use with DEMO spreadsheet. I've definetly crashed full 2.5MB spreadsheet in safe mode, but so far not the DEMO on I've attached. I'll keep using it in safe mode and see how long that last. I can upload my user profile if that's helpful. Steps to Reproduce: Reproducing the slow performance on INDEX(MATCH) formulas is very easy: 1. Open spreadsheet attached 2. Go to first sheet 'INDEX(MATCH)' 3. Drag down another 100 rows. Reproducing the memory fault is harder to pin down. 1. Open spreadsheet attached 2. If that's not enough then trying to work on it for a few minutes is usually sufficient 3. Actual Results: Hang + Memory Leak a seemingly random intervals. Hang without memory increase for long time whilst calculating. Expected Results: Calculations that take significant amount of time should not lock up UI, or cause application to be un-responsive. They should just stop use editing spreadsheet and indicate some how that recalculation is in progress. Under no circumstance should LibreOffice start using infinitely more RAM until computer locks up. Reproducible: Sometimes User Profile Reset: No Additional Info: Not sure if either of these bugs relate to issues I'm having: https://bugs.documentfoundation.org/show_bug.cgi?id=139444 https://bugs.documentfoundation.org/show_bug.cgi?id=144142 Due to this bug I can't run latest version: https://bugs.documentfoundation.org/show_bug.cgi?id=148069
Created attachment 178981 [details] Demonstration Spreadsheet This spreadsheet contains the INDEX(range,MATCH(1, ("X"=range) * ("Y"=range), 0),1) formulas (to do a lookup based on two criteria).
Created attachment 178982 [details] Demonstration Spreadsheet Spreadsheet with INDEX(range,MATCH(1, ("X"=range) * ("Y"=range), 0),1) formulas (to do a lookup based on two criteria).
Created attachment 178983 [details] Apple Crash Report - Demo Spreadsheet Memory Exponential increase In normal (i.e. not safe mode) after DEMO spreadsheet (only think open) hang and start using ever increasing amounts of RAM
Created attachment 178984 [details] Apple Crash Report - 2.5 MB Spreadsheet In normal (i.e. not safe mode) after 2.5MB spreadsheet hang and started using ever increasing amounts of RAM
Created attachment 178985 [details] Screen Shot of DEMO spreadsheet Saving Sometimes saving task 30 seconds and libreoffice stops responding.
Created attachment 178986 [details] Screenshot of hang while calculating lots of INDEX(MATCH) formulas on fill
Created attachment 178987 [details] Screenshot of RAM stats during LibreOffice Hang + Memory Leak This was probably 10-20 seconds after it stopped responding, and if I'd have left another 30 computer would have locked up.
Created attachment 178988 [details] When I tried to archive user profile to upload
Created attachment 178989 [details] RAM Statistics -- After 2.5MB spreadsheet memory leak left for a while. The Inverse spike is the moment I force quit Libreoffice.
Created attachment 178990 [details] RAM Statistc - A few force quits in regular succession Note: compared of other screenshot I'd closed a few other applications so more Ram was available.
Not reproduced in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: f461c889ac4bc053c306537f644ec4bf3e0d5128 CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded
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.
(In reply to Xisco Faulí from comment #12) > 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. That is difficult for me to do because the latest version of Libreoffice crashes with a blank spreadsheet from template for other reason reported in this bug: https://bugs.documentfoundation.org/show_bug.cgi?id=148069
[Automated Action] NeedInfo-To-Unconfirmed
I didn't have any memory leaks but I got the 100% CPU loading in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 0a05b1f46263a16c6d40c841a317c3ba9f4d31d6 CPU threads: 4; OS: Mac OS X 12.3.1; UI render: default; VCL: osx Locale: ru-RU (ru_RU.UTF-8); UI: en-US Calc: threaded My steps: 1. Open the example 2. Go to sheet 'INDEX(MATCH)' 3. Select a last row with data on the sheet 4. Try expand/drag it to over 100 rows to down => LO hangs with 100% CPU loading Julien could you please test it on your machine and if you'll get the same please will create the perfgraph? Thank you
Created attachment 179245 [details] Flamegraph Indeed, I reproduced the hang. Here's a Flamegraph retrieved on pc Debian x86-64 with master sources updated today (+gen rendering).
Noel/Eike: thought you might be interested in this perf pb in Calc. I attached a Flamegraph in a previous comment.
Dear Peter, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Hi QA Administrators, As requested I've just run a further tests on new version of LibreOffice. I can't run LibreOffice 24 on my main machine as I'm still running MacOS10.14 which isn't supported, however I'm currently using LibreOffice 7.5.8.2 which is relatively stable in other use cases on my system. Test Steps: - I download the Demonstration Spreadsheet attached above. - I opened it in LibreOffice 7.5.8.2 and waited for a few minutes. - I noted that LibreOffice was using 2.42GB of ram (I had on other .docx open). - I clicked around a bit and changed worksheets for 5mins. - I check ram usage and it had started increasing continuously (3.2, 3.4, 3.6GBs....). - I force quit LibreOffice When I've got another machine up and running later OS, I'll try and reproduce in version 24.