Re: postgresql error

From: Vasiliy G Tolstov <v(dot)tolstov(at)selfip(dot)ru>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql error
Date: 2009-09-28 11:15:42
Message-ID: 1254136542.23564.8.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

В Пнд, 28/09/2009 в 13:11 +0200, Martijn van Oosterhout пишет:
> On Mon, Sep 28, 2009 at 02:33:36PM +0400, Vasiliy G Tolstov wrote:
> > Hello!
> >
> > I'm using postgresql (8.0.15) on Gentoo Linux (2.6.27.29-titan #2 SMP
> > Sun Aug 16 15:12:53 MSD 2009 x86_64 Intel(R) Xeon(R) CPU E5420 @ 2.50GHz
> > GenuineIntel GNU/Linux)
> >
> > some time (meybe every four day) postgresql get error to all clients
> > what try to connect , a can attach strace to it:
>
> 1. What error?
> 2. What do the logfiles say?
>
> Have a nice day,

postgres(at)calipso ~ $ psql
psql: FATAL: semctl(1048608, 15, SETVAL, 0) failed: Invalid argument

I can't see errors in log-files.

Daemon was started by gentoo init script:

start() {
checkconfig || return 1

ebegin "Starting PostgreSQL"

if [ -f "$PGDATA/postmaster.pid" ] ; then
rm -f "$PGDATA/postmaster.pid"
fi

start-stop-daemon --start \
--pidfile "${PGDATA}/postmaster.pid" \
--chuid ${PGUSER}:${PGGROUP} \
--exec /usr/bin/postmaster \
-- \
-D "${PGDATA}" \
--silent-mode=true \
${PGOPTS}

eend $?
}

--
Vasiliy G Tolstov <v(dot)tolstov(at)selfip(dot)ru>
Selfip.Ru

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Mason 2009-09-28 11:53:00 Re: PostgreSQL reads each 8k block - no larger blocks are used - even on sequential scans
Previous Message Martijn van Oosterhout 2009-09-28 11:11:57 Re: postgresql error