[Spacewalk-list] Problem with RHNPUSH (ORACLE ???)
Pradeep Kilambi
pkilambi at redhat.com
Wed Jul 29 13:11:13 UTC 2009
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
> <mailto: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
>> <mailto: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 <mailto: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 list Spacewalk-list at redhat.com
>> <mailto:Spacewalk-list at redhat.com>
>> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
> --
> --
> Pradeep Kilambi
> RHN Satellite Engineering
> pkilambi at redhat.com <mailto:pkilambi at redhat.com>
> Phone: +1 919 754 4285
> RHCE # 805008680430554
>
>
>
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com <mailto: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 list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
--
--
Pradeep Kilambi
RHN Satellite Engineering
pkilambi at redhat.com
Phone: +1 919 754 4285
RHCE # 805008680430554
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090729/3305149c/attachment.htm>
More information about the Spacewalk-list
mailing list