 | | | RHEL3 system hanging | RHEL3 system hanging 2006-11-03 - By Yi Liu
Back
I am running postgresql database server for a mailing list server. Just one
week ago, I added a 200G SATA disk and 2G more memory to the system. The
original system has 120G SATA disk and 2G memory. I only have one Pentinum 4
CPU in the box. Even after applying the latest kernel 2.4.21-47.0.1.EL, I
already have two times of system hanging since last Saturday. Note that I am
still using the initial 2GB swap space.
I actually checked the message and cron log files under /var/log for what
happened. The system hanging appears to happen sometime after the postgresql
database server tried to create a bunch of temporary tables using some
implicit index. I am not sure it needs to use a lot of space. I also found
that I have the same message notice before, but I did not have the system
hanging issue.
Is there any idea how to fix this issue? Though the latest RHEL 3 security
advisory mentioned one flaw directly related to this issue, I assumed it's
been taken care by the latest update and I am running a single cpu version.
Thanks,
Yi
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas
-microsoft-com:office:word" 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 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@(protected)
{font-family:SimSun;
panose-1 (See http://ose-1.ora-code.com):2 1 6 0 3 1 1 1 1 1;}
@(protected)
{font-family:"\@(protected)";
panose-1 (See http://ose-1.ora-code.com):2 1 6 0 3 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@(protected) Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I am running postgresql database server for a mailing list server. Just
one week ago, I added a 200G SATA disk and 2G more memory to the system. The
original system has 120G SATA disk and 2G memory. I only have one Pentinum 4
CPU in the box. Even after applying the latest kernel 2.4.21-47.0.1.EL, I
already have two times of system hanging since last Saturday. Note that I am
still using the initial 2GB swap space.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I actually checked the message and cron log files under /var/log for
what happened. The system hanging appears to happen sometime after the
postgresql database server tried to create a bunch of temporary tables using
some implicit index. I am not sure it needs to use a lot of space. I also found
that I have the same message notice before, but I did not have the system
hanging issue.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Is there any idea how to fix this issue? Though the latest RHEL 3
security advisory mentioned one flaw directly related to this issue, I assumed
it’s been taken care by the latest update and I am running a single cpu
version.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Yi<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
</body>
</html>
--
Taroon-list mailing list
Taroon-list@(protected)
https://www.redhat.com/mailman/listinfo/taroon-list
|
|
|