Hi Guillaume,

Thanks for the -proposed build. I tested `watcher 2:12.0.0-0ubuntu1.3`
(noble / cloud-archive:caracal candidate, delivered via our internal
Ubuntu mirror as `noble-updates/universe`) against a production Sunbeam
2024.1 deployment (`watcher-k8s` charm, channel
`2024.1/stable/lp2086710`) and wanted to share the SRU verification
results.

**Environment**
- Ubuntu 24.04.4 LTS (Noble), Sunbeam 2024.1
- `watcher-k8s` charm channel: `2024.1/stable/lp2086710`, revision 138
- 3 units: `watcher/0`, `watcher/1`, `watcher/2`, all `active/idle`
- Package candidate confirmed via `apt-cache policy watcher-api`: 
`2:12.0.0-0ubuntu1.3`

**Check 1 — No QueuePool/TimeoutError in decision-engine logs (last 60min)**
```
sudo k8s kubectl logs -n openstack watcher-0 -c watcher-decision-engine 
--since=60m | grep -iEc "queuepool|TimeoutError"
0
```
Result: PASS** (0 matches).

**Check 2 — Sleeping MySQL connections not accumulating**
First sample (immediately after the above):
```
SELECT count(*), state FROM information_schema.processlist GROUP BY state;
count(*)  state
1         executing
15                    <- empty/sleeping state
```
15 is at the documented "under ~15" ceiling on the first sample. We're taking a 
second sample after an overnight interval, as recommended in the test case, to 
confirm the count does not trend upward. Will follow up with that second data 
point in a separate comment.

**Check 3 — watcher-decision-engine reports ACTIVE**
```
openstack optimize service list
+----+-------------------------+-----------+--------+
| ID | Name                    | Host      | Status |
+----+-------------------------+-----------+--------+
|  1 | watcher-decision-engine | watcher-0 | ACTIVE |
|  2 | watcher-applier         | watcher-0 | ACTIVE |
|  3 | watcher-decision-engine | watcher-2 | ACTIVE |
|  4 | watcher-applier         | watcher-2 | ACTIVE |
|  5 | watcher-decision-engine | watcher-1 | ACTIVE |
|  6 | watcher-applier         | watcher-1 | ACTIVE |
+----+-------------------------+-----------+--------+
```
**Result: PASS** (6/6 ACTIVE across all 3 units).

Will report back with the overnight Check 2 sample; if it stays bounded
as expected we'll tag this `verification-caracal-done`.

-- 
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2086710

Title:
  [SRU] watcher's use of apscheduler is incompatible with python 3.12
  and eventlet

To manage notifications about this bug go to:
https://bugs.launchpad.net/cloud-archive/caracal/+bug/2086710/+subscriptions


-- 
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to