X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B955B9DCA6A; Wed, 21 Dec 2005 16:31:02 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13899-02; Wed, 21 Dec 2005 16:31:03 -0400 (AST) X-Greylist: delayed 00:17:19.424148 by SQLgrey- X-Greylist: from auto-whitelisted by SQLgrey- Received: from thoth.cs.ucr.edu (thoth.cs.ucr.edu [138.23.169.15]) by postgresql.org (Postfix) with ESMTP id 032549DC84A; Wed, 21 Dec 2005 16:00:32 -0400 (AST) Received: from www.cs.ucr.edu (localhost [127.0.0.1]) by thoth.cs.ucr.edu (Postfix) with ESMTP id EB17A6816; Wed, 21 Dec 2005 11:42:55 -0800 (PST) Received: from 138.23.210.20 (SquirrelMail authenticated user barai) by www.cs.ucr.edu with HTTP; Wed, 21 Dec 2005 11:42:56 -0800 (PST) Message-ID: <4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu> Date: Wed, 21 Dec 2005 11:42:56 -0800 (PST) Subject: PostgreSQL crashing From: barai@cs.ucr.edu To: pgsql-general@postgresql.org Cc: pgsql-admin@postgresql.org User-Agent: SquirrelMail/1.4.5 [CVS] MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.276 required=5 tests=[AWL=-0.275, NO_REAL_NAME=0.55] X-Spam-Score: 0.276 X-Spam-Level: X-Archive-Number: 200512/252 X-Sequence-Number: 19972 PostgreSQL runs for a while but always eventually (30min - 2hrs) crashes. I thought it was memory initially but Memtest had no errors after running for a day. I don't think it is a hardware issues because I can run other applications without error. I have ran both version 8.0.3 and 8.1.1 with the same error. I have posted a clipping of the crash from the system log. Any help would be greatly appreciated. Dec 20 17:14:57 server4 kernel: postmaster: page allocation failure. order:0, mode:0xd0 Dec 20 17:14:57 server4 kernel: [] __alloc_pages+0x2e1/0x2f7 Dec 20 17:14:57 server4 kernel: [] __get_free_pages+0x18/0x24 Dec 20 17:14:57 server4 kernel: [] kmem_getpages+0x1c/0xbb Dec 20 17:14:57 server4 kernel: [] cache_grow+0xab/0x138 Dec 20 17:14:57 server4 kernel: [] cache_alloc_refill+0x165/0x19d Dec 20 17:14:57 server4 kernel: [] kmem_cache_alloc+0x51/0x57 Dec 20 17:14:57 server4 kernel: [] mempool_alloc+0xb2/0x135 Dec 20 17:14:57 server4 kernel: [] autoremove_wake_function+0x0/0x2d Dec 20 17:14:57 server4 kernel: [] autoremove_wake_function+0x0/0x2d Dec 20 17:14:57 server4 kernel: [] bio_alloc+0x15/0x168 Dec 20 17:14:57 server4 kernel: [] sync_page_io+0x25/0xa2 Dec 20 17:14:57 server4 kernel: [] write_disk_sb+0x5a/0x86 Dec 20 17:15:01 server4 kernel: [] sync_sbs+0x22/0x2f Dec 20 17:15:01 server4 kernel: [] md_update_sb+0x84/0xc6 Dec 20 17:15:01 server4 kernel: [] md_write_start+0x5e/0x8c Dec 20 17:15:01 server4 kernel: [] make_request+0x22a/0x2b3 [raid1] Dec 20 17:15:01 server4 kernel: [] generic_make_request+0x18e/0x19e Dec 20 17:15:01 server4 kernel: [] submit_bio+0xca/0xd2 Dec 20 17:15:01 server4 kernel: [] test_set_page_writeback+0xad/0xe1 Dec 20 17:15:01 server4 kernel: [] swap_writepage+0x9a/0xa3 Dec 20 17:15:01 server4 kernel: [] pageout+0x8d/0xcc Dec 20 17:15:01 server4 kernel: [] shrink_list+0x207/0x3ed Dec 20 17:15:01 server4 kernel: [] __pagevec_release+0x15/0x1d Dec 20 17:15:01 server4 kernel: [] shrink_cache+0x1dd/0x34d Dec 20 17:15:01 server4 kernel: [] shrink_zone+0xa7/0xb6 Dec 20 17:15:01 server4 kernel: [] shrink_caches+0x4c/0x57 Dec 20 17:15:01 server4 kernel: [] try_to_free_pages+0xc3/0x1a7 Dec 20 17:15:01 server4 kernel: [] __alloc_pages+0x1fe/0x2f7 Dec 20 17:15:01 server4 kernel: [] __get_free_pages+0x18/0x24 Dec 20 17:15:01 server4 kernel: [] kmem_getpages+0x1c/0xbb Dec 20 17:15:01 server4 kernel: [] cache_grow+0xab/0x138 ...