Nextcloud get very slow after installing Nextcloud Office

Good day,

After installing Nextcloud Office, the instance get very slow at a point of it is not loading anymore. I did a reboot of the VM, doubled memory and CPU cores without any success.

Nextcloud was fully updated to it’s latest version.

The server is under now load as you can see here:

Screenshot at 2022-10-31 04-01-42

The VM is running Ubuntu Server 20.04 LTS.

The VM is reachable by SSH, Apache is running:

But, I cannot connect to Nextcloud:

How I can fix this issue? Which log should be relevant to be posted here? I don’t know by where to start.

Best regards,

Guillaume

I would start with disabling the command using occ.

Hello,

By disabling richdocuments: 6.3.1 the instance is responding again.

According to Nextcloud Server Locks up Slow when Collabora Server is offline · Issue #2486 · nextcloud/richdocuments · GitHub the issue may be caused by the Collabora server being offline but, in my case it is just not configured so it probably taking it for an offline server.

How to configure it? If I enable it, the instance seem hanging.

I do found Poor performance when enabled · Issue #2392 · nextcloud/richdocuments · GitHub

I will need some assistance with the app configuration.

Thank-you

Guillaume

This is happening probably because you are using Docker for Nextcloud and trying to run the built-in Collabora CODE instance. This combination is known to cause massive problems with speed and timeouts and such. Install Collabora CODE separately and you will not have an issue anymore.

Hello,

No Docker has been used for that Nextcloud instance. The Collabora CODE is hosted on a different server.

Thank-you

Guillaume

Independent fro how you run the components it’s cruical both system can reach each other (and e.g. trust TLS certs). perform the tests described in the troubleshooting guide

Verify connectivity from browser
https://office.example.com/hosting/capabilities
https://office.example.com/hosting/discovery

Verify connectivity from Nextcloud
curl https://office.example.com/hosting/capabilities
curl https://office.example.com/hosting/discovery

Verify connection from the Collabora server
curl https://nextcloud.example.com/status.php

This steps proof good every component has required connectivity…

Hi,

The Daemon seem not running:

root@onlineoffice-dc:~# systemctl status coolwsd
× coolwsd.service - Collabora Online WebSocket Daemon
     Loaded: loaded (/lib/systemd/system/coolwsd.service; enabled; vendor preset: enabled)
     Active: failed (Result: core-dump) since Wed 2022-11-02 00:08:13 EDT; 2 days ago
    Process: 3459 ExecStart=/usr/bin/coolwsd --version --o:sys_template_path=/opt/cool/systemplate --o:child_root_path=/opt/cool/child-roots --o:file_server_root_path=/usr/share/coolwsd (code=dumped, signal=ABRT)
   Main PID: 3459 (code=dumped, signal=ABRT)
        CPU: 1.315s

Nov 02 00:08:13 onlineoffice-dc systemd[1]: coolwsd.service: Main process exited, code=dumped, status=6/ABRT
Nov 02 00:08:13 onlineoffice-dc systemd[1]: coolwsd.service: Failed with result 'core-dump'.
Nov 02 00:08:13 onlineoffice-dc systemd[1]: coolwsd.service: Consumed 1.315s CPU time.
Nov 02 00:08:13 onlineoffice-dc systemd[1]: coolwsd.service: Scheduled restart job, restart counter is at 14.
Nov 02 00:08:13 onlineoffice-dc systemd[1]: Stopped Collabora Online WebSocket Daemon.
Nov 02 00:08:13 onlineoffice-dc systemd[1]: coolwsd.service: Consumed 1.315s CPU time.
Nov 02 00:08:13 onlineoffice-dc systemd[1]: coolwsd.service: Start request repeated too quickly.
Nov 02 00:08:13 onlineoffice-dc systemd[1]: coolwsd.service: Failed with result 'core-dump'.
Nov 02 00:08:13 onlineoffice-dc systemd[1]: Failed to start Collabora Online WebSocket Daemon.
root@onlineoffice-dc:~# systemctl start coolwsd
root@onlineoffice-dc:~# systemctl status coolwsd
● coolwsd.service - Collabora Online WebSocket Daemon
     Loaded: loaded (/lib/systemd/system/coolwsd.service; enabled; vendor preset: enabled)
     Active: active (running) since Fri 2022-11-04 20:14:47 EDT; 1s ago
   Main PID: 19018 (coolwsd)
      Tasks: 1 (limit: 2237)
     Memory: 40.9M
        CPU: 1.457s
     CGroup: /system.slice/coolwsd.service
             └─19018 /usr/bin/coolwsd --version --o:sys_template_path=/opt/cool/systemplate --o:child_root_path=/opt/cool/child-roots --o:file_server_root_path=/usr/share/coolwsd

Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.587506 -0400 [ coolwsd ] TRC  Pre-read 28 file(s) from directory: /usr/share/coolwsd/browser/dist/images/help/it: insert-table.png slide-layouts.png mana>
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.588381 -0400 [ coolwsd ] DBG  Caching files in [/usr/share/coolwsd/browser/dist/images/help/es]| wsd/FileServer.cpp:726
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.611590 -0400 [ coolwsd ] TRC  Pre-read 28 file(s) from directory: /usr/share/coolwsd/browser/dist/images/help/es: insert-table.png slide-layouts.png mana>
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.612103 -0400 [ coolwsd ] DBG  Caching files in [/usr/share/coolwsd/browser/dist/images/help/pt-BR]| wsd/FileServer.cpp:726
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.645163 -0400 [ coolwsd ] TRC  Pre-read 25 file(s) from directory: /usr/share/coolwsd/browser/dist/images/help/pt-BR: slide-layouts.png manage-changes.png>
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.645681 -0400 [ coolwsd ] DBG  Caching files in [/usr/share/coolwsd/browser/dist/images/help/fr]| wsd/FileServer.cpp:726
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.681052 -0400 [ coolwsd ] TRC  Pre-read 28 file(s) from directory: /usr/share/coolwsd/browser/dist/images/help/fr: insert-table.png slide-layouts.png mana>
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.681665 -0400 [ coolwsd ] DBG  Caching files in [/usr/share/coolwsd/browser/dist/images/help/en]| wsd/FileServer.cpp:726
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.710428 -0400 [ coolwsd ] TRC  Pre-read 28 file(s) from directory: /usr/share/coolwsd/browser/dist/images/help/en: insert-table.png slide-layouts.png mana>
Nov 04 20:14:48 onlineoffice-dc coolwsd[19018]: wsd-19018-19018 2022-11-04 20:14:48.795510 -0400 [ coolwsd ] DBG  Caching files in [/usr/share/coolwsd/browser/dist/images/dark]| wsd/FileServer.cpp:726
lines 1-20/20 (END)

