I am actually working for universal fix as the fix in the
https://bugzilla.redhat.com/show_bug.cgi?id=1576002
<https://bugzilla.redhat.com/show_bug.cgi?id=1576002> was targeting one
specific database and data there.
Hopefully I'll finish with this this week.
Tomas
On 05/22/2018 11:23 PM, Guy Matz wrote:
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 <http://nevra_orig.id> where nevra_id = nevra_dup.id
<http://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 <[email protected]
<mailto:[email protected]>> wrote:
Hello,
have you restored the database from backup after you've applied
patch from https://bugzilla.redhat.com/show_bug.cgi?id=1576002
<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
<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 list
[email protected] <mailto:[email protected]>
https://www.redhat.com/mailman/listinfo/spacewalk-list
<https://www.redhat.com/mailman/listinfo/spacewalk-list>
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
