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

I'm just running createdb to create the database - and it hangs, and the only
error message I can find anywhere are the dup(0) message in the postmaster
log.  I have a bunch of scripts that create/import tables in that database
once it's created - the dump file that I have I created using pg_dump, but
I've never tried it...I'm guessing it would be executed using psql?

Is there an alternative method to the createdb command?

Thanks,
Mike

Quoting Mike G <mike@thegodshalls.com>:

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




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