bodhi icon indicating copy to clipboard operation
bodhi copied to clipboard

`bodhi updates download` on Fedora 32 frequently failing with error "Could not locate column in row for column 'comments.id'"

Open AdamWill opened this issue 3 years ago • 5 comments

Within the last few hours - I'm guessing since Bodhi 5.5 was deployed on the server end? - I'm seeing openQA tests that run bodhi updates download --updateid=(someid) fail quite often, with an error "Could not locate column in row for column 'comments.id'", see e.g. here. This is a significant issue for openQA. I can't immediately seem to reproduce it locally on Rawhide with bodhi-client-5.2.2-2.fc33, will try on an F32 box shortly. F32 has bodhi-client 5.1.1 I believe.

AdamWill avatar Aug 13 '20 19:08 AdamWill

This is actually reproducible on F33 as well, it's just very intermittent. It happens around once in every six tries. It happens when the client is doing this:

resp = client.query(**{attr: value})

with 'updateid' as the attr and 'FEDORA-2020-74b4efe302' as the value. Somehow that query is going wrong one in six times.

AdamWill avatar Aug 13 '20 21:08 AdamWill

A mail to devel@ reports the same problem with fedpkg update.

AdamWill avatar Aug 13 '20 23:08 AdamWill

Cross reference for the infra ticket: https://pagure.io/fedora-infrastructure/issue/9234

hroncok avatar Aug 14 '20 09:08 hroncok

fwiw, also getting errors for comment_bug_assoc.id and testcases.id lately.

AdamWill avatar Aug 31 '20 18:08 AdamWill

@nirik just "scaled it to 1 pod instead of 2" and that seems to be helping. I tried the bodhi updates download --updateid=(someid) 20+ times without failure and have done a couple other things since without any failures.

AdamWill avatar Aug 31 '20 19:08 AdamWill