• [^] # Re: Galera la galère

    Posté par . En réponse au message MariaDB/Galera cluster - Mysql is gone away | Got an error reading communication packets. Évalué à 1. Dernière modification le 09 mars 2018 à 23:03.

    Il ne semble rien y avoir de spécial (en tout cas rien d'indiqué).
    Pour le moment les services semblent refonctionner mais dans service mysql status je continue d'avoir des erreurs comme suit. Ça provoque des erreurs de chargements de page par moment voir le crash de zoneminder.

    mar 09 18:08:59 ServerOne mysqld[8743]: 2018年03月09日 18:08:59 139850175325952 [Warning] Aborted connection 534 to db: 'zoneminder_database' user: 'zoneminder_user' host: 'ServerOne.BDD' (Got an error reading communication packets)
mar 09 18:08:59 ServerOne mysqld[8743]: 2018年03月09日 18:08:59 139850175325952 [Warning] Aborted connection 548 to db: 'zoneminder_database' user: 'zoneminder_user' host: 'ServerOne.BDD' (Got an error reading communication packets)
mar 09 18:08:59 ServerOne mysqld[8743]: 2018年03月09日 18:08:59 139849818568448 [Warning] Aborted connection 549 to db: 'zoneminder_database' user: 'zoneminder_user' host: 'ServerOne.BDD' (Got an error reading communication packets)
mar 09 18:08:59 ServerOne mysqld[8743]: 2018年03月09日 18:08:59 139849817962240 [Warning] 558 to db: 'zoneminder_database' user: 'zoneminder_user' host: 'ServerOne.BDD' (Got an error reading communication packets)
mar 09 18:08:59 ServerOne mysqld[8743]: 2018年03月09日 18:08:59 139849818568448 [Warning] 557 to db: 'zoneminder_database' user: 'zoneminder_user' host: 'ServerOne.BDD' (Got an error reading communication packets)
mar 09 18:09:01 ServerOne mysqld[8743]: 2018年03月09日 18:09:01 139849818265344 [Warning] 554 to db: 'zoneminder_database' user: 'zoneminder_user' host: 'ServerOne.BDD' (Got an error reading communication packets)
mar 09 18:09:01 ServerOne mysqld[8743]: 2018年03月09日 18:09:01 139849818871552 [Warning] 552 to db: 'zoneminder_database' user: 'zoneminder_user' host: 'ServerOne.BDD' (Got an error reading communication packets)
mar 09 18:20:52 ServerOne mysqld[8743]: 2018年03月09日 18:20:52 139849371322112 [Warning] 1425 to db: 'nextcloud_database' user: 'nextcloud_user' host: 'Haproxy_Frontend' (Got an error reading communication packets)
mar 09 20:37:58 ServerOne mysqld[8743]: 2018年03月09日 20:37:58 139849371019008 [Warning] 9999 to db: 'nextcloud_database' user: 'nextcloud_user' host: 'ServerOne.BDD' (Got an error reading communication packets)

    Note : j'ai re-purgé mariadb et galera puis ré-installé, ré-injecté mes backup et cluster désactivé (mode mono-machine).