[Spacewalk-list] Upgrade 2.7 -> 2.8: schema upgrade fails

[Tomáš Kašpárek]

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 <tkaspare at redhat.com 
> <mailto:tkaspare at 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
>     <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
>>     Spacewalk-list at redhat.com <mailto:Spacewalk-list at redhat.com>
>>     https://www.redhat.com/mailman/listinfo/spacewalk-list
>>     <https://www.redhat.com/mailman/listinfo/spacewalk-list>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20180523/bcc86dd8/attachment.htm>