Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group