<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
If you have properly configured repositories on your Spacewalk
machine and Spacewalk 2.8 repo enabled, just run "yum update
spacewalk-schema".<br>
<br>
In the package there's a fix I did so you just need to restore the
database like you did previously and re-run the upgrade.<br>
<br>
Tomáš<br>
<br>
<div class="moz-cite-prefix">On 05/23/2018 05:02 PM, Guy Matz wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CABnTgtWbf+c1mzdX9gyRFwC+AiMhhY0qEzq+somVMbUO7aLy3A@mail.gmail.com">
<div dir="ltr">
<div>
<div>Great! Does that resolve my issue? Or will Tomáš's work
resolve it?<br>
<br>
</div>
Where can I retrieve spacewalk-schema-2.8.25-1?<br>
<br>
</div>
Thank you!<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Wed, May 23, 2018 at 7:32 AM, Jiří
Dostál <span dir="ltr"><<a
href="mailto:jdostal@redhat.com" target="_blank"
moz-do-not-send="true">jdostal@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> 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="m_-6140049503046885176moz-cite-prefix">Dne
23.5.2018 v 10:03 Tomáš Kašpárek napsal(a):<br>
</div>
<div>
<div class="h5">
<blockquote type="cite"> 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/sh<wbr>ow_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="m_-6140049503046885176moz-cite-prefix">On
05/22/2018 11:23 PM, Guy Matz wrote:<br>
</div>
<blockquote type="cite">
<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-<wbr>upgrade/20180522-130306-to-<wbr>spacewalk-schema-2.8.log<br>
UPDATE 1<br>
COMMIT<br>
<wbr>
?column?<br>
------------------------------<wbr>------------------------------<wbr>------------------------------<wbr>-----<br>
spacewalk-schema-2.7-to-<wbr>spacewalk-schema-2.8/001-<wbr>rhnpackageevr-rhn_pe_v_r_e_uq.<wbr>sql.postgresql<br>
(1 row)<br>
<br>
CREATE FUNCTION<br>
DROP TRIGGER<br>
psql:/var/log/spacewalk/<wbr>schema-upgrade/20180522-<wbr>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"
target="_blank" moz-do-not-send="true">nevra_orig.id</a>
where nevra_id = <a
href="http://nevra_dup.id" target="_blank"
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/sh<wbr>ow_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="m_-6140049503046885176h5"><br>
<br>
<div
class="m_-6140049503046885176m_928613561772718680moz-cite-prefix">On
05/21/2018 10:37 PM, Guy Matz wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div class="m_-6140049503046885176h5">
<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-upgr<wbr>ade:<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/sh<wbr>ow_bug.cgi?id=1576002</a><br>
<br>
</div>
But now I get:<br>
#
/usr/bin/spacewalk-schema-upgr<wbr>ade<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_-6140049503046885176m_928613561772718680mimeAttachmentHeader"></fieldset>
<br>
</div>
</div>
<pre>______________________________<wbr>_________________
Spacewalk-list mailing list
<a class="m_-6140049503046885176m_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_-6140049503046885176m_928613561772718680moz-txt-link-freetext" href="https://www.redhat.com/mailman/listinfo/spacewalk-list" target="_blank" moz-do-not-send="true">https://www.redhat.com/mailman<wbr>/listinfo/spacewalk-list</a></pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
<br>
<fieldset
class="m_-6140049503046885176mimeAttachmentHeader"></fieldset>
<br>
<pre>______________________________<wbr>_________________
Spacewalk-list mailing list
<a class="m_-6140049503046885176moz-txt-link-abbreviated" href="mailto:Spacewalk-list@redhat.com" target="_blank" moz-do-not-send="true">Spacewalk-list@redhat.com</a>
<a class="m_-6140049503046885176moz-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>
</div>
<span class="HOEnZb"><font color="#888888">
<pre class="m_-6140049503046885176moz-signature" cols="72">--
Jiří Dostál | Associate Software Engineer
Red Hat Satellite
</pre>
</font></span></div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</body>
</html>