ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.86k stars 327 forks source link

Memory leak while working with spreadsheet file #748

Closed longyn closed 1 month ago

longyn commented 2 years ago

This issue is unique.

Operating System

Windows 10 / 8.1 / 7

Version information

6.4.2.6

Expected Behavior

excel open and edit well.

Actual Behavior

Memory exhaust, and editor_helper.exe cost 19.2GB memory.

Reproduction Steps

  1. open the attachment
  2. do some editor, and change some cells.
  3. check the memory cost. Gante.xlsx

Additional information

image

VladimirProkofiev52 commented 2 years ago

Hello! @Longyn, we were unable to replicate the problem on our computers. Your problem has been tested on Windows 10 and Linux OS. Product version 6.4.0 and above. Could you send us a screen video recording that will reflect the problem you reported.

Kirill commented 2 years ago

I have this problem too. I haven't open at this moment any open documents (tables and presentation). I return to my notebook after some time near hour and see that it's work too slowly. I check task manager and see editors_helper.exe

Windows 10 Pro 21H1 19043.1348 ONLYOFFICE Desktop Editors версия 6.4.2.6

ss_20211124_131356_7

Last file which I open - document and it be 5 hours ago.

ShockwaveNN commented 2 years ago

@Kirill Sorry, I don't think it's enought information for us, we already rechecked several times and didn't find any exact scenario for memory leak It may depend of current status of your OS or something like this

I'll leave this issue opened but I really hope someone could provide exact scenario about how to reproduce memory leak on any hardware

Kirill commented 2 years ago

Sorry Pavel. I can't reproduse this issue manually. It's go on without закономерности. If you add logging for this, I can send logs when it's happend again. For now I delete this process.

longyn commented 2 years ago

image

Met this again. Speadsheet process is terminated, but editorhelper.exe remains.

It's not a 100% issue, cannot reproduce it manually.

In a summary, I met this problem about 5 times in a month.

It almost happened when or after do something with MS excel file.

longyn commented 2 years ago

@VladimirProkofiev52

Hi, met it again on ver. 7.x, it's a NREP issue.

I am opening a xlsx from 1/22/2022 to today(1/24/2022). Just a simple xlsx with 7 sheets, every sheet has below 100 rows and 10 columns. In a short time, the cpu fans goes fastly, and the memory exhaust.

image image

When suspend the the process, the memory cost reduced from 99% to 78%

After kill the process, the opening sheet is

image

longyn commented 2 years ago

PS: How can I help to locate the issue.

VladimirProkofiev52 commented 2 years ago

Hello! @longyn, we were unable again to replicate the problem on our computers.

I edited the file for five days without closing the spreadsheet editor or turning off the computer. The file was open for two days, did not make any changes, but watched the memory consumption.

ShockwaveNN said:

don't think it's enought information for us, we already rechecked several times and didn't find any exact scenario for memory leak It may depend of current status of your OS or something like this

We will continue to look for the problem, but without a precise scenario, it will be difficult.

If you find the exact sequence of actions that leads to the memory leak, please describe it to us.

draconical commented 2 years ago

@VladimirProkofiev52 Hello there. I met exactly the same problem. I was working on text doc, then closed onlyoffice and started doing some other stuff. Some time later i noticed my pc is lagging as hell. As result: RAM usage for editors_helper.exe was about 10GB.

I edited the file for five days without closing the spreadsheet editor or turning off the computer. The file was open for two days, did not make any changes, but watched the memory consumption

My thoughts on this subject:

longyn commented 2 years ago

In last few months, I used Onlyoffice desktop editor as my office editor, and met the problem 3 times. It seems a non reproduceable problem.

Sometimes, I opened a small excel, and leave it background, not interactive at all. But the editor_helper.exe memory leak cause the computer hang, can't do anything.

Is there any logs I can capture for resolving it.

VladimirProkofiev52 commented 8 months ago

Hello! @longyn Since the discovery of your issue, we've released several updated versions of our editor. The current version is 8.0.0. Can you please confirm if you're still experiencing the problem with the latest versions of our editor?

longyn commented 7 months ago

@VladimirProkofiev52 Thanks for your update. I will try the new version 8.0.0, and update my comment.

Rita-Bubnova commented 1 month ago

I close this issue. Feel free to comment or reopen it if you got further questions.