Date: Fri, 19 Aug 2005 11:54:19 +0200 From: =?ISO-8859-2?Q?Zbigniew_Zag=F3rski?= <kuwaka@zbigg.org> To: freebsd-ports@freebsd.org Subject: postgresql-server-8.0.3: select() failed in postmaster: Inappropriate ioctl for device Message-ID: <4305AC4B.5020105@zbigg.org>
next in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4305AC4B.5020105>