#10357 [bodhi] NoSuchColumnError: "Could not locate column in row for column 'bugs.id'"
Closed: Upstream 2 years ago by kevin. Opened 2 years ago by ignatenkobrain.

https://bodhi.fedoraproject.org/updates/FEDORA-EPEL-NEXT-2021-48e4aed536

 Traceback (most recent call last): File "/usr/lib/python3.9/site-packages/pyramid_mako/__init__.py", line 148, in __call__ result = template.render_unicode(**system) File "/usr/lib/python3.9/site-packages/mako/template.py", line 478, in render_unicode return runtime._render( File "/usr/lib/python3.9/site-packages/mako/runtime.py", line 878, in _render _render_context( File "/usr/lib/python3.9/site-packages/mako/runtime.py", line 920, in _render_context _exec_template(inherit, lclcontext, args=args, kwargs=kwargs) File "/usr/lib/python3.9/site-packages/mako/runtime.py", line 947, in _exec_template callable_(context, *args, **kwargs) File "/usr/lib/python3.9/site-packages/bodhi/server/templates/master.html", line 142, in render_body ${self.body()} File "/usr/lib/python3.9/site-packages/bodhi/server/templates/update.html", line 20, in render_body <% update.bugs.sort(key = lambda x: x.bug_id) %> File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 294, in __get__ return self.impl.get(instance_state(instance), dict_) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/attributes.py", line 730, in get value = self.callable_(state, passive) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/strategies.py", line 759, in _load_for_state return self._emit_lazyload( File "<string>", line 1, in <lambda> File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/strategies.py", line 900, in _emit_lazyload q(session) File "/usr/lib64/python3.9/site-packages/sqlalchemy/ext/baked.py", line 544, in all return list(self) File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 100, in instances cursor.close() File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__ compat.raise_( File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 80, in instances rows = [proc(row) for row in fetch] File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 80, in <listcomp> rows = [proc(row) for row in fetch] File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 524, in _instance tuple([row[column] for column in pk_cols]), File "/usr/lib64/python3.9/site-packages/sqlalchemy/orm/loading.py", line 524, in <listcomp> tuple([row[column] for column in pk_cols]), File "/usr/lib64/python3.9/site-packages/sqlalchemy/engine/result.py", line 681, in _key_fallback util.raise_( File "/usr/lib64/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_ raise exception NoSuchColumnError: "Could not locate column in row for column 'bugs.id'" 

https://github.com/fedora-infra/bodhi/issues/4287 upstream.

Hopefully we can get the fix rolled out soon.

Metadata Update from @kevin:
- Issue close_status updated to: Upstream
- Issue status updated to: Closed (was: Open)

2 years ago

This is starting to get really annoying. :weary:

It has also resulted in this update getting stuck in a weird state: https://bodhi.fedoraproject.org/updates/FEDORA-2021-1937205ae5

After pushing the "submit" button, the "no bugs.id" error happened somewhere during the "editing" process, and now the update wasn't pushed back into the "pending → testing" state as it should have been (and I also had to edit the update notes and flags a second time because they were not applied the first time ...)

:cry: Looks like bodhi 5.7.2 fixed this particular issue, but introduced a new, similar one:
https://github.com/fedora-infra/bodhi/issues/4302

Login to comment on this ticket.

Metadata