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@inmedius.com