Very slow login after updating to 21.0.3

mercurio · April 15, 2021, 6:34pm

Thanks so much for the tip!
Here is the result:

No OC found
t.getLanguage @ main.js:1
value @ main.js:1
(anonymous) @ main.js:1
(anonymous) @ main.js:1
n @ main.js:1
(anonymous) @ main.js:1
n @ main.js:1
(anonymous) @ main.js:1
(anonymous) @ main.js:1
n @ main.js:1
(anonymous) @ main.js:1
(anonymous) @ main.js:1
 JQMIGRATE: Migrate is installed, version 3.3.2
 jQuery is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ files_client.js:1
(anonymous) @ files_client.js:1
0 @ files_client.js:1
n @ files_client.js:1
704 @ files_client.js:1
n @ files_client.js:1
(anonymous) @ files_client.js:1
(anonymous) @ files_client.js:1
 $ is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ files_client.js:1
(anonymous) @ files_client.js:1
0 @ files_client.js:1
n @ files_client.js:1
704 @ files_client.js:1
n @ files_client.js:1
(anonymous) @ files_client.js:1
(anonymous) @ files_client.js:1
 $ is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
mounted @ notifications-main.js:337
zt @ notifications-main.js:7
Ke @ notifications-main.js:7
insert @ notifications-main.js:7
L @ notifications-main.js:7
(anonymous) @ notifications-main.js:7
t._update @ notifications-main.js:7
r @ notifications-main.js:7
pn.get @ notifications-main.js:7
pn @ notifications-main.js:7
t @ notifications-main.js:7
Mn.$mount @ notifications-main.js:7
t._init @ notifications-main.js:7
Mn @ notifications-main.js:7
(anonymous) @ notifications-main.js:357
n @ notifications-main.js:1
(anonymous) @ notifications-main.js:1
(anonymous) @ notifications-main.js:1
 $ is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
mounted @ notifications-main.js:337
zt @ notifications-main.js:7
Ke @ notifications-main.js:7
insert @ notifications-main.js:7
L @ notifications-main.js:7
(anonymous) @ notifications-main.js:7
t._update @ notifications-main.js:7
r @ notifications-main.js:7
pn.get @ notifications-main.js:7
pn @ notifications-main.js:7
t @ notifications-main.js:7
Mn.$mount @ notifications-main.js:7
t._init @ notifications-main.js:7
Mn @ notifications-main.js:7
(anonymous) @ notifications-main.js:357
n @ notifications-main.js:1
(anonymous) @ notifications-main.js:1
(anonymous) @ notifications-main.js:1
 $ is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
mounted @ notifications-main.js:337
zt @ notifications-main.js:7
Ke @ notifications-main.js:7
insert @ notifications-main.js:7
L @ notifications-main.js:7
(anonymous) @ notifications-main.js:7
t._update @ notifications-main.js:7
r @ notifications-main.js:7
pn.get @ notifications-main.js:7
pn @ notifications-main.js:7
t @ notifications-main.js:7
Mn.$mount @ notifications-main.js:7
t._init @ notifications-main.js:7
Mn @ notifications-main.js:7
(anonymous) @ notifications-main.js:357
n @ notifications-main.js:1
(anonymous) @ notifications-main.js:1
(anonymous) @ notifications-main.js:1
 Notifications permissions not yet requested
 jQuery is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ sidebar.js:1
(anonymous) @ sidebar.js:1
(anonymous) @ sidebar.js:1
n @ sidebar.js:1
(anonymous) @ sidebar.js:1
n @ sidebar.js:1
(anonymous) @ sidebar.js:1
(anonymous) @ sidebar.js:1
 $ is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ sidebar.js:1
(anonymous) @ sidebar.js:1
(anonymous) @ sidebar.js:1
n @ sidebar.js:1
(anonymous) @ sidebar.js:1
n @ sidebar.js:1
(anonymous) @ sidebar.js:1
(anonymous) @ sidebar.js:1
 Handlebars is deprecated: please ship your own, this will be removed in Nextcloud 20
pe @ main.js:1
get @ main.js:1
(anonymous) @ activity-sidebar.js:127
(anonymous) @ activity-sidebar.js:387
activity-sidebar.js:603 Uncaught TypeError: Cannot read property 'extend' of undefined
    at activity-sidebar.js:603
    at activity-sidebar.js:803
