[Re] Re: [Re] Re: Winsock error 10035 while trying to upgrade from 8.0 to 8.2

From: "Cyril VELTER" <cyril(dot)velter(at)metadys(dot)com>
To: magnus(at)hagander(dot)net
Cc: cyril(dot)velter(at)metadys(dot)com, pgsql-general(at)postgresql(dot)org
Subject: [Re] Re: [Re] Re: Winsock error 10035 while trying to upgrade from 8.0 to 8.2
Date: 2007-05-30 10:17:35
Message-ID: 0-39232424468-2674-1824419@CFGEM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


De : mailto:magnus(at)hagander(dot)net
> Cyril VELTER wrote:
> > OK, I've the results of my tests :
> >
> > With the previous code, then message "SOCKERROR" is printed 5 times during
the
> > whole process (100 Gb dump import with psql). There one group of three and
one
> > group of two, but I don't have timestamps and am not sure if they are
printing
> > in the same loop or not. The import is finally successful.
>
> Ok.
>
>
> > The second test I have done is to remove FD_ACCEPT I still have the
message
> > one times, but it still happen. The import is also sucessfull.
>
> Ok. So FD_ACCEPT is not the fix. Good, I didn't think it would be.
>
>
> >> I'm also a bit worried about it getting caught in a tight loop if the
> >> error codes are wrong, but probably it just goes back into waitfor.. and
> >> blocks the second time. Otherwise, you'd see screenfuls of that message.
> >>
> >> Can you determine if it was hit two times right after each other, or if
> >> there was time between them?
> >
> > For the first test I don't known the amount of time between them (I have
two
> > groups separeted in the logs with other messages).
>
> Ok. I'm thinking of just sticking a minimal wait in there to protect
> against absolute runaway, but that should be enough I think.
>
>
> > What do you think ? may be a bug in the windows server installation I have

> > (this machines have not been updated for some times, perhaps I should try
to do
> > that and see if the problem is still there. In the long run, I plan to
upgrade
> > to windows 2003).
>
> I don't *think* it should be a bug with your version, it doesn't look
> like it. but if you're not on the latest service pack, that's certainly
> possible. Please update to latest servicepack + updates from Windows
> Update / WSUS, and let me know if the problem persists.

I AM on the latest service pack (on 2k it would be VERY OLD otherwise), but I
only do an update with windows update once in a year. I'll schedule an update
in the next weeks and keep you informed about the results.

> Meanwhile, I'll try to cook up a patch.


thanks for your help

cyril

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bhavana.Rakesh 2007-05-30 11:36:11 jdbc pg_hba.conf error
Previous Message Purusothaman A 2007-05-30 10:13:37 Re: Corruption of files in PostgreSQL