WARNING: dup(0) failed after 3195 successes: Bad file descriptor

Hello list,

I'm just reposting this question, that didn't get feedback a few weeks ago. I
can't for the life of me guess why I'm getting this error in the logs when the
postmaster service starts. I've got it running in cygwin on XP Pro (SP2),
originally with ipc-daemon, now with cygserver. I've seen similar postings
about this answer, but I can't tell if anyone has actually resolved it...

A better description of what I've done to try to fix this is below...

Any guesses/suggestions?

Thanks,
Mike

-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org [mailto:pgsql-cygwin-
owner(at)postgresql(dot)org] On Behalf Of Mike Leahy
Sent: July 10, 2004 1:20 AM
To: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] WARNING: dup(0) failed after 3195 successes: Bad file
descriptor

Hello list,

I'm getting this error as well. I'm running XP Pro, with SP2 (RC2). Until
just now I had PostgreSQL 7.4.1. As far as I could tell, everything was
running fine...then as I was updating some tables I started getting errors
(sorry I didn't record them). I had my whole database backed up, so I tried
to delete the database using "dropdb" so I could reload the backup, but the
dropdb command just hung there and did nothing...

I tried cleaning out the whole PG data folder, and reinitializing. It seemed
okay...I could run "createuser", but it hung again with "createdb". Next I
installed PostgreSQL 7.4.3. I got through the setup okay, and the services
appear to be running fine, db initialized okay, and I could create new users
as before, but the postmaster.log still has the same "dup(0)" error, and it
still hangs if I try to create a database.

Earlier this week I installed the second release of XP SP2 - I suppose that
could have something to do with it. Did the others with this error find a
solution?

Kind regards,
Michael Leahy

-----Original Message-----
From: pgsql-cygwin-owner(at)postgresql(dot)org [mailto:pgsql-cygwin-
owner(at)postgresql(dot)org] On Behalf Of Jason Tishler
Sent: June 14, 2004 12:07 PM
To: David P. Lurie
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] WARNING: dup(0) failed after 3195 successes: Bad file
descriptor

David,

On Sun, Jun 13, 2004 at 07:42:30PM -0400, David P. Lurie wrote:
> The following warning occurs each time that postgresql 7.4.2 is loaded:
>
> WARNING: dup(0) failed after 3195 successes: Bad file descriptor
> [snip]
>
> Is this a serious problem? Occurs on two different XP Pro systems.

AFAICT, no.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

----------------------------------------
This mail sent through www.mywaterloo.ca

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

----------------------------------------
This mail sent through www.mywaterloo.ca