(anonymous) @ activity-sidebar.js:603
(anonymous) @ activity-sidebar.js:803
 jQuery is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ script.js:492
 jQuery is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ files.js:122
 session heartbeat polling started
 $ is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ backgroundjobs.js:24
 $ is deprecated: The global jQuery is deprecated. It will be updated to v3.x in Nextcloud 21. In later versions of Nextcloud it might be removed completely. Please ship your own.
pe @ main.js:1
get @ main.js:1
(anonymous) @ backgroundjobs.js:26

mercurio · April 15, 2021, 6:36pm

Ah understood, thanks.
The fact is that all the registers consulted so far stop at April, the day of the update …

Beltran1337 · April 15, 2021, 6:36pm

Thank you for your words @MichaIng

And @mercurio is that the result of the performance section?

Can you please attach an screenshot instead of the raw text output?

Thanks man, let’s fix this!!

MichaIng · April 15, 2021, 6:54pm

That was regular browser console log. Also good to see but no error that I do not see as well. I even get two other TypeErrors but they do not delay the page load here.

Interesting would be either the performance or the network tab of the developer tools, like:

Beltran1337 · April 15, 2021, 8:01pm

Okay man, thank you for sharing.

Sort it by time and check what is consuming that amount of performance.

I see that you have the app “Talk” enabled. Well, the Spreed app aka Talk have a lot of performance improvement that you can do on the database to make it faster.

Have you ever done one of those?

mercurio · April 16, 2021, 11:09am

Here I am Beltran1337,
and I’m sorry if I only answer you now!
So yes they were the results of the performance section. Anyway here is the screenshot:

Beltran1337 · April 16, 2021, 11:21am

Hey there, thank you replying man!

And WOW 5 minutes wasted at the login file, there’s something very strange happening there.

Can you please send your virtualhost/apache .conf file?

mercurio · April 16, 2021, 11:42am

But thanks to you!
Forgive me I did not understand: do you want me to post you the apache.conf file?

Beltran1337 · April 16, 2021, 11:57am

Yes, post your nextcloud.conf from you apache’s directory.

Example: cat /etc/apache2/sites-enabled/nextcloud.conf

Or whatever name/directory you have it installed.

If you do not know where it is, run this:

find / -iname nextcloud.conf

Hope this helps, then we can start fixing things.

mercurio · April 16, 2021, 12:27pm

So, here it is:

<IfModule mod_ssl.c>
SSLStaplingCache shmcb:/var/run/apache2/stapling_cache(128000)
	<VirtualHost _default_:443>

	ServerAdmin renzo79@oreste.hopto.org
	ServerName oreste.hopto.org
	DocumentRoot /var/ww/html/nextcloud/

	<Directory /var/www/html/nextcloud/>
	    Options +FollowSymLinks
	    AllowOverride All

	<IfModule mod_dav.c>
	    Dav Off
	</IfModule>


	SetEnv HOME /var/www/html/nextcloud/
	SetEnv HTTP_HOME /var/www/html/nextcloud/
	</Directory>

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

	SSLEngine On
	SSLCertificateFile /etc/letsencrypt/live/oreste.hopto.org/fullchain.pem
	SSLCertificateKeyFile /etc/letsencrypt/live/oreste.hopto.org/privkey.pem

	</VirtualHost>
</IfModule>

Beltran1337 · April 16, 2021, 12:47pm

Okay, thank you for sharing, I suggest you to change your config to the following:

REMEMBER TO STOP APACHE’S SERVICE BEFORE DOING THE CHANGES

<IfModule mod_ssl.c>
SSLStaplingCache shmcb:/var/run/apache2/stapling_cache(128000)
<VirtualHost *:80>
        ServerName  oreste.hopto.org
        ServerAdmin renzo79@oreste.hopto.org
        DocumentRoot /var/www/html/nextcloud/

        Redirect permanent / https://your.nextcloud.domain.com
        RewriteEngine On
        RewriteCond %{HTTPS} off
        RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [R=301,L]
