pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
could not bind socket for statistics collector:
13+ messages / 4 participants
[nested] [flat]

* could not bind socket for statistics collector:
@ 2004-01-01 15:58  Denis Grannell <dgrannell@web.de>
  0 siblings, 1 reply; 13+ messages in thread

From: Denis Grannell @ 2004-01-01 15:58 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I have just upgraded to 7.4.1 and since restarting
postmaster I am getting the following error message
in the logfile:
"could not bind socket for statistics collector: 
"Cannot assign requested address".
My setup is:

OS : 			Solaris 9(sparc)
Postgres Version:	7.4.1 (upgraded from 7.3.2)

The message only started appearing after the
upgrade. It never happened on 7.3.2.
Everything else seems to be working OK, the
database save and restore worked fine between
the versions and all the data seem to be complete.
Accessing the databases using either PHP or JDBC
is all working as it always has.

I read somewhere that, to fix this, all I would 
need to do would be to uncomment the line 
"::1  localhost" in /etc/inet/ipnodes and restart 
the postmaster. However this line is already 
uncommented on my system, also I have been using 
postgres 7.3.x versions on this exact same system 
for well over a year without any errors.
 
thanks for any assistance,
Denis.

Denis Grannell, Kapuzinerstr. 45, D-80469 Muenchen
Tel: 				 	    ++49 89 201 3672       
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ 



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-01 18:06  Michael Fuhr <mike@fuhr.org>
  parent: Denis Grannell <dgrannell@web.de>
  0 siblings, 1 reply; 13+ messages in thread

From: Michael Fuhr @ 2004-01-01 18:06 UTC (permalink / raw)
  To: Denis Grannell <dgrannell@web.de>; +Cc: pgsql-admin

On Thu, Jan 01, 2004 at 04:58:39PM +0100, Denis Grannell wrote:
> 
> I have just upgraded to 7.4.1 and since restarting
> postmaster I am getting the following error message
> in the logfile:
> "could not bind socket for statistics collector: 
> "Cannot assign requested address".
> My setup is:
> 
> OS : 			Solaris 9(sparc)
> Postgres Version:	7.4.1 (upgraded from 7.3.2)

[snip]

> I read somewhere that, to fix this, all I would 
> need to do would be to uncomment the line 
> "::1  localhost" in /etc/inet/ipnodes and restart 
> the postmaster. However this line is already 
> uncommented on my system, also I have been using 
> postgres 7.3.x versions on this exact same system 
> for well over a year without any errors.

The following message suggests that the solution is to comment, not
uncomment, the "::1 localhost" line in /etc/inet/ipnodes:

http://archives.postgresql.org/pgsql-hackers/2003-11/msg00744.php

I commented out that line on my Solaris 9 box, and the statistics
collector was then able to start.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-01 18:27  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 13+ messages in thread

From: Tom Lane @ 2004-01-01 18:27 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: Denis Grannell <dgrannell@web.de>; pgsql-admin

> On Thu, Jan 01, 2004 at 04:58:39PM +0100, Denis Grannell wrote:
>> I have just upgraded to 7.4.1 and since restarting
>> postmaster I am getting the following error message
>> in the logfile:
>> "could not bind socket for statistics collector: 
>> "Cannot assign requested address".

Is it actually an ERROR, or just a LOG?  If the latter, ignore it.
There's no problem unless you also see
"LOG: disabling statistics collector for lack of working socket"

Making the message disappear would require getting your kernel and
libc on the same page about whether IPv6 is supported or not.  I don't
know enough about Solaris to know how/where to fix that.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-01 18:50  Michael Fuhr <mike@fuhr.org>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 13+ messages in thread

From: Michael Fuhr @ 2004-01-01 18:50 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Denis Grannell <dgrannell@web.de>; pgsql-admin

