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 -- To unsubscribe, e-mail: uyuni-users+unsubscribe@opensuse.org To contact the owner, e-mail: uyuni-users+owner@opensuse.org