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(at)thegodshalls(dot)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(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
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
>

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