Nextcloud get very slow after installing Nextcloud Office

guillaumesoucy · October 31, 2022, 7:59am

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:

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

wwe · October 31, 2022, 10:11am

I would start with disabling the command using occ.

guillaumesoucy · October 31, 2022, 11:50pm

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

zerojay · November 1, 2022, 1:10am

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.

guillaumesoucy · November 1, 2022, 4:16am

Hello,

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

Thank-you

Guillaume

wwe · November 1, 2022, 7:44am

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…

guillaumesoucy · November 5, 2022, 12:32am

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

wwe · November 5, 2022, 8:44pm

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…

guillaumesoucy · January 14, 2023, 7:11am

Hello,

Where to input the CODE server url to richdocuments using the terminal and occ? I can’t proceed using the webGUI as all the guides are suggesting as it is not responding.

Guillaume

guillaumesoucy · January 14, 2023, 7:25am

Also, I would like to add when entering that url: office.domain.tld:9980/browser/dist/cool.html it loads this:

guillaumesoucy · January 14, 2023, 6:18pm

An Update:

The connection could now be establish with the CODE server:

screenshot1

But, it fails to open documents:

screenshot2
screenshot3

I’d put links to screenshots uploads keeps failing.

How to make it work?

wwe · January 14, 2023, 8:34pm

@guillaumesoucy

please don’t hijack old thread with unrelated issues - open another topic.
use search and find solutions e.g. Nextcloud Collabora integration

guillaumesoucy · January 14, 2023, 11:56pm

Will all my respect Sir, I’m the author of this current thread, I’m not hijacking anything.

Will do a quick search and if nothing found I will open a new topic a you suggest.

With regards,

Guillaume

wwe · January 15, 2023, 9:55am

Yes sir i recognize you are are topic starter. I believe your current issue has nothing to do with the initial problem this is why I recommend you to open new thread so the forum stays organized. The goal is to discuss one problem per thread rather having some user personal support thread

UPDATE: Please don’t do cross-postings with other forums as well!

https://forum.collaboraonline.com/t/code-daemon-wont-stay-up/1463

P.S.: your screenshot shows Collabora address without https:// prefix, this might be a reason. Please follow the guide I posted earlier.

wwe · January 18, 2023, 9:55am

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.