Skip site navigation (1) Skip section navigation (2)

Re: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: tanakalen <tanakalen(at)gmail(dot)com>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"
Date: 2012-09-24 14:42:03
Message-ID: 1348497086-sup-3863@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Excerpts from tanakalen's message of lun sep 17 06:00:05 -0300 2012:
> The following bug has been logged on the website:
> 
> Bug reference:      7545
> Logged by:          Len Tanaka
> Email address:      tanakalen(at)gmail(dot)com
> PostgreSQL version: 9.2.0
> Operating system:   Mac OS X 10.6.8
> Description:        
> 
> Multiple log files with same error repeated:
> poll() failed: Invalid argument
> 
> Prior to error, in user account in user table doing an insert that has not
> failed in past. Unresponsive thereafter. Unable to shutdown postmaster.
> 
> configure:
> ./configure --with-includes=/sw/include --with-libraries=/sw/lib --with-perl
> --with-python --with-openssl --with-bonjour --with-pam --with-krb5
> --with-ldap --enable-thread-safety --with-libxml --with-libxslt
> --enable-dtrace

So the full log files correspond to the server log file, right?  What
process is filling the logs?  (You can tell by adding a %p to
log_line_prefix in postgresql.conf, if it's not there already).

Is the table a FDW table or something otherwise funny?  Please give more
details; also about the underlying platform (is this a non-Intel
dinosaur or something?)

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


In response to

pgsql-bugs by date

Next:From: Dave PageDate: 2012-09-24 15:42:43
Subject: Re: BUG #7564: window installer of Postgresql 9.2 and service configuration
Previous:From: Alvaro HerreraDate: 2012-09-24 14:16:35
Subject: Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group