Re: server auto-restarts and ipcs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: server auto-restarts and ipcs
Date: 2004-11-09 01:16:15
Message-ID: 13012.1099962975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

"Ed L." <pgsql(at)bluepolka(dot)net> writes:
> A power failure led to failed postmaster restart using 7.4.6 (see output
> below). The short-term fix is usually to delete the pid file and restart.

> I often wonder why ipcs never seems to show the shared memory
> block in question?

The shared memory block would certainly not still exist after a system
reboot, so what we have here is a misleading error message. Looking at
the code, the most plausible explanation appears to be that
shmctl(IPC_STAT) is failing (which it ought to) and returning some errno
code different from EINVAL (which is the case we are expecting to see).
What platform are you on, and what does its shmctl(2) man page document
as error conditions?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2004-11-09 01:44:17 Re: Newbie Question, how to grant permissions on all tables in schema/db
Previous Message Kenji Morishige 2004-11-09 01:00:49 Newbie Question, how to grant permissions on all tables in schema/db

Browse pgsql-hackers by date

  From Date Subject
Next Message Eric B.Ridge 2004-11-09 02:09:38 Re: unnest
Previous Message Oliver Jowett 2004-11-09 01:02:13 Re: Increasing the length of pg_stat_activity.current_query...