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

From: Mike G <mike(at)thegodshalls(dot)com>
To: Mike Leahy <mgleahy(at)fes(dot)uwaterloo(dot)ca>
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: WARNING: dup(0) failed after 3195 successes: Bad file descriptor
Date: 2004-08-05 01:22:07
Message-ID: 20040805012207.GA25434@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Hussein Badakhchani 2004-08-05 12:53:33 initdb failing
Previous Message victor.filho 2004-08-04 16:18:47 PostgreSQL in Windows2000 PRO