Re: Stats Collector Won't Start

tgl@sss.pgh.pa.us (Tom Lane) writes:
> Brad Nicholson <bnichols@ca.afilias.info> writes:
>> On Wed, 2006-10-18 at 14:31 -0400, Tom Lane wrote:
>>> Would you try strace'ing postmaster start to see what gets passed to the
>>> socket() and bind() calls just before this message comes out?
>
>> Here is the relative output from truss.
>
>> socket(2, 2, 0)                                 = 7
>> bind(7, 0x00000001100E3BF0, 16)                 Err#13 EACCES
>
> Well, that's pretty odd --- I'd have expected to see something involving
> 127.0.0.1 (ie, 7F000001 in one byte order or another).  Does your
> /etc/hosts file map "localhost" to something other than 127.0.0.1?

Nope, it maps right.

Note that the 0x00000001100E3BF0 value is not an IP address; it is a
pointer to a (struct sockaddr *).

> Also, do regular connections to this postmaster work across TCP/IP?
> If getaddrinfo() is broken I'd expect there to be problems binding
> to the postmaster's listen socket too ...

There's evidently a difference between TCP and UDP, here.

From a gdb run...

259     pgstat.c: No such file or directory.
        in pgstat.c
(gdb) print addrs
$7 = (struct addrinfo *) 0x1100e3af0
(gdb) print addrs[0]
$8 = {ai_flags = 0, ai_family = 2, ai_socktype = 0, ai_protocol = 0, ai_addrlen = 16, ai_canonname = 0x0, ai_addr =
0x1100e3b30,ai_next = 0x0} 
(gdb) print addrs[1]
$9 = {ai_flags = 1532713819, ai_family = 0, ai_socktype = 0, ai_protocol = 16, ai_addrlen = 1153484460985942017,
ai_canonname= 0x0, ai_addr = 0x0,  
  ai_next = 0x0}
(gdb) print addrs[2]
$10 = {ai_flags = 1, ai_family = 269388064, ai_socktype = 0, ai_protocol = 960, ai_addrlen = 0, ai_canonname = 0x0,
ai_addr= 0x0, ai_next = 0x0} 
(gdb) print addrs[3]
$11 = {ai_flags = 0, ai_family = 0, ai_socktype = 0, ai_protocol = 0, ai_addrlen = 0, ai_canonname = 0x0, ai_addr =
0x0,ai_next = 0x0} 
(gdb) print addr->ai_addrlen
$16 = 16
(gdb) print addr->ai_addr->sa_family
$17 = 2 '\002'
(gdb) print addr->ai_addr->sa_data
$18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
(gdb) print addr->ai_addr
$19 = (struct sockaddr *) 0x1100e3b30
(gdb) step
300     in pgstat.c
(gdb) step
errstart (elevel=15, filename=0x10029f648 "pgstat.c", lineno=302, funcname=0x11000f258 "pgstat_init") at elog.c:149
149     elog.c: No such file or directory.
        in elog.c
--
"cbbrowne","@","acm.org"
http://cbbrowne.com/info/emacs.html
They have finally found the most ultimately useless thing on the web...
Found at the Victoria's Secret website:
   "The online shop: Text Only Listing"