richdocumentscode icon indicating copy to clipboard operation
richdocumentscode copied to clipboard

Update to 6.4.607 makes the whole nextcloud installation unusable

Open Moini opened this issue 3 years ago • 22 comments

Hi!

Last night I updated the community development version on my 20.0.8 nextcloud instance (without any extra memory caching, we're only 2 users) to 6.4.607 / 3.7.16, and right after the update, my nextcloud server became so slow that it got basically unusable (load times > 3 min per page).

I've had to disable the two Collabora apps via occ. After that, the server worked at normal speed again.

Please let me know how I can help debug the problem.

Moini avatar Mar 10 '21 21:03 Moini

Could you please describe your environment (docker?, snap?, something else?) ARM or x86_64? What distro? Do you see anything suspicious in the logs? Ideally we would like to reproduce the bug in our environment.

timar avatar Mar 12 '21 10:03 timar

Thank you, @timar .

  • Ubuntu 18.04.5 LTS
  • Nextcloud installed manually
  • PHP 7.2.24-0ubuntu0.18.04.7
  • x86_64

No errors, no warnings in the nextcloud logfiles, except for:

  • "appinfo/app.php is deprecated, use \OCP\AppFramework\Bootstrap\IBootstrap on the application class instead."
  • Calendar app and Deck app complain that 'Token does not exist.'

Both appear unrelated, as they also happen with the Collabora apps not active.

Just tested whether the update to latest version (as of today?) makes a difference - it does not.

Disabling only richdocuments is enough to get the server back to a usable state.

Collabora Online 3.7.17 Collabora Online - Built-in CODE Server 6.4.607

Moini avatar Mar 12 '21 13:03 Moini

Just tried uninstalling / reinstalling, still the same. Switching between apps takes very long.

Moini avatar Mar 12 '21 13:03 Moini

Same problem here. After updating Built-in CODE server from 6.4.601 to .606 or .607 nextcloud is very slow. No entries in the logfiles.

Collabora Online App tells me "Es konnte keine Verbindung zum Collabora Online-Server hergestellt werden." (connection to Collabora online server couldn't be established).

After deactivating built-in CODE server and downgrading to .601 everything is fine.

Nextcloud 20.0.8 installed manually on Apache2 (Ubuntu 20.04 LTS) Collabora Online 3.7.17 Collabora Online - Built-in CODE Server x64 6.4.606 and .607

mermaid-marina avatar Mar 13 '21 11:03 mermaid-marina

Oh, there's a way to downgrade? @mermaid-marina
How can I install a specific version?

Moini avatar Mar 13 '21 18:03 Moini

Yes, there's a way to downgrade. With Ubuntu 20.04 and Nextcloud installed manually in /var/www/nextcloud this worked for me:

Deinstall CODE 6.4.607 via Nextcloud's "Apps" menu. After deinstalling CODE:

cd /var/www/nextcloud/apps
sudo -u www-data wget https://github.com/CollaboraOnline/richdocumentscode/releases/download/6.4.601/richdocumentscode.tar.gz
sudo -u www-data tar xzvf richdocumentscode.tar.gz
sudo -u www-data rm richdocumentscode.tar.gz
cd ..
sudo -u www-data php ./occ app:enable richdocumentscode 

mermaid-marina avatar Mar 13 '21 19:03 mermaid-marina

Wonderful, thank you, @mermaid-marina!

Moini avatar Mar 15 '21 19:03 Moini

Downgrading to 606 did not help, downgrading to 601 did. So the problem must already have been introduced with 606.

Moini avatar Mar 15 '21 19:03 Moini

Would you mind re-testing with version 6.4.705?

timar avatar Mar 22 '21 14:03 timar

Same behaviour as with 6.4.606 and up. System is slowing down, no entries in the log file.

mermaid-marina avatar Mar 22 '21 14:03 mermaid-marina

6.4.705 seems to be working now on Nextcloud 21.0.0 and on 20.0.8 Thank you!

brtptrs avatar Mar 22 '21 15:03 brtptrs

6.4.705 is working fine on Arch/NGINX/MariaDB/PHP8.

nursoda avatar Mar 22 '21 22:03 nursoda

Problem returns with 6.4.705 :/

Downgrading again.

Moini avatar Mar 23 '21 00:03 Moini

Also using apache2, like mermaid-marina, in case that could be relevant.

Moini avatar Mar 23 '21 01:03 Moini

Apache 2.4.41 PHP 7.4.3 MySQL 8.0.23 Nextcloud 20.0.8

Installed NC Apps:

  • accessibility: 1.6.0
  • activity: 2.13.4
  • analytics: 3.4.1
  • apporder: 0.12.0
  • audioplayer: 3.1.0
  • audioplayer_editor: 0.3.0
  • bruteforcesettings: 2.0.1
  • calendar: 2.1.3
  • camerarawpreviews: 0.7.10
  • checksum: 1.1.2
  • cloud_federation_api: 1.3.0
  • comments: 1.10.0
  • contacts: 3.5.1
  • contactsinteraction: 1.1.0
  • dashboard: 7.0.0
  • dav: 1.16.2
  • epubreader: 1.4.5
  • external: 3.7.2
  • extract: 1.3.1
  • federatedfilesharing: 1.10.2
  • federation: 1.10.1
  • files: 1.15.0
  • files_antivirus: 3.2.0
  • files_pdfviewer: 2.0.1
  • files_rightclick: 0.17.0
  • files_sharing: 1.12.2
  • files_texteditor: 2.14.0
  • files_trashbin: 1.10.1
  • files_versions: 1.13.0
  • files_videoplayer: 1.9.0
  • firstrunwizard: 2.9.0
  • forms: 2.2.2
  • logreader: 2.5.0
  • lookup_server_connector: 1.8.0
  • mail: 1.9.3
  • nextcloud_announcements: 1.9.0
  • notes: 4.0.4
  • notifications: 2.8.0
  • oauth2: 1.8.0
  • password_policy: 1.10.1
  • photos: 1.2.3
  • polls: 1.7.5
  • privacy: 1.4.0
  • provisioning_api: 1.10.0
  • radio: 1.0.3
  • ransomware_protection: 1.10.0
  • recommendations: 0.8.0
  • richdocuments: 3.7.17
  • richdocumentscode: 6.4.601
  • serverinfo: 1.10.0
  • settings: 1.2.0
  • sharebymail: 1.10.0
  • support: 1.3.0
  • survey_client: 1.8.0
  • systemtags: 1.10.0
  • tasks: 0.13.6
  • text: 3.1.0
  • theming: 1.11.0
  • twofactor_backupcodes: 1.9.0
  • updatenotification: 1.10.0
  • user_status: 1.0.1
  • viewer: 1.4.0
  • weather_status: 1.0.0
  • workflowengine: 2.2.0

config.php:

$CONFIG = array (
  'instanceid' => 'nnn',
  'passwordsalt' => 'nnn',
  'secret' => 'nnn',
  'trusted_domains' =>
  array (
    0 => 'nextcloud.nnn.de',
  ),
  'datadirectory' => '/var/www/nc_data',
  'dbtype' => 'mysql',
  'version' => '20.0.8.1',
  'overwrite.cli.url' => 'https://nextcloud.nnn.de:443',
  'overwriteprotocol' => 'https',
  'dbname' => 'nextcloud',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => 'nnn',
  'installed' => true,
  'maintenance' => false,
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'app_install_overwrite' =>
  array (
    0 => 'occweb',
  ),
  'mail_from_address' => 'webmaster',
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => 'nnn.de',
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtphost' => 'smtp.nnn.de',
  'mail_smtpport' => '465',
  'mail_smtpname' => 'nnn',
  'mail_smtppassword' => 'nnn',
  'log_type' => 'file',
  'logfile' => '/var/www/nc_data/nextcloud.log',
  'loglevel' => 2,
  'logdateformat' => 'F d, Y H:i:s',
  'theme' => '',

Apache Configuration:

<VirtualHost *:443>
        ServerName nextcloud.nnn.de
        ServerAdmin [email protected]

        Include /etc/ssl/ionos/options-ssl-apache.conf

        DocumentRoot /var/www/nextcloud

        ErrorLog ${APACHE_LOG_DIR}/nextcloud_error.log
        CustomLog ${APACHE_LOG_DIR}/nextcloud_access.log combined

        # For most configuration files from conf-available/, which are
        # enabled or disabled at a global level, it is possible to
        # include a line for only one particular virtual host. For example the
        # following line enables the CGI configuration for this host only
        # after it has been globally disabled with "a2disconf".
        #Include conf-available/serve-cgi-bin.conf

        <IfModule mod_headers.c>
                Header always set Strict-Transport-Security "max-age=15552000; includeSubDomains"
        </IfModule>

        <Directory /var/www/nextcloud/>
                Require all granted
                Options FollowSymlinks MultiViews
                AllowOverride All
                <IfModule mod_dav.c>
                        Dav off
                </IfModule>
                SetEnv HOME /var/www/nextcloud
                SetEnv HTTP_HOME /var/www/nextcloud
                Satisfy Any
        </Directory>
</VirtualHost>

mermaid-marina avatar Mar 23 '21 08:03 mermaid-marina

I'm having the same issue. I tried multiple versions and they all render the installation unusable. Disabling this app makes everything work again. My environment is ARM64 installation, using docker-compose (sqlite, nginx proxy). The same machine running on a single docker container (sqlite, no proxy) worked just fine with the latest version. My guess is that it has something to do with the CODE server not being reachable from the container/through the proxy.

rolandoam avatar Apr 09 '21 04:04 rolandoam

Updating Nextcloud from 20.0.8 to 20.0.9 (manual upgrade) solved the problem for me; 6.4.705 is running as expected now.

mermaid-marina avatar Apr 12 '21 12:04 mermaid-marina

Can't confirm that for my own installation :-/ Used the webupdater, for both.

After deactivating, performance is better again.

Moini avatar Apr 12 '21 13:04 Moini

just updated nextcloud to the latest version, still having the same issues. I still have to disable the CODE server to have a functional installation.

rolandoam avatar Apr 15 '21 20:04 rolandoam

I'm not seeing the problem any more. I uninstalled both apps (frontend and server) completely (not just deactivated) and reinstalled them after upgrading NC. Maybe that helps.

brtptrs avatar Apr 16 '21 07:04 brtptrs

Same issue here. It appears to be only when Nextcloud is behind a reverse proxy. When I connect to it directly via IP, it works fine. But when I connect to it via my domain name, it just times out half of the time. Tried different installation methods, too. (Docker and Snap) Here's the setup I have if that's important: I have Nextcloud and MariaDB running inside a docker container listening on port 8083, which is behind an Nginx Reverse Proxy using a bit of management software called Nginx Proxy Manager. My domain name uses Cloudflare Protection too.

morg-mov avatar Apr 19 '22 21:04 morg-mov

Yes, there's a way to downgrade. With Ubuntu 20.04 and Nextcloud installed manually in /var/www/nextcloud this worked for me:

Deinstall CODE 6.4.607 via Nextcloud's "Apps" menu. After deinstalling CODE:

cd /var/www/nextcloud/apps
sudo -u www-data wget https://github.com/CollaboraOnline/richdocumentscode/releases/download/6.4.601/richdocumentscode.tar.gz
sudo -u www-data tar xzvf richdocumentscode.tar.gz
sudo -u www-data rm richdocumentscode.tar.gz
cd ..
sudo -u www-data php ./occ app:enable richdocumentscode 

Thank you! This worked perfectly. Even on NCpi 24. I can confirm the new CODE server makes NC unuseable. Only accessible via SSH to diasable the app again.

Oberlurch3000 avatar Jun 27 '22 15:06 Oberlurch3000