J’ai exactement la même chose que vous, mais à une heure légèrement décalée :
[Sun Jun 20 06:39:02.822528 2021] [php7:error] [pid 13250] [client 192.168.0.49:48230] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
Stack trace:
#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '366d98c761b8b33', Array)
#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
#3 /var/www/html/core/class/config.class.php(187): DB::Prepare('SELECT `key`,`v...', Array, 1)
#4 /var/www/html/core/class/translate.class.php(34): config::byKeys(Array)
#5 /var/www/html/core/class/translate.class.php(151): translate::getConfig('language', 'fr_FR')
#6 /var/www/html/core/class/translate.class.php(75): translate::getLanguage()
#7 /var/www/html/core/class/translate.class.php(54): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
#8 /var/www/html/core/class/translate.class.php(165): translate::sentence('Chauffage', '/var/www/html/c...', false)
#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage' in /var/www/html/core/class/DB.class.php on line 40
Moi, ce qui m’étonne, c’est l’adresse IP mis en cause (192.168.0.49). C’est celle de mon antenne BLEA déportée.
Pas de lien avec le mot Chauffage que je retrouve dans le fichier de log.
Mais j’ai aussi une autre adresse :
[Sun Jun 20 06:39:02.371732 2021] [php7:error] [pid 19133] [client 127.0.0.1:38992] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
Stack trace:
#0 /var/www/html/core/class/DB.class.php(40): PDO->__construct('mysql:host=loca...', 'jeedom', '366d98c761b8b33', Array)
#1 /var/www/html/core/class/DB.class.php(50): DB::initConnection()
#2 /var/www/html/core/class/DB.class.php(82): DB::getConnection()
#3 /var/www/html/core/class/config.class.php(187): DB::Prepare('SELECT `key`,`v...', Array, 1)
#4 /var/www/html/core/class/translate.class.php(34): config::byKeys(Array)
#5 /var/www/html/core/class/translate.class.php(151): translate::getConfig('language', 'fr_FR')
#6 /var/www/html/core/class/translate.class.php(75): translate::getLanguage()
#7 /var/www/html/core/class/translate.class.php(54): translate::exec('{{Chauffage}}', '/var/www/html/c...', false)
#8 /var/www/html/core/class/translate.class.php(165): translate::sentence('Chauffage', '/var/www/html/c...', false)
#9 /var/www/html/core/config/jeedom.config.php(23): __('Chauffage' in /var/www/html/core/class/DB.class.php on line 40
Le « chauffage » est probablement juste le premier mot dont il cherche la traduction lors de l’affichage (c’est une catégorie) donc ce n’est pas relevant.
Si ce n’était pas celui-là ça serait un autre.
Mais du coup, c’est quoi qui créer ces erreurs ?
En cherchant, c’est cela semble arriver à beaucoup d’entre nous, sans cause identifiée (sur le forum).
Mais il y forcement une cause.
De ce que je comprend, c’est une erreur de connexion à la base de données.
J’ai supprimé la stack trace dans les logs ci-dessous (identique à ce qu’il y a dans les autres posts)
[Sun Jun 20 06:55:53.825931 2021] [php7:error] [pid 29729] [client 127.0.0.1:48878] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:53.838757 2021] [php7:error] [pid 9242] [client 127.0.0.1:48880] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:53.845892 2021] [php7:error] [pid 30140] [client 127.0.0.1:48882] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:54.965437 2021] [php7:error] [pid 16259] [client 127.0.0.1:48884] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.065441 2021] [php7:error] [pid 24430] [client 127.0.0.1:48886] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.125225 2021] [php7:error] [pid 8916] [client 127.0.0.1:48888] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.407392 2021] [php7:error] [pid 16875] [client 127.0.0.1:48892] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.330174 2021] [php7:error] [pid 28608] [client 127.0.0.1:48890] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.414529 2021] [php7:error] [pid 26256] [client 127.0.0.1:48894] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.422071 2021] [php7:error] [pid 29729] [client 127.0.0.1:48896] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.429346 2021] [php7:error] [pid 9242] [client 127.0.0.1:48900] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:55.431946 2021] [php7:error] [pid 30140] [client 127.0.0.1:48898] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:56.448831 2021] [php7:error] [pid 16259] [client 127.0.0.1:48904] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:56.455892 2021] [php7:error] [pid 24430] [client 127.0.0.1:48906] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:55:56.463580 2021] [php7:error] [pid 8916] [client 127.0.0.1:48908] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:56:01.083310 2021] [php7:error] [pid 16875] [client 127.0.0.1:48916] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:56:01.090771 2021] [php7:error] [pid 28608] [client 127.0.0.1:48918] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
[Sun Jun 20 06:56:01.098958 2021] [php7:error] [pid 26256] [client 127.0.0.1:48920] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] No such file or directory in /var/www/html/core/class/DB.class.php:40
À la même heure, j’ai des erreurs dans 2 plugins.
RFXCom
[2021-06-20 06:55:53][ERROR] : Error on send request to jeedom, return code 500
[2021-06-20 06:55:55][ERROR] : Error on send request to jeedom, return code 500
[2021-06-20 06:55:56][ERROR] : Error on send request to jeedom, return code 500
[2021-06-20 06:56:01][ERROR] : Error on send request to jeedom, return code 500
Xiaomi Home
[2021-06-20 06:55:55][ERROR] : Error on send request to jeedom, return code 500
[2021-06-20 06:55:55][ERROR] : Error on send request to jeedom, return code 500
Édit :
Dans le fichier de log /var/log/mysql/error.log.1.gz, on peut voir qu’il y a un redémarrage de la base de donnée
2021-06-20 6:55:51 0 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2021-06-20 6:55:51 0 [Note] Event Scheduler: Purging the queue. 0 events
2021-06-20 6:55:51 0 [Note] InnoDB: FTS optimize thread exiting.
2021-06-20 6:55:51 0 [Note] InnoDB: Starting shutdown...
2021-06-20 6:55:51 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2021-06-20 6:55:51 0 [Note] InnoDB: Instance 0, restricted to 2048 pages due to innodb_buf_pool_dump_pct=25
2021-06-20 6:55:51 0 [Note] InnoDB: Buffer pool(s) dump completed at 210620 6:55:51
2021-06-20 6:55:52 0 [Note] InnoDB: Shutdown completed; log sequence number 4995372127; transaction id 18299704
2021-06-20 6:55:52 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-06-20 6:55:52 0 [Note] /usr/sbin/mysqld: Shutdown complete
2021-06-20 6:55:58 0 [Warning] The parameter innodb_large_prefix is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2021-06-20 6:56:03 0 [Warning] The parameter innodb_large_prefix is deprecated and has no effect. It may be removed in future releases. See https://mariadb.com/kb/en/library/xtradbinnodb-file-format/
2021-06-20 6:56:03 0 [Note] InnoDB: Using Linux native AIO
2021-06-20 6:56:03 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2021-06-20 6:56:03 0 [Note] InnoDB: Uses event mutexes
2021-06-20 6:56:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-06-20 6:56:03 0 [Note] InnoDB: Number of pools: 1
2021-06-20 6:56:03 0 [Note] InnoDB: Using generic crc32 instructions
2021-06-20 6:56:03 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2021-06-20 6:56:03 0 [Note] InnoDB: Completed initialization of buffer pool
2021-06-20 6:56:03 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2021-06-20 6:56:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-06-20 6:56:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-06-20 6:56:03 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-06-20 6:56:03 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2021-06-20 6:56:03 0 [Note] InnoDB: Waiting for purge to start
2021-06-20 6:56:03 0 [Note] InnoDB: 10.3.29 started; log sequence number 4995372136; transaction id 18299703
2021-06-20 6:56:03 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2021-06-20 6:56:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-06-20 6:56:03 0 [Note] Server socket created on IP: '127.0.0.1'.
2021-06-20 6:56:03 0 [Note] Reading of all Master_info entries succeeded
2021-06-20 6:56:03 0 [Note] Added new Master_info '' to hash table
2021-06-20 6:56:03 0 [Note] /usr/sbin/mysqld: ready for connections
Édit 2 :
Je soupçonne le watchdog de jeedom d’avoir redémarrer la base
Bonjour à tous,
avez vous réussi à identifier la cause et résoudre le problème?
Chez moi j’ai remarqué que les messages d’erreur apparaissaient une dizaine de minute après le début des sauvegardes et en effet à chaque lancement de sauvegarde manuel, 10 minutes plus tard et les erreurs apparaissent
j’ai désactivé tout les plugins et tous les scénarios et plus d’erreur au lancement des sauvegardes
j’ai réactivé petit à petit et le problème est réapparu avec le plugin zwave
en gros toute mes plugins (Sauf Zwave) et mes scénarios ca passe
activation du zwave ça passe mais lancement du réseau et Topology loaded les erreurs recommence au moment des sauvegarde
je me demande donc si le plugin zwave n’utiliserais pas une quantité importante de connexion et avec la sauvegarde c’est la goutte d’eau qui fait déborder les connexions
Qu’en pensez vous et avez vous fait le même constat?