Scenarios qui se bloquent depuis dernieres MAJ

HerveK · Message par **HerveK** » 05 juin 2019, 13:23

MrGreen a écrit : ↑
05 juin 2019, 10:46
ok j'avais le même genre de paramètres
Peux tu les passer à 200. Il faut l'ajouter dans le my.cnf ou le 50-server.cnf

tu auras :
max_connections = 200
max_user_connections = 200

penses à redémarrer mysql et check dans jeedom avec show variables like "max_user_connections"

En fait j'ai fait la Mise à Jour de Calendar Agenda , juste avant celle de Jeedom, hier .

Et ... je soupçonne un peu le plugin (sans preuve) ,
Mais ce plugin m'a déjà joué des tours du même type :
Durant un an , chaque semaine Jeedom se bloquait juste après minuit ... et à y perdre son latin .
Loïc s'y est intéressé aussi et n'a pas vraiment trouvé mais il y a travaillé !

Ses premieres options étaient ... comme les tiennes, comme celle que tu me proposes ce matin.

Au final au bout d'un an un ami m'a dit de désactiver le calendar ...
Et là, ensuite, tout est passe comme sur des roulettes

Il y a un petit mois j'ai réactivé le plugin calendar en créer un nouveau lien calendar (de exchange suis passé à gmail)
J'ai donc supprimé mon fichier Calendar et recréé un nouvel ics.
Ca a bien marché ... jusque là

Donc retenter un an de galere : pas très envie

Mais je vais suivre de très près tes résultats

MrGreen · Message par **MrGreen** » 05 juin 2019, 16:31

ok merci pour tes infos. J'utilise très peu agenda, donc je ne saurais te dire.
regardes le log scenario_execution et copie colle si tu as des entrées d'erreur stp

HerveK · Message par **HerveK** » 05 juin 2019, 17:04

Suis repassé en 3.3.24 : j'y ai installé le scénario avec le code que tu as fait (Encore Merci):
Et je vois que déjà en 3.3.24 j'ai des blocages : Rien de bien grave mais des blocages :

Donc pour le contenu du log demandé :

Code : Tout sélectionner

[2019-06-05 15:20:03][ERROR] : Arret du scénario car il a dépassé le timeout global de 300 secondes : Living Suspensions Allumages Programmés Soir V2
[2019-06-05 16:10:04][ERROR] : Arret du scénario car il a dépassé le timeout global de 300 secondes : Hue Jour Mode Jour Lumineux Auto
[2019-06-05 16:45:04][ERROR] : Arret du scénario car il a dépassé le timeout global de 300 secondes : Philips Eyecare Allumage Soirée

Cela semble ne pas gêner pour le moment ...

Je suis cela ...

HerveK · Message par **HerveK** » 05 juin 2019, 20:25

MrGreen a écrit : ↑
05 juin 2019, 16:31
ok merci pour tes infos. J'utilise très peu agenda, donc je ne saurais te dire.
regardes le log scenario_execution et copie colle si tu as des entrées d'erreur stp

