Thread: [7.4] statistics collector: Protocol not supported

[7.4] statistics collector: Protocol not supported

From
"Marc G. Fournier"
Date:
I suspect it might be because I'm running in a jail'd environment, but
what should I be looking at to confirm?

could not create socket for statistics collector: Protocol not supported

it appears to be running though:

pgsql 60120  0.0  0.1 14112 3420  ??  SsJ   3:32AM   0:00.01 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
-S(postgres)
 
pgsql 60121  0.0  0.1  4908 3316  ??  SJ    3:32AM   0:00.00 postmaster: stats buffer process    (postgres)
pgsql 60123  0.0  0.1  3964 3364  ??  SJ    3:32AM   0:00.00 postmaster: stats collector process    (postgres)

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


Re: [7.4] statistics collector: Protocol not supported

From
Kurt Roeckx
Date:
On Sat, Nov 22, 2003 at 11:32:18PM -0400, Marc G. Fournier wrote:
> 
> I suspect it might be because I'm running in a jail'd environment, but
> what should I be looking at to confirm?
> 
> could not create socket for statistics collector: Protocol not supported

You probably shouldn't worry about it.  Maybe this message could
be made more clear too.

It probably does socket(AF_INET6), which fails, and gives the
above message, and then tries socket(AF_INET) which works.


Kurt



Re: [7.4] statistics collector: Protocol not supported

From
Tom Lane
Date:
Kurt Roeckx <Q@ping.be> writes:
> On Sat, Nov 22, 2003 at 11:32:18PM -0400, Marc G. Fournier wrote:
>> I suspect it might be because I'm running in a jail'd environment, but
>> what should I be looking at to confirm?
>> 
>> could not create socket for statistics collector: Protocol not supported

> You probably shouldn't worry about it.  Maybe this message could
> be made more clear too.
> It probably does socket(AF_INET6), which fails, and gives the
> above message, and then tries socket(AF_INET) which works.

If you don't see something about "disabling statistics collector for
lack of working socket" then there's no reason to worry.

I'm surprised you don't see any similar message about failing to create
an IPv6 postmaster listen socket though?
        regards, tom lane


Re: [7.4] statistics collector: Protocol not supported

From
"Marc G. Fournier"
Date:
On Sun, 23 Nov 2003, Tom Lane wrote:

> Kurt Roeckx <Q@ping.be> writes:
> > On Sat, Nov 22, 2003 at 11:32:18PM -0400, Marc G. Fournier wrote:
> >> I suspect it might be because I'm running in a jail'd environment, but
> >> what should I be looking at to confirm?
> >>
> >> could not create socket for statistics collector: Protocol not supported
>
> > You probably shouldn't worry about it.  Maybe this message could
> > be made more clear too.
> > It probably does socket(AF_INET6), which fails, and gives the
> > above message, and then tries socket(AF_INET) which works.
>
> If you don't see something about "disabling statistics collector for
> lack of working socket" then there's no reason to worry.
>
> I'm surprised you don't see any similar message about failing to create
> an IPv6 postmaster listen socket though?

Nope, this is everything from the startup:

Nov 23 03:30:58 pgsql74 postgres[59990]: [1-1] LOG:  could not create socket for statistics collector: Protocol not
supported
Nov 23 03:30:58 pgsql74 postgres[59993]: [2-1] LOG:  database system was shut down at 2003-11-23 03:22:39 GMT
Nov 23 03:30:58 pgsql74 postgres[59993]: [3-1] LOG:  checkpoint record is at 0/9B0B8C
Nov 23 03:30:58 pgsql74 postgres[59993]: [4-1] LOG:  redo record is at 0/9B0B8C; undo record is at 0/0; shutdown TRUE
Nov 23 03:30:58 pgsql74 postgres[59993]: [5-1] LOG:  next transaction ID: 534; next OID: 17142
Nov 23 03:30:58 pgsql74 postgres[59993]: [6-1] LOG:  database system is ready

Is it easy to do a quick message change to state that it was the IPv6
socket that failed?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664


Re: [7.4] statistics collector: Protocol not supported

From
Tom Lane
Date:
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> Is it easy to do a quick message change to state that it was the IPv6
> socket that failed?

I deliberately did not do that because we were well past error message
freeze for 7.4, but we certainly should fix it for 7.5.
        regards, tom lane


Re: [7.4] statistics collector: Protocol not supported

From
Bruce Momjian
Date:
Tom Lane wrote:
> "Marc G. Fournier" <scrappy@postgresql.org> writes:
> > Is it easy to do a quick message change to state that it was the IPv6
> > socket that failed?
> 
> I deliberately did not do that because we were well past error message
> freeze for 7.4, but we certainly should fix it for 7.5.

Yes, I am unsure why the mention of IPv6 was removed from the original
patch I submitted.  Does anyone remember?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: [7.4] statistics collector: Protocol not supported

From
Tom Lane
Date:
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Yes, I am unsure why the mention of IPv6 was removed from the original
> patch I submitted.  Does anyone remember?

You sure you aren't confusing this code with the listen-socket-opening
code over in backend/libpq/ ?

The libpq code identifies the socket type (and I think we should just
borrow that logic for pgstat.c) but I don't believe anyone proposed
making pgstat do so, because up till this recent patch it wouldn't try
more than one socket type anyway.
        regards, tom lane


Re: [7.4] statistics collector: Protocol not supported

From
Bruce Momjian
Date:
Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Yes, I am unsure why the mention of IPv6 was removed from the original
> > patch I submitted.  Does anyone remember?
> 
> You sure you aren't confusing this code with the listen-socket-opening
> code over in backend/libpq/ ?
> 
> The libpq code identifies the socket type (and I think we should just
> borrow that logic for pgstat.c) but I don't believe anyone proposed
> making pgstat do so, because up till this recent patch it wouldn't try
> more than one socket type anyway.

Oh, yes confused.  I never considered the stats listener message before.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073