Re: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument" - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"
Date
Msg-id 1348497086-sup-3863@alvh.no-ip.org
Whole thread Raw
In response to BUG #7545: Unresponsive server with error log reporting: "poll() failed: Invalid argument"  (tanakalen@gmail.com)
List 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:
>=20
> Bug reference:      7545
> Logged by:          Len Tanaka
> Email address:      tanakalen@gmail.com
> PostgreSQL version: 9.2.0
> Operating system:   Mac OS X 10.6.8
> Description:       =20
>=20
> Multiple log files with same error repeated:
> poll() failed: Invalid argument
>=20
> Prior to error, in user account in user table doing an insert that has =
not
> failed in past. Unresponsive thereafter. Unable to shutdown postmaster.
>=20
> configure:
> ./configure --with-includes=3D/sw/include --with-libraries=3D/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?)

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

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #6704: ALTER EXTENSION postgis SET SCHEMA leaves dangling relations
Next
From: raphael.petit@biomerieux.com
Date:
Subject: BUG #7564: window installer of Postgresql 9.2 and service configuration