19/12/2023 matin - Panne partielle sur sans-nuage.fr

[ljf]

Les services utilisant la base de données mariadb sont à plat depuis ce matin.

[ljf]

La base de données a été relancée.

Explication technique

Elle s’est arrêtée à cause d’un problème de manque de mémoire ram (erreur A process of this unit has been killed by the OOM killer), une action définitive est donc à prévoir sur ce sujet.

déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1222]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
déc. 16 01:59:06 sans-nuage.fr mariadbd[915]: 2023-12-16  1:59:06 0 [Note] InnoDB: Buffer pool(s) load completed at 231216  1:59:06
déc. 17 06:56:38 sans-nuage.fr mariadbd[915]: 2023-12-17  6:56:38 2381 [Warning] Aborted connection 2381 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 16:42:35 sans-nuage.fr mariadbd[915]: 2023-12-17 16:42:35 169008 [Warning] Aborted connection 169008 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error writing communication packets)
déc. 17 17:00:11 sans-nuage.fr mariadbd[915]: 2023-12-17 17:00:11 169615 [Warning] Aborted connection 169615 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 17:00:13 sans-nuage.fr mariadbd[915]: 2023-12-17 17:00:13 169597 [Warning] Aborted connection 169597 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177491 [Warning] Aborted connection 177491 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177489 [Warning] Aborted connection 177489 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177490 [Warning] Aborted connection 177490 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177487 [Warning] Aborted connection 177487 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177488 [Warning] Aborted connection 177488 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177485 [Warning] Aborted connection 177485 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177486 [Warning] Aborted connection 177486 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177484 [Warning] Aborted connection 177484 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177475 [Warning] Aborted connection 177475 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177464 [Warning] Aborted connection 177464 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 19 05:29:46 sans-nuage.fr systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.
déc. 19 05:29:46 sans-nuage.fr systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
déc. 19 05:29:46 sans-nuage.fr systemd[1]: mariadb.service: Failed with result 'oom-kill'.
déc. 19 05:29:46 sans-nuage.fr systemd[1]: mariadb.service: Consumed 3h 24min 44.253s CPU time.
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1125]: Looking for 'mariadb' as: /usr/bin/mariadb
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1125]: Looking for 'mariadb-check' as: /usr/bin/mariadb-check
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1125]: This installation of MariaDB is already upgraded to 10.5.18-MariaDB.
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1125]: There is no need to run mysql_upgrade again for 10.5.21-MariaDB.
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1125]: You can use --force if you still want to run mysql_upgrade
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1125]: Running 'mariadb-check' with connection arguments: --socket='/run/mysqld/mysqld.sock' --host='localhost' --socket='/var/run/mysqld/mysqld.sock' --host='localhost' --socket='/v>
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1193]: Checking for insecure root accounts.
déc. 16 01:59:05 sans-nuage.fr /etc/mysql/debian-start[1222]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
déc. 16 01:59:06 sans-nuage.fr mariadbd[915]: 2023-12-16  1:59:06 0 [Note] InnoDB: Buffer pool(s) load completed at 231216  1:59:06
déc. 17 06:56:38 sans-nuage.fr mariadbd[915]: 2023-12-17  6:56:38 2381 [Warning] Aborted connection 2381 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 16:42:35 sans-nuage.fr mariadbd[915]: 2023-12-17 16:42:35 169008 [Warning] Aborted connection 169008 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error writing communication packets)
déc. 17 17:00:11 sans-nuage.fr mariadbd[915]: 2023-12-17 17:00:11 169615 [Warning] Aborted connection 169615 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 17:00:13 sans-nuage.fr mariadbd[915]: 2023-12-17 17:00:13 169597 [Warning] Aborted connection 169597 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177491 [Warning] Aborted connection 177491 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177489 [Warning] Aborted connection 177489 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177490 [Warning] Aborted connection 177490 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177487 [Warning] Aborted connection 177487 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177488 [Warning] Aborted connection 177488 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177485 [Warning] Aborted connection 177485 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177486 [Warning] Aborted connection 177486 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177484 [Warning] Aborted connection 177484 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177475 [Warning] Aborted connection 177475 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 17 18:05:27 sans-nuage.fr mariadbd[915]: 2023-12-17 18:05:27 177464 [Warning] Aborted connection 177464 to db: 'etherpad_mypads' user: 'etherpad_mypads' host: 'localhost' (Got an error reading communication packets)
déc. 19 05:29:46 sans-nuage.fr systemd[1]: mariadb.service: A process of this unit has been killed by the OOM killer.