Je vois qu'une fois qu'on a killé le scenario avec ton code on peut relancer le scenario sans pb.
Ne pourrait on pas integrer le lancement du scenario à ton code (après l'avoir killé) ?
Nb attention que la boucle ne soit pas infinie ...

Une idée ...
Dis moi ce que tu en penses ...
Toi et Loic .

Bonne soiree
Herve

Poumi · Message par **Poumi** » 05 juin 2019, 20:28

HerveK a écrit : ↑
05 juin 2019, 20:25

MrGreen a écrit : ↑
05 juin 2019, 16:31
ok merci pour tes infos. J'utilise très peu agenda, donc je ne saurais te dire.
regardes le log scenario_execution et copie colle si tu as des entrées d'erreur stp
Je vois qu'une fois qu'on a killé le scenario avec ton code on peut relancer le scenario sans pb.
Ne pourrait on pas integrer le lancement du scenario à ton code (après l'avoir killé) ?
Nb attention que la boucle ne soit pas infinie ...

Une idée ...
Dis moi ce que tu en penses ...
Toi et Loic .

Bonne soiree
Herve

Vu les différents logs, on dirait que le scénario se finit bien mais que le changement de statut en db plante. Donc à priori aucune raison de le relancer

HerveK · Message par **HerveK** » 06 juin 2019, 06:27

Poumi a écrit : ↑
05 juin 2019, 20:28

HerveK a écrit : ↑
05 juin 2019, 20:25

MrGreen a écrit : ↑
05 juin 2019, 16:31
ok merci pour tes infos. J'utilise très peu agenda, donc je ne saurais te dire.
regardes le log scenario_execution et copie colle si tu as des entrées d'erreur stp
Je vois qu'une fois qu'on a killé le scenario avec ton code on peut relancer le scenario sans pb.
Ne pourrait on pas integrer le lancement du scenario à ton code (après l'avoir killé) ?
Nb attention que la boucle ne soit pas infinie ...

Une idée ...
Dis moi ce que tu en penses ...
Toi et Loic .

Bonne soiree
Herve
Vu les différents logs, on dirait que le scénario se finit bien mais que le changement de statut en db plante. Donc à priori aucune raison de le relancer

Ok .
Merci de l'info .
Ca simplifie .

HerveK · Message par **HerveK** » 06 juin 2019, 07:15

Je modifie ma réponse plus haut ...
Pour moi : à 7h j'ai un scenario d'allumage de lampe qui se met en route

A 7h00 :

Code : Tout sélectionner

[2019-06-06 07:00:05][SCENARIO] Arret du scénario car il a dépassé le timeout global de 300 secondes : 300s

Il n'a pas attendu 300s le scenario code

Et à 07h01 et 30s ne voyant rien s'allumer .... j'ai relancé manuellement

Code : Tout sélectionner

[2019-06-06 07:01:27][SCENARIO] Start : Scenario lance manuellement.
[2019-06-06 07:01:27][SCENARIO] Exécution du sous-élément de type [action] : action
[2019-06-06 07:01:27][SCENARIO] Pause de 30 seconde(s)
[2019-06-06 07:01:57][SCENARIO] Exécution de la commande [Living][Suspension 1][Couleur] avec comme option(s) : {"background":"0","color":"#ffd087"}
[2019-06-06 07:01:57][SCENARIO] Exécution de la commande [Living][Suspension 1][Luminosité] avec comme option(s) : {"background":"0","slider":10}
[2019-06-06 07:01:57][SCENARIO] Pause de 30 seconde(s)
[2019-06-06 07:02:27][SCENARIO] Exécution de la commande [Living][Suspension 2][Couleur] avec comme option(s) : {"background":"0","color":"#ffd087"}
[2019-06-06 07:02:27][SCENARIO] Exécution de la commande [Living][Suspension 2][Luminosité] avec comme option(s) : {"background":"0","slider":10}
[2019-06-06 07:02:28][SCENARIO] Lancement du scénario : Living Transition Allumage Suspensions options : []
[2019-06-06 07:02:28][SCENARIO] Exécution du sous-élément de type [condition] : in
[2019-06-06 07:02:28][SCENARIO] Evaluation de la condition : [30] = 30
[2019-06-06 07:02:28][SCENARIO] Tâche : 1009 programmée à : 2019-06-06 07:32:28 (+ 30 min)
[2019-06-06 07:02:28][SCENARIO] Fin correcte du scénario

Donc 1 question :
Pourquoi le scenario code donné plus haut n'attend pas les 300s pour se déclancher ?
Et
Pour moi oui obligé de relancer manuellement.

MrGreen · Message par **MrGreen** » 06 juin 2019, 08:34

Hello tous,
ce scénario n'est qu'un patch temporaire, avant d'essayer de trouver une solution. J'ai ouvert un ticket et Loic (Jeedom) a déjà répondu à pas mal de mes emails (je le remercie pour son temps). Un code a déjà été corrigé (mais pas sûr que tous les probs viennent de là) et je crois qu'il suffit de réappliquer la dernière mise à jour pour que ça le prenne en compte.

Et un autre code à été envoyé hier soir (j'attends leurs retours)

Hervé, j'ai modifié un peu le scénario ce matin :

Code : Tout sélectionner

$timeout = 300;
foreach (scenario::all() as $scenario) {
  $runtime = strtotime('now') - strtotime($scenario->getLastLaunch());
  if ($runtime>$timeout && $scenario->getState()=='starting') {
    $i = 0;
    while($state == 'starting'){
      sleep(1);
      $state = $scenario->getState();
      $i++;
      if($i>5){
        break;
      }
    }
    if ($state=='starting') {
      $scenario->stop();
      $scenario->setLog(__('Arret du scénario car il a dépassé le timeout global de '.$timeout.' secondes : ', __FILE__) . $timeout . 's');
      $scenario->persistLog();
      log::add('scenario', 'error', __('Arret du scénario car il a dépassé le timeout global de '.$timeout.' secondes : ', __FILE__).$scenario->getName());
    }
  }
}

C'est en test sur mon jeedom.

Aussi Hervé, tu m'as donné ton log scenario. C'est le scenario_execution qui m'intéresse. C'est dans celui-ci qu'on voit s'il y a des erreurs PHP de connexion MySql.
Si tu peux regarder stp

HerveK · Message par **HerveK** » 06 juin 2019, 08:59

On avance, on avance ...
De mon coté j'ai désactivé ce matin 8h le plugin Calendar ... pour voir ... (Cf précédent échange)

Mon log

Code : Tout sélectionner

Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:32:06 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
 2019/06/02 12:34:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:34:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:34:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:34:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:34:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:34:16 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
 2019/06/02 12:36:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Salon": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:36:14 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Salon": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
 2019/06/02 12:38:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:38:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:38:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:38:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:38:16 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/02 12:38:16 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Traceback (most recent call last):
  File "/var/www/html/plugins/nut/resources/nut.py", line 37, in <module>
    ups = PyNUT.PyNUTClient( host=address, login=user,password=password )
  File "/var/www/html/plugins/nut/resources/PyNUT.py", line 86, in __init__
    self.__connect()
  File "/var/www/html/plugins/nut/resources/PyNUT.py", line 105, in __connect
    self.__srv_handler = telnetlib.Telnet( self.__host, self.__port )
  File "/usr/lib/python2.7/telnetlib.py", line 211, in __init__
    self.open(host, port, timeout)
  File "/usr/lib/python2.7/telnetlib.py", line 227, in open
    self.sock = socket.create_connection((host, port), timeout)
  File "/usr/lib/python2.7/socket.py", line 575, in create_connection
    raise err
socket.error: [Errno 111] Connection refused
                                                                                                    
                                                                                                                                                                  Traceback (most recent call last):
  File "/var/www/html/plugins/nut/resources/nut.py", line 37, in <module>
    ups = PyNUT.PyNUTClient( host=address, login=user,password=password )
  File "/var/www/html/plugins/nut/resources/PyNUT.py", line 86, in __init__
    self.__connect()
  File "/var/www/html/plugins/nut/resources/PyNUT.py", line 105, in __connect
    self.__srv_handler = telnetlib.Telnet( self.__host, self.__port )
  File "/usr/lib/python2.7/telnetlib.py", line 211, in __init__
    self.open(host, port, timeout)
  File "/usr/lib/python2.7/telnetlib.py", line 227, in open
    self.sock = socket.create_connection((host, port), timeout)
  File "/usr/lib/python2.7/socket.py", line 575, in create_connection
    raise err
socket.error: [Errno 111] Connection refused
                     
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     2019/06/03 12:32:02 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:32:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:32:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:32:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:32:05 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:32:05 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
  2019/06/03 12:34:02 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:34:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:34:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:34:14 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:34:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:34:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:36:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Salon": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:36:14 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Salon": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
 2019/06/03 12:38:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:38:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:38:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:38:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:38:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/03 12:38:16 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                                                                                                                                                                                              
                                                                                                                                                                                                                           2019/06/04 12:32:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:32:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:32:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:32:05 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:32:06 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:32:06 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Living": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
 2019/06/04 12:34:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:34:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:34:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:34:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:34:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:34:16 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Cuisine": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
 2019/06/04 12:36:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Salon": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:36:14 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Salon": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
 2019/06/04 12:38:03 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:38:04 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:38:05 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:38:15 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:38:16 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
2019/06/04 12:38:17 Failed to create file system for "onedriveHkPerso:/Kdom/Cameras/Entree": failed to get root: Get https://api.onedrive.com/v1.0/drive/root:/: oauth2: cannot fetch token: 400 Bad Request
Response: {"error":"invalid_grant","error_description":"The user could not be authenticated as the grant is expired. The user must sign in again."}
                                                                                                                                                                                                                                                     kill: (2398): Aucun processus de ce type
                       kill: (12010): Aucun processus de ce type
                                                                          kill: (30527): Aucun processus de ce type
                              kill: (4074): Aucun processus de ce type
                                                                                                                                                                                                                                                                           
                                                                                                                                                                    
                                              kill: (26855): Aucun processus de ce type

MrGreen · Message par **MrGreen** » 06 juin 2019, 09:28

Ok merci. RAS (sauf beaucoup d'erreurs des caméras

Tu as roolback hier vers 12h30 ?

Aussi je te confirme une chose :
dans le fichier de config mysql, il faudrait que tu testes :
max_connections = 200
max_user_connections = 0
+ redémarrage de mysql

et vérifier dans Jeedom, roue crantée, menu Configuration -> OS DB -> Base de donnée -> Administration -> Vérifier les valeurs en lançant :
show variables like "max_user_connections"
puis
show variables like "max_connections"

Un des problèmes est que pour les installations un peu lourdes : Il y a beaucoup d'appels mysql. En augmentant la max_connections, on va répondre aux moments de surcharges.

On peut aussi s'amuser à surveiller le show full processlist (mysql)

HerveK · Message par **HerveK** » 06 juin 2019, 09:38

Pour les erreurs de caméra : je l'ai vu hier , et normalement c'est réparé lol .
Oui je suis revenu ancienne version 3.3.24 par un snapshoot hier vers 12h30

Sinon :
J'ai installé ta derniere version du code,
Désactivé tjrs depuis 8h ce matin Calendar (depuis là ton fichier code n'a rien bloqué)
Je ne passe pas en 3.3.25 car tu sembles dire qu'il y a encore des modifs en cours de validation chez Loic.

Pour la modif MySql ... lol suis pas un grand spécialiste de la ligne de commande ,
Je fais cela ... à tete reposée dès que

Merci de nous avoir tenu informés et de continuer

HerveK · Message par **HerveK** » 06 juin 2019, 09:56

Voilà ce que Loic m'avait envoyé à l'époque :

Bonjour,
Dans ce cas il va falloir en ssh il faut faire :
sudo su -
echo "max_connections = 200" >> /etc/mysql/conf.d/jeedom_my.cnf
Et redemarrer la box

Donc dès que ...
En fait j'attends jusqu'à "ce soir" voir si d'avoir désactiver Calendar à une influence ou pas (je le verrais au travers de ton code)

HerveK · Message par **HerveK** » 06 juin 2019, 10:01

Comme je ne sais pas si cela peut influencer ou vous guider j'envoie ce que je viens de recevoir :
Rappel : j'ai désactivé Calendar (mais je n'avais pas encore installé la derniere version)

Gestion Système:
6 Juin 2019 10:00
Plugin Concerné: cron
Notification: [Erreur] Classe ou fonction non trouvée calendar::pull()

Bien que j'ai désactivé Calendar

MrVince · Message par **MrVince** » 06 juin 2019, 11:09

Bonjour,

Voici ma config :

Code : Tout sélectionner

Distributor ID:	Debian
Description:	Debian GNU/Linux 9.8 (stretch)
Release:	9.8
Codename:	stretch

Et voici mon log scenario_execution

Code : Tout sélectionner

Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('1')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('1')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('26')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('1')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('1')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('1')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('1')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('23')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('22')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('25')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41
Stack trace:
#0 /var/www/html/core/class/DB.class.php(41): PDO->__construct('mysql:host=192....', 'jeedom', 'jeedom', Array)
#1 /var/www/html/core/class/DB.class.php(54): DB->__construct()
#2 /var/www/html/core/class/DB.class.php(86): DB::getConnection()
#3 /var/www/html/core/class/scenario.class.php(65): DB::Prepare('SELECT `id`, `n...', Array, 0, 8, 'scenario')
#4 /var/www/html/core/php/jeeScenario.php(39): scenario::byId('20')
#5 {main}
thrown in /var/www/html/core/class/DB.class.php on line 41

Si cela peut aider.

MrGreen · Message par **MrGreen** » 06 juin 2019, 11:41

MrVince a écrit : ↑
06 juin 2019, 11:09
thrown in /var/www/html/core/class/DB.class.php on line 41
PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1040] Too many connections' in /var/www/html/core/class/DB.class.php:41

Too many connections -> faire la modif mysql du max_connextions etc... décrite juste un peu au dessus

Hervé, et ceux qui veulent tester : Repassez en dernière version de jeedom et prendre la nouvelle version du fichier scenario.php.

La modif est en Alpha, et en teste chez Loïc et moi même : https://github.com/jeedom/core/commit/b ... d95f855165

Le fichier à remplacer est : https://raw.githubusercontent.com/jeedo ... .class.php

Cette modif est en test pour voir si on a pas de remontée d'erreur (dans les notifs en haut de jeedom) quand tout va bien.

Mais dans tous les cas. Ceux qui sont concernés par le Too many connections devront faire la modif du max_connextions.

HerveK · Message par **HerveK** » 06 juin 2019, 11:46

Je fais cela dans l'après midi .
Je te vous tiens au courant .

Merci !

MrVince · Message par **MrVince** » 06 juin 2019, 12:02

Merci MrGreen, j'étais justement en train de me pencher là dessus.

Petit problème, je n'ai pas de fichier etc/mysql/conf.d/jeedom_my.cnf

Je me renseigne rapidement..

MrGreen · Message par **MrGreen** » 06 juin 2019, 12:31

MrVince a écrit : ↑
06 juin 2019, 12:02
Petit problème, je n'ai pas de fichier etc/mysql/conf.d/jeedom_my.cnf

oui ça dépend des versions de linux.
Si tu es RPI dernière version, c'est le /etc/mysql/mariadb.conf.d/50-server.cnf

sinon un locate my.cnf pour le trouver (si locate pas installé : apt-get install locate, et puis updatedb)

HerveK a écrit : ↑
06 juin 2019, 11:46
Je fais cela dans l'après midi .
Je te vous tiens au courant .

Merci !

Yes

plante pas ta box, penses au snap

HerveK · Message par **HerveK** » 06 juin 2019, 14:39

MrGreen a écrit : ↑
06 juin 2019, 12:31

MrVince a écrit : ↑
06 juin 2019, 12:02
Petit problème, je n'ai pas de fichier etc/mysql/conf.d/jeedom_my.cnf
oui ça dépend des versions de linux.
Si tu es RPI dernière version, c'est le /etc/mysql/mariadb.conf.d/50-server.cnf

sinon un locate my.cnf pour le trouver (si locate pas installé : apt-get install locate, et puis updatedb)

HerveK a écrit : ↑
06 juin 2019, 11:46
Je fais cela dans l'après midi .
Je te vous tiens au courant .

Merci !
Yes plante pas ta box, penses au snap

Je pense avoir tout fait :

Passer à 200 connexions Ok
Mise à jour de tous les plugins
Réactivation de Calendar
Mise à jour du Core en version 3.3.25
Changement du fichier scenario.class.php

MrGreen
Dois je garder actif le scenario avec ton code ? (le nouveau code donné ce matin) ?

EDIT : Si j'ai bien compris le nouveau fichier scenario.class il remplace le scenario avec ton code.
J'ai donc supprimé le scenario avec ton Code ,
MAIS
Merci de Confirmer

MrGreen · Message par **MrGreen** » 06 juin 2019, 21:07

HerveK a écrit : ↑
06 juin 2019, 14:39

MrGreen
Dois je garder actif le scenario avec ton code ? (le nouveau code donné ce matin) ?

Moi j'ai laissé le scénario activé pour check, mais effectivement, si tout va bien, il n'y en aura plus besoin.
Pour infos : Je n'ai pas eu de remontée d'erreur de la journée. Une première !

Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Re: Scenarios qui se bloquent depuis dernieres MAJ

Qui est en ligne ?