postgresql-server-8.0.3: select() failed in postmaster: Inappropriate ioctl for device

[Zbigniew Zagórski]

Hi,

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[89874]: [1-1] LOG:  XX000: select() failed in postmaster: Inappropriate ioctl for device
<snip> postgres[89874]: [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.

Platform:
   PostgreSQL: psql (PostgreSQL) 8.0.3 (also happens on 7.4)
   FreeBSD:    5.2-RELEASE

Thanks, Greetings.

Zbigniew Zagórski