Page MenuHomeDevCentral

Allow to reconnect automatically to MariaDB
Open, HighPublic

Description

18:38:15 < Dereckson> [complector] Deploy autochmod-git fix (D3996)
18:38:20 < Dereckson> .+log [Complector] Deploy autochmod-git fix (D3996)

Only the second expression worked. When debugging why, it showed MariaDB connection was out, after a tunnel interface update:

18:44:49 <Dereckson> .tcl could_be_a_component Complector
18:44:49 <Wearg> Tcl error: Error 2006 (Server has gone away)

There is an opportunity to automatically remediate to that situation in registry command to detect that case and reconnect automatically using <code>sqlrehash</code> to retry once.

Plan:

  • Replace sql by a new safesql command in registry procedure
  • Define safesql command as a sql command wrapped in a catch block, to detect the case server has been disconnected and reconnect in that case before retry (once)
  • Could also be interesting to report any other MySQL/MariaDB reconnection error to Sentry.

Related Objects