[08:07:36]
<thatoo> Hello, this morning I realize that CPU of my ynh is working at 100%
When I do a `sudo htop` I get the following :
[08:07:40]
<thatoo> https://aria.im/_matrix/media/v1/download/defis.info/vOGXVMkhJjyPLEGPGhtdyBCC
[08:08:29]
<thatoo> I guess something is wrong with mariadb. I tried rebooting ynh, it didn't change anything. I don't know much how to debug mariadb.
[08:57:10]
<orhtej2> > <@thatoo:defis.info> I guess something is wrong with mariadb. I tried rebooting ynh, it didn't change anything. I don't know much how to debug mariadb.
Get into mariadb shell and execute `show processlist` perhaps to locate offending queries?
[08:57:40]
<Séβαστιεν> Il y a une question que je me pose depuis un moment. Le FAI ou est mon serveur Yunohost ne gère pas l’IPV6 ni le reverse DNS. Si je le fais passer par un VPN (FFDN), pourrai-je récupérer cet IPV6 et un reverse DNS ?
[09:01:47]
<thatoo> ```
MariaDB [(none)]> show processlist;
+-----+-----------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+-----------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
| 330 | nextcloud | localhost | nextcloud | Query | 1444 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 338 | nextcloud | localhost | nextcloud | Query | 1379 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 345 | nextcloud | localhost | nextcloud | Query | 1322 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 347 | nextcloud | localhost | nextcloud | Query | 1315 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 351 | nextcloud | localhost | nextcloud | Query | 1231 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 354 | nextcloud | localhost | nextcloud | Query | 1197 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 358 | nextcloud | localhost | nextcloud | Query | 1014 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 367 | nextcloud | localhost | nextcloud | Query | 954 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 372 | nextcloud | localhost | nextcloud | Query | 888 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 377 | nextcloud | localhost | nextcloud | Query | 858 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 382 | nextcloud | localhost | nextcloud | Query | 825 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 385 | nextcloud | localhost | nextcloud | Query | 768 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 388 | nextcloud | localhost | nextcloud | Query | 729 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 392 | nextcloud | localhost | nextcloud | Query | 585 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 395 | nextcloud | localhost | nextcloud | Query | 564 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 401 | nextcloud | localhost | nextcloud | Query | 103 | Sending data | SELECT DISTINCT `s`.`id`, `s`.`nid`, `s`.`id_prim`, `s`.`visibility`, `s`.`type`, `s`.`subtype`, `s` | 0.000 |
| 403 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |
+-----+-----------+-----------+-----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
```
[09:02:17]
<thatoo> I don't know if it means something
[09:05:55]
<thatoo> nextcloud doesn't answer (I didn't check that before now) but it makes sens. I check everything else and everything is working.
[09:06:18]
<thatoo> nextcloud doesn't answer (I didn't check that before now) but it makes sens. I check everything else and everything is working. SO the issue is with nextcloud database but I don't know what.
[09:28:46]
<thatoo> If I restart mysql, I can access for few seconds to nextcloud, go to admin settings and I can see the following logs :
```
SQLSTATE[HY000] [2002] No such file or directory
Exception thrown: Doctrine\DBAL\Exception
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2002] No such file or directory at /var/www/nextcloud/lib/private/DB/Connection.php#139
```
[09:51:58]
<thatoo> I hesitate. Should I try updating yunohost and nextcloud to last version? Can it help?
[09:55:50]
<thatoo> I set nextcloud in maintenance mode but it doesn't help
[10:11:31]
<thatoo> If I set nextcloud maintenance mode ON and then I restart mysql, then it's fine. As soon as I set nextcloud maintenance mode OFF again, then mariadb becomes crazy again.
[10:16:22]
<orhtej2> Hmmm not sure what to do about it honestly, some index is missing perhaps?
[10:16:36]
<thatoo> And then, with maintenance mode ON
```
MariaDB [(none)]> show processlist;
+-----+------+-----------+------+---------+------+----------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+-----+------+-----------+------+---------+------+----------+------------------+----------+
| 223 | root | localhost | NULL | Query | 0 | starting | show processlist | 0.000 |
+-----+------+-----------+------+---------+------+----------+------------------+----------+
1 row in set (0,000 sec)
```
MariaDB [(none)]> Ctrl-C -- exit!
[10:16:56]
<orhtej2> Or some crawler is indexing the contents?
[10:18:23]
<thatoo> should I try updating and hope some kind of maintenance operation helps mysql to be ok again?
[10:19:05]
<orhtej2> Thats an option for sure, what version are you running?
[10:19:26]
<thatoo> just the one before 28.0.5~ynh1
[10:21:40]
<orhtej2> Perhaps disable apps if you have custom ones installed?
[10:23:07]
<thatoo> Are all app mentioned as "Featured" ok?
[10:24:32]
<orhtej2> Disable random ones and see what sticks 😜
[10:25:29]
<orhtej2> Also theres oprion to see full query in process list, perhaps that will give you some insight?
[10:27:16]
<thatoo> > Also theres oprion to see full query in process list, perhaps that will give you some insight?
sorry, I didn't get that one
[10:28:47]
<thatoo> Indeed, disabling a bunch of apps solved the issue.
[10:29:03]
<thatoo> I'll enable them one by one to find the guilty one.
[10:30:04]
<orhtej2> > <@thatoo:defis.info> sorry, I didn't get that one
`show full processlist` does not truncate the query
[10:37:07]
<thatoo> so the guilty app is `social`
[10:38:39]
<thatoo> thank you orhtej2 for your help
[14:33:09]
<isAAAc> > <@tuxakadjseb:mozilla.org> Il y a une question que je me pose depuis un moment. Le FAI ou est mon serveur Yunohost ne gère pas l’IPV6 ni le reverse DNS. Si je le fais passer par un VPN (FFDN), pourrai-je récupérer cet IPV6 et un reverse DNS ?
pourquoi pas hoster ton serveur directement chez un membre de FFDN ? genre aquilenet par exemple, mais il y en a d'autres
[16:09:18]
<Séβαστιεν> À ma connaissance, la FFDN ne gère que l’ADSL chez moi (Maine-et-Loire).
[16:41:34]
<pti-jean> > <@tuxakadjseb:mozilla.org> Il y a une question que je me pose depuis un moment. Le FAI ou est mon serveur Yunohost ne gère pas l’IPV6 ni le reverse DNS. Si je le fais passer par un VPN (FFDN), pourrai-je récupérer cet IPV6 et un reverse DNS ?
À mon avis oui...
Autre avantage d'auto-hébergé (avec éventuellement un VPN)... c'est de pouvoir faire rapidement des backup avec rpi-clone!
[17:01:14]
<Séβαστιεν> En fait, j’ai FAImaison (FFDN de Nantes) chez moi en ADSL. Le serveur est chez ma mère, qui a la fibre.
[17:18:43]
<isAAAc> > <@tuxakadjseb:mozilla.org> À ma connaissance, la FFDN ne gère que l’ADSL chez moi (Maine-et-Loire).
https://www.aquilenet.fr/services/fibre/
[17:21:46]
<Séβαστιεν> Merci isAAAc. Je vais étudier ça de près.
[23:14:43]
<Alnotz> ```
Warning: The configuration file '/etc/ssh/sshd_config' has been manually modified and will not be updated
```
Ha, c’est possible de repasser en mode automatique ?
[23:15:48]
<Alnotz> Une manière de réinitialiser ce fichier sans réinstaller YunoHost ?
[23:16:06]
<Aleks (he/him/il/lui)> `yunohost tools regen-conf ssh --dry-run --with-diff` puis si t'es content, `yunohost tools regen-conf ssh --force`
[23:19:55]
<Alnotz> Merci pour cette astuce Aleks (he/him/il/lui). :-)
[23:20:59]
*Alnotz continue d’étudier la sécurité de sa machine.