rssLink RSS for all categories
 
icon_blue
icon_green
icon_orange
icon_orange
icon_red
icon_green
icon_green
icon_orange
icon_red
icon_orange
icon_red
icon_green
icon_green
icon_orange
icon_orange
icon_red
icon_blue
icon_green
icon_red
icon_orange
icon_green
icon_green
icon_red
icon_blue
icon_orange
icon_green
icon_green
icon_green
icon_green
icon_green
icon_red
 

FS#35689 — max_connections on SharedSQL

Attached to Project— Web Hosting / CloudDB
Incident
P19 / Shared SQL
CLOSED
100%
We encounter errors about "max_user_connections" that look illegitimate on P19 SharedSQL. Investigation in progress.

---

Nous rencontrons des erreurs de "max_user_connections" qui semblent illégitimes sur les SharedSQL de P19. Nous investigons.
Date:  Tuesday, 11 December 2018, 09:47AM
Reason for closing:  Done
Comment by OVH - Friday, 07 December 2018, 16:03PM

Those databases errors widely result in 500 errors on your website.
The deployment of the ProxySQL (see http://travaux.ovh.net/?do=details&id=35499) and a tiny error on few customers resulted in a snow-ball effect. 2 causes resulting in a problem, each of them, independently, are not a problem at all. That's why the diagnose was hard, and that's why the change passed our tests.

---

Ces erreurs de bases de données aboutissent généralement à une erreur 500 sur votre site web.
Le déploiement des ProxySQL (cf. http://travaux.ovh.net/?do=details&id=35499) ainsi qu'une petite erreur sur quelques clients ont entraîné un effet boule de neige. 2 causes qui aboutissent à un probleme, mais chacune d'elles, prises indépendamment, n'en provoquent pas. C'est pourquoi le problème était dur à diagnostiquer, c'est également pourquoi le changement a passé tous nos tests.


Comment by OVH - Saturday, 08 December 2018, 16:01PM

Saturday 10:10

Below the full list of servers with users reaching max_user_connections:

mysql55-110.perso.ha.ovh.net: 50
mysql55-34.perso.ha.ovh.net: 56
mysql55-196.perso.ha.ovh.net: 3
mysql55-40.perso.ha.ovh.net: 5
mysql55-211.perso.ha.ovh.net: 4
mysql55-58.perso.ha.ovh.net: 82
mysql55-239.bdb.ha.ovh.net: 21
mysql55-237.perso.ha.ovh.net: 7
mysql55-157.perso.ha.ovh.net: 41
mysql55-116.business.ha.ovh.net: 23
mysql55-165.perso.ha.ovh.net: 37
mysql55-167.perso.ha.ovh.net: 216
mysql55-253.perso.ha.ovh.net: 61
mysql55-171.perso.ha.ovh.net: 39
mysql55-127.perso.ha.ovh.net: 61
mysql55-177.perso.ha.ovh.net: 25
mysql55-14.bdb.ha.ovh.net: 4
mysql55-55.perso.ha.ovh.net: 4
mysql55-15.perso.ha.ovh.net: 174
mysql55-106.perso.ha.ovh.net: 117
mysql55-162.pro.ha.ovh.net: 17
mysql55-255.perso.ha.ovh.net: 127
mysql55-121.perso.ha.ovh.net: 126
mysql55-112.perso.ha.ovh.net: 19
mysql55-128.perso: ?


The appropriate patch has been sucessfully deployed on these servers.

Saturday 12:05:

No more users reaching max_user_connections on theirs DB.

To limit unwanted side effects, the patch will be deployed on all servers from Monday.


Comment by OVH - Saturday, 08 December 2018, 18:41PM


We have just patched additional servers to fix some residual max_user_connections reached:

mysql55-224.perso.ha.ovh.net
mysql55-142.perso.ha.ovh.net
mysql55-41.perso.ha.ovh.net
mysql55-205.perso.ha.ovh.net
mysql55-75.bdb.ha.ovh.net
mysql55-108.perso.ha.ovh.net

Task is closed.


Comment by OVH - Monday, 10 December 2018, 09:31AM

All the servers will be patched in a couple of minutes.

---

L'ensemble des serveurs va être patché dans quelques minutes.


Comment by OVH - Monday, 10 December 2018, 14:50PM

About half of the servers are now patched.

---

Le patch est maintenant déployé sur la moitié des serveurs.


Comment by OVH - Monday, 10 December 2018, 15:34PM

ETA: 16:30 french time


Comment by OVH - Monday, 10 December 2018, 16:24PM

Patch had been deployed everywhere. Another one is being tested to ensure sustainability of the changes.

---

Le patch a été déployé partout. Un autre est en cours de tests afin d'assurer la pérénité de ces changements.


Comment by OVH - Monday, 10 December 2018, 17:43PM

Patch will be deployed in a couple of minutes.

---

Le patch va être déployé dans quelques instants.


Comment by OVH - Monday, 10 December 2018, 18:32PM

First part had been deployed.

---

La première partie a été déployée.


Comment by OVH - Tuesday, 11 December 2018, 00:17AM

Second part (50%) had been deployed.

---

La seconde partie (50%) a été déployée.


Comment by OVH - Tuesday, 11 December 2018, 09:47AM

All had been deployed.

---

Tout a été déployé.