UndefinedTable: missing FROM-clause entry for table "c"

[greinick]

Hi, two days ago I noticed an error "UndefinedTable: missing FROM-clause entry for table "c"" during the spacewalk-repo-sync run.

Today I did the update from uyuni 2022.10 to 2022.11 hoping that this will pull things straight again.

But it did not.

I still get the error on all repos. Any hints / suggetsions? Thanks & Regards . Götz

15:07:13 Patches in repo: 0.
15:07:14 Updating overview of 53 systems
Traceback (most recent call last):
File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 299, in _execute_wrapper
retval = function(*p, **kw)
File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 182, in _execute
return self.execute(args, kwargs)
File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 322, in execute
self._real_cursor.execute(self.sql, params)
psycopg2.errors.UndefinedTable: missing FROM-clause entry for table "c"
LINE 4: coalesce(c.org_id, 1),
^

[greinick]

Looks like fixed by recent patchupdates.