From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | <erik(dot)myllymaki(at)aviawest(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: logfiles filling up |
Date: | 2006-05-03 16:05:25 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA35363@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hm. Ok.
The log file contains a PID field, IIRC. Does that PID:
1) Stay the same, or change?
2) Match postmaster, or postgres.exe? If postgres.exe, is it just a
backend?
3) If it's just a backend, is it enough to kill off that backend?
//Magnus
> -----Original Message-----
> From: Erik Myllymaki [mailto:erik(dot)myllymaki(at)aviawest(dot)com]
> Sent: Wednesday, May 03, 2006 3:49 PM
> To: Magnus Hagander
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] logfiles filling up
>
> 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
> >>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Erik Myllymaki | 2006-05-03 16:16:57 | Re: logfiles filling up |
Previous Message | Csaba Nagy | 2006-05-03 16:01:10 | Re: The planner chooses seqscan+sort when there is an |