Understand this error

From: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
To: GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Understand this error
Date: 2009-04-30 13:00:54
Message-ID: 584200.48954.qm@web52512.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
my database entry in mode recovery,
analyzing my pg_log I seem this:

system logger process (PID 6517) was terminated by signal 9
background writer process (PID 6519) was terminated by signal 9
terminating any other active server processes

and OS in var/logs:

kernel: [<ffffffff800ba475>] out_of_memory+0x53/0x267
kernel: [<ffffffff8000f012>] __alloc_pages+0x229/0x2b2
kernel: [<ffffffff80031f4b>] read_swap_cache_async+0x45/0xd8
kernel: [<ffffffff800bf60c>] swapin_readahead+0x60/0xd3
kernel: [<ffffffff80008f3a>] __handle_mm_fault+0x952/0xdf2
kernel: [<ffffffff800127fd>] sock_def_readable+0x34/0x5f
kernel: [<ffffffff80251481>] unix_dgram_sendmsg+0x43d/0x4cf
kernel: [<ffffffff800645a5>] do_page_fault+0x4b8/0x81d
kernel: [<ffffffff80037264>] do_sock_write+0xc4/0xce
kernel: [<ffffffff8008630f>] dequeue_task+0x18/0x37
kernel: [<ffffffff80060ab8>] thread_return+0x0/0xea
kernel: [<ffffffff8005be1d>] error_exit+0x0/0x84
kernel: [<ffffffff8008bfb3>] do_syslog+0x173/0x3ae
kernel: [<ffffffff8008bf81>] do_syslog+0x141/0x3ae
kernel: [<ffffffff8009b666>] autoremove_wake_function+0x0/0x2e
kernel: [<ffffffff800f65fd>] kmsg_read+0x3a/0x44
kernel: [<ffffffff8000b212>] vfs_read+0xcb/0x171
kernel: [<ffffffff8001145c>] sys_read+0x45/0x6e
kernel: [<ffffffff8005b2c1>] tracesys+0xd1/0xdc

kernel: Free swap = 0kB
kernel: Total swap = 2031608kB
kernel: Free swap: 0kB
kernel: 4390912 pages of RAM
kernel: 280785 reserved pages
kernel: 10222 pages shared
kernel: 4 pages swap cached
kernel: Out of memory: Killed process 6519 (postmaster).

How prenvent postgres use all memory of system?Why this happen?

Thanks for all
Paulo

Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastian Böhm 2009-04-30 14:42:13 possible consistency problem
Previous Message Grzegorz Buś 2009-04-30 11:57:12 could not bind IPv4 socket