This is a multi-part message in MIME format.
------_=_NextPart_001_01C8E18A.3DB4AEC0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Hi,
This is Selva from India=2E
Actually my application is using the postgres 7=2E2=2E4 as backend=2E
Around 8 client consoles will be connecting and making the transactions
to one of the tables in the database=2E
We started all 8 machines and made automatic transactions for every one
minute from all the machines to the database=2E
Machines were running without any problem for 2 days (without shutting
down the machines)=2E
After 2 days 6 of the machines were hung since they were not able to
establish a connection with the table=2E
At the point of time, number of records in the table is 35000=2E (Vac***
is not happening)
But other 2 machines are working fine=2E
Errors are as below:
Mac 1: At 6:51:15 - ERROR: cannot open pg_class_oid_index: Permission
denied
Mac 2: At 6:51:45 - ERROR: cannot open pg_class_oid_index: Permission
denied
Mac 3: At 6:53:54 - FATAL 1: cannot open pg_attribute: Permission
denied
Max connections configured in the database is 60
Shared buffer 256
Our application will use around 2 connections each machine=2E Plus 1
connection will be opened and closed for every transaction=2E
Please let me know what exactly is the problem and how it can be solved=2E
Thanks in advance,
Selva
DISCLAIMER:
---------------------------------------------------------------------------=
--------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and=
intended for the named recipient(s) only=2E
It shall not attach any liability on the originator or HCL or its=
affiliates=2E Any views or opinions presented in=20
this email are solely those of the author and may not necessarily reflect=
the opinions of HCL or its affiliates=2E
Any form of reproduction, dissemination, copying, disclosure,
modification,=
distribution and / or publication of=20
this message without the prior written consent of the author of this
e-mail=
is strictly prohibited=2E If you have
received this email in error please delete it and notify the sender=
immediately=2E Before opening any mail and=20
attachments please check them for viruses and defect=2E
---------------------------------------------------------------------------=
--------------------------------------------
------_=_NextPart_001_01C8E18A.3DB4AEC0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=
=3D"urn:schemas-microsoft-com:office:word" xmlns:st1=
=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://www=2Ew3=
=2Eorg/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"country-region"/>
<o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@[EMAIL PROTECTED]
"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@[EMAIL PROTECTED]
4 6 4 5 5 5 2 3 4;}
@[EMAIL PROTECTED]
"MS UI Gothic";
panose-1:2 11 6 0 7 2 5 8 2 4;}
@[EMAIL PROTECTED]
"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@[EMAIL PROTECTED]
"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@[EMAIL PROTECTED]
"\@[EMAIL PROTECTED]
UI Gothic";
panose-1:2 11 6 0 7 2 5 8 2 4;}
/* Style Definitions */
p=2EMsoNormal, li=2EMsoNormal, div=2EMsoNormal
{margin:0mm;
margin-bottom:=2E0001pt;
text-align:justify;
text-justify:inter-ideograph;
font-size:10=2E5pt;
font-family:Century;}
a:link, span=2EMsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span=2EMsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span=2EEmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:windowtext;}
span=2EEmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@[EMAIL PROTECTED]
Section1
{size:595=2E3pt 841=2E9pt;
margin:99=2E25pt 30=2E0mm 30=2E0mm 30=2E0mm;
layout-grid:18=2E0pt;}
div=2ESection1
{page:Section1;}
-->
</style>
</head>
<body lang=3DJA link=3Dblue vlink=3Dpurple style=
=3D'text-justify-trim:punctuation'>
<div class=3DSection1 style=3D'layout-grid:18=2E0pt'>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>This is Selva from <st1:place w:st=
=3D"on"><st1:country-region
w:st=3D"on">India</st1:country-region></st1:place>=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Actually my application is using the postgres
7=
=2E2=2E4
as backend=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Around 8 client consoles will be connecting
and
making the transactions to one of the tables in the database=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>We started all 8 machines and made automatic
transactions for every one minute from all the machines to the database=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Machines were running without any problem for
2=
days
(without shutting down the machines)=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>After 2 days 6 of the machines were hung
since=
they
were not able to establish a connection with the table=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>At the point of time, number of records in
the=
table
is 35000=2E (Vac*** is not happening)<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>But other 2 machines are working fine=
=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Errors are as=
below:<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Mac 1: At 6:51:15 - </span></font><font size=
=3D1
face=3D"MS UI Gothic"><span lang=3DEN-US style=3D'font-size:9=
=2E0pt;font-family:"MS UI Gothic"'>ERROR:
cannot open pg_class_oid_index: Permission=
denied<o:p></o:p></span></font></p>
<p class=3DMsoNormal align=3Dleft style=
=3D'text-align:left;text-autospace:none'><font
size=3D2 face=3DArial><span lang=3DEN-US style=3D'font-size:10=
=2E0pt;font-family:Arial'>Mac
2: At 6:51:45 – </span></font><font size=3D1 face=3D"MS UI=
Gothic"><span
lang=3DEN-US style=3D'font-size:9=2E0pt;font-family:"MS UI=
Gothic"'>ERROR:
cannot open pg_class_oid_index: Permission=
denied<o:p></o:p></span></font></p>
<p class=3DMsoNormal align=3Dleft style=
=3D'text-align:left;text-autospace:none'><font
size=3D2 face=3DArial><span lang=3DEN-US style=3D'font-size:10=
=2E0pt;font-family:Arial'>Mac
3: At 6:53:54 - </span></font><font size=3D1 face=3D"MS UI Gothic"><span
lang=3DEN-US style=3D'font-size:9=2E0pt;font-family:"MS UI Gothic"'>FATAL=
1:
cannot open pg_attribute: Permission denied<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Max connections configured in the database is=
60<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Shared buffer 256<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Our application will use around 2 connections=
each
machine=2E Plus 1 connection will be opened and closed for every=
transaction=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Please let me know what exactly is the
problem=
and
how it can be solved=2E<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Thanks in
advance,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US style=
=3D'font-size:
10=2E0pt;font-family:Arial'>Selva<o:p></o:p></span></font></p>
</div>
</body>
</html>
<table><tr><td bgcolor=3D#ffffff><font color=3D#000000>DISCLAIMER:<br>
---------------------------------------------------------------------------=
--------------------------------------------<br>
<br>
The contents of this e-mail and any attachment(s) are confidential and=
intended for the named recipient(s) only=2E<br>
It shall not attach any liability on the originator or HCL or its=
affiliates=2E Any views or opinions presented in <br>
this email are solely those of the author and may not necessarily reflect=
the opinions of HCL or its affiliates=2E<br>
Any form of reproduction, dissemination, copying, disclosure,
modification,=
distribution and / or publication of <br>
this message without the prior written consent of the author of this
e-mail=
is strictly prohibited=2E If you have<br>
received this email in error please delete it and notify the sender=
immediately=2E Before opening any mail and <br>
attachments please check them for viruses and defect=2E<br>
<br>
---------------------------------------------------------------------------=
--------------------------------------------<br>
</font></td></tr></table>
------_=_NextPart_001_01C8E18A.3DB4AEC0--
|
