Re: logfiles filling up

From: Erik Myllymaki <erik(dot)myllymaki(at)aviawest(dot)com>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: logfiles filling up
Date: 2006-05-03 13:48:38
Message-ID: 4458B4B6.10803@aviawest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

yes I do.

Magnus Hagander wrote:
> 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
>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Javier de la Torre 2006-05-03 14:00:12 psql is slow and it does not take much resources
Previous Message Magnus Hagander 2006-05-03 13:45:04 Re: logfiles filling up