Search Postgresql Archives

Re: logfiles filling up

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Do you actively use SSL on this server?

//Magnus 

> -----Original Message-----
> From: pgsql-general-owner@xxxxxxxxxxxxxx 
> [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Erik 
> Myllymaki
> Sent: Wednesday, May 03, 2006 3:36 PM
> To: pgsql-general@xxxxxxxxxxxxxx
> 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
> 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux