| *** dmitriis is now known as Guest2496 | 10:50 | |
| frickler | do we have database performance issues again? https://zuul.opendev.org/t/openstack/builds?job_name=ironic-inspector-tempest-uefi-redfish-vmedia&skip=0 spins forever without a result | 12:31 |
|---|---|---|
| fungi | once corvus is awake, i'll see if i can find out how he's been profiling the queries to find out which one is suboptimally expressed | 13:54 |
| corvus | fungi: frickler i just "show full processlist" and then ask mysql to explain the query. but i can already tell you that searching for job_name without a project has always been problematic; there's a comment in the code about it: https://opendev.org/zuul/zuul/src/branch/master/zuul/driver/sql/sqlconnection.py#L188-L192 | 14:22 |
| corvus | if you can add more filtering items, like project, that should work | 14:22 |
| corvus | https://zuul.opendev.org/t/openstack/builds?job_name=ironic-inspector-tempest-uefi-redfish-vmedia&project=openstack/ironic | 14:22 |
| fungi | corvus: thanks! i guess run that shortly after attempting such a request so that you catch it before the query times out? | 14:23 |
| corvus | yep, you get a whole 30 seconds to catch it before it times out :) | 14:23 |
| fungi | even i type faster than that | 14:23 |
| opendevreview | Takashi Kajinami proposed openstack/project-config master: Migrate release-openstack-puppet to jammy https://review.opendev.org/c/openstack/project-config/+/925986 | 14:34 |
| fungi | #status log Pruned backups on backup02.ca-ymq-1.vexxhost.opendev.org, bringing volume utilization down from 90% to 73% | 15:26 |
| opendevstatus | fungi: finished logging | 15:26 |
| opendevreview | Jan Gutter proposed zuul/zuul-jobs master: [wip] Update ensure-kubernetes with podman support https://review.opendev.org/c/zuul/zuul-jobs/+/924970 | 18:35 |
| opendevreview | Jan Gutter proposed zuul/zuul-jobs master: [wip] Update ensure-kubernetes with podman support https://review.opendev.org/c/zuul/zuul-jobs/+/924970 | 18:37 |
| opendevreview | James E. Blair proposed zuul/zuul-jobs master: ensure-podman: add tasks to configure socket group https://review.opendev.org/c/zuul/zuul-jobs/+/925916 | 18:41 |
| opendevreview | Jan Gutter proposed zuul/zuul-jobs master: [wip] Update ensure-kubernetes with podman support https://review.opendev.org/c/zuul/zuul-jobs/+/924970 | 19:43 |
| opendevreview | Jan Gutter proposed zuul/zuul-jobs master: [DNM] check k8s-crio job for health https://review.opendev.org/c/zuul/zuul-jobs/+/926013 | 20:04 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!