[hackers-jp: 39] Re: [HACKERS] 7.4RC2 regression failur and not running stats collector process on Solaris

[Kiyoshi Sawada]

沢田です。

stats ... FAILED に、端を発した、Solaris の
could not bind socket for statistics collector:
の件です。

src/backend/postmaster/pgstat.c の pgstat_init() のロジックを見ろ！ 
とのことで、エラーメッセージが出ているところを追っかけると、
------------------------------------------
/*
* Bind it to a kernel assigned port on localhost and get the assigned
* port via getsockname().
*/
if (bind(pgStatSock, addr->ai_addr, addr->ai_addrlen) < 0)
{
   ereport(LOG,
                (errcode_for_socket_access(),
                 errmsg("could not bind socket for statistics collector: %m")));
   goto startup_failed;
}
------------------------------------------

どうやら、bind()がエラーを出しているようです。
で、bind()って何？ などなどを調査中です。
引き続きアドバイスをいただけたら幸いです。


On Tue, 11 Nov 2003 22:35:18 -0500  Tom Lane <tgl ＠ sss.pgh.pa.us> wrote:

> Kiyoshi Sawada <sawa ＠ nagoya2.jrc.or.jp> writes:
> > On Tue, 11 Nov 2003 09:18:48 -0500  Tom Lane <tgl ＠ sss.pgh.pa.us> wrote:
> >> So why not?  Try looking in the postmaster log for errors related to
> >> stats collector startup.  (pstat is irrelevant, btw.)
> 
> > LOG:  could not bind socket for statistics collector: Cannot assign requested address
> 
> Hmm ... that's sure the problem, but what can we do about it?  ISTM that
> any non-broken system ought to be able to resolve "localhost".  Actually
> it's worse than that: your system resolved "localhost" and then refused
> to bind to any of the IP addresses it had resolved.  Look at the logic
> in pgstat_init() in src/backend/postmaster/pgstat.c.  I think this
> suggests a misconfiguration in your system ... but if you can suggest a
> more robust way of setting up that connection, I'm all ears ...
> 
> 			regards, tom lane

-- 
沢田 潔 <sawa ＠ nagoya2.jrc.or.jp>