Issue loading sheet files and collaborative working

Various issues on onlyoffice workspace community

Hello,
I have encountered various problems on Onlyoffice Community

The most annoying is the slow loading of the sheet file when opened by several users simultaneously.
The examples open without problem, our other sheet files when they are not opened by several users simultaneously open without problem too, but several users working on the same file, it can take between 2 and 3 minutes to open.

These problems occur on both versions of Workspace community, for Windows and for Linux.

At first I installed on Windows server 2016 and windows server 2019, then I switched to Linux Ubuntu 20.04 as a virtual machine, hoping it would work better, but in the end it’s all the same.

at first, just after installing the server, everything seems to work fine, but as more users connect and work simultaneously, this problem occurs

The server hard configuration is a station I7 13th gen with 32 GB Ram
The Ubuntu VM configuration is 8 core with 16 Go Ram , 8 Go Swap

for the local network I’ve done all the tests and there’s no problem.

Here are the log files (ubuntu)
if anyone can help me find the problem
https://drive.google.com/drive/folders/1j440l4PkDjwh4ejIzTEgSlgP71PXpy4R?usp=sharing

Thanks in advance

Just to add some information
on ubuntu I used this documentation
“Installing ONLYOFFICE Workspace Community from RPM/DEB packages using the provided script”

here the last log file

Now there’s a particular sheet file that takes a long time to load even when there’s only one user logged in

on the same file there’s a page that seems to be blocked
every time someone tries to modify a cell there’s a “this range cannot be modified” message
in the protection menu, the “locked cell” option is grayed out and cannot be modified

Hello @tinego,
Please specify the version of Document Server component of Workspace.
Also, please provide the original file with which the issue can be reproduced, the screen recording of the issue reproduction with devTools Console/Network tabs opened (F12 for Chrome/Firefox)
Do you use any proxy?

Hello
I’m posting the requested details here because my colleague who created the topic can no longer write a reply.

We don’t use a proxy
the document server version is 8.3.3-18

You’ll find here logs, DevTools Console/Network screenshots, and an example of the spreadsheet here

https://drive.google.com/drive/folders/1R9w0iq4u0cemQvok4CuIAXxkxBtIqSi1?usp=sharing

Thanks for your help

Hello @Sam_D

Can you perform clean loading of a document to gather network cascade? Basically, the scenario is:

  1. Reproduce the issue with slow loading;
  2. Open browser console, then Network tab;
  3. Reload the page with the editor with opened browser console;
  4. Make screenshot of the cascade tree to see what loads slowly.

Additionally, it’d be useful to have a HAR file for that operation. You can get it by using Export .HAR option of browser console (refer to the documentation of your browser to find one).

Please note that HAR may contain sensitive information. I recommend sharing it via PM.

Are the screenshots we’ve already sent you unclear or incomplete?
here is the link to view them:

https://drive.google.com/drive/folders/1M_qxkf5JXUlLYOs82wjjXBo8JesYdHyk?usp=sharing

I’ll send you the Har file by private message

Thank you