Out of memory!! EN linux con Postgres :s

From: Edwin Quijada <listas_quijada(at)hotmail(dot)com>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Out of memory!! EN linux con Postgres :s
Date: 2009-09-11 19:28:01
Message-ID: BLU137-W154E4D64B63C4C4D17DC67E3E70@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda


Este error me acaba de salir en uno de mis servidores y la verdad estoy super preocupado.
Mi sistema operativo es debian Etch 4.0 con Postgres 8.3.7

El sistema se frizo y no hacia nada ni podia conectarse nadie solo respondia a los ping
Solo le pude tirar foto a las pantallas q salieron donde decia out of memory

Al rvisar el log de messages consegui esto

Sep 11 14:21:22 diamante kernel: [] out_of_memory+0x25/0x13a
Sep 11 14:21:22 diamante kernel: [] __alloc_pages+0x1f5/0x275
Sep 11 14:21:22 diamante kernel: [] __pte_alloc+0x11/0x74
Sep 11 14:21:22 diamante kernel: [] __handle_mm_fault+0x65/0x740
Sep 11 14:21:22 diamante kernel: [] do_page_fault+0x18a/0x481
Sep 11 14:21:22 diamante kernel: oom-killer: gfp_mask=0x84d0, order=0
Sep 11 14:21:22 diamante kernel: [] out_of_memory+0x25/0x13a
Sep 11 14:21:22 diamante kernel: [] __alloc_pages+0x1f5/0x275
Sep 11 14:21:22 diamante kernel: [] __pte_alloc+0x11/0x74
Sep 11 14:21:22 diamante kernel: [] __handle_mm_fault+0x6d8/0x740
Sep 11 14:21:22 diamante kernel: [] __handle_mm_fault+0x65/0x740
Sep 11 14:21:22 diamante kernel: [] do_page_fault+0x18a/0x481
Sep 11 14:21:22 diamante kernel: [] do_page_fault+0x0/0x481
Sep 11 14:21:22 diamante kernel: [] error_code+0x39/0x40
Sep 11 14:21:22 diamante kernel: Mem-info:
Sep 11 14:21:22 diamante kernel: DMA per-cpu:
Sep 11 14:21:22 diamante kernel: cpu 0 hot: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: cpu 0 cold: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: cpu 1 hot: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: cpu 1 cold: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: cpu 2 hot: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: cpu 2 cold: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: cpu 3 hot: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: cpu 3 cold: high 0, batch 1 used:0
Sep 11 14:21:22 diamante kernel: DMA32 per-cpu: empty
Sep 11 14:21:22 diamante kernel: Normal per-cpu:
Sep 11 14:21:22 diamante kernel: cpu 0 hot: high 186, batch 31 used:30
Sep 11 14:21:22 diamante kernel: cpu 0 cold: high 62, batch 15 used:53
Sep 11 14:21:22 diamante kernel: cpu 1 hot: high 186, batch 31 used:26
Sep 11 14:21:22 diamante kernel: cpu 1 cold: high 62, batch 15 used:58
Sep 11 14:21:22 diamante kernel: cpu 2 hot: high 186, batch 31 used:11
Sep 11 14:21:22 diamante kernel: cpu 2 cold: high 62, batch 15 used:54
Sep 11 14:21:22 diamante kernel: cpu 3 hot: high 186, batch 31 used:154
Sep 11 14:21:22 diamante kernel: cpu 3 cold: high 62, batch 15 used:51
Sep 11 14:21:22 diamante kernel: HighMem per-cpu:
Sep 11 14:21:22 diamante kernel: cpu 0 hot: high 186, batch 31 used:21
Sep 11 14:21:22 diamante kernel: cpu 0 cold: high 62, batch 15 used:57
Sep 11 14:21:22 diamante kernel: cpu 1 hot: high 186, batch 31 used:86
Sep 11 14:21:22 diamante kernel: cpu 1 cold: high 62, batch 15 used:50
Sep 11 14:21:22 diamante kernel: cpu 2 hot: high 186, batch 31 used:14
Sep 11 14:21:22 diamante kernel: cpu 2 cold: high 62, batch 15 used:47
Sep 11 14:21:22 diamante kernel: cpu 3 hot: high 186, batch 31 used:28
Sep 11 14:21:22 diamante kernel: cpu 3 cold: high 62, batch 15 used:58
Sep 11 14:21:22 diamante kernel: Free pages: 7864kB (552kB HighMem)
Sep 11 14:21:22 diamante kernel: Active:641286 inactive:44822 dirty:1 writeback:27 unstable:0 free:1966 slab:13468 mapped:233023 pagetables:202125
Sep 11 14:21:22 diamante kernel: DMA free:3588kB min:68kB low:84kB high:100kB active:0kB inactive:0kB present:16384kB pages_scanned:0 all_unreclaimable? yes
Sep 11 14:21:22 diamante kernel: lowmem_reserve[]: 0 0 880 4080
Sep 11 14:21:22 diamante kernel: DMA32 free:0kB min:0kB low:0kB high:0kB active:0kB inactive:0kB present:0kB pages_scanned:0 all_unreclaimable? no
Sep 11 14:21:22 diamante kernel: lowmem_reserve[]: 0 0 880 4080
Sep 11 14:21:22 diamante kernel: Normal free:3724kB min:3756kB low:4692kB high:5632kB active:664kB inactive:436kB present:901120kB pages_scanned:2246 all_un$
Sep 11 14:21:22 diamante kernel: lowmem_reserve[]: 0 0 0 25600
Sep 11 14:21:22 diamante kernel: HighMem free:552kB min:512kB low:3928kB high:7344kB active:2564480kB inactive:178852kB present:3276800kB pages_scanned:281 $
Sep 11 14:21:22 diamante kernel: lowmem_reserve[]: 0 0 0 0
Sep 11 14:21:22 diamante kernel: DMA: 1*4kB 0*8kB 0*16kB 0*32kB 0*64kB 0*128kB 0*256kB 1*512kB 1*1024kB 1*2048kB 0*4096kB = 3588kB
Sep 11 14:21:22 diamante kernel: DMA32: empty

