Search Postgresql Archives

Re: Out of Memory - 8.2.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--- "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux