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 or flat)
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

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-2014 The PostgreSQL Global Development Group