<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-2">
</head>
<body>
Hi,<br>
<br>
fix provided in mentioned BZ is now available in
spacewalk-schema-2.8.25-1.<br>
<br>
Regards,<br>
Jiri<br>
<br>
<div class="moz-cite-prefix">Dne 23.5.2018 v 10:03 Tomáš Kašpárek
napsal(a):<br>
</div>
<blockquote type="cite"
cite="mid:25fc9ccd-f219-8e04-35b5-417e3f66dc9d@redhat.com">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-2">
I am actually working for universal fix as the fix in the <a
href="https://bugzilla.redhat.com/show_bug.cgi?id=1576002"
target="_blank" moz-do-not-send="true">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1576002</a>
was targeting one specific database and data there.<br>
<br>
Hopefully I'll finish with this this week.<br>
<br>
Tomas<br>
<br>
<div class="moz-cite-prefix">On 05/22/2018 11:23 PM, Guy Matz
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CABnTgtXHeb-ACmbmP=vv3HBTA47CQMQB2oJJxGKo_gXN_hLw8Q@mail.gmail.com">
<div dir="ltr">
<div>
<div>Darn. Still failing with what looks to be the same
error:<br>
bash-4.2$ cat
/var/log/spacewalk/schema-upgrade/20180522-130306-to-spacewalk-schema-2.8.log<br>
UPDATE 1<br>
COMMIT<br>
?column?<br>
-----------------------------------------------------------------------------------------------<br>
spacewalk-schema-2.7-to-spacewalk-schema-2.8/001-rhnpackageevr-rhn_pe_v_r_e_uq.sql.postgresql<br>
(1 row)<br>
<br>
CREATE FUNCTION<br>
DROP TRIGGER<br>
psql:/var/log/spacewalk/schema-upgrade/20180522-130306-script.sql:57:
ERROR: null value in column "nevra_id" violates not-null
constraint<br>
DETAIL: Failing row contains (4966, null).<br>
CONTEXT: SQL statement "update rhnsnapshotpackage set
nevra_id = <a href="http://nevra_orig.id"
moz-do-not-send="true">nevra_orig.id</a> where nevra_id
= <a href="http://nevra_dup.id" moz-do-not-send="true">nevra_dup.id</a>"<br>
PL/pgSQL function fix_rhn_pe_v_r_e_uq() line 28 at SQL
statement<br>
<br>
</div>
Any other ideas?<br>
<br>
<br>
<br>
</div>
Thank you!!<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Tue, May 22, 2018 at 2:52 AM,
Tomáš Kašpárek <span dir="ltr"><<a
href="mailto:tkaspare@redhat.com" target="_blank"
moz-do-not-send="true">tkaspare@redhat.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF"> Hello,<br>
<br>
have you restored the database from backup after you've
applied patch from <a
href="https://bugzilla.redhat.com/show_bug.cgi?id=1576002"
target="_blank" moz-do-not-send="true">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1576002</a>?<br>
It seems like you've applied patch after the schema
upgrade failed and you're trying to restore the
schema-upgrade process. Unfortunately, this is not how
it works with schema upgrade and you need to go back to
prior version of schema from backup and restart the
schema-upgrade process completely.<br>
<br>
Tomas
<div>
<div class="h5"><br>
<br>
<div class="m_928613561772718680moz-cite-prefix">On
05/21/2018 10:37 PM, Guy Matz wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="h5">
<div dir="ltr">
<div>
<div>
<div>
<div>Hello! When trying to upgrade from
2.7 to 2.8, I got this error during
/usr/bin/spacewalk-schema-<wbr>upgrade:<br>
<br>
null value in column "nevra_id" violates
not-null constraint<br>
<br>
I tried making the changes in the schema
upgrade patch here:<br>
<a
href="https://bugzilla.redhat.com/show_bug.cgi?id=1576002"
target="_blank" moz-do-not-send="true">https://bugzilla.redhat.com/<wbr>show_bug.cgi?id=1576002</a><br>
<br>
</div>
But now I get:<br>
# /usr/bin/spacewalk-schema-<wbr>upgrade<br>
Unknown schema name [(0 rows)] found.<br>
<br>
</div>
Any thoughts would be greatly appreciated.<br>
<br>
</div>
Thanks,<br>
</div>
Guy<br>
</div>
<br>
<fieldset
class="m_928613561772718680mimeAttachmentHeader"></fieldset>
<br>
</div>
</div>
<pre>______________________________<wbr>_________________
Spacewalk-list mailing list
<a class="m_928613561772718680moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com" target="_blank" moz-do-not-send="true">Spacewalk-list@redhat.com</a>
<a class="m_928613561772718680moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank" moz-do-not-send="true">https://www.redhat.com/<wbr>mailman/listinfo/spacewalk-<wbr>list</a></pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Spacewalk-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com">Spacewalk-list@redhat.com</a>
<a class="moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list">https://www.redhat.com/mailman/listinfo/spacewalk-list</a></pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Jiří Dostál | Associate Software Engineer
Red Hat Satellite
</pre>
</body>
</html>