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

[Tommaso Rossetto]

Sorry Edwind but i receive the same error...  [?]

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.



2009/7/24 Edwind Richzendy Contreras Soto <richzendy at gmail.com>

> 2009/7/25 Tommaso Rossetto <tommaso.rossetto at gmail.com>:
> > Hi all,
> >
> > when I launch rhnpush I get this error message :
> >
> > Using POST request
> > 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 1 seconds and trying again...
> > Uploading package base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm
> > Using POST request
> > 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 4 seconds and trying again...
> > Uploading package base/CentOS/setroubleshoot-2.0.5-3.el5.noarch.rpm
> > Using POST request
> > 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...
> >
> >
> > and this in the final :
> >
> >
> > 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
> >
> >
> > Could someone help me to resolve it please?
> > There is something wrong in my oracle settings?
> >
> > many thanks.
> >
>
>
> login in oracle using sqlplus, set max conections to 400, use this
> commands:
>
> # sqlplus spacewalk at xe
>
> SQL> alter system set processes = 400 scope=spfile;
> SQL> alter system set "_optimizer_filter_pred_pullup" = false scope=spfile;
> SQL> alter system set "_optimizer_cost_based_transformation" = off
> scope=spfile;
> SQL> alter system set query_rewrite_enabled = true;
> SQL> quit
>
> and restart oracle:
>
> # /sbin/service oracle-xe restart
>
> >
> > _______________________________________________
> > Spacewalk-list mailing list
> > Spacewalk-list at redhat.com
> > https://www.redhat.com/mailman/listinfo/spacewalk-list
> >
>
> _______________________________________________
> 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/20090724/07157eba/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 344.gif
Type: image/gif
Size: 352 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20090724/07157eba/attachment.gif>