On Thu, Jan 01, 2004 at 01:27:16PM -0500, Tom Lane wrote:
> > On Thu, Jan 01, 2004 at 04:58:39PM +0100, Denis Grannell wrote:
> >> I have just upgraded to 7.4.1 and since restarting
> >> postmaster I am getting the following error message
> >> in the logfile:
> >> "could not bind socket for statistics collector: 
> >> "Cannot assign requested address".
> 
> Is it actually an ERROR, or just a LOG?  If the latter, ignore it.
> There's no problem unless you also see
> "LOG: disabling statistics collector for lack of working socket"

Dang...I'm not the original poster, but I thought I remembered the
statistics collector not starting when I saw the "could not bind
socket" message.  However, I just backed out the "fix" I mentioned in
my previous post (the fix being to comment out "::1 localhost" from
/etc/inet/ipnodes), and although the "could not bind socket" message is
now logged, the statistics collector nevertheless appears to be running.
Must be a memory fault on my part, unless that behavior changed recently.

> Making the message disappear would require getting your kernel and
> libc on the same page about whether IPv6 is supported or not.  I don't
> know enough about Solaris to know how/where to fix that.

That's what commenting out "::1 localhost" from /etc/inet/ipnodes appears
to do.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-01 19:10  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Michael Fuhr <mike@fuhr.org>
  1 sibling, 1 reply; 13+ messages in thread

From: Tom Lane @ 2004-01-01 19:10 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: Denis Grannell <dgrannell@web.de>; pgsql-admin

Michael Fuhr <mike@fuhr.org> writes:
> On Thu, Jan 01, 2004 at 01:27:16PM -0500, Tom Lane wrote:
>> Is it actually an ERROR, or just a LOG?  If the latter, ignore it.
>> There's no problem unless you also see
>> "LOG: disabling statistics collector for lack of working socket"

> Dang...I'm not the original poster, but I thought I remembered the
> statistics collector not starting when I saw the "could not bind
> socket" message.

We did have a problem of that sort in 7.4 beta releases --- pgstats
would give up instead of continuing to try additional results from
getaddrinfo().  I don't recall at the moment if the fix was in 7.4.0
or not, but it's definitely there in 7.4.1.

>> Making the message disappear would require getting your kernel and
>> libc on the same page about whether IPv6 is supported or not.  I don't
>> know enough about Solaris to know how/where to fix that.

> That's what commenting out "::1 localhost" from /etc/inet/ipnodes appears
> to do.

Oh, okay, I misread what you were trying to do.  Yeah, that sounds like
a plausible fix.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-01 23:11  Denis Grannell <dgrannell@web.de>
  parent: Michael Fuhr <mike@fuhr.org>
  1 sibling, 1 reply; 13+ messages in thread

From: Denis Grannell @ 2004-01-01 23:11 UTC (permalink / raw)
  To: pgsql-admin

Hi Michael

> > 
> > Is it actually an ERROR, or just a LOG?  If the latter, ignore it.
> > There's no problem unless you also see

It's a LOG. I should have mentioned that in my first mail. 
So, I'll take your advice and ignore it.

> 
> That's what commenting out "::1 localhost" from /etc/inet/ipnodes appears
> to do.

The computer world desperately needs some new phrases to replace
'uncommenting' and 'commenting out'.
Imagine in a converstaion - hup...'scuse me, I wish to uncomment 
what you just said!!

Anyway, I have now 'commented out' the offending line in 
/etc/inet/ipnodes and the message no longer appears 
in the logfile.

Is there a fair probability that other parts of Solaris mightn't 
need that line 'commented in', for want of a better phrase?

Thanks a lot for your quick responses,

cheers,
Denis



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-01 23:17  Denis Grannell <dgrannell@web.de>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 13+ messages in thread

From: Denis Grannell @ 2004-01-01 23:17 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Hi Tome
> 
> We did have a problem of that sort in 7.4 beta releases --- pgstats
> would give up instead of continuing to try additional results from
> getaddrinfo().  I don't recall at the moment if the fix was in 7.4.0
> or not, but it's definitely there in 7.4.1.

