Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Socket problem using beta2 on Windows-XP


  • From: Thomas Hallgren <thhal(at)mailblocks(dot)com>
  • To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
  • Subject: Socket problem using beta2 on Windows-XP
  • Date: Thu, 29 Sep 2005 08:50:30 +0200
  • Message-id: <thhal-0NycXBFmg8bQ2+Jr46bQjc5xXqCWgs/@mailblocks.com>

Hi,
I've installed PostgreSQL 8.1-beta2 as a service on my Windows-XP box. It runs fine but I get repeated messages like this in the log:

2005-09-29 00:41:09 FATAL: could not duplicate socket 1880 for use in backend: error code 10038

and for each message printed, a new postgres process is created. To make things worse, those processes do not die when I stop the service.

I use sysinternals tcpview to monitor my sockets. I know that no other process is using 1880. Each started postgres process will occupy two, seemingly random ports that apparently form a loop somehow. This is a typical entry:

  <non-existent>:3136	TCP	127.0.0.1:1554	127.0.0.1:1555 ESTABLISHED	
  <non-existent>:3136	TCP	127.0.0.1:1555	127.0.0.1:1554	ESTABLISHED	

The weird thing is that there is no process with pid 3136 (hence the name <non-existent>). There is a postgres process with another pid in my process listing. If I kill that, the <non-existstent> entries go away.

Looks like pid 3136 is talking to itself. A pipe() followed by failure to start the new process perhaps?

Regards,
Thomas Hallgren




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group