<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-CA" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Has anyone else seen this?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I found someone else who had the exact same problem, however no one seemed to have replied to its resolution?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><a href="http://www.redhat.com/archives/spacewalk-list/2013-February/msg00068.html">http://www.redhat.com/archives/spacewalk-list/2013-February/msg00068.html</a> (Similar problem)<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Has anyone experienced a problem during the rhnpush <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Internal server error 500 Internal Server Error</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Error pushing /root/BAC/TIVsm-JBB.x86_64.rpm: (500)</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Waiting 2 seconds and trying again...</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Uploading package /root/BAC/TIVsm-JBB.x86_64.rpm</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Using POST request</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Internal server error 500 Internal Server Error</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Error pushing /root/BAC/TIVsm-JBB.x86_64.rpm: (500)</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Waiting 1 seconds and trying again...</span><span style="font-size:13.5pt;color:black"><br>
</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">Giving up after 3 attempts<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white">I checked the /var/log/rhn/rhn_upload_package_push.log<o:p></o:p></span></b></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><b>So then I check the oracle tns listener db logs, it appears the listener intermittently for spacewalk stops listening which causes the rhnpush to fail, and return a internal 500 error. I have updated the hosts file and changed the rhn.conf
to use the ip instead of the db host name to see if that help? I would like to know if anyone else has experienced this and what they did to resolute the issue?<o:p></o:p></b></p>
<p class="MsoNormal"><b><o:p> </o:p></b></p>
<p class="MsoNormal"><b>Please and tahnk you</b><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black;background:white"><o:p> </o:p></span></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">2014/12/15 20:38:22 -07:00 6407 ::1: server/apacheUploadServer.handler('GET method received, returning',)<o:p></o:p></p>
<p class="MsoNormal">2014/12/15 20:38:22 -07:00 6394 ::1: rhnSQL/driver_cx_Oracle.connect('Connecting to database', 'spacewalk@//kam100.db.com/XE')<o:p></o:p></p>
<p class="MsoNormal">2014/12/15 20:38:22 -07:00 6394 ::1: rhnSQL/driver_cx_Oracle.connect('ERROR', 'Connection attempt failed', 12516, 'ORA-12516: TNS:listener could not find available handler with matching protocol stack\n')<o:p></o:p></p>
<p class="MsoNormal">2014/12/15 20:38:22 -07:00 6394 ::1: server/apacheUploadServer._wrapper('ERROR', 'Unhandled exception')<o:p></o:p></p>
<p class="MsoNormal">2014/12/15 20:38:26 -07:00 5510 ::1: package_push/package_push.headerParserHandler('Username', None, 'Force', 0)<o:p></o:p></p>
<p class="MsoNormal"><b><o:p> </o:p></b></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">/listener/alert/log.xml<o:p></o:p></p>
<p class="MsoNormal"><msg time='2014-12-16T09:48:07.721-08:00' org_id='oracle' comp_id='tnslsnr'<o:p></o:p></p>
<p class="MsoNormal">type='UNKNOWN' level='16' host_id= kam100.db.com<o:p></o:p></p>
<p class="MsoNormal">host_addr='10.0.9.107'><o:p></o:p></p>
<p class="MsoNormal"><txt>16-DEC-2014 09:48:07 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=java)(HOST= kam100.db.com)(USER=tomcat))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.9.101)(PORT=45479)) * establish * XE * 12516<o:p></o:p></p>
<p class="MsoNormal"></txt><o:p></o:p></p>
<p class="MsoNormal"></msg><o:p></o:p></p>
<p class="MsoNormal"><msg time='2014-12-16T09:48:07.721-08:00' org_id='oracle' comp_id='tnslsnr'<o:p></o:p></p>
<p class="MsoNormal">type='UNKNOWN' level='16' host_id= kam100.db.com host_addr='10.0.9.107'><o:p></o:p></p>
<p class="MsoNormal"><txt>TNS-12516: TNS:listener could not find available handler with matching protocol stack<o:p></o:p></p>
<p class="MsoNormal"></txt><o:p></o:p></p>
<p class="MsoNormal"></msg><o:p></o:p></p>
<p class="MsoNormal"><msg time='2014-12-16T09:48:07.722-08:00' org_id='oracle' comp_id='tnslsnr'<o:p></o:p></p>
<p class="MsoNormal">type='UNKNOWN' level='16' host_id= kam100.db.com<o:p></o:p></p>
<p class="MsoNormal">host_addr='10.0.9.107'><o:p></o:p></p>
<p class="MsoNormal"><txt>16-DEC-2014 09:48:07 * (CONNECT_DATA=(SERVICE_NAME=XE)(CID=(PROGRAM=java)(HOST= kam100.db.com)(USER=tomcat))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.0.9.101)(PORT=45480)) * establish * XE * 12516<o:p></o:p></p>
<p class="MsoNormal"></txt><o:p></o:p></p>
<p class="MsoNormal"></msg><o:p></o:p></p>
<p class="MsoNormal"><msg time='2014-12-16T09:48:07.722-08:00' org_id='oracle' comp_id='tnslsnr'<o:p></o:p></p>
<p class="MsoNormal">type='UNKNOWN' level='16' host_id= kam100.db.com<o:p></o:p></p>
<p class="MsoNormal">host_addr='10.0.9.107'><o:p></o:p></p>
<p class="MsoNormal"><txt>TNS-12516: TNS:listener could not find available handler with matching protocol stack<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial","sans-serif";color:#76B900;mso-fareast-language:EN-CA">Nick Tailor<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#414B56;mso-fareast-language:EN-CA">Nicktailor.com</span><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#76B900;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<hr>
<font face="Arial" size="2">This email is intended only for the addressee. It may contain confidential or proprietary information that cannot be disclosed without BCLC's permission. If you have received this email in error, please notify the sender immediately
and delete the email.</font>
</body>
</html>