PostgreSQL shutting down

From: "Thom Hixenbaugh" <thixenbaugh(at)inmedius(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: PostgreSQL shutting down
Date: 2003-05-09 18:40:22
Message-ID: 000701c3165a$730040d0$ca687241@catfish
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

I'm having a problem with my PostgreSQL service shutting down after a period
of use. The only clue I have to go by is this entry in the Postmaster.log
file

ZeroProcSemaphore: semctl(id=384,SETVAL) failed: Identifier removed

2003-05-01 10:17:17 [1316] DEBUG: server process (pid 2824) exited with
exit code 255

2003-05-01 10:17:17 [1316] DEBUG: terminating any other active server
processes

2003-05-01 10:17:17 [1316] DEBUG: all server processes terminated;
reinitializing shared memory and semaphores

IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not enough
memory

This error usually means that PostgreSQL's request for a shared

memory segment exceeded available memory or swap space.

To reduce the request size (currently 1441792 bytes), reduce

PostgreSQL's shared_buffers parameter (currently 64) and/or

its max_connections parameter (currently 32).

The PostgreSQL Administrator's Guide contains more information about

shared memory configuration.

2003-05-01 10:18:24 [1592] DEBUG: database system was interrupted at
2003-05-01 10:16:28

2003-05-01 10:18:24 [1592] DEBUG: checkpoint record is at 0/6124658

2003-05-01 10:18:24 [1592] DEBUG: redo record is at 0/6124658; undo
record is at 0/0; shutdown TRUE

2003-05-01 10:18:24 [1592] DEBUG: next transaction id: 3985367; next oid:
84154

2003-05-01 10:18:24 [1592] DEBUG: database system was not properly shut
down; automatic recovery in progress

2003-05-01 10:18:24 [1592] DEBUG: ReadRecord: record with zero length at
0/6124698

2003-05-01 10:18:24 [1592] DEBUG: redo is not required

2003-05-01 10:18:27 [1592] DEBUG: database system is ready

2003-05-01 10:18:30 [2200] DEBUG: connection: host=127.0.0.1 user=mentor
database=mentordb

2003-05-01 10:18:30 [2892] DEBUG: connection: host=127.0.0.1 user=mentor
database=mentorarchivedb

2003-05-01 10:18:36 [2088] DEBUG: connection: host=127.0.0.1 user=mentor
database=mentordb

2003-05-01 10:20:11 [2908] DEBUG: connection: host=127.0.0.1 user=mentor
database=mentordb

we tried changing the max connections, and shared buffers up, and down, and
neither seemed to work. I also deleted the cygpic*, and multifile* files,
because a previous post stated that this may help a similar problem, but it
also didn't make any differences.

Thanks in advance

Thom Hixenbaugh

Inmedius Customer Support

Inmedius, Inc.

1425 Forbes Ave. (Sixth Floor)

Pittsburgh, PA 15219

(412)690-2360 ext 225

thixenbaugh(at)inmedius(dot)com

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Frank Seesink 2003-05-09 20:12:01 Re: UPDATE 2: Windows XP, Cygwin 1.3.22-1, PostgreSQL 7.3.2,
Previous Message Parag Sagar 2003-05-09 05:57:56 Initialization Problem.