Bonjour
depuis vendredi 23/02 je rencontre un probléme à partir de 21H et ce jusqu’a dans lanuit.
Mon jeedom plante vers 21H et aprés dans la nuit avec l’erreur : TOO MANY CONNECTION.
a cette heure 21h17, j’ai une augmentation soudaine des connections et apaches.
j’ai désactiver tout les scenarios et tout les plugins, et tout les crons, et ca continue à monter.
Le plugin Mobile je ne peux pas le supprimer. ca tourne pendant des heures et ca reste.
Que faire maintenant???
avec la commande
showprocess;
Id User Host db Command Time State Info Progress
5983 jeedom localhost jeedom Query 4033 init for update DELETE FROM historyArch WHERE cmd_id='3982' 0.000
6348 jeedom localhost jeedom Query 4008 init for update DELETE FROM historyArch WHERE cmd_id='3982' 0.000
7291 jeedom localhost jeedom Query 943 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7338 jeedom localhost jeedom Query 1041 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7361 jeedom localhost jeedom Query 857 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7575 jeedom localhost jeedom Query 958 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7591 jeedom localhost jeedom Query 973 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7630 jeedom localhost jeedom Query 927 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7631 jeedom localhost jeedom Query 1018 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7632 jeedom localhost jeedom Query 988 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7633 jeedom localhost jeedom Query 825 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7634 jeedom localhost jeedom Query 1003 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7658 jeedom localhost jeedom Query 912 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7659 jeedom localhost jeedom Query 897 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7674 jeedom localhost jeedom Query 875 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7676 jeedom localhost jeedom Query 840 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7684 jeedom localhost jeedom Query 718 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7690 jeedom localhost jeedom Query 810 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7692 jeedom localhost jeedom Query 588 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7693 jeedom localhost jeedom Query 788 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7694 jeedom localhost jeedom Query 771 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7701 jeedom localhost jeedom Query 756 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7702 jeedom localhost jeedom Query 741 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7706 jeedom localhost jeedom Query 618 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7707 jeedom localhost jeedom Query 686 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7712 jeedom localhost jeedom Query 635 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7715 jeedom localhost jeedom Query 650 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7716 jeedom localhost jeedom Query 701 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7719 jeedom localhost jeedom Query 665 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7720 jeedom localhost jeedom Query 603 Statistics SELECT AVG(CAST(value AS DECIMAL(12,2))) as avg, MIN(CAST(value AS DECIMAL(12,2))) as min, MAX(CAST( 0.000
7789 jeedom localhost jeedom Sleep 5 null 0.000
7808 jeedom localhost jeedom Sleep 2 null 0.000
7828 jeedom localhost jeedom Sleep 5 null 0.000
7831 jeedom localhost jeedom Sleep 7 null 0.000
7832 jeedom localhost jeedom Sleep 7 null 0.000
7836 jeedom localhost jeedom Sleep 7 null 0.000
7858 jeedom localhost jeedom Query 0 starting SHOW PROCESSLIST 0.000
7859 jeedom localhost jeedom Sleep 7 null 0.000
7861 jeedom localhost jeedom Sleep 3 null 0.000
7862 jeedom localhost jeedom Sleep 3 null 0.000
7868 jeedom localhost jeedom Sleep 7 null 0.000
7870 jeedom localhost jeedom Sleep 7 null 0.000
7872 jeedom localhost jeedom Sleep 5 null 0.000
7881 jeedom localhost jeedom Sleep 10 null 0.000
le plugin mobile tourne avec une conf reseau externe en nok ?
non d’hab c’est en ok.
c’est passer en nok car j’ai tout coupé.
LA rien ne tourne et j’ai 93 connections…
On ne sait rien de ton jeedom.
Comment savoir si c’est normal ou pas.
Qu’est-ce qui tourne ? plugin, esp32 requete autres venant de trucs et autres ?
