Darn. Still failing with what looks to be the same error:
bash-4.2$ cat
/var/log/spacewalk/schema-upgrade/20180522-130306-to-spacewalk-schema-2.8.log
UPDATE 1
COMMIT
?column?
-----------------------------------------------------------------------------------------------
spacewalk-schema-2.7-to-spacewalk-schema-2.8/001-rhnpackageevr-rhn_pe_v_r_e_uq.sql.postgresql
(1 row)
CREATE FUNCTION
DROP TRIGGER
psql:/var/log/spacewalk/schema-upgrade/20180522-130306-script.sql:57:
ERROR: null value in column "nevra_id" violates not-null constraint
DETAIL: Failing row contains (4966, null).
CONTEXT: SQL statement "update rhnsnapshotpackage set nevra_id =
nevra_orig.id where nevra_id = nevra_dup.id"
PL/pgSQL function fix_rhn_pe_v_r_e_uq() line 28 at SQL statement
Any other ideas?
Thank you!!
On Tue, May 22, 2018 at 2:52 AM, Tomáš Kašpárek <tkasp...@redhat.com> wrote:
> Hello,
>
> have you restored the database from backup after you've applied patch from
> https://bugzilla.redhat.com/show_bug.cgi?id=1576002?
> 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.
>
> Tomas
>
>
> On 05/21/2018 10:37 PM, Guy Matz wrote:
>
> Hello! When trying to upgrade from 2.7 to 2.8, I got this error during
> /usr/bin/spacewalk-schema-upgrade:
>
> null value in column "nevra_id" violates not-null constraint
>
> I tried making the changes in the schema upgrade patch here:
> https://bugzilla.redhat.com/show_bug.cgi?id=1576002
>
> But now I get:
> # /usr/bin/spacewalk-schema-upgrade
> Unknown schema name [(0 rows)] found.
>
> Any thoughts would be greatly appreciated.
>
> Thanks,
> Guy
>
>
> _______________________________________________
> Spacewalk-list mailing
> listSpacewalk-list@redhat.comhttps://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
_______________________________________________
Spacewalk-list mailing list
Spacewalk-list@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-list
