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

[Pradeep Kilambi]

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
> 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/20090727/b022a4a1/attachment.htm>