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

[Tommaso Rossetto]

Ok many thanks for your help

bye

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

>  On 07/29/2009 03:11 AM, Tommaso Rossetto wrote:
>
> 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
>
>
> No that just means the nightly builds perhaps dint pick up the change. I'll
> rebuild newer versions today and lets see if those work.
>
> ~ Prad
>
>
>
>
> 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)
>
> ------------------------------
>
> _______________________________________________
> 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/9df7f9ab/attachment.htm>