[Spacewalk-list] internal server error 500 when trying to upload packages.

[puck at i29.net]

It looks like Oracle probably died. I recommend you reboot the whole 
system to make sure Oracle stops and starts fully (the oracle-xe service 
doesn't always work correctly for me) and then run the Oracle bugfixes 
at the end of the Oracle Setup page:

sqlplus spacewalk/spacewalk at xe
 > alter system set processes = 400 scope=spfile;
 > alter system set "_optimizer_filter_pred_pullup"=false scope=spfile;
 > alter system set "_optimizer_cost_based_transformation"=off scope=spfile;
 > commit;

That should prevent the Oracle crash from happening again.

Jem Tallon


Gerhardus.Geldenhuis at gta-travel.com wrote:
> Hi 
> I get the following error when trying to upload my Centos package
> directory:
>
> Waiting 5 seconds and trying again...
> Internal server error 500 Internal Server Error
> Error pushing
> /mnt/nfs/os/x86_64/centos/5/Update/CentOS/fonts-KOI8-R-1.0-9.1.1.noarch.
> rpm: Error 500 (500)
> Waiting 3 seconds and trying again...
>
>
> >From the /var/log/rhn/rhn_upload_package_push.log
> 2008/10/20 16:27:04 +01:00 5103 127.0.0.1:
> rhnSQL/int_oracle.connect('Connecting to database', 'xe')
> 2008/10/20 16:27:04 +01:00 5103 127.0.0.1:
> package_push/package_push.headerParserHandler('Username', None, 'Force',
> 0)
> 2008/10/20 16:27:05 +01:00 5086 127.0.0.1:
> rhnSQL/int_oracle.check_connection('ERROR', "DATABASE CONNECTION TO 'xe'
> LOST", "Exception information: 'NoneType' object has no attribute
> 'cursor'")
> 2008/10/20 16:27:05 +01:00 5086 127.0.0.1:
> rhnSQL/int_oracle.connect('Connecting to database', 'xe')
> 2008/10/20 16:27:05 +01:00 5086 127.0.0.1:
> package_push/package_push.headerParserHandler('Username', None, 'Force',
> 0)
> 2008/10/20 16:27:06 +01:00 5120 127.0.0.1:
> rhnSQL/int_oracle.connect('Connecting to database', 'xe')
> 2008/10/20 16:27:06 +01:00 5120 127.0.0.1:
> package_push/package_push.headerParserHandler('Username', None, 'Force',
> 0)
> 2008/10/20 16:27:06 +01:00 5100 127.0.0.1:
> rhnSQL/int_oracle.check_connection('ERROR', "DATABASE CONNECTION TO 'xe'
> LOST", "Exception information: 'NoneType' object has no attribute
> 'cursor'")
> 2008/10/20 16:27:06 +01:00 5100 127.0.0.1:
> rhnSQL/int_oracle.connect('Connecting to database', 'xe')
> 2008/10/20 16:27:06 +01:00 5100 127.0.0.1:
> package_push/package_push.headerParserHandler('Username', None, 'Force',
> 0)
>
> Is there anywhere else I can look for errors? I am not sure what this
> errors mean/implies.
>
> I can connect to the database fine using sqlplus.
>
> Regards
>
> ______________________________________________________________________
> This email has been scanned by the MessageLabs Email Security System.
> For more information please visit http://www.messagelabs.com/email 
> ______________________________________________________________________
>
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20081020/05966dca/attachment.htm>