Several issues after upgrading to Nextcloud 21

Hi all,

I (accidentally) upgraded from Nextcloud 20.0.8 to 21.0.1 today.
I was mislead by the update notification telling me the next patch version (20.0.9) was available and started the updater without checking the version number.

After some minor hiccups (the web updater timed out during the backup step initially, so I used the updater.phar CLI), the upgrade succeeded.

Here is a list of issues I’m experiencing that may or may not be related to each other:

  • Logging in to the web interface now takes between 30 sec and 1 min, sometimes I even get 504 errors
  • Calendar/tasks (CalDAV) and contacts (CardDAV) synchronization stopped working on iOS and macOS (I’ve also tried 3rd party clients without success)
  • Nextcloud News feed synchronization with Fiery Feeds (iOS app) stopped working

My guess is that the main issue is related to the login timing out but I cannot say for sure.
I would really appreciate any advice on how to fix these issues.

My config:

  • Nextcloud version: 21.0.1 (linuxserverio/nextcloud:version-21.0.1)
  • Operating system and version: Ubuntu 18.04.5 LTS host running Docker
  • Apache or nginx version: nginx 1.18.0
  • PHP version: 7.4.15

Things I’ve already tried:

  • Removing entries from Mariadb oc_bruteforce_attempts
  • Disabling bruteforcesettings entirely (it was the only app without v21 support…)
  • Fixing Administration > Overview > Security & setup warnings (now the only advice left is /.well-known/webfinger resolution)
  • Verified that /.well-known/{cal,card}dav correctly resolve to remote.php/dav/

Thank you very much in advance!

Fabian

1 Like

I have the same issues, except the slow login, since i use SSO.
I made a ticket on github:

1 Like

I found a solution to the “slow login” problem: deleting redundant entries in the oc_authtoken table.
The improved login speed also fixed the issues related to Card/CalDAV clients.

Here’s a brief description of how I pinpointed the issue, in case it helps anyone:

First, I created a new Nextcloud user and took some statistics on the login wait time using the Firefox dev tools.
My user averaged 30 seconds until successful login whereas the newly created user averaged 2 seconds.
I started to look into the mysql.log (enabled with set global general_log=1; as root DB user) and found many queries of the form:

update oc_authtoken set password = 'xxxxx' where id = xxx;

There were about 100 of these queries for every login attempt of my user which caused the login slowness.
I duplicated the table (as a backup) and then deleted all rows related to my user with:

delete from oc_authtoken where login_name = '<username>';

The average login wait time is now around 4 seconds.

5 Likes

Hello,
and thanks for the tip!
I beg your pardon, but … I just didn’t understand what to start and what to do! :blush: :blush: :blush:
Could you please be simpler and more patient?

1 Like

Hi @fabsta, apparently quite a few other users, myself included, also have this problem.

Could you please describe the procedure you used in detail so that it can be reproduced by users who are not database specialists.

Thanks a lot!

1 Like

Hi @zone42, please check the following issue for a more detailed description and a workaround: Logintoken are Invalidated 21.0.1 · Issue #26502 · nextcloud/server · GitHub.

The problem is that all auth tokens are renewed at each login in version 21.0.1 which causes the slow login performance.

You can apply this fix from one of the comments as a workaround until it gets resolved in a release: Logintoken are Invalidated 21.0.1 · Issue #26502 · nextcloud/server · GitHub.

Let me know if anything remains unclear!

3 Likes

The workaround works well.

Thx

1 Like

This workaround helped me, too. This should be addressed by the developers ASAP. I couldn’t use the web frontend for ages.

By removing extra authtoken from database solved my slow login issue! (also solved slow DAV issue)

as described by @fabsta
delete from oc_authtoken where login_name = ‘’;

This is the correct solution!