From owner-freebsd-ports@FreeBSD.ORG Fri Aug 19 09:54:31 2005 Return-Path: X-Original-To: freebsd-ports@freebsd.org Delivered-To: freebsd-ports@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 7863316A41F for ; Fri, 19 Aug 2005 09:54:31 +0000 (GMT) (envelope-from kuwaka@zbigg.org) Received: from alpha.filmzone.pl (alpha.filmzone.pl [64.191.111.25]) by mx1.FreeBSD.org (Postfix) with ESMTP id 260E443D46 for ; Fri, 19 Aug 2005 09:54:30 +0000 (GMT) (envelope-from kuwaka@zbigg.org) Received: from up6.internetdsl.tpnet.pl ([80.55.145.6] helo=[10.0.0.50]) by alpha.filmzone.pl with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.51) id 1E63dG-0002qO-34 for freebsd-ports@freebsd.org; Fri, 19 Aug 2005 11:57:51 +0200 Message-ID: <4305AC4B.5020105@zbigg.org> Date: Fri, 19 Aug 2005 11:54:19 +0200 From: =?ISO-8859-2?Q?Zbigniew_Zag=F3rski?= User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: freebsd-ports@freebsd.org Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - alpha.filmzone.pl X-AntiAbuse: Original Domain - freebsd.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - zbigg.org X-Source: X-Source-Args: X-Source-Dir: Subject: postgresql-server-8.0.3: select() failed in postmaster: Inappropriate ioctl for device X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 19 Aug 2005 09:54:31 -0000 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: ---- postgres[89874]: [1-1] LOG: XX000: select() failed in postmaster: Inappropriate ioctl for device 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