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.
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.
Hello,
and thanks for the tip!
I beg your pardon, but … I just didn’t understand what to start and what to do!
Could you please be simpler and more patient?