Обсуждение: postgreslog - panic message

surabhi.ahuja wrote:
> hi,
> i am getting the following error messages:
>
> <2006-05-24 15:28:08 CDT%>LOG:  could not bind IPv4 socket: Address already in use
> <2006-05-24 15:28:08 CDT%>HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds and
retry.
> <2006-05-24 15:28:08 CDT%>WARNING:  could not create listen socket for "localhost"
> <2006-05-24 15:28:08 CDT%>LOG:  database system was shut down at 2006-05-24 15:28:08 CDT

This is what it says. You've either got:
1. another version of PostgreSQL running on port 5432
2. Something else on port 5432
3. The operating-system hasn't recycled the port after a shutdown (it
can take a few seconds sometimes).

I assume it started up after this?

> <2006-05-24 16:19:39 CDT%>PANIC:  could not locate a valid checkpoint record
> <2006-05-24 16:19:39 CDT%>LOG:  startup process (PID 6548) was terminated by signal 6
> <2006-05-24 16:19:39 CDT%>LOG:  aborting startup due to startup process failure
> <2006-05-24 16:21:28 CDT%>LOG:  database system was shut down at 2006-05-24 16:01:00 CDT
> <2006-05-24 16:21:28 CDT%>LOG:  record with zero length at 0/AC92BC
> <2006-05-24 16:21:28 CDT%>LOG:  invalid primary checkpoint record
> <2006-05-24 16:21:28 CDT%>LOG:  record with zero length at 0/AC9280
> <2006-05-24 16:21:28 CDT%>LOG:  invalid secondary checkpoint record
> <2006-05-24 16:21:28 CDT%>PANIC:  could not locate a valid checkpoint record
> <2006-05-24 16:21:28 CDT%>LOG:  startup process (PID 8428) was terminated by signal 6
>
> i am using postgres 8.0.0

You should be running the latest release of 8.0.8 - there are 8 sets of
bug-fixes between your version and the latest.

> please tell as to what might be going wrong.

Either the WAL has been corrupted (have you had a crash? Are your disks
reliable?), PG is reading the wrong file (unlikely) or you've hit a bug
in 8.0.0. Read the release notes for 8.0 and see if any of the changes
could affect you.

http://www.postgresql.org/docs/8.0/static/release.html

--
   Richard Huxton
   Archonet Ltd

On May 25 11:04, Richard Huxton wrote:
> surabhi.ahuja wrote:
> >hi,
> >i am getting the following error messages:
> >
> ><2006-05-24 15:28:08 CDT%>LOG:  could not bind IPv4 socket: Address
> >already in use
> ><2006-05-24 15:28:08 CDT%>HINT:  Is another postmaster already running on
> >port 5432? If not, wait a few seconds and retry.
> ><2006-05-24 15:28:08 CDT%>WARNING:  could not create listen socket for
> >"localhost"
> ><2006-05-24 15:28:08 CDT%>LOG:  database system was shut down at
> >2006-05-24 15:28:08 CDT
>
> This is what it says. You've either got:
> 1. another version of PostgreSQL running on port 5432
> 2. Something else on port 5432
> 3. The operating-system hasn't recycled the port after a shutdown (it
> can take a few seconds sometimes).

Just for curiosity, shouldn't SO_REUSEADDR (in
backend/libpq/pqcomm.c:342) handle the 3rd possibility in the above
list? Or isn't this behaviour guaranteed by SO_REUSEADDR on every
platform?


Regards.

"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in> writes:
> <2006-05-24 16:21:28 CDT%>LOG:  database system was shut down at =
> 2006-05-24 16:01:00 CDT
> <2006-05-24 16:21:28 CDT%>LOG:  record with zero length at 0/AC92BC
> <2006-05-24 16:21:28 CDT%>LOG:  invalid primary checkpoint record
> <2006-05-24 16:21:28 CDT%>LOG:  record with zero length at 0/AC9280
> <2006-05-24 16:21:28 CDT%>LOG:  invalid secondary checkpoint record
> <2006-05-24 16:21:28 CDT%>PANIC:  could not locate a valid checkpoint =
> record
> <2006-05-24 16:21:28 CDT%>LOG:  startup process (PID 8428) was =
> terminated by signal 6

Hm, those are remarkably small values of the checkpoint record pointers;
roughly what you'd see immediately after initdb.  What's the history of
this installation?  If it's not freshly initdb'd, the only thing I can
think is that somebody has restored an old version of pg_control into
the directory tree.  Which would be a pretty bad move, but maybe you can
recover with pg_resetxlog.

            regards, tom lane

surabhi.ahuja wrote:
> where can i download the rpms for the PostgreSQL version 8.0.8
> till now we have been using 8.0.0.
>
> thanks,
> regards
> Surabhi
>

you can from here :

http://www.postgresql.org/ftp/binary/v8.0.8/linux/

leonel