Getting "getsockopt(TCP_KEEPALIVE) failed" LOG message in PG Logs on Solaris 10 - Mailing list pgsql-bugs

From Dhiraj Chawla
Subject Getting "getsockopt(TCP_KEEPALIVE) failed" LOG message in PG Logs on Solaris 10
Date
Msg-id CAJgtxT6QL0_Gt+TkSDw=q1=YVJkT73FoSrtStcu5Hy+-SXn8rw@mail.gmail.com
Whole thread Raw
List pgsql-bugs
Hi,

I am getting "getsockopt(TCP_KEEPALIVE) failed: Option not supported by protocol" log message in the PG Logs whenever I run a query referencing "pg_catalog.pg_settings" on Solaris 10 (both Sprac and x86-64).

You can reproduce this case by running a query like: SELECT name, setting, unit FROM pg_catalog.pg_settings;

This happens only the first time you execute the query though.

This issue was reproducible to me on both PostgreSQL 9.0.4 and PostgreSQL 9.2.4. This happens when I run the query via psql or pgAdminIII by connecting to the database server over the TCP socket (i.e. by providing host details in -h). Same behavior is not reproducible if I connect to database server over Unix Socket.

I am not sure if this has been reported before, but I thought I should bring this issue to your notice.

regards,


Dhiraj Chawla
Senior Software Engineer
EnterpriseDB Corporation
The Enterprise PostgreSQL Company

Phone: +91-20-30589522

pgsql-bugs by date:

Previous
From: Mátyás Milos
Date:
Subject: win8
Next
From: tommi.korhonen@thl.fi
Date:
Subject: BUG #8513: Error recognizing data type in union