Re: WARNING: dup(0) failed after 3195 successes: Bad file descriptor - Mailing list pgsql-cygwin

Hi,

How are you trying to create the database?  Through psql,pgadmin, or something else?

How did you backup the database?  pg_dumpall, pg_dump or something else?

I believe I have seen that error in my logs as well but it has not prevented me from doing anything.

Mike
 Wed, Aug 04, 2004 at 02:47:33AM -0400, Mike Leahy wrote:
> 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@postgresql.org [mailto:pgsql-cygwin-
> owner@postgresql.org] On Behalf Of Mike Leahy
> Sent: July 10, 2004 1:20 AM
> To: pgsql-cygwin@postgresql.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@postgresql.org [mailto:pgsql-cygwin-
> owner@postgresql.org] On Behalf Of Jason Tishler
> Sent: June 14, 2004 12:07 PM
> To: David P. Lurie
> Cc: pgsql-cygwin@postgresql.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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly