nextcloud / richdocuments

📑 Collabora Online for Nextcloud
https://nextcloud.com/collaboraonline
355 stars 116 forks source link

Poor performance when enabled #2392

Open MauritzFunke opened 2 years ago

MauritzFunke commented 2 years ago

Describe the bug When I enable the extension every 3-5 minutes the mariadb server gets flooded with about 150 requests at which it hits the process limit, increasing the limit does not help. During the time the whole application becomes unresponsive.

To Reproduce Steps to reproduce the behavior:

  1. Enable the plugin

Expected behavior It shouldnt flood the mariadb server

Screenshots MySQL Processlist

Server details

Operating system: Debian 10.12 Web server: Apache/2.4.38 Database: 10.3.34-MariaDB-0 PHP version: PHP 8.1.9 Nextcloud version: 24.0.3 Version of the richdocuments app 6.2.0 Version of Collabora Online Not installed

stefandesu commented 2 years ago

Not sure if it's the same issue, but when I enable the app, my whole Nextcloud literally becomes unresponsive, and the only solution is to run occ app:disable richdocuments.

AJMitev commented 2 years ago

I am experiencing the same problem after the last update.

Fritofour commented 2 years ago

Hi, same problem on my side. Have to disable the extension to make the server OK. :/

jeromeLB commented 2 years ago

I removed the v6.2.0 and re-installed the v6.1.1: there is the same problem

AJMitev commented 2 years ago

I am not sure why but activating richdocuments and richdocumentscore_arm64 and then configuring it via terminal has resolved my issue.

sudo -u www-data php occ config:app:set --value https://domain.com/apps/richdocumentscode_arm64/proxy.php?req=  richdocuments wopi_url
sudo -u www-data php occ richdocuments:activate-config