PANIC: read of clog file 3165, offset 0 failed: Success

--_000_D78A8169F9436B4DB978300336168F3B3359AFE6C2SWBREXCH00u cs_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Please assist, I am getting the following error when trying to vacuum analy=
ze the database(database name db0532). It's PostgreSQL_7.3.4 running on Cen=
tOS5

db0532=3D# vacuum analyze;
PANIC: read of clog file 3165, offset 0 failed: Success
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.

Confidentiality Notice:http://ucs.co.za/conf.html

________________________________
The contents of and attachments to this e-mail are intended for the address=
ee only, and may contain the confidential information of UCS Group and/or i=
ts subsidiaries. Any review, use or dissemination thereof by anyone other t=
han the intended addressee is prohibited. If you are not the intended addre=
ssee please notify the writer immediately and destroy the e-mail. UCS Group=
Limited and its subsidiaries distance themselves from and accept no liabil=
ity for unauthorised use of their e-mail facilities or e-mails sent other t=
han strictly for business purposes.

--_000_D78A8169F9436B4DB978300336168F3B3359AFE6C2SWBREXCH00u cs_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" xmlns:p=3D"urn:schemas-m=
icrosoft-com:office:powerpoint" xmlns:a=3D"urn:schemas-microsoft-com:office=
:access" xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s=3D"=
uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs=3D"urn:schemas-microsof=
t-com:rowset" xmlns:z=3D"#RowsetSchema" xmlns:b=3D"urn:schemas-microsoft-co=
m:office:publisher" xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadshee=
t" xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" xmlns=
:odc=3D"urn:schemas-microsoft-com:office:odc" xmlns:oa=3D"urn:schemas-micro=
soft-com:office:activation" xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc=3D"http://m=
icrosoft.com/officenet/conferencing" xmlns:D=3D"DAV:" xmlns:Repl=3D"http://=
schemas.microsoft.com/repl/" xmlns:mt=3D"http://schemas.microsoft.com/share=
point/soap/meetings/" xmlns:x2=3D"http://schemas.microsoft.com/office/excel=
/2003/xml" xmlns:ppda=3D"http://www.passport.com/NameSpace.xsd" xmlns:ois=
=3D"http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir=3D"http://=
schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds=3D"http://www.w3=
..org/2000/09/xmldsig#" xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint=
/dsp" xmlns:udc=3D"http://schemas.microsoft.com/data/udc" xmlns:xsd=3D"http=
://www.w3.org/2001/XMLSchema" xmlns:sub=3D"http://schemas.microsoft.com/sha=
repoint/soap/2002/1/alerts/" xmlns:ec=3D"http://www.w3.org/2001/04/xmlenc#"=
xmlns:sp=3D"http://schemas.microsoft.com/sharepoint/" xmlns:sps=3D"http://=
schemas.microsoft.com/sharepoint/soap/" xmlns:xsi=3D"http://www.w3.org/2001=
/XMLSchema-instance" xmlns:udcs=3D"http://schemas.microsoft.com/data/udc/so=
ap" xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " xmlns:udc=
p2p=3D"http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf=3D"http:/=
/schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss=3D"http://sche=
mas.microsoft.com/office/2006/digsig-setup" xmlns:dssi=3D"http://schemas.mi=
crosoft.com/office/2006/digsig" xmlns:mdssi=3D"http://schemas.openxmlformat=
s.org/package/2006/digital-signature" xmlns:mver=3D"http://schemas.openxmlf=
ormats.org/markup-compatibility/2006" xmlns:m=3D"http://schemas.microsoft.c=
om/office/2004/12/omml" xmlns:mrels=3D"http://schemas.openxmlformats.org/pa=
ckage/2006/relationships" xmlns:spwp=3D"http://microsoft.com/sharepoint/web=
partpages" xmlns:ex12t=3D"http://schemas.microsoft.com/exchange/service s/20=
06/types" xmlns:ex12m=3D"http://schemas.microsoft.com/exchange/service s/200=
6/messages" xmlns:pptsl=3D"http://schemas.microsoft.com/sharepoint/soap/ Sli=
deLibrary/" xmlns:spsl=3D"http://microsoft.com/webservices/SharePointPor tal=
Server/PublishedLinksService" xmlns:Z=3D"urn:schemas-microsoft-com:" xmlns:=
st=3D"" xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 12 (filtered medium)">
<style>

