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

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: [email protected] [mailto:pgsql-cygwin-
> [email protected]] On Behalf Of Mike Leahy
> Sent: July 10, 2004 1:20 AM
> To: [email protected]
> 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: [email protected] [mailto:pgsql-cygwin-
> [email protected]] On Behalf Of Jason Tishler
> Sent: June 14, 2004 12:07 PM
> To: David P. Lurie
> Cc: [email protected]
> 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 [email protected] so that your
>       message can get through to the mailing list cleanly

---------------------------(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