postgresql-server-8.0.3: select() failed in postmaster:
Inappropriate ioctl for device
kuwaka at zbigg.org
Fri Aug 19 09:54:31 GMT 2005
I've god problem with postgresql server on FreeBSD 5.2-RELEASE.
Postgresql is installed by ports.
After some time (about 1000-15000 connections, each one transaction
with 1-50 of selects, updates are rare) postmaster stops receiving
connections (but is still alive and silently waits for children).
Snippet from logs at this moment:
<snip> postgres: [1-1] LOG: XX000: select() failed in postmaster: Inappropriate ioctl for device
<snip> postgres: [1-2] LOCATION: ServerLoop, postmaster.c:1183
The most strangest part of this, that in FreeBSD manual page of
select(2) ENOTTY (errno code for 'Inappropriate ioctl for device')
is not listed.
Postgresql hackers said that it's rather OS or port bug.
Anybody seen such weird error? Should I report PR for OS or port.
PostgreSQL: psql (PostgreSQL) 8.0.3 (also happens on 7.4)
More information about the freebsd-ports