Sep 11 14:21:22 diamante kernel: Normal: 69*4kB 1*8kB 1*16kB 1*32kB 1*64kB 0*128kB 1*256kB 0*512kB 1*1024kB 1*2048kB 0*4096kB = 3724kB
Sep 11 14:21:22 diamante kernel: HighMem: 40*4kB 1*8kB 0*16kB 0*32kB 0*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 552kB
Sep 11 14:21:22 diamante kernel: Swap cache: add 7801199, delete 7765751, find 3761617/4380188, race 265+430
Sep 11 14:21:22 diamante kernel: Free swap = 1808756kB
Sep 11 14:21:22 diamante kernel: Total swap = 2947888kB
Sep 11 14:21:22 diamante kernel: Free swap: 1808756kB
Sep 11 14:21:22 diamante kernel: [] do_page_fault+0x0/0x481
Sep 11 14:21:22 diamante kernel: [] error_code+0x39/0x40
Sep 11 14:21:22 diamante kernel: Mem-info:
Sep 11 14:21:22 diamante kernel: DMA per-cpu:


Alguein podria darme mas pistas donde seguir investigando para determinar porque paso esto?
Es la primera vez que consigo algo asi :(

Mi server tiene 3GB de Ram
Dell 2850
Disco SCSI
Debian Etch 4.0

*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas

*-Soporte PostgreSQL

*-www.jqmicrosistemas.com
*-809-849-8087
*-------------------------------------------------------*
_________________________________________________________________

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Jaime Casanova 2009-09-11 20:02:07 Re: Out of memory!! EN linux con Postgres :s
Previous Message Hugo Lucero Martinez 2009-09-11 18:41:26 recuperar baase