Re: logfiles filling up

Do you actively use SSL on this server?

//Magnus

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Erik
> Myllymaki
> Sent: Wednesday, May 03, 2006 3:36 PM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] logfiles filling up
>
> I will add to my initial post:
>
> This is a fresh install with a small database (30MB over 12
> tables), no other applications on this server and only one
> user - it's a development machine.
>
> And when I say the logfiles "fill up" I mean the entire
> partition fills, rapidly, until there is "no room left on device".
>
> The last time this happened it took less than 10 minutes for
> 7GB to fill.
>
> Seems to happen every couple of days.
>
> Shutting down Postgres and removing the logfiles, and then
> restarting Postgres fixes things temporarily.
>
> Erik Myllymaki wrote:
> > I'm running Postgresql 8.1.3 on Windows 2003.
> >
> > logfiles fill with the following line:
> >
> > "SSL SYSCALL error: A blocking operation was interrupted by
> a call to
> > WSACancelBlockingCall."
> >
> > Any ideas?
> >
> > Thanks.
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 9: In versions below 8.0, the planner will ignore your desire to
> > choose an index scan if your joining column's datatypes do not
> > match
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>