Strange behavior of PostgreSQL on Linux - Mailing list pgsql-hackers

From Denis Perchine
Subject Strange behavior of PostgreSQL on Linux
Date
Msg-id 00121012514602.18833@dyp.perchine.com
Whole thread Raw
Responses Re: Strange behavior of PostgreSQL on Linux  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hello,

I have quite strange problem. It's lsof -i -n -P
postmaste 20018      postgres    6u  IPv4 12241380       TCP 
127.0.0.1:5432->127.0.0.1:6651 (CLOSE)

And there is no pair for it.

Backtrace of the backend shows:
(gdb) bt
#0  0x40198ba2 in recv () from /lib/libc.so.6
#1  0x80ab2c5 in pq_recvbuf ()
#2  0x80ab395 in pq_getbytes ()
#3  0x80eaa7c in SocketBackend ()
#4  0x80eab13 in ReadCommand ()
#5  0x80ebb9c in PostgresMain ()
#6  0x80d69a2 in DoBackend ()
#7  0x80d6581 in BackendStartup ()
#8  0x80d593a in ServerLoop ()
#9  0x80d53c4 in PostmasterMain ()
#10 0x80abbb6 in main ()
#11 0x400fe9cb in __libc_start_main () at ../sysdeps/generic/libc-start.c:122

[root@mx /root]# ps axwfl|grep 20018
040   507 20018 21602   0   0 15292    0 tcp_re SW   pts/0      0:00  \_ 
[postmaster]

[root@mx /root]# uname -a
Linux mx.xxx.com 2.2.16-3 #1 Mon Jun 19 19:11:44 EDT 2000 i686 unknown

Looks like it tries to read on socket which is already closed from other 
side. And it seems like recv did not return in this case. Is this OK, or 
kernel bug?

On the other side I see entries like this:
httpd      4260          root    4u  IPv4 12173018       TCP 
127.0.0.1:3994->127.0.0.1:5432 (CLOSE_WAIT)

And again. There is no any corresponding postmaster process. Does anyone has 
such expirience before? And what can be the reason of such strange things.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------


pgsql-hackers by date:

Previous
From: Bruce Guenter
Date:
Subject: Re: CRC, hash & Co.
Next
From: ncm@zembu.com (Nathan Myers)
Date:
Subject: Re: Re: CRC