I have also definitely installed 7.4.1. There's no doubt
about that. Here is the header from the Release Notes,
cut and pasted into this mail:

                               Release Notes

                               Release 7.4.1

     Release date: 2003-12-22


cheers,
Denis



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-01 23:54  Michael Fuhr <mike@fuhr.org>
  parent: Denis Grannell <dgrannell@web.de>
  0 siblings, 1 reply; 13+ messages in thread

From: Michael Fuhr @ 2004-01-01 23:54 UTC (permalink / raw)
  To: Denis Grannell <dgrannell@web.de>; +Cc: pgsql-admin

On Fri, Jan 02, 2004 at 12:11:54AM +0100, Denis Grannell wrote:
> 
> Anyway, I have now 'commented out' the offending line in 
> /etc/inet/ipnodes and the message no longer appears 
> in the logfile.
> 
> Is there a fair probability that other parts of Solaris mightn't 
> need that line 'commented in', for want of a better phrase?

Possibly if you're using IPv6, although if you are, then you probably
wouldn't be getting the "could not bind socket" messages and this thread
wouldn't have come up.  If you're concerned about it, then I'd suggest
asking in a Solaris-specific forum such as the comp.unix.solaris newsgroup
or the sun-managers mailing list.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-02 00:09  Denis Grannell <dgrannell@web.de>
  parent: Michael Fuhr <mike@fuhr.org>
  0 siblings, 1 reply; 13+ messages in thread

From: Denis Grannell @ 2004-01-02 00:09 UTC (permalink / raw)
  To: Michael Fuhr <mike@fuhr.org>; +Cc: pgsql-admin

Hi Michael,

> > Is there a fair probability that other parts of Solaris mightn't
> > need that line 'commented in', for want of a better phrase?
>
> Possibly if you're using IPv6, although if you are, then you probably
> wouldn't be getting the "could not bind socket" messages and this thread
> wouldn't have come up.  If you're concerned about it, then I'd suggest
> asking in a Solaris-specific forum such as the comp.unix.solaris newsgroup
> or the sun-managers mailing list.

No, I'm not using IPv6 and since you've classified the
message as being harmless then I'm happy with that.
It's the postgres software that's the most important thing
and it appears to be working fine.

cheers,
Denis








^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-02 00:29  Michael Fuhr <mike@fuhr.org>
  parent: Denis Grannell <dgrannell@web.de>
  0 siblings, 1 reply; 13+ messages in thread

From: Michael Fuhr @ 2004-01-02 00:29 UTC (permalink / raw)
  To: Denis Grannell <dgrannell@web.de>; +Cc: pgsql-admin

On Fri, Jan 02, 2004 at 01:09:51AM +0100, Denis Grannell wrote:
> Hi Michael,
> 
> > > Is there a fair probability that other parts of Solaris mightn't
> > > need that line 'commented in', for want of a better phrase?
> >
> > Possibly if you're using IPv6, although if you are, then you probably
> > wouldn't be getting the "could not bind socket" messages and this thread
> > wouldn't have come up.  If you're concerned about it, then I'd suggest
> > asking in a Solaris-specific forum such as the comp.unix.solaris newsgroup
> > or the sun-managers mailing list.
> 
> No, I'm not using IPv6 and since you've classified the
> message as being harmless then I'm happy with that.

Give credit (or blame :-) where it's due: Tom Lane said that the message
could be ignored as long as you weren't also seeing "disabling statistics
collector for lack of working socket."

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector:
@ 2004-01-02 09:26  Denis Grannell <dgrannell@web.de>
  parent: Michael Fuhr <mike@fuhr.org>
  0 siblings, 0 replies; 13+ messages in thread

From: Denis Grannell @ 2004-01-02 09:26 UTC (permalink / raw)
  To: pgsql-admin

Hi,