root@onlineoffice-dc:~# 
root@onlineoffice-dc:~# 
root@onlineoffice-dc:~# 
root@onlineoffice-dc:~# systemctl status coolwsd
× coolwsd.service - Collabora Online WebSocket Daemon
     Loaded: loaded (/lib/systemd/system/coolwsd.service; enabled; vendor preset: enabled)
     Active: failed (Result: core-dump) since Fri 2022-11-04 20:14:56 EDT; 2min 16s ago
    Process: 19069 ExecStart=/usr/bin/coolwsd --version --o:sys_template_path=/opt/cool/systemplate --o:child_root_path=/opt/cool/child-roots --o:file_server_root_path=/usr/share/coolwsd (code=dumped, signal=ABRT)
   Main PID: 19069 (code=dumped, signal=ABRT)
        CPU: 1.544s

Nov 04 20:14:56 onlineoffice-dc systemd[1]: coolwsd.service: Main process exited, code=dumped, status=6/ABRT
Nov 04 20:14:56 onlineoffice-dc systemd[1]: coolwsd.service: Failed with result 'core-dump'.
Nov 04 20:14:56 onlineoffice-dc systemd[1]: coolwsd.service: Consumed 1.544s CPU time.
Nov 04 20:14:56 onlineoffice-dc systemd[1]: coolwsd.service: Scheduled restart job, restart counter is at 5.
Nov 04 20:14:56 onlineoffice-dc systemd[1]: Stopped Collabora Online WebSocket Daemon.
Nov 04 20:14:56 onlineoffice-dc systemd[1]: coolwsd.service: Consumed 1.544s CPU time.
Nov 04 20:14:56 onlineoffice-dc systemd[1]: coolwsd.service: Start request repeated too quickly.
Nov 04 20:14:56 onlineoffice-dc systemd[1]: coolwsd.service: Failed with result 'core-dump'.
Nov 04 20:14:56 onlineoffice-dc systemd[1]: Failed to start Collabora Online WebSocket Daemon.

It crashed few seconds after starting it.

So, I tried to reinstall it using this guide without any success.

root@onlineoffice-dc:/usr/share/keyrings# apt-get update
Hit:1 http://ca.archive.ubuntu.com/ubuntu jammy InRelease
Hit:2 http://ca.archive.ubuntu.com/ubuntu jammy-updates InRelease
Hit:3 http://ca.archive.ubuntu.com/ubuntu jammy-backports InRelease             
Hit:4 http://ca.archive.ubuntu.com/ubuntu jammy-security InRelease              
Ign:5 https://www.collaboraoffice.com/repos/CollaboraOnline/21.11/customer-ubuntu2204- ./ InRelease
Err:6 https://www.collaboraoffice.com/repos/CollaboraOnline/21.11/customer-ubuntu2204- ./ Release
  404  Not Found [IP: 46.235.227.219 443]
Reading package lists... Done
E: The repository 'https://www.collaboraoffice.com/repos/CollaboraOnline/21.11/customer-ubuntu2204- ./ Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
root@onlineoffice-dc:/usr/share/keyrings#

But I can’t.

Guillaume

the current problem is definitely related to Cool itself - better you reach out to their forum.

the issue with package installation is because you are missing $customer_hash from the repo URI and for this reason your system doesn’t find the repo at all

cat << EOF > /etc/apt/sources.list.d/collaboraonline.sources
Types: deb
URIs:https://www.collaboraoffice.com/repos/CollaboraOnline/21.11/customer-ubuntu2004-$customer_hash
Suites: ./
Signed-By: /usr/share/keyrings/collaboraonline-release-keyring.gpg
EOF

I didn’t spend time to understand where the customer_hash comes from - please double check Cool docs - maybe you miss some important steps…