Very Computer

It seems that a value of addr->ai_socktype returned by getaddrinfo in
pg_stat.c is not SOCK_DGRAM.

Kenji Sugita                                      

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

I don't see any pg_stat.c in the source tree.  Can you show us the exact
line, and perhaps the failure.

---------------------------------------------------------------------------

--
  Bruce Momjian                        |  http://candle.pha.pa.us

  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

He means pgstat.c of course.

Kurt

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command

What system are you running on, and does it have a getaddrinfo()
or not?

If I tell getaddrinfo() it should return a SOCK_DGRAM, it can
only mean that getaddrinfo() is broken.

Kurt

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Oops typo, fixed in new attachment.

Kurt

pgstat.diff < 1K Download

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

What do you base this on?

My guess is that it returns an ipv6 address while you do not have
IPv6 support in the kernel.  If that is the case, the attached
patch should fix it.

Kurt

pgstat.diff < 1K Download

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Date: Wed, 2 Jul 2003 19:20:11 +0200

;;; What system are you running on, and does it have a getaddrinfo()
;;; or not?

Red Hat Linux and Mac OS X 10.2.6. Both nm libc display getaddrinfo as follows:

$ nm /lib/libc.so.6 | grep getaddrinfo
0009fe3c T getaddrinfo
$

$ nm /usr/lib/libc.dylib | grep getaddrinfo
/usr/lib/libc.dylib(getaddrinfo.o):
90037dc0 T _getaddrinfo
         U _getaddrinfo
$

;;; If I tell getaddrinfo() it should return a SOCK_DGRAM, it can
;;; only mean that getaddrinfo() is broken.

What value shuld be passed to a following socket call with addr->ai_socktype?

====  pgstats.c  ====
        if ((pgStatSock = socket(addr->ai_family,
                addr->ai_socktype, addr->ai_protocol)) < 0)
        {
                elog(LOG, "PGSTAT: socket() failed: %m");
                goto startup_failed;
        }

Subject: Re: [HACKERS] PostgreSQL 7.4devel - LOG: PGSTAT: socket() failed: Invalid argument
Date: Wed, 2 Jul 2003 20:52:00 +0200

;;; > > It seems that a value of addr->ai_socktype returned by getaddrinfo in
;;; > > pg_stat.c is not SOCK_DGRAM.
;;; >
;;; > What do you base this on?

Red Hat Linux 6.2 base.

    $ uname -rs  
    Linux 2.2.18-0ph1smp
    $

For Mac OS X it produces LOG:  PGSTAT: socket() failed: Protocol not supported.

;;; > My guess is that it returns an ipv6 address while you do not have
;;; > IPv6 support in the kernel.  If that is the case, the attached
;;; > patch should fix it.
;;; >
;;;
;;; Oops typo, fixed in new attachment.

I tried it for current build.

Index: postmaster/pgstat.c
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/backend/postmaster/pgstat.c,v
retrieving revision 1.37
diff -u -r1.37 pgstat.c
--- postmaster/pgstat.c 12 Jun 2003 07:36:51 -0000      1.37

        /*
         * Create the UDP socket for sending and receiving statistic messages
         */
-       hints.ai_flags = AI_PASSIVE;
+       hints.ai_flags = AI_PASSIVE | AI_ADDRCONFIG;
        hints.ai_family = PF_UNSPEC;
        hints.ai_socktype = SOCK_DGRAM;
        hints.ai_protocol = 0;
$

And then:

$ postmaster (on Red Hat)
...
2003-07-03 10:19:38 [29761] LOG:  XX000: PGSTAT: getaddrinfo2() failed: Name or service not known
LOCATION:  pgstat_init, pgstat.c:193
...

Kenji Sugita                                      

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings