<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Bonjour,<br>
<br>
Il y a un build en nightly avec les modifications mentionnées par
Denis.<br>
<br>
<a class="moz-txt-link-freetext" href="https://wapt.tranquil.it/wapt/nightly/wapt-1.7.4.6237-1c00cefd/">https://wapt.tranquil.it/wapt/nightly/wapt-1.7.4.6237-1c00cefd/</a><br>
<br>
Changelog : <br>
<tt><br>
</tt><tt>WAPT-1.7.4-6237 (2019-11-18) </tt><tt>(not released)<br>
</tt><tt>----------------------------</tt><tt><br>
</tt><tt><br>
</tt><tt>(hash 1c00cefd)</tt><tt><br>
</tt><tt><br>
</tt><tt>* waptserver : add fix to workaround flask-socketio bug
<a class="moz-txt-link-freetext" href="https://github.com/miguelgrinberg/Flask-SocketIO/issues/1054">https://github.com/miguelgrinberg/Flask-SocketIO/issues/1054</a>
(AttributeError: 'Request' object has no attribute 'sid')</tt><tt><br>
</tt><tt><br>
</tt><tt>* waptserver : be sure db is closed before trying to open
it (for dev mode)</tt><tt><br>
</tt><tt><br>
</tt><tt>* waptserver : add logs messages when an exception message
is sent back to the user.</tt><tt><br>
</tt><tt><br>
</tt><tt>WAPT-1.7.4-6234 (2019-11-14) </tt><tt>(not released)<br>
</tt><tt>----------------------------</tt><tt><br>
</tt><tt><br>
</tt><tt>(hash ad237eee)</tt><tt><br>
</tt><tt><br>
</tt><tt>* waptserver : upgrade peewee DB python module to 3.11.2.
explicit connection handling to DB to track potential limbo
connections (which could lead to db pool exhaustion)</tt><tt><br>
</tt><tt><br>
</tt><tt>* waptwua : Trap exception when pushing WU to Windows cache
to allow valid updates to be installed even if some could not be
verified properly.</tt><tt><br>
</tt><tt><br>
</tt><tt><br>
</tt><tt>WAPT-1.7.4-6232 (2019-10-31) </tt><tt><br>
</tt><tt>----------------------------</tt><tt><br>
</tt><tt><br>
</tt><tt>(hash2090b0e6d52cecfb04f8fa4c279e7c0a0252d6e2</tt><tt><br>
</tt><tt><br>
</tt><tt>* wapt-get session-setupp : fix bad print in session_setup.
regression introduced in b30b1b1a550a4 (1.7.4.6229)</tt><tt><br>
</tt><tt><br>
</tt><tt>WAPT-1.7.4-6230 (2019-10-23) (not released)</tt><tt><br>
</tt><tt>----------------------------</tt><tt><br>
</tt><tt>(hash 391d382f)</tt><tt><br>
</tt><tt><br>
</tt><tt>* return server git hash version and edition in ping and
usage_statistics</tt><tt><br>
</tt><tt><br>
</tt><tt>* be sure to have server_uuid on windows when during setup</tt><tt><br>
</tt><tt><br>
</tt><tt>* fix for .git partially included in built package manifest<br>
<br>
<br>
</tt><br>
<div class="moz-cite-prefix">Le 18/11/2019 à 11:13, Frederic
Garesche a écrit :<br>
</div>
<blockquote type="cite"
cite="mid:832466634.44138.1574072023204.JavaMail.zimbra@insa-rennes.fr">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div style="font-family: courier
new,courier,monaco,monospace,sans-serif; font-size: 13pt; color:
#000000">
<div>Salut Denis,<br>
</div>
<div><br data-mce-bogus="1">
</div>
<div>Super, c'est une bonne nouvelle.<br data-mce-bogus="1">
</div>
<div><br data-mce-bogus="1">
</div>
<div>Y a plus qu'à attendre...<br data-mce-bogus="1">
</div>
<div><br data-mce-bogus="1">
</div>
<div>Bonne journée,<br data-mce-bogus="1">
</div>
<div><br>
</div>
<div data-marker="__SIG_PRE__">
<div>
<div
style="color:#5e5e5d;font-size:13px;font-family:'arial'"><span
style="font-family:'courier new' , 'courier' , 'monaco'
, monospace , sans-serif"><b><span style="color:#333333">Frédéric
GARESCHÉ</span><br>
</b></span></div>
<div
style="color:#5e5e5d;font-size:13px;font-family:'arial'"><span
style="color:rgb( 128 , 128 , 128 );font-family:'courier
new' , 'courier' , 'monaco' , monospace , sans-serif"><b>Équipe
Assistance et Exploitation<br>
</b></span></div>
<div
style="color:#5e5e5d;font-size:13px;font-family:'arial'"><span
style="color:rgb( 128 , 128 , 128 );font-family:'courier
new' , 'courier' , 'monaco' , monospace , sans-serif"><b>Direction
du Système d'Information (D.S.I)</b></span></div>
<div
style="color:#5e5e5d;font-size:13px;font-family:'arial'"><span
style="color:rgb( 128 , 128 , 128 );font-family:'courier
new' , 'courier' , 'monaco' , monospace , sans-serif"><b>Correspondant
Département EII et laboratoire IETR<br>
</b>Tél. : +33 (0)2 23 2<strong>3 82 81</strong></span></div>
<div
style="color:#5e5e5d;font-size:13px;font-family:'arial'">
<div><span style="color:rgb( 128 , 128 , 128
);font-family:'courier new' , 'courier' , 'monaco' ,
monospace , sans-serif">20 avenue des Buttes de
Coësmes</span><br>
<span style="color:rgb( 128 , 128 , 128
);font-family:'courier new' , 'courier' , 'monaco' ,
monospace , sans-serif">CS 70839 - 35 708 RENNES Cedex
7</span></div>
</div>
<div
style="color:#5e5e5d;font-size:13px;font-family:'arial'"><span
style="color:#808080"></span><br>
</div>
<a href="https://www.insa-rennes.fr" target="_blank"
rel="nofollow noopener noreferrer" moz-do-not-send="true"><img
src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
alt=""
data-mce-src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
moz-do-not-send="true"></a><br>
</div>
</div>
<div><br>
</div>
<hr id="zwchr" data-marker="__DIVIDER__">
<div data-marker="__HEADERS__"><b>De: </b>"Denis Cardon"
<a class="moz-txt-link-rfc2396E" href="mailto:dcardon@tranquil.it"><dcardon@tranquil.it></a><br>
<b>À: </b>"Frederic Garesche"
<a class="moz-txt-link-rfc2396E" href="mailto:Frederic.Garesche@insa-rennes.fr"><Frederic.Garesche@insa-rennes.fr></a><br>
<b>Cc: </b>"Hubert TOUVET" <a class="moz-txt-link-rfc2396E" href="mailto:htouvet@tranquil.it"><htouvet@tranquil.it></a>,
"wapt" <a class="moz-txt-link-rfc2396E" href="mailto:wapt@lists.tranquil.it"><wapt@lists.tranquil.it></a><br>
<b>Envoyé: </b>Lundi 18 Novembre 2019 10:59:34<br>
<b>Objet: </b>Re: [Wapt] Arrêt aléatoire du serveur wapt<br>
</div>
<div><br>
</div>
<div data-marker="__QUOTED_TEXT__">
<div>
<div style="font-family: "arial",
"helvetica", sans-serif; font-size: 12pt; color:
rgb(0, 0, 0);">
<div>Salut Frédéric,<br>
</div>
<br>
<div>on pense avoir trouvé le soucis par rapport à ce bug.
Il semble que dans certains cas les connexions Postgres
ouvertes par Peewee (la couche d'abstraction sur la base
postgres) ne sont pas toujours retournées dans le pool
de connexion. Hubert a fait une maj en fin de semaine
dernière pour bénéficier d'un nouveau paramètre Peewee
pour désactiver l'ouverture de connexion automatique
(mode autoconnect=False) ce qui a permit de trouver
quelques cas de try: except: finally: où la connexion ne
repartait pas bien dans le pool. On a mis en place le
patch chez un client qui avait le soucis, le connexion
pool ne s'épuise plus, ça semble concluant. On vous
tiens au courant.<br>
</div>
<br>
<div>Cordialement,<br>
</div>
<br>
<div>Denis<br>
</div>
<br>
<hr id="zwchr">
<div>
<blockquote style="border-left: 2px solid rgb(16, 16,
255); margin-left: 5px; padding-left: 5px; color:
rgb(0, 0, 0); font-weight: normal; font-style: normal;
text-decoration: none; font-family:
"helvetica", "arial", sans-serif;
font-size: 12pt;"><b>De: </b>"Frederic Garesche"
<a class="moz-txt-link-rfc2396E" href="mailto:Frederic.Garesche@insa-rennes.fr"><Frederic.Garesche@insa-rennes.fr></a><br>
<b>À: </b>"Hubert TOUVET" <a class="moz-txt-link-rfc2396E" href="mailto:htouvet@tranquil.it"><htouvet@tranquil.it></a><br>
<b>Cc: </b>"wapt" <a class="moz-txt-link-rfc2396E" href="mailto:wapt@lists.tranquil.it"><wapt@lists.tranquil.it></a><br>
<b>Envoyé: </b>Lundi 18 Novembre 2019 08:55:12<br>
<b>Objet: </b>Re: [Wapt] Arrêt aléatoire du serveur
wapt<br>
</blockquote>
</div>
<div>
<blockquote style="border-left: 2px solid rgb(16, 16,
255); margin-left: 5px; padding-left: 5px; color:
rgb(0, 0, 0); font-weight: normal; font-style: normal;
text-decoration: none; font-family:
"helvetica", "arial", sans-serif;
font-size: 12pt;">
<div style="font-family: "courier new",
"courier", "monaco", monospace,
sans-serif; font-size: 13pt; color: rgb(0, 0, 0);">
<div>Bonjour,<br>
</div>
<br>
<div>Debian 9<br>
</div>
<div>Waptserver version 1.7.4.6229<br>
</div>
<br>
<div>Le service n'utilise plus les 100% cpu mais
j'ai toujours le problème d'arrêt de communication
avec le service.<br>
</div>
<br>
<div>Je remets le résultat de la commande demandée :<br>
</div>
<div><span style="font-size: 10pt;">pids=$(pgrep -f
"server.py"); for f in /proc/$pids/fdinfo/*; do
cat $f | grep flags | grep -q -v 400[0,1,2]
&& ls -al /proc/$pids/fd/$(basename $f);
done;</span><br>
<span style="font-size: 10pt;"><em>lr-x------ 1
wapt www-data 64 nov. 14 08:16
/proc/26112/fd/0 -> /dev/null</em></span><br>
<span style="font-size: 10pt;"><em>lrwx------ 1
wapt www-data 64 nov. 14 08:16
/proc/26112/fd/1 -> socket:[583691]</em></span><br>
<span style="font-size: 10pt;"><em>lr-x------ 1
wapt www-data 64 nov. 14 08:16
/proc/26112/fd/15 -> /dev/urandom</em></span><br>
<span style="font-size: 10pt;"><em>lrwx------ 1
wapt www-data 64 nov. 14 08:16
/proc/26112/fd/2 -> socket:[583691]</em></span><br>
<span style="font-size: 10pt;"><em>lrwx------ 1
wapt www-data 64 nov. 14 08:16
/proc/26112/fd/3 -> anon_inode:[eventpoll]</em></span><br>
<span style="font-size: 10pt;"><em>lr-x------ 1
wapt www-data 64 nov. 14 08:16
/proc/26112/fd/8 -> /dev/urandom</em></span><br>
<br>
</div>
<div>J'ai mis en place un cron en ajoutant timeout 5
à la commande que vous m'avez fourni :<br>
</div>
<div><span style="font-size: 10pt;">timeout 5 wget
-t 1 -q -O- <a class="moz-txt-link-freetext" href="http://127.0.0.1:8080/ping">http://127.0.0.1:8080/ping</a>
--no-check-certificate | grep "WAPT Server
running" || (echo Restart; systemctl restart
waptserver )</span><br>
</div>
<br>
<div>Sans timeout, la commande wget est très longue
lorsque le service ne fonctionne pas correctement.
La commande wget possède une option pour définir
le timeout mais cela ne fonctionne pas dans ce
cas.<br>
</div>
<br>
<div>Cordialement,<br>
</div>
<br>
<div>
<div>
<div style="color: rgb(94, 94, 93); font-size:
13px; font-family: "arial";"><span
style="font-family: "courier new",
"courier", "monaco",
monospace, sans-serif;"><b><span
style="color: rgb(51, 51, 51);">Frédéric
GARESCHÉ</span><br>
</b></span></div>
<div style="color: rgb(94, 94, 93); font-size:
13px; font-family: "arial";"><span
style="color: rgb(128, 128, 128);
font-family: "courier new",
"courier", "monaco",
monospace, sans-serif;"><b>Équipe Assistance
et Exploitation<br>
</b></span></div>
<div style="color: rgb(94, 94, 93); font-size:
13px; font-family: "arial";"><span
style="color: rgb(128, 128, 128);
font-family: "courier new",
"courier", "monaco",
monospace, sans-serif;"><b>Direction du
Système d'Information (D.S.I)</b></span></div>
<div style="color: rgb(94, 94, 93); font-size:
13px; font-family: "arial";"><span
style="color: rgb(128, 128, 128);
font-family: "courier new",
"courier", "monaco",
monospace, sans-serif;"><b>Correspondant
Département EII et laboratoire IETR<br>
</b>Tél. : +33 (0)2 23 2<strong>3 82 81</strong></span></div>
<div style="color: rgb(94, 94, 93); font-size:
13px; font-family: "arial";">
<div><span style="color: rgb(128, 128, 128);
font-family: "courier new",
"courier", "monaco",
monospace, sans-serif;">20 avenue des
Buttes de Coësmes</span><br>
<span style="color: rgb(128, 128, 128);
font-family: "courier new",
"courier", "monaco",
monospace, sans-serif;">CS 70839 - 35 708
RENNES Cedex 7</span></div>
</div>
<div style="color: rgb(94, 94, 93); font-size:
13px; font-family: "arial";"><span
style="color: rgb(128, 128, 128);"></span><br>
</div>
<a href="https://www.insa-rennes.fr"
rel="nofollow noopener noreferrer nofollow
noopener noreferrer nofollow noopener
noreferrer" target="_blank"
moz-do-not-send="true"><img alt=""
data-mce-src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
saveddisplaymode="" style=""
moz-do-not-send="true"></a><br>
</div>
</div>
<br>
<hr id="zwchr">
<div><b>De: </b>"Frederic Garesche"
<a class="moz-txt-link-rfc2396E" href="mailto:frederic.garesche@insa-rennes.fr"><frederic.garesche@insa-rennes.fr></a><br>
<b>À: </b>"Hubert TOUVET"
<a class="moz-txt-link-rfc2396E" href="mailto:htouvet@tranquil.it"><htouvet@tranquil.it></a><br>
<b>Cc: </b>"wapt" <a class="moz-txt-link-rfc2396E" href="mailto:wapt@lists.tranquil.it"><wapt@lists.tranquil.it></a><br>
<b>Envoyé: </b>Jeudi 24 Octobre 2019 10:15:38<br>
<b>Objet: </b>Re: [Wapt] Arrêt aléatoire du
serveur wapt<br>
</div>
<br>
<div>
<div style="font-family: "courier new",
"courier", "monaco",
monospace, sans-serif; font-size: 13pt; color:
rgb(0, 0, 0);">
<div>Effectivement, j'ai ce problème<br>
</div>
<br>
<div>USER PID %CPU %MEM VSZ RSS
TTY STAT START TIME COMMAND<br>
</div>
<div>root 1289 0.0 0.1 264188 62028
? Ss oct.22 0:00 /usr/bin/python2
/usr/bin/salt-minion<br>
root 1392 0.1 0.1 628992 80328
? Sl oct.22 3:19 /usr/bin/python2
/usr/bin/salt-minion<br>
root 1422 0.0 0.1 356156 55984
? S oct.22 0:00 /usr/bin/python2
/usr/bin/salt-minion<br>
wapt 1527 <strong>99.7</strong> 0.8
517776 402612 ? Rs oct.22 2735:27
/opt/wapt/bin/python
/opt/wapt/waptserver/server.py<br>
</div>
<br>
<div>Je mets à jour wapt et je vous tiens au
courant.<br>
</div>
<br>
<div>Cordialement,<br>
</div>
<br>
<div>
<div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span
style="font-family: "courier
new", "courier",
"monaco", monospace,
sans-serif;"><b><span style="color:
rgb(51, 51, 51);">Frédéric GARESCHÉ</span><br>
</b></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span style="color:
rgb(128, 128, 128); font-family:
"courier new",
"courier", "monaco",
monospace, sans-serif;"><b>Équipe
Assistance et Exploitation<br>
</b></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span style="color:
rgb(128, 128, 128); font-family:
"courier new",
"courier", "monaco",
monospace, sans-serif;"><b>Direction du
Système d'Information (D.S.I)</b></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span style="color:
rgb(128, 128, 128); font-family:
"courier new",
"courier", "monaco",
monospace, sans-serif;"><b>Correspondant
Département EII et laboratoire IETR<br>
</b>Tél. : +33 (0)2 23 2<strong>3 82 81</strong></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";">
<div><span style="color: rgb(128, 128,
128); font-family: "courier
new", "courier",
"monaco", monospace,
sans-serif;">20 avenue des Buttes de
Coësmes</span><br>
<span style="color: rgb(128, 128, 128);
font-family: "courier new",
"courier",
"monaco", monospace,
sans-serif;">CS 70839 - 35 708 RENNES
Cedex 7</span></div>
</div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span style="color:
rgb(128, 128, 128);"></span><br>
</div>
<a href="https://www.insa-rennes.fr"
rel="nofollow noopener noreferrer nofollow
noopener noreferrer nofollow noopener
noreferrer" target="_blank"
moz-do-not-send="true"><img alt=""
data-mce-src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
saveddisplaymode="" style=""
moz-do-not-send="true"></a><br>
</div>
</div>
<br>
<hr id="zwchr">
<div><b>De: </b>"Frederic Garesche"
<a class="moz-txt-link-rfc2396E" href="mailto:frederic.garesche@insa-rennes.fr"><frederic.garesche@insa-rennes.fr></a><br>
<b>À: </b>"Hubert TOUVET"
<a class="moz-txt-link-rfc2396E" href="mailto:htouvet@tranquil.it"><htouvet@tranquil.it></a><br>
<b>Cc: </b>"wapt"
<a class="moz-txt-link-rfc2396E" href="mailto:wapt@lists.tranquil.it"><wapt@lists.tranquil.it></a><br>
<b>Envoyé: </b>Jeudi 24 Octobre 2019 10:11:03<br>
<b>Objet: </b>Re: [Wapt] Arrêt aléatoire du
serveur wapt<br>
</div>
<br>
<div>
<div>
<div style="font-family: "courier
new", "courier",
"monaco", monospace, sans-serif;
font-size: 13pt; color: rgb(0, 0, 0);">
<div>Je regarde ça.<br>
</div>
<br>
<div>
<div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span
style="font-family: "courier
new", "courier",
"monaco", monospace,
sans-serif;"><b><span
style="color: rgb(51, 51,
51);">Frédéric GARESCHÉ</span><br>
</b></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span
style="color: rgb(128, 128, 128);
font-family: "courier
new", "courier",
"monaco", monospace,
sans-serif;"><b>Équipe Assistance
et Exploitation<br>
</b></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span
style="color: rgb(128, 128, 128);
font-family: "courier
new", "courier",
"monaco", monospace,
sans-serif;"><b>Direction du
Système d'Information (D.S.I)</b></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span
style="color: rgb(128, 128, 128);
font-family: "courier
new", "courier",
"monaco", monospace,
sans-serif;"><b>Correspondant
Département EII et laboratoire
IETR<br>
</b>Tél. : +33 (0)2 23 2<strong>3
82 81</strong></span></div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";">
<div><span style="color: rgb(128,
128, 128); font-family:
"courier new",
"courier",
"monaco", monospace,
sans-serif;">20 avenue des
Buttes de Coësmes</span><br>
<span style="color: rgb(128, 128,
128); font-family: "courier
new", "courier",
"monaco", monospace,
sans-serif;">CS 70839 - 35 708
RENNES Cedex 7</span></div>
</div>
<div style="color: rgb(94, 94, 93);
font-size: 13px; font-family:
"arial";"><span
style="color: rgb(128, 128, 128);"></span><br>
</div>
<a href="https://www.insa-rennes.fr"
rel="nofollow noopener noreferrer
nofollow noopener noreferrer
nofollow noopener noreferrer"
target="_blank"
moz-do-not-send="true"><img alt=""
data-mce-src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
src="http://ressources.insa-rennes.fr/images/logos/logo-INSARennes_mail.jpg"
saveddisplaymode="" style=""
moz-do-not-send="true"></a><br>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
<br>
_______________________________________________<br>
WAPT mailing list<br>
<a class="moz-txt-link-abbreviated" href="mailto:WAPT@lists.tranquil.it">WAPT@lists.tranquil.it</a><br>
<a class="moz-txt-link-freetext" href="http://lists.tranquil.it/listinfo/wapt">http://lists.tranquil.it/listinfo/wapt</a></blockquote>
</div>
</div>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</body>
</html>