Re: Out of Memory - 8.2.4

From: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Erik Jones <erik(at)myemma(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Amiel <becauseimjeff(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Out of Memory - 8.2.4
Date: 2007-08-27 16:12:17
Message-ID: 560536.79096.qm@web60815.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--- "Joshua D. Drake" <jd(at)commandprompt(dot)com> wrote:

> We are actually diagnosing a similar problem on this
> end, where we get a
> failure at 1920... I am currently trying to get some
> DEBUG output.

Tracking for last few days.
Does not appear to happen when little or no user
activity (like Saturday) I don't know if that rules
out autovacuum or not (if no update threshholds are
reached, no vacuuming will take place anyway)

Aug 23 11:11:51 db-1 postgres[8455]: [ID 748848
local0.warning] [2-1] 2007-08-23 11:11:51 CDT ERROR:
out of memory
Aug 23 11:11:51 db-1 postgres[8455]: [ID 748848
local0.warning] [2-2] 2007-08-23 11:11:51 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 23 11:34:49 db-1 postgres[8910]: [ID 748848
local0.warning] [2-1] 2007-08-23 11:34:49 CDT ERROR:
out of memory
Aug 23 11:34:49 db-1 postgres[8910]: [ID 748848
local0.warning] [2-2] 2007-08-23 11:34:49 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 23 12:06:47 db-1 postgres[9562]: [ID 748848
local0.warning] [2-1] 2007-08-23 12:06:47 CDT ERROR:
out of memory
Aug 23 12:06:47 db-1 postgres[9562]: [ID 748848
local0.warning] [2-2] 2007-08-23 12:06:47 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 23 12:58:47 db-1 postgres[10617]: [ID 748848
local0.warning] [2-1] 2007-08-23 12:58:47 CDT ERROR:
out of memory
Aug 23 12:58:47 db-1 postgres[10617]: [ID 748848
local0.warning] [2-2] 2007-08-23 12:58:47 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 23 15:15:35 db-1 postgres[13400]: [ID 748848
local0.warning] [2-1] 2007-08-23 15:15:35 CDT ERROR:
out of memory
Aug 23 15:15:35 db-1 postgres[13400]: [ID 748848
local0.warning] [2-2] 2007-08-23 15:15:35 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 23 16:50:47 db-1 postgres[15422]: [ID 748848
local0.warning] [2-1] 2007-08-23 16:50:47 CDT ERROR:
out of memory
Aug 23 16:50:47 db-1 postgres[15422]: [ID 748848
local0.warning] [2-2] 2007-08-23 16:50:47 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 24 10:46:46 db-1 postgres[10508]: [ID 748848
local0.warning] [2-1] 2007-08-24 10:46:46 CDT ERROR:
out of memory
Aug 24 10:46:46 db-1 postgres[10508]: [ID 748848
local0.warning] [2-2] 2007-08-24 10:46:46 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 24 11:29:00 db-1 postgres[11539]: [ID 748848
local0.warning] [2-1] 2007-08-24 11:29:00 CDT ERROR:
out of memory
Aug 24 11:29:00 db-1 postgres[11539]: [ID 748848
local0.warning] [2-2] 2007-08-24 11:29:00 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 24 11:50:04 db-1 postgres[12051]: [ID 748848
local0.warning] [2-1] 2007-08-24 11:50:04 CDT ERROR:
out of memory
Aug 24 11:50:04 db-1 postgres[12051]: [ID 748848
local0.warning] [2-2] 2007-08-24 11:50:04 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 24 12:00:33 db-1 postgres[12310]: [ID 748848
local0.warning] [2-1] 2007-08-24 12:00:33 CDT ERROR:
out of memory
Aug 24 12:00:33 db-1 postgres[12310]: [ID 748848
local0.warning] [2-2] 2007-08-24 12:00:33 CDT
DETAIL: Failed on request of size 536870910.
--
Aug 24 16:03:19 db-1 postgres[18263]: [ID 748848
local0.warning] [2493-1] 2007-08-24 16:03:19.296 CDT
18263ERROR: out of memory
Aug 24 16:03:19 db-1 postgres[18263]: [ID 748848
local0.warning] [2493-2] 2007-08-24 16:03:19.296 CDT
18263DETAIL: Failed on request of size 536870910.
--
Aug 24 16:45:46 db-1 postgres[19313]: [ID 748848
local0.warning] [3356-1] 2007-08-24 16:45:46.804 CDT
19313ERROR: out of memory
Aug 24 16:45:46 db-1 postgres[19313]: [ID 748848
local0.warning] [3356-2] 2007-08-24 16:45:46.804 CDT
19313DETAIL: Failed on request of size 536870910.
--
Aug 24 17:29:16 db-1 postgres[20379]: [ID 748848
local0.warning] [4238-1] 2007-08-24 17:29:16.926 CDT
20379ERROR: out of memory
Aug 24 17:29:16 db-1 postgres[20379]: [ID 748848
local0.warning] [4238-2] 2007-08-24 17:29:16.926 CDT
20379DETAIL: Failed on request of size 536870910.
--
Aug 24 17:40:02 db-1 postgres[20651]: [ID 748848
local0.warning] [4452-1] 2007-08-24 17:40:02.682 CDT
20651ERROR: out of memory
Aug 24 17:40:02 db-1 postgres[20651]: [ID 748848
local0.warning] [4452-2] 2007-08-24 17:40:02.682 CDT
20651DETAIL: Failed on request of size 536870910.
--
Aug 26 11:14:56 db-1 postgres[22161]: [ID 748848
local0.warning] [56115-1] 2007-08-26 11:14:56.077 CDT
22161ERROR: out of memory
Aug 26 11:14:56 db-1 postgres[22161]: [ID 748848
local0.warning] [56115-2] 2007-08-26 11:14:56.077 CDT
22161DETAIL: Failed on request of size 536870910.
--
Aug 26 11:27:41 db-1 postgres[22477]: [ID 748848
local0.warning] [56381-1] 2007-08-26 11:27:41.141 CDT
22477ERROR: out of memory
Aug 26 11:27:41 db-1 postgres[22477]: [ID 748848
local0.warning] [56381-2] 2007-08-26 11:27:41.141 CDT
22477DETAIL: Failed on request of size 536870910.
--
Aug 26 11:37:27 db-1 postgres[22729]: [ID 748848
local0.warning] [56603-1] 2007-08-26 11:37:27.476 CDT
22729ERROR: out of memory
Aug 26 11:37:27 db-1 postgres[22729]: [ID 748848
local0.warning] [56603-2] 2007-08-26 11:37:27.476 CDT
22729DETAIL: Failed on request of size 536870910.
--
Aug 26 13:02:47 db-1 postgres[24831]: [ID 748848
local0.warning] [58357-1] 2007-08-26 13:02:47.721 CDT
24831ERROR: out of memory
Aug 26 13:02:47 db-1 postgres[24831]: [ID 748848
local0.warning] [58357-2] 2007-08-26 13:02:47.721 CDT
24831DETAIL: Failed on request of size 536870910.
--
Aug 26 14:15:54 db-1 postgres[26625]: [ID 748848
local0.warning] [59885-1] 2007-08-26 14:15:54.583 CDT
26625ERROR: out of memory
Aug 26 14:15:54 db-1 postgres[26625]: [ID 748848
local0.warning] [59885-2] 2007-08-26 14:15:54.583 CDT
26625DETAIL: Failed on request of size 536870910.
--
Aug 26 14:38:10 db-1 postgres[27167]: [ID 748848
local0.warning] [60334-1] 2007-08-26 14:38:10.817 CDT
27167ERROR: out of memory
Aug 26 14:38:10 db-1 postgres[27167]: [ID 748848
local0.warning] [60334-2] 2007-08-26 14:38:10.817 CDT
27167DETAIL: Failed on request of size 536870910.
--
Aug 26 14:57:42 db-1 postgres[27662]: [ID 748848
local0.warning] [60748-1] 2007-08-26 14:57:42.690 CDT
27662ERROR: out of memory
Aug 26 14:57:42 db-1 postgres[27662]: [ID 748848
local0.warning] [60748-2] 2007-08-26 14:57:42.690 CDT
27662DETAIL: Failed on request of size 536870910.
--
Aug 26 17:25:41 db-1 postgres[1352]: [ID 748848
local0.warning] [63840-1] 2007-08-26 17:25:41.189 CDT
1352ERROR: out of memory
Aug 26 17:25:41 db-1 postgres[1352]: [ID 748848
local0.warning] [63840-2] 2007-08-26 17:25:41.189 CDT
1352DETAIL: Failed on request of size 536870910.
--
Aug 26 18:10:21 db-1 postgres[2467]: [ID 748848
local0.warning] [64756-1] 2007-08-26 18:10:21.684 CDT
2467ERROR: out of memory
Aug 26 18:10:21 db-1 postgres[2467]: [ID 748848
local0.warning] [64756-2] 2007-08-26 18:10:21.684 CDT
2467DETAIL: Failed on request of size 536870910.
--
Aug 26 18:42:15 db-1 postgres[3246]: [ID 748848
local0.warning] [65420-1] 2007-08-26 18:42:15.973 CDT
3246ERROR: out of memory
Aug 26 18:42:15 db-1 postgres[3246]: [ID 748848
local0.warning] [65420-2] 2007-08-26 18:42:15.973 CDT
3246DETAIL: Failed on request of size 536870910.
--
Aug 27 08:05:48 db-1 postgres[23092]: [ID 748848
local0.warning] [82122-1] 2007-08-27 08:05:48.214 CDT
23092ERROR: out of memory
Aug 27 08:05:48 db-1 postgres[23092]: [ID 748848
local0.warning] [82122-2] 2007-08-27 08:05:48.214 CDT
23092DETAIL: Failed on request of size 536870910.
--
Aug 27 08:25:06 db-1 postgres[23569]: [ID 748848
local0.warning] [82520-1] 2007-08-27 08:25:06.407 CDT
23569ERROR: out of memory
Aug 27 08:25:06 db-1 postgres[23569]: [ID 748848
local0.warning] [82520-2] 2007-08-27 08:25:06.407 CDT
23569DETAIL: Failed on request of size 536870910.
--
Aug 27 08:38:05 db-1 postgres[23909]: [ID 748848
local0.warning] [82785-1] 2007-08-27 08:38:05.991 CDT
23909ERROR: out of memory
Aug 27 08:38:05 db-1 postgres[23909]: [ID 748848
local0.warning] [82785-2] 2007-08-27 08:38:05.991 CDT
23909DETAIL: Failed on request of size 536870910.
--
Aug 27 09:20:09 db-1 postgres[24945]: [ID 748848
local0.warning] [83640-1] 2007-08-27 09:20:09.331 CDT
24945ERROR: out of memory
Aug 27 09:20:09 db-1 postgres[24945]: [ID 748848
local0.warning] [83640-2] 2007-08-27 09:20:09.331 CDT
24945DETAIL: Failed on request of size 536870910.
--
Aug 27 09:30:08 db-1 postgres[25155]: [ID 748848
local0.warning] [83857-1] 2007-08-27 09:30:08.536 CDT
25155ERROR: out of memory
Aug 27 09:30:08 db-1 postgres[25155]: [ID 748848
local0.warning] [83857-2] 2007-08-27 09:30:08.536 CDT
25155DETAIL: Failed on request of size 536870910.
--
Aug 27 09:40:01 db-1 postgres[25396]: [ID 748848
local0.warning] [84040-1] 2007-08-27 09:40:01.195 CDT
25396ERROR: out of memory
Aug 27 09:40:01 db-1 postgres[25396]: [ID 748848
local0.warning] [84040-2] 2007-08-27 09:40:01.195 CDT
25396DETAIL: Failed on request of size 536870910.
--
Aug 27 09:53:16 db-1 postgres[25729]: [ID 748848
local0.warning] [84289-1] 2007-08-27 09:53:16.815 CDT
25729ERROR: out of memory
Aug 27 09:53:16 db-1 postgres[25729]: [ID 748848
local0.warning] [84289-2] 2007-08-27 09:53:16.815 CDT
25729DETAIL: Failed on request of size 536870910.
--
Aug 27 10:46:01 db-1 postgres[27008]: [ID 748848
local0.warning] [85355-1] 2007-08-27 10:46:01.888 CDT
27008ERROR: out of memory
Aug 27 10:46:01 db-1 postgres[27008]: [ID 748848
local0.warning] [85355-2] 2007-08-27 10:46:01.888 CDT
27008DETAIL: Failed on request of size 536870910.


____________________________________________________________________________________
Sick sense of humor? Visit Yahoo! TV's
Comedy with an Edge to see what's on, when.
http://tv.yahoo.com/collections/222

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kamil Srot 2007-08-27 16:37:17 Re: Tables dissapearing
Previous Message Jonah H. Harris 2007-08-27 16:08:17 Re: [HACKERS] Undetected corruption of table files