Thread: winsock error 10004

winsock error 10004

From
Cédric Villemain
Date:
Hi,

I get the following error with postgresql 8.2.7 on a "Microsoft windows server
2003 R2 Standard Edition Service pack 1" :

« LOG:  could not rename temporary statistics file "global/pgstat.tmp"
to "global/pgstat.stat": iso-8859-1 winsock error 10004 »

It happens frequently, without using SSL (I have seen some post relative to
SSL with windows).

Any idea ?

--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org

Re: winsock error 10004

From
Craig Ringer
Date:
Cédric Villemain wrote:
> Hi,
>
> I get the following error with postgresql 8.2.7 on a "Microsoft windows server
> 2003 R2 Standard Edition Service pack 1" :
>
> « LOG:  could not rename temporary statistics file "global/pgstat.tmp"
> to "global/pgstat.stat": Unknown winsock error 10004 »
>
> It happens frequently, without using SSL (I have seen some post relative to
> SSL with windows).
>
> Any idea ?

The usual question with weird Windows errors: Do you have a virus
scanner? If so, have you tried completely disabling it or uninstalling
it (NOT just excluding PostgreSQL) and re-tested?

--
Craig Ringer

Re: winsock error 10004

From
Cédric Villemain
Date:
Le Monday 21 July 2008, Craig Ringer a écrit :
> Cédric Villemain wrote:
> > Hi,
> >
> > I get the following error with postgresql 8.2.7 on a "Microsoft windows
> > server 2003 R2 Standard Edition Service pack 1" :
> >
> > « LOG:  could not rename temporary statistics file "global/pgstat.tmp"
> > to "global/pgstat.stat": iso-8859-1 winsock error 10004 »
> >
> > It happens frequently, without using SSL (I have seen some post relative
> > to SSL with windows).
> >
> > Any idea ?
>
> The usual question with weird Windows errors: Do you have a virus
> scanner? If so, have you tried completely disabling it or uninstalling
> it (NOT just excluding PostgreSQL) and re-tested?

Unfortunely, there are no virus scanner or things like that in the server.

>
> --
> Craig Ringer



--
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org

Re: winsock error 10004

From
Rainer Bauer
Date:
Cédric Villemain wrote:

>I get the following error with postgresql 8.2.7 on a "Microsoft windows server
>2003 R2 Standard Edition Service pack 1" :
>
>« LOG:  could not rename temporary statistics file "global/pgstat.tmp"
>to "global/pgstat.stat": Unknown winsock error 10004 »

10004 is WSAEINTR: Interrupted function call (a blocking operation was
interrupted by a call to WSACancelBlockingCall).

Not sure what happens in your case, but I was able to dig up this thread:
<http://archives.postgresql.org/pgsql-patches/2006-04/msg00034.php>

Maybe Magnus or some other Win32 hacker can shed some light on it.

Rainer

Re: winsock error 10004

From
Valentin Bogdanov
Date:
It's a long shot but I found another interesting info which might be the ca=
use for this error.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3D2471447&SiteID=3D1


Regards

Val


--- On Mon, 21/7/08, Rainer Bauer <usenet@munnin.com> wrote:

> From: Rainer Bauer <usenet@munnin.com>
> Subject: Re: [BUGS] winsock error 10004
> To: pgsql-bugs@postgresql.org
> Date: Monday, 21 July, 2008, 11:41 AM
> C=E9dric Villemain wrote:
>=20
> >I get the following error with postgresql 8.2.7 on a
> "Microsoft windows server=20
> >2003 R2 Standard Edition Service pack 1" :
> >
> >=AB LOG:  could not rename temporary statistics file
> "global/pgstat.tmp"=20
> >to "global/pgstat.stat": Unknown winsock
> error 10004 =BB
>=20
> 10004 is WSAEINTR: Interrupted function call (a blocking
> operation was
> interrupted by a call to WSACancelBlockingCall).
>=20
> Not sure what happens in your case, but I was able to dig
> up this thread:
> <http://archives.postgresql.org/pgsql-patches/2006-04/msg00034.php>
>=20
> Maybe Magnus or some other Win32 hacker can shed some light
> on it.
>=20
> Rainer
>=20
> --=20
> Sent via pgsql-bugs mailing list
> (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs


      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now=
 at Yahoo! http://uk.docs.yahoo.com/ymail/new.html