> > No, I'm not using IPv6 and since you've classified the
> > message as being harmless then I'm happy with that.
> 
> Give credit (or blame :-) where it's due: Tom Lane said that the message
> could be ignored as long as you weren't also seeing "disabling statistics
> collector for lack of working socket."
>

I thought I had already written an appropriate acknowledgement 
by CCing the whole list, but I take your point, so:
Let it be known here in this public forum, henceforth and 
forevermore, that it was Tom Lane and none other, who 
assured me that the message in my logfile was benign. :-)
The call I opened under the subject:
"could not bind socket for statistics collector:", is now
resolved.
Thanks Tom for a speedy and accurate response.

cheers,
Denis




^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* Re: could not bind socket for statistics collector
@ 2004-05-11 15:10  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Graham Clarke <grahamc@53tech.com>
  0 siblings, 0 replies; 13+ messages in thread

From: Tom Lane @ 2004-05-11 15:10 UTC (permalink / raw)
  To: Graham Clarke <grahamc@53tech.com>; +Cc: pgsql-admin

Graham Clarke <grahamc@53tech.com> writes:
> Hi - I'm trying to get postgres 7.4.2 going on RedHat ES
> The build went fine but I get the following when trying to start postgres 
> with this command:

> LOG:  disabling statistics collector for lack of working socket

It tries to bind a UDP port to the hostname "localhost".  I'm guessing
there is something messed up in your /etc/hosts or DNS configuration,
such that that name doesn't resolve to 127.0.0.1 like it should.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 13+ messages in thread

* could not bind socket for statistics collector
@ 2004-05-11 17:21  Graham Clarke <grahamc@53tech.com>
  0 siblings, 1 reply; 13+ messages in thread

From: Graham Clarke @ 2004-05-11 17:21 UTC (permalink / raw)
  To: pgsql-admin

Hi - I'm trying to get postgres 7.4.2 going on RedHat ES

The build went fine but I get the following when trying to start postgres 
with this command:

[postgres@brothers bin]$ ./pg_ctl -D /usr/local/pgsql/data/ -o "-i" start

LOG:  could not create IPv6 socket: Address family not supported by protocol
postmaster successfully started
[postgres@brothers bin]$ LOG:  could not bind socket for statistics 
collector: C
annot assign requested address
LOG:  disabling statistics collector for lack of working socket
LOG:  database system was shut down at 2004-05-11 10:12:17 EDT
LOG:  checkpoint record is at 0/9B12D8
LOG:  redo record is at 0/9B12D8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 536; next OID: 17142
LOG:  database system is ready


Thanks in advance for help & insight into what's going on here.

Cheers
Graham




Graham Clarke
GrahamC@53Tech.com
www.53Tech.com
603.643.9955




^ permalink  raw  reply  [nested|flat] 13+ messages in thread


end of thread, other threads:[~2004-05-11 17:21 UTC | newest]

Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-01-01 15:58 could not bind socket for statistics collector: Denis Grannell <dgrannell@web.de>
2004-01-01 18:06 ` Michael Fuhr <mike@fuhr.org>
2004-01-01 18:27   ` Tom Lane <tgl@sss.pgh.pa.us>
2004-01-01 18:50     ` Michael Fuhr <mike@fuhr.org>
2004-01-01 19:10       ` Tom Lane <tgl@sss.pgh.pa.us>
2004-01-01 23:17         ` Denis Grannell <dgrannell@web.de>
2004-01-01 23:11       ` Denis Grannell <dgrannell@web.de>
2004-01-01 23:54         ` Michael Fuhr <mike@fuhr.org>
2004-01-02 00:09           ` Denis Grannell <dgrannell@web.de>
2004-01-02 00:29             ` Michael Fuhr <mike@fuhr.org>
2004-01-02 09:26               ` Denis Grannell <dgrannell@web.de>
2004-05-11 17:21 could not bind socket for statistics collector Graham Clarke <grahamc@53tech.com>
2004-05-11 15:10 ` Re: could not bind socket for statistics collector Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox