[Spacewalk-list] Problem with RHNPUSH (ORACLE ???)

[Tommaso Rossetto]

Ok Prad,

I have upgrade it to the latest nightly build but it still not works

When I try rhnpush I get this message :

Connecting to http://localhost/APP
Internal Server Error

I have already try restarting rhn-satellite service...
I must launch again the spacewalk-setup procedure ??

thanks


2009/7/27 Pradeep Kilambi <pkilambi at redhat.com>

>  On 07/27/2009 10:59 AM, Tommaso Rossetto wrote:
>
> Ok thanks David,
>
> the first error has gone but the second not....
> For your info I was able to set only at 4000 RHNPACKAGECHANGELOG "TEXT"
> column value (5000 oracle say isn't possible) but I think this is
> sufficient..
>
> Now remains to understand why the second error persists...
>
> Have you some other idea? What can I do?
>
>
> The second error should be resolved as part of commit
> 88e29677361c7051475f4e53a796b5182119bc54 . I  think the latest
> spacewalk-backend nightly should have this fix.
>
> ~ Prad
>
>
>
>
>
>
> 2009/7/24 David Nutter <davidn at bioss.sari.ac.uk>
>
>> On Fri, Jul 24, 2009 at 10:01:30AM +0200, Tommaso Rossetto wrote:
>> > *Hi all,
>> >
>> > when I launch rhnpush I get this error message :*
>>
>> *snip*
>>
>> > Error pushing base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm: Error
>> > 500Error Message:
>> >     ORA-12899: value too large for column
>> > "SPACEWALK"."RHNPACKAGECHANGELOG"."TEXT" (actual: 3002, maximum: 3000)
>> > Error Class Code: 54
>> > Error Class Info:
>> >      Package Upload Failed due to uniqueness constraint violation.
>> >      Make sure the package does not have any duplicate dependencies or
>> >      does not already exists on the server (500)
>> > Waiting 2 seconds and trying again...
>>
>>
>>  The above should be easy to fix - just increase the size of the column
>> "TEXT" in table RHNPACKAGECHANGELOG. Offhand, and
>> untested, this will probably be a command like:
>>
>> ALTER TABLE RHNPACKAGECHANGELOG MODIFY (TEXT VARCHAR2(5000));
>>
>> My knowledge of oracle is minimal so the above command may be wrong. Even
>> if
>> it succeeds it may have bad effects so use at your own risk.
>>
>> > Error Message:
>> >     ORA-00001: unique constraint (SPACEWALK.RHN_CNP_CID_NID_UQ) violated
>> > ORA-06512: at "SPACEWALK.RHN_CHANNEL", line 916
>> > ORA-06512: at line 1
>> > Error Class Code: 23
>> > Error Class Info: Could not update database entry.
>> >
>> > xargs: rhnpush: exited with status 255; aborting
>>
>>  Here follows some wild speculation:
>>
>> I think that constraint ensures that package IDs are unique on the
>> spacewalk server. Possibly the previous error is leaving some kind of
>> uncompleted upload which is causing the constraint to be violated but
>> once the push session ends the failed uploads have their transactions
>> rolled back leaving no visible evidence such as a half uploaded
>> package visible on the spacewalk website.
>>
>> Consequently if you fix the first error, the second may go away too.
>>
>> End of wild speculation.
>>
>> Regards,
>>
>> --
>> David Nutter                            Tel: +44 (0)131 650 4888
>> BioSS, JCMB, King's Buildings, Mayfield Rd, EH9 3JZ. Scotland, UK
>>
>> Biomathematics and Statistics Scotland (BioSS) is formally part of The
>> Scottish Crop Research Institute (SCRI), a registered Scottish charity
>> No. SC006662
>>
>> _______________________________________________
>> Spacewalk-list mailing list
>> Spacewalk-list at redhat.com
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>>
>
>
>
> --
> Tommaso Rossetto
> vicolo I Maggio , 13
> Maserada sul Piave - 31052 (TV)
>
> ------------------------------
>
> _______________________________________________
> Spacewalk-list mailing listSpacewalk-list at redhat.comhttps://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>
> --
> --
> Pradeep Kilambi
> RHN Satellite Engineeringpkilambi at redhat.com
> Phone: +1 919 754 4285
> RHCE # 805008680430554
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>



-- 
Tommaso Rossetto
vicolo I Maggio , 13
Maserada sul Piave - 31052 (TV)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090729/8898491f/attachment.htm>