Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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


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

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


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:

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

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= user=mentor

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

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

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


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




pgsql-cygwin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group