</VirtualHost>	
<VirtualHost *:443>

	ServerAdmin renzo79@oreste.hopto.org
	ServerName oreste.hopto.org
	DocumentRoot /var/ww/html/nextcloud/

	<Directory /var/www/html/nextcloud/>
	    Require all granted
	    AllowOverride All
        Options FollowSymLinks MultiViews

	<IfModule mod_dav.c>
	    Dav Off
	</IfModule>


	SetEnv HOME /var/www/html/nextcloud/
	SetEnv HTTP_HOME /var/www/html/nextcloud/
	</Directory>

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

	SSLEngine On
	SSLCertificateFile /etc/letsencrypt/live/oreste.hopto.org/fullchain.pem
	SSLCertificateKeyFile /etc/letsencrypt/live/oreste.hopto.org/privkey.pem

	</VirtualHost>
</IfModule>

After this changes, start you apache’s service.

I hope that resolve your issue. Good luck mate.

PS.: You may need to add a “+” before “FollowSymLinks” and “MultiViews”. But test without it first.

PS 2.: Remember to change the “https://your.nextcloud.domain.com” line.

mercurio · April 16, 2021, 1:08pm

No change, unfortunately…
With the +, gives me an error, does not restart apache2.service.

Beltran1337 · April 16, 2021, 1:21pm

Okay, so let’s try one more thing.

But first, one question: Do you have any cache service running? Example: Redis.

1) sudo -u www-data php /var/www/nextcloud/occ maintenance:mode --on
2) chown -R www-data:www-data /var/www/nextcloud/
3) chmod -R 770 /var/www/nextcloud/
4) sudo -u www-data php /var/www/nextcloud/occ maintenance:repair
5) sudo -u www-data php /var/www/nextcloud/occ db:add-missing-columns
6) sudo -u www-data php /var/www/nextcloud/occ db:add-missing-indices
7) sudo -u www-data php /var/www/nextcloud/occ maintenance:update:htaccess
8) sudo -u www-data php /var/www/nextcloud/occ maintenance:mode --off
9) sudo systemctl restart apache2

Also, check your php version running “php -v”, that can help a lot.

Make sure you have php-fpm installed and running.

Hope this helps, have a nice weekend.

All the best!

mercurio · April 16, 2021, 1:30pm

You are really kind and helpful, and above all you don’t give up!
No, no cache services, I’ve never been able to set one up.
Before doing the operations you asked me, do I always have to stop apache2.service?
And this is my version of php:

orestis@orestis:~$ php -v
PHP 7.4.16 (cli) (built: Mar  5 2021 07:54:38) ( NTS )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
    with Zend OPcache v7.4.16, Copyright (c), by Zend Technologies

which I installed by activating the ondrej repositories.

Beltran1337 · April 16, 2021, 1:33pm

Thank you man, let’s fix your server!!

And it’s always a best practice to stop apache’s service before changing any apache config file, but for the commands that I mentioned above, they are not related to apache’s config files.

So in this case, it’s not necessary to stop the service, only restart it on the end to make sure it applies the repaired nextcloud’s files.

Good luck mate.

mercurio · April 16, 2021, 2:22pm

Nothing to do, unfortunately …
While I was giving the commands you suggested, did it seem to me that she was saying that everything was already fine?
Is it time to give up and format everything?

Beltran1337 · April 16, 2021, 2:27pm

Sorry to hear that.

I would suggest you to reinstall only your httpd server (apache), but that can leave some traces and bugs behind.

Unfortunately the easiest/faster/secure way would be to do a fresh install…

If you have any data, you can backup them and later just copy to the new data folder.

Also, I recommend you to only copy the files from the users and not the user’s folder, because it can conflict with a future DB.

Hope you can resolve it man, sorry that I could not been more helpful for that.

Good luck brotha!

mercurio · April 16, 2021, 2:31pm

Are you kidding? You were really kind and helpful, thank you very much!!!
Patience, I will do a new clean installation, after all it was from NC19 that I did not and then I have a backup copy of all the data stored.

A curiosity forgive me !: what exactly do you mean by “Also, I recommend you to only copy the files from the users and not the user’s folder, because it can conflict with a future DB.”?

fabsta · April 16, 2021, 3:09pm

I’ve had a very similar issue after the upgrade to 21.0.1. I just fixed it myself, hope it helps you too: Several issues after upgrading to Nextcloud 21 - #3 by fabsta.

Beltran1337 · April 16, 2021, 4:23pm

Okay mate, good luck. NC 21.0.1 is working flawless here.

I said that because I had problems in the past copying all the “/data” folder an pasting on the new NC installation. So what I recommend to you (if you are planning to bkp/recover the data) is to copy the user’s folder individually.

Did you understand?

Have a nice weekend brotha!