Re: Out of Memory - 8.2.4

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Out of Memory - 8.2.4
Date: 2007-08-28 20:52:56
Message-ID: 20070828205256.GB21106@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Amiel wrote:
> I notice in the log entries for the out of memory events have no username, database name or host
> identifier (while regular logged events do) Does that mean anything to anybody?
>
> Aug 28 08:25:50 db-1 postgres[29019]: [ID 748848 local0.warning] [111900-1] 2007-08-28
> 08:25:50.081 CDT 29019ERROR: out of memory
> Aug 28 08:25:50 db-1 postgres[29019]: [ID 748848 local0.warning] [111900-2] 2007-08-28
> 08:25:50.081 CDT 29019DETAIL: Failed on request of size 536870910.
>
> (regular log entry)
> Aug 28 08:26:45 db-1 postgres[28785]: [ID 748848 local0.info] [114999-1] 2007-08-28 08:26:45.413
> CDT jboss prod 192.168.20.44 28785LOG: duration: 22606.146 ms execute <unnamed>: select

Interesting. What's your log_line_prefix? Does it have "%q" somewhere?

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-28 20:55:05 Re: Out of Memory - 8.2.4
Previous Message Jeff Amiel 2007-08-28 20:43:38 Re: Out of Memory - 8.2.4