Hi, A patch with the fix for this problem will be released tomorrow, most likely in the morning (CET) Stay tuned! :-) El jueves, 24 de noviembre de 2022 15:43:56 (CET) Thomas Weis escribió:

thanks Simon,

I´ve added comment to the github issue

Regards Thomas

...

Am 24.11.2022 um 13:53 schrieb Simon Avery :

Hi Thomas,

You're not alone - I raised this yesterday as a bug following the 2022.11 update - please pop on there and add your experiences too.

https://github.com/uyuni-project/uyuni/issues/6193

Despite what the webui is telling you, it's possible that your repos have synced okay.

Look in /var/log/rhn/reposync for recent logs and see the actual responses.

In my case, these repos are syncing okay, but I think what is happening that a script to update an internal database after that sync is failing, and that is what's generating the error.

I look forwards to some feedback from a dev once they get a moment to look at this.

S

-----Original Message----- From: Thomas Weis Sent: 24 November 2022 12:01 To: General discussion related to the openSUSE Uyuni project Subject: [EXTERNAL EMAIL] spacewalk-repo-sync failed after update 2022.10 to 2022.11

hello everyone

After updating from 2022.10 to 2022.11, after running spacewalk-repo-sync -p opensuse_leap15_4-x86_64, the process aborted with an error. The following error message was generated:

12:26:52 Repo URL: http://download.opensuse.org/distribution/leap/15.4/repo/oss/ 12:26:52 Packages in repo: 96026 12:34:39 No new packages to sync. 12:34:40 12:34:40 Patches in repo: 0. 12:34:45 12:34:45 Importing media products file products. 12:34:45 *** NOTE: Importing mediaproducts file for the channel 'opensuse_leap15_4-x86_64'. Previous media products will be discarded. 12:42:56 Updating overview of 1 systems

Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgre sql.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_postgre sql.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),

^

During handling of the above exception, another exception occurred:

Traceback (most recent call last): File "/usr/bin/spacewalk-repo-sync", line 286, in <module>

sys.exit(abs(main() or 0))

File "/usr/bin/spacewalk-repo-sync", line 269, in main

elapsed_time, channel_ret_code = sync.sync()

File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.py" , line 705, in sync> self.update_servers()

File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.py" , line 739, in update_servers> taskomatic.add_to_system_overview_update_queue(row["id"])

File "/usr/lib/python3.6/site-packages/spacewalk/server/taskomatic.py", line 103, in add_to_system_overview_update_queue> h.execute(sid=sid)

File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 150, in execute> return self._execute_wrapper(self._execute, *p, **kw)

File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgre sql.py", line 309, in _execute_wrapper> raise sql_base.SQLStatementPrepareError(str(self.dbh), e.pgerror, self.sql)

spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError: ('ERROR: missing FROM-clause entry for table "c"\nLINE 4: coalesce(c.org_id, 1),\n ^\n', "", "\n INSERT INTO rhnTaskQueue (org_id, task_name, task_data, priority, earliest)\n VALUES (\n coalesce(c.org_id, 1),\n 'update_system_overview',\n %(sid)s,\n 0,\n current_timestamp\n )\n ")

After that it was completely canceled.

The update from 2022.10 to 2022.11 ran without errors, the webgui is accessible. what can be done Restore from snapshot?

Thanks for support!

Regards Thomas

-- Julio González Gil Release Engineer, SUSE Manager and Uyuni jgonzalez@suse.com