--- "Joshua D. Drake" <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly