On August 21, 2019 12:21:29 PM GMT+03:00, Boris Manojlovic <boris@steki.net> wrote:
Hi list,
reason why all of you had issues with updates from opensuse 15.1 is kernel update that originated from suse sources (or someone made exactly SAME kind of mistake)
in source code (database code) you will find your mentioned unique index creation code
``` CREATE UNIQUE INDEX rhn_pkg_clr_pid_cld_uq ON rhnPackageChangeLogRec (package_id, changelog_data_id) NOLOGGING TABLESPACE [[32m_tbs]]; ```
so what happens in other part of code is next get changelog data from rpm, insert it into db line by line (all text as one row per changelog entry ) some other stuff in between try adding rpm package changelog info into table as bellow (arbitrary values 10 and 3 just to show point) ``` info into packagechangelogrec ( pkg_id=10 , chg_id=3 ,...); info into packagechangelogrec ( pkg_id=10 , chg_id=3 ,...); <- second one fails with unique index problerm ` insert will of course fail with given error (from log file pasted) as package has exactly same changelog entries.
hope this helps someone in future to debug this kind of error
P.S. sorry for not responding to thread as is, simply was not subscribed before :)
P.P.S.
Not sure list got it as i still did not confirm my subscription before sending...
Is it fixed, as I thought my Uyuni DB 'ended' and redeployed again :) ?
I will need to create all repos again.
Best Regards, Strahil Nikolov
It's definitely not fixed: 01:39:50 01:39:50 Importing packages to DB: Importing packages: |--------------------------------------------------| 0.21% 01:41:24 0.21 % Importing packages: |--------------------------------------------------| 0.38% 01:42:40 duplicate key value violates unique constraint "rhn_pkg_clr_pid_cld_uq" DETAIL: Key (package_id, changelog_data_id)=(36047, 35803) already exists. 01:42:40 Unexpected error: 01:42:40 Traceback (most recent call last): File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.py", line 568, in sync ret = self.import_packages(plugin, data['id'], url, is_non_local_repo) File "/usr/lib/python3.6/site-packages/spacewalk/satellite_tools/reposync.py", line 1086, in import_packages importer.run() File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/importLib.py", line 764, in run self.submit() File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/packageImport.py", line 343, in submit transactional=self.transactional) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 853, in processPackages transactional=transactional) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2158, in __processObjectCollection__ return self.__doDML(dml) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2263, in __doDML self.__doInsert(dml.insert, dml.tables) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2270, in __doInsert self.__doInsertTable(tname, dict) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backend.py", line 2285, in __doInsertTable insertObj.query(hash) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backendLib.py", line 459, in query executeStatement(statement, values, chunksize) File "/usr/lib/python3.6/site-packages/spacewalk/server/importlib/backendLib.py", line 484, in executeStatement count += statement.executemany(**tempdict) File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 159, in executemany return self._execute_wrapper(self._executemany, *p, **kw) File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 298, in _execute_wrapper retval = function(*p, **kw) File "/usr/lib/python3.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", line 348, in _executemany self._real_cursor.executemany(self.sql, all_kwargs) psycopg2.IntegrityError: duplicate key value violates unique constraint "rhn_pkg_clr_pid_cld_uq" DETAIL: Key (package_id, changelog_data_id)=(36047, 35803) already exists. Does anyone know the names of the offending packages ? Best Regards, Strahil Nikolov -- To unsubscribe, e-mail: uyuni-users+unsubscribe@opensuse.org To contact the owner, e-mail: uyuni-users+owner@opensuse.org