I did try the solution recommended here Several issues after upgrading to Nextcloud 21 and the same account could login in a few seconds.
- Login to MySQL execute query on owncloud DB
- oc_authtoken MariaDB [owncloud]> delete from oc_authtoken where login_name = ‘user’;
- Query OK, 1701 rows affected (2.434 sec)
- After I could login with the same user through the web in under 10 seconds
I did have to reauthenticate on some clients, but I could login through the web. No significant effect on mobile clients, other than having to reauthenticate. Unfortunately 24 hours later I cannot log in through the web again.
A quick MariaDB [owncloud]> select login_name, count(*) from oc_authtoken group by login_name; shows this user now has 3,265 tokens.