Out of memory for spreadsheet editor tab in browser

Tech support for Enterprise Version
Post Reply
rudais
Posts: 23
Joined: Mon Oct 02, 2017 11:14 am

Out of memory for spreadsheet editor tab in browser

Post by rudais » Fri Aug 31, 2018 4:44 am

Hello,

In spreadsheet editor in some cases our server users have been running into issue where
if something is done with whole row or column then editor thinks that the action is being
applied to "whole" row/column up to infinity. Which end's in client side browser attempting to
process it and spreadsheet editor tab ram consumption simply grows up to around 4gigs and kicks
out with using to much ram before document can be loaded.

This problem is not always reproducible. I've seen it even being triggered when selecting whole column
and applying filtering to it. Or when pressing upper left button that marks all cells and preparing to
copy the content.

Yesterday we ran into scenario where up to 6 users where working on one document simultaneously and
one of them had applied some action to document that caused this same effect. Which ended up being saved
Ones that had document open were still able to do various things with it. But for ones that tried opening
it again it ended up in that OOM situational with browser tab.

Has something like this been reported/fixed? I am currently running latest versions that are available
via docker control panel upgrade panel.

Regards,
Rudais.

Maxim
Posts: 1821
Joined: Tue Oct 11, 2016 2:34 pm

Re: Out of memory for spreadsheet editor tab in browser

Post by Maxim » Fri Aug 31, 2018 6:39 am

Hello rudais!
How much RAM on your Onlyoffice server?

rudais
Posts: 23
Joined: Mon Oct 02, 2017 11:14 am

Re: Out of memory for spreadsheet editor tab in browser

Post by rudais » Fri Aug 31, 2018 6:54 am

1. Server has about 10G ram and 14G swap.

Code: Select all

krisjanis@oo:~$ free -m                                                                                                                                                                                                
              total        used        free      shared  buff/cache   available                                                                                                                                        
Mem:           9761        4419        1379         152        3962        4818                                                                                                                                        
Swap:         13118         692       12426           
Per grafana I can see that server had some resource spikes, but nothing that should had exceeded what I have provisioned for it's VM.
oo_grafana.png
server_stats_grafana
oo_grafana.png (211.23 KiB) Viewed 731 times
2. On workstations we usually have 8-16G depending on HW build age. But browsers them selves seem to have this +-4G limit per tab.

3. How does this processing work? I though that over all it's done on client browser side when doc is being loaded?

Maxim
Posts: 1821
Joined: Tue Oct 11, 2016 2:34 pm

Re: Out of memory for spreadsheet editor tab in browser

Post by Maxim » Fri Aug 31, 2018 7:03 am

Hello rudais!
Is it docker installation?

rudais
Posts: 23
Joined: Mon Oct 02, 2017 11:14 am

Re: Out of memory for spreadsheet editor tab in browser

Post by rudais » Fri Aug 31, 2018 7:16 am

Yes, it's a docker installation.

Post Reply