You have been subscribed to a public bug by Mauricio Faria de Oliveira (mfo):
[Impact]
wait_timeout is the number of seconds the MySQL server waits for activity
before closing the connection.
MySQL v8.0.24 writes the reason for the connection before closing it, and the
client receives a more informative error message
(ER_CLIENT_INTERACTION_TIMEOUT).
Snmptrapd does not handle this error code, so the connection will not reconnect
to the MySQL server afterward.
[Test Plan]
1. Setup MySQL server and modify wait_timeout to 15 in
/etc/MySQL/mysql.conf.d/mysqld.cnf
2. Setup snmptrapd and execute snmptrap command
3. Sleep 15 seconds and re-execute snmptrap command, then the connection will
fail until the snmptrapd service restarted
[Where problems could occur]
Once the error happens, snmptrapd will keep the sql commands and resend it
after reconnecting to the MySQL server.
The regression can be considered as low.
[Other Info]
** Affects: net-snmp (Ubuntu)
Importance: Undecided
Assignee: ChengEn, Du (chengendu)
Status: In Progress
** Affects: net-snmp (Ubuntu Bionic)
Importance: Undecided
Assignee: ChengEn, Du (chengendu)
Status: In Progress
** Affects: net-snmp (Ubuntu Focal)
Importance: Undecided
Assignee: ChengEn, Du (chengendu)
Status: In Progress
** Affects: net-snmp (Ubuntu Jammy)
Importance: Undecided
Assignee: ChengEn, Du (chengendu)
Status: In Progress
** Affects: net-snmp (Ubuntu Kinetic)
Importance: Undecided
Assignee: ChengEn, Du (chengendu)
Status: In Progress
** Affects: net-snmp (Ubuntu Lunar)
Importance: Undecided
Assignee: ChengEn, Du (chengendu)
Status: In Progress
** Tags: bionic focal jammy kinetic lunar patch sts sts-sponsor
--
Snmptrapd cannot reconnect to MySQL server after hitting MySQL wait_timeout
https://bugs.launchpad.net/bugs/1999711
You received this bug notification because you are a member of SE SRU ("STS")
Sponsors, which is subscribed to the bug report.
--
Mailing list: https://launchpad.net/~sts-sponsors
Post to : [email protected]
Unsubscribe : https://launchpad.net/~sts-sponsors
More help : https://help.launchpad.net/ListHelp
