Re: [EXTERNAL EMAIL] spacewalk-repo-sync failed after update 2022.10 to 2022.11

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_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), ^

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_postgresql.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