Re: caracara failing to bind to localhost?

Lists: pgsql-hackers
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cbbrowne(at)ca(dot)afilias(dot)info
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: caracara failing to bind to localhost?
Date: 2010-02-27 04:02:31
Message-ID: 12583.1267243351@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Buildfarm member caracara has been failing the last few days because of
this:

LOG: could not bind socket for statistics collector: Cannot assign requested address
LOG: disabling statistics collector for lack of working socket

That code hasn't changed recently, AFAIK, so I'm thinking something's
broken in the machine's environment. Any ideas?

regards, tom lane


From: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: cbbrowne(at)ca(dot)afilias(dot)info, pgsql-hackers(at)postgresql(dot)org
Subject: Re: caracara failing to bind to localhost?
Date: 2010-02-27 14:02:15
Message-ID: ae46fee11002270602y226cf282t4ff042e4b340b3f8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

2010/2/27 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Buildfarm member caracara has been failing the last few days because of
> this:
>
> LOG:  could not bind socket for statistics collector: Cannot assign requested address
> LOG:  disabling statistics collector for lack of working socket
>
> That code hasn't changed recently, AFAIK, so I'm thinking something's
> broken in the machine's environment.  Any ideas?

Firewall or that ipv6's issues when ::1 for localhost is enabled in
/etc/hosts or that cases when there is an ipv4 address and an ipv6
alias in the same eth0? Was the tcpip_socket variable changed on
caracara's host?

[]s
Dickson S. Guedes
mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
http://guedesoft.net - http://www.postgresql.org.br


From: Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
To: "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: caracara failing to bind to localhost?
Date: 2010-03-02 23:22:02
Message-ID: 4B8D9D9A.7020604@ca.afilias.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Dickson S. Guedes wrote:
> 2010/2/27 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
>> Buildfarm member caracara has been failing the last few days because of
>> this:
>>
>> LOG: could not bind socket for statistics collector: Cannot assign requested address
>> LOG: disabling statistics collector for lack of working socket
>>
>> That code hasn't changed recently, AFAIK, so I'm thinking something's
>> broken in the machine's environment. Any ideas?
>>
>
> Firewall or that ipv6's issues when ::1 for localhost is enabled in
> /etc/hosts or that cases when there is an ipv4 address and an ipv6
> alias in the same eth0? Was the tcpip_socket variable changed on
> caracara's host?
>
> []s
> Dickson S. Guedes
> mail/xmpp: guedes(at)guedesoft(dot)net - skype: guediz
> http://guedesoft.net - http://www.postgresql.org.br
>
I had dropped an interface on my laptop...

"ifup lo" brought back the local loopback, thereby restoring 127.0.0.1,
so everything should work now. I hope... :-).