Nextcloud version 24.0.4
Operating system and version Ubuntu 20.04
Apache version Apache/2.4.52
PHP version 8.0
Mysql version mysql Ver 8.0.30-0ubuntu0.22.04.1
The issue you are facing:
Is this the first time you’ve seen this error? (Y/N): N
My CPU is very busy on my nextcloud and the temperature very hight until I restart mysql …
So
I made a nextcloud “single user” to test -
Using the pidstat -t -p [pid-of-mysqld] I can see that when I make a connexion using my browser, I’ve got threads with “connection” using CPU … normal … but … they still remain when I disconnect and still use CPU
THat increase my CPU that doesn’t get down and higths my CPU temperature …
Only solution : restart the mysql service
what I see in pidstat 10:13:02 128 - 149875 0,00 0,00 0,00 0,00 0,00 10 |__connection
10:13:02 128 - 149876 0,00 0,00 0,00 0,00 0,00 4 |__connection
10:13:02 128 - 149930 0,00 0,00 0,00 0,00 0,00 5 |__connection
10:13:02 128 - 149931 0,00 0,00 0,00 0,00 0,00 5 |__connection
10:13:02 128 - 149932 0,00 0,00 0,00 0,00 0,00 2 |__connection
10:13:02 128 - 149933 13,00 3,00 0,00 0,00 16,00 7 |__connection
10:13:02 128 - 149934 0,00 0,00 0,00 0,00 0,00 4 |__connection
10:13:02 128 - 149935 0,00 0,00 0,00 0,00 0,00 5 |__connection
Half an hour after my disconnexion , still “connection” threads alive ( it changes from time to time which one is using CPU)
10:44:52 128 - 149875 0,00 0,00 0,00 0,00 0,00 0 |__connection
10:44:52 128 - 149876 0,00 0,00 0,00 0,00 0,00 11 |__connection
10:44:52 128 - 149930 0,00 0,00 0,00 0,00 0,00 0 |__connection
10:44:52 128 - 149931 0,00 0,00 0,00 0,00 0,00 3 |__connection
10:44:52 128 - 149932 0,00 0,00 0,00 0,00 0,00 7 |__connection
10:44:52 128 - 149933 0,00 0,00 0,00 0,00 0,00 10 |__connection
10:44:52 128 - 149934 13,00 1,00 0,00 0,00 14,00 10 |__connection
10:44:52 128 - 149935 0,00 0,00 0,00 0,00 0,00 6 |__connection
Temperature while threads alive (sensors command)
Sensor 1: +76.2°C (low = -273.1°C, high = +65261.8°C)
Sensor 2: +81.5°C (low = -273.1°C, high = +65261.8°C)
Temperature after mysql restart
Sensor 1: +43.9°C (low = -273.1°C, high = +65261.8°C)
Sensor 2: +45.9°C (low = -273.1°C, high = +65261.8°C)