</style>
</head>
<body lang=3D"EN-US" link=3D"blue" vlink=3D"purple">
<div class=3D"Section1">
Please assist, I am getting the following error when=
trying to vacuum analyze the database(database name db0532). It’s Po=
stgreSQL_7.3.4 running on CentOS5<o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
db0532=3D# vacuum analyze;<o:p></o:p>
PANIC: read of cl=
og file 3165, offset 0 failed: Success<o:p></o:p>
server closed the connection unexpectedly<o:p></o:p>=

 This prob=
ably means the server terminated abnormally<o:p></o:p>
 before or=
while processing the request.<o:p></o:p>
The connection to the server was lost. Attempting re=
set: Failed.<o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
 <o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
<o:p> </o:p>
Confidentiality Notice:<a href=
=3D"http://ucs.co.za/conf.html">http://ucs.co.za=
/conf.html</a><o:p></o:p>
<o:p> </o:p>
<o:p> </o:p>
</div>
 
<hr>
The contents of and attachme=
nts to this e-mail are intended for the addressee only, and may contain the=
confidential information of UCS Group and/or its subsidiaries. Any review,=
use or dissemination thereof by anyone
other than the intended addressee is prohibited. If you are not the intend=
ed addressee please notify the writer immediately and destroy the e-mail. U=
CS Group Limited and its subsidiaries distance themselves from and accept n=
o liability for unauthorised use
of their e-mail facilities or e-mails sent other than strictly for busines=
s purposes. 

</body>
</html>

--_000_D78A8169F9436B4DB978300336168F3B3359AFE6C2SWBREXCH00u cs_--

Khangelani Gama [ Mo, 19 April 2010 09:17 ] [ ID #2039361 ]

Re: PANIC: read of clog file 3165, offset 0 failed: Success

I am not a member of the Postgres team and so I don't have any special
knowledge, but I can tell you two things for sure:

1) Version 7.3.4 is not supported any more, see:
http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_P olicy

You should arrange to upgrade to a supported version as soon as
possible. Preferably to 8.4, but you would need to study the release
notes of each of the major releases in-between and see what
compatibility issues you would need to face. In particular, there was a
change in 8.3 regarding type-casting behavior that might require a
significant re-write of your applications.

2) The Postgres experts will need more information about your situation
in order to give you advice. For one thing, they will want to see the
contents of your $PGDATA/pg_clog directory. Issue the command "ls -l"
in that directory and capture the output.

Also, is it possible you are running out of disk space? Have there been
any other errors recently? Check your operating system logs.

Thank you,

Lewis Kapell
Computer Operations
Seton Home Study School

On 4/19/2010 3:17 AM, Khangelani Gama wrote:
> Please assist, I am getting the following error when trying to vacuum
> analyze the database(database name db0532). It=92s PostgreSQL_7.3.4
> running on CentOS5
>
> db0532=3D# vacuum analyze;
>
> *PANIC: read of clog file 3165, offset 0 failed: Success*
>
> server closed the connection unexpectedly
>
> This probably means the server terminated abnormally
>
> before or while processing the request.
>
> The connection to the server was lost. Attempting reset: Failed.
>
> * *
>
> Confidentiality Notice:http://ucs.co.za/conf.html
>
>
> ------------------------------------------------------------ -----------=
-
> The contents of and attachments to this e-mail are intended for the
> addressee only, and may contain the confidential information of UCS
> Group and/or its subsidiaries. Any review, use or dissemination thereof
> by anyone other than the intended addressee is prohibited. If you are
> not the intended addressee please notify the writer immediately and
> destroy the e-mail. UCS Group Limited and its subsidiaries distance
> themselves from and accept no liability for unauthorised use of their
> e-mail facilities or e-mails sent other than strictly for business purp=
oses.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Lewis Kapell [ Mo, 19 April 2010 16:06 ] [ ID #2039366 ]

Re: PANIC: read of clog file 3165, offset 0 failed:Success

Lewis Kapell wrote:
> I am not a member of the Postgres team and so I don't have any
> special knowledge, but I can tell you two things for sure:
>
> 1) Version 7.3.4 is not supported any more, see:
> http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_P olicy
>
> You should arrange to upgrade to a supported version as soon as
> possible.

Yeah, at least update to 7.3.21 which is not supported but has quite a
few bugs fixed -- and I think this misleading error message was fixed in
one of them.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Alvaro Herrera [ Mo, 19 April 2010 16:47 ] [ ID #2039368 ]