Re: logfiles filling up

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: logfiles filling up
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA35361@algol.sollentuna.se
обсуждение исходный текст
Ответ на logfiles filling up  (Erik Myllymaki <erik.myllymaki@aviawest.com>)
Ответы Re: logfiles filling up  (Erik Myllymaki <erik.myllymaki@aviawest.com>)
Список pgsql-general
Do you actively use SSL on this server?

//Magnus

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Erik Myllymaki
Дата:
Сообщение: Re: logfiles filling up
Следующее
От: Erik Myllymaki
Дата:
Сообщение: Re: logfiles filling up