pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: barai@cs.ucr.edu
To: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: PostgreSQL crashing
Date: Wed, 21 Dec 2005 11:42:56 -0800 (PST)
Message-ID: <4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu> (raw)

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:  [<c0143271>] __alloc_pages+0x2e1/0x2f7
Dec 20 17:14:57 server4 kernel:  [<c014329f>] __get_free_pages+0x18/0x24
Dec 20 17:14:57 server4 kernel:  [<c0145bfc>] kmem_getpages+0x1c/0xbb
Dec 20 17:14:57 server4 kernel:  [<c014674a>] cache_grow+0xab/0x138
Dec 20 17:14:57 server4 kernel:  [<c014693c>] cache_alloc_refill+0x165/0x19d
Dec 20 17:14:57 server4 kernel:  [<c0146b37>] kmem_cache_alloc+0x51/0x57
Dec 20 17:14:57 server4 kernel:  [<c0142019>] mempool_alloc+0xb2/0x135
Dec 20 17:14:57 server4 kernel:  [<c011fec9>]
autoremove_wake_function+0x0/0x2d
Dec 20 17:14:57 server4 kernel:  [<c011fec9>]
autoremove_wake_function+0x0/0x2d
Dec 20 17:14:57 server4 kernel:  [<c015de0e>] bio_alloc+0x15/0x168
Dec 20 17:14:57 server4 kernel:  [<c026c48f>] sync_page_io+0x25/0xa2
Dec 20 17:14:57 server4 kernel:  [<c026d97c>] write_disk_sb+0x5a/0x86
Dec 20 17:15:01 server4 kernel:  [<c026d9ca>] sync_sbs+0x22/0x2f
Dec 20 17:15:01 server4 kernel:  [<c026da5b>] md_update_sb+0x84/0xc6
Dec 20 17:15:01 server4 kernel:  [<c02706b5>] md_write_start+0x5e/0x8c
Dec 20 17:15:01 server4 kernel:  [<f882faf7>] make_request+0x22a/0x2b3
[raid1]
Dec 20 17:15:01 server4 kernel:  [<c02232e4>]
generic_make_request+0x18e/0x19e
Dec 20 17:15:01 server4 kernel:  [<c02233be>] submit_bio+0xca/0xd2
Dec 20 17:15:01 server4 kernel:  [<c0144812>]
test_set_page_writeback+0xad/0xe1
Dec 20 17:15:01 server4 kernel:  [<c0152ad7>] swap_writepage+0x9a/0xa3
Dec 20 17:15:01 server4 kernel:  [<c01487ed>] pageout+0x8d/0xcc
Dec 20 17:15:01 server4 kernel:  [<c0148a33>] shrink_list+0x207/0x3ed
Dec 20 17:15:01 server4 kernel:  [<c0147cb4>] __pagevec_release+0x15/0x1d
Dec 20 17:15:01 server4 kernel:  [<c0148df6>] shrink_cache+0x1dd/0x34d
Dec 20 17:15:01 server4 kernel:  [<c01494b4>] shrink_zone+0xa7/0xb6
Dec 20 17:15:01 server4 kernel:  [<c014950f>] shrink_caches+0x4c/0x57
Dec 20 17:15:01 server4 kernel:  [<c0149606>] try_to_free_pages+0xc3/0x1a7
Dec 20 17:15:01 server4 kernel:  [<c014318e>] __alloc_pages+0x1fe/0x2f7
Dec 20 17:15:01 server4 kernel:  [<c014329f>] __get_free_pages+0x18/0x24
Dec 20 17:15:01 server4 kernel:  [<c0145bfc>] kmem_getpages+0x1c/0xbb
Dec 20 17:15:01 server4 kernel:  [<c014674a>] cache_grow+0xab/0x138
...




view thread (4+ messages)  latest in thread

Message-ID: <4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu>
Permalink:  ../4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu/
Also on:    postgresql.org/message-id/4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: barai@cs.ucr.edu, pgsql-general@postgresql.org
  Subject: Re: PostgreSQL crashing
  In-Reply-To: <4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu>
  References: <4301.138.23.210.20.1135194176.squirrel@www.cs.ucr.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox