After discussing comments #20 and #23 with ChengEn we agreed that bionic
may not need that fix.
Hence, I'm removing it from the affected series.
** No longer affects: net-snmp (Ubuntu Bionic)
--
You received this bug notification because you are a member of SE
("STS") Sponsors, which is
This bug was fixed in the package net-snmp - 5.8+dfsg-2ubuntu2.7
---
net-snmp (5.8+dfsg-2ubuntu2.7) focal; urgency=medium
* Fix snmptrapd reconnection issue after hitting MySQL wait_timeout
(LP: #1999711)
- d/p/snmptrapd-mysql-reconnection-after-hitting-wait_timeout.patch
** Tags removed: verification-needed
** Tags added: verification-done
--
You received this bug notification because you are a member of SE
("STS") Sponsors, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1999711
Title:
Snmptrapd cannot reconnect to MySQL server after
This bug was fixed in the package net-snmp - 5.9.1+dfsg-1ubuntu2.6
---
net-snmp (5.9.1+dfsg-1ubuntu2.6) jammy; urgency=medium
* Fix snmptrapd reconnection issue after hitting MySQL wait_timeout
(LP: #1999711)
-
This bug was fixed in the package net-snmp - 5.9.3+dfsg-1ubuntu1.4
---
net-snmp (5.9.3+dfsg-1ubuntu1.4) kinetic; urgency=medium
* Fix snmptrapd reconnection issue after hitting MySQL wait_timeout
(LP: #1999711)
-
After restart:
* same s390x testbed setup error for php,
* asterisk is fine this time
* new regression reported for cluster-glue (which was fine before):
=== ha_logger ===
logd is not runningautopkgtest [07:00:28]: test logd: ---]
autopkgtest [07:00:29]: test logd: - - - - -
I've looked into the regressions and both of them seem unrelated:
* asterisk:
: failure: Timed out on waiting for ssh connection
autopkgtest [18:39:03]: ERROR: testbed failure: cannot send to testbed: [Errno
32] Broken pipe
* php8.1:
VirtSubproc.Timeout
autopkgtest [20:46:20]: ERROR: testbed
I have tested the following versions: 5.9.3+dfsg-1ubuntu1.4 for kinetic,
5.9.1+dfsg-1ubuntu2.6 for jammy, and 5.8+dfsg-2ubuntu2.7 for focal. The
issue no longer exists in these versions based on the same test plan.
** Tags removed: verification-needed-focal verification-needed-jammy
The patch actually resolved two issues. The first issue was related to
the reconnection problem with snmptrapd. The second issue was that
whenever the snmptrapd hit the MySQL wait timeout, all events in the
queue were being cleared instead of resent. As the error was expected,
it wasn't ideal to
the SRU rationale mentions mysql 8.0.24 which is only present in focal
and later. bionic does not have mysql-8.0 at all, it shipped mysql-5.7.
Why is a change needed for bionic?
** Changed in: net-snmp (Ubuntu Bionic)
Status: In Progress => Incomplete
** Changed in: net-snmp (Ubuntu
Hello ChengEn, or anyone else affected,
Accepted net-snmp into kinetic-proposed. The package will build now and
be available at https://launchpad.net/ubuntu/+source/net-
snmp/5.9.3+dfsg-1ubuntu1.4 in a few hours, and then in the -proposed
repository.
Please help us by testing this new package.
** Description changed:
[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
First, sorry for the vague test plan.
I should tidy it up instead of just paste the whole steps.
I'd like to clarify that the definition of HAVE_MYSQL_OPTIONS is introduced in
a separate commit (011342d8e453 snmptrapd: Let configure check for
mysql_options()) that is unrelated to the issue I'm
Thanks for the updated patches and detailed test case.
For the future, when you are adding the "Origin" tag to the DEP3 header
in the patch, if the fix was merged upstream, please use a commit to the
master/main branch or some other stable reference, instead of a PR.
For this particular case,
This bug was fixed in the package net-snmp - 5.9.3+dfsg-2ubuntu2
---
net-snmp (5.9.3+dfsg-2ubuntu2) lunar; urgency=medium
* Fix snmptrapd reconnection issue after hitting MySQL wait_timeout
(LP: #1999711)
- d/p/snmptrapd-mysql-reconnection-after-hitting-wait_timeout.patch
Thanks for the detailed steps to reproduce!
Just a copy/paste from pastebin (internal).
> Here are the steps to reproduce the issue.
> https://pastebin.canonical.com/p/MkZ9PR7kmh/
Steps to reproduce:
A. Launch 3 VMs (1 for MySQL Server, 1 Xenial snmptrapd client and 1
Focal snmptrapd client):
@dgadomski @ahasenack
Sorry for not noticing the follow-up commit.
The build error doesn't happen in ubuntu but maybe on other platforms.
For integrity, I uploaded new patches and please use those for testing.
Again, sorry for any inconvenience.
@ahasenack
Here are the steps to reproduce the
Attached is a patch that resolves the issue on Lunar.
** Patch added: "lunar_snmptrapd_mysql_reconnection_build_error.debdiff"
https://bugs.launchpad.net/ubuntu/+source/net-snmp/+bug/1999711/+attachment/5647956/+files/lunar_snmptrapd_mysql_reconnection_build_error.debdiff
--
You received
Attached is a patch that resolves the issue on Kinetic.
** Patch added: "kinetic_snmptrapd_mysql_reconnection.debdiff"
https://bugs.launchpad.net/ubuntu/+source/net-snmp/+bug/1999711/+attachment/5647954/+files/kinetic_snmptrapd_mysql_reconnection.debdiff
--
You received this bug
Attached is a patch that resolves the issue on Jammy.
** Patch added: "jammy_snmptrapd_mysql_reconnection.debdiff"
https://bugs.launchpad.net/ubuntu/+source/net-snmp/+bug/1999711/+attachment/5647953/+files/jammy_snmptrapd_mysql_reconnection.debdiff
--
You received this bug notification
Attached is a patch that resolves the issue on Focal.
** Patch added: "focal_snmptrapd_mysql_reconnection.debdiff"
https://bugs.launchpad.net/ubuntu/+source/net-snmp/+bug/1999711/+attachment/5647952/+files/focal_snmptrapd_mysql_reconnection.debdiff
--
You received this bug notification
Attached is a patch that resolves the issue on Bionic.
** Patch added: "bionic_snmptrapd_mysql_reconnection.debdiff"
https://bugs.launchpad.net/ubuntu/+source/net-snmp/+bug/1999711/+attachment/5647951/+files/bionic_snmptrapd_mysql_reconnection.debdiff
--
You received this bug notification
I noticed a follow-up commit in the upstream git repo a week or so after
the original fix:
original fix:
commit 62b2907a46c9e495c1c71114cc8f18ed137b7f34
Author: Chengen Du
Date: Wed Nov 23 14:11:36 2022 +0800
apps/snmptrap: Fix mysql reconnection after hitting wait_timeout
MySQL
I'll see if I can sponsor this
--
You received this bug notification because you are a member of SE SRU
("STS") Sponsors, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1999711
Title:
Snmptrapd cannot reconnect to MySQL server after hitting MySQL
wait_timeout
Status
** Tags added: se-sponsor-dgadomski
--
You received this bug notification because you are a member of SE SRU
("STS") Sponsors, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1999711
Title:
Snmptrapd cannot reconnect to MySQL server after hitting MySQL
wait_timeout
** Tags removed: sts-sponsor
--
You received this bug notification because you are a member of SE SRU
("STS") Sponsors, which is subscribed to the bug report.
https://bugs.launchpad.net/bugs/1999711
Title:
Snmptrapd cannot reconnect to MySQL server after hitting MySQL
wait_timeout
Status
26 matches
Mail list logo
