pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedToo many private FDs
3+ messages / 3 participants
[nested] [flat]
* Too many private FDs
@ 1999-12-01 08:42 Rolf Lüttecke <rluettecke@gcd.de>
0 siblings, 2 replies; 3+ messages in thread
From: Rolf Lüttecke @ 1999-12-01 08:42 UTC (permalink / raw)
To: pgsql-interfaces
Hi folks,
is anyone able to explain the following error-message extracted from
the "server.log"?
-- ERROR: AllocateFile: too many private FDs demanded
-- pq_recvbuf: unexpected EOF on client connection
-- IpcMemoryCreate: shmget failed (Identifier removed) key=5432007,
size=96424, permission=600
-- SISegmentGet: failed: Identifier removed
-- FATAL 1: CreateSharedInvalidationState: failed segment init
-- FATAL 1: AttachSLockMemory: could not attach segment
The main postmaster-process dies, still leaving the other postgres-
processes active (but not working). This happens roundabout once a
day caused by different workstations and different functions.
A few environment information:
PostgreSQL 6.5.2 w/ SuSE 6.0 (2.0.36) running on a SNI-Primergy 070
Access-method: w/ Insight's ODBC-driver (6.5/0006) from MS-Access
Thanx in advance
- Rolf
_____________________________________________________________________
"Rolf Luettecke" <rluettecke@gcd.de>
Gesellschaft für
Computer- u. Datentechnik mbH
http://www.gcd.de
Internet Business Solutions
_____________________________________________________________________
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Too many private FDs
@ 1999-12-01 12:09 awilliam@whitemice.org
parent: Rolf Lüttecke <rluettecke@gcd.de>
1 sibling, 0 replies; 3+ messages in thread
From: awilliam@whitemice.org @ 1999-12-01 12:09 UTC (permalink / raw)
To: Rolf Lüttecke <rluettecke@gcd.de>; +Cc: pgsql-interfaces
> -- ERROR: AllocateFile: too many private FDs demanded
> -- pq_recvbuf: unexpected EOF on client connection
> -- IpcMemoryCreate: shmget failed (Identifier removed) key=5432007,
> size=96424, permission=600
> -- SISegmentGet: failed: Identifier removed
> -- FATAL 1: CreateSharedInvalidationState: failed segment init
> -- FATAL 1: AttachSLockMemory: could not attach segment
> A few environment information:
> PostgreSQL 6.5.2 w/ SuSE 6.0 (2.0.36) running on a SNI-Primergy 070
> Access-method: w/ Insight's ODBC-driver (6.5/0006) from MS-Access
I have had similair problems with the Informix Online database engine.
You need to be running a 2.2.x kernel and to use the sysctrl
interface to increase the number of file handles (by default limited
to 1024) and possibly the maximum shared memory size.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] Too many private FDs
@ 1999-12-01 15:34 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rolf Lüttecke <rluettecke@gcd.de>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 1999-12-01 15:34 UTC (permalink / raw)
To: Rolf Lüttecke <rluettecke@gcd.de>; +Cc: pgsql-interfaces
Rolf =?iso-8859-1?Q?L=FCttecke?= <rluettecke@gcd.de> writes:
> is anyone able to explain the following error-message extracted from
> the "server.log"?
> -- ERROR: AllocateFile: too many private FDs demanded
Do you use password verification for any of your clients?
There is a file descriptor leak in the 6.5.* postmaster that is
triggered when an invalid user name is presented to the password
check routine. Add a FreeFile() call to the bottom of the check
routine, like this:
inline patch 1: src/backend/libpq/password.c (+2/-0 lines) download inline-1.patch
*** src/backend/libpq/password.c.orig Tue May 25 12:09:00 1999
--- src/backend/libpq/password.c Wed Dec 1 10:30:46 1999
***************
*** 90,95 ****
--- 90,97 ----
return STATUS_ERROR;
}
}
+
+ FreeFile(pw_file);
snprintf(PQerrormsg, ERROR_MSG_LENGTH,
"verify_password: user '%s' not found in password file.\n",
end of thread, other threads:[~1999-12-01 15:34 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-01 08:42 Too many private FDs Rolf Lüttecke <rluettecke@gcd.de>
1999-12-01 12:09 ` awilliam@whitemice.org
1999-12-01 15:34 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox