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

[Edwind Richzendy Contreras Soto]

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
>