Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
Facebook
Downloads
Home
>
mailing lists
Understand this error - Mailing list pgsql-general
From
paulo matadr
Subject
Understand this error
Date
April 30, 2009
22:24:48
Msg-id
584200.48954.qm@web52512.mail.re2.yahoo.com
Whole thread
Raw
Responses
Re: Understand this error
Re: Understand this error
Re: Understand this error
List
pgsql-general
Tree view
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:
Top 10
-
Celebridades
-
Música
-
Esportes
pgsql-general
by date:
Previous
From:
Craig Ringer
Date:
30 April 2009, 22:23:53
Subject:
Mapping output from a SEQUENCE into something non-repeating/colliding but random-looking?
Next
From:
Alvaro Herrera
Date:
30 April 2009, 22:42:20
Subject:
Re: triggers and execute...
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
I confirm that I have read and accepted PostgresPro’s
Privacy Policy
.
I agree to get Postgres Pro discount offers and other marketing communications.
✖
×
×
Everywhere
Documentation
Mailing list
List:
all lists
pgsql-general
pgsql-hackers
buildfarm-members
pgadmin-hackers
pgadmin-support
pgsql-admin
pgsql-advocacy
pgsql-announce
pgsql-benchmarks
pgsql-bugs
pgsql-chat
pgsql-cluster-hackers
pgsql-committers
pgsql-cygwin
pgsql-docs
pgsql-hackers-pitr
pgsql-hackers-win32
pgsql-interfaces
pgsql-jdbc
pgsql-jobs
pgsql-novice
pgsql-odbc
pgsql-patches
pgsql-performance
pgsql-php
pgsql-pkg-debian
pgsql-pkg-yum
pgsql-ports
pgsql-rrreviewers
pgsql-ru-general
pgsql-sql
pgsql-students
pgsql-testers
pgsql-translators
pgsql-www
psycopg
Period
anytime
within last day
within last week
within last month
within last 6 months
within last year
Sort by
date
reverse date
rank
Services
24×7×365 Technical Support
Migration to PostgreSQL
High Availability Deployment
Database Audit
Remote DBA for PostgreSQL
Products
Postgres Pro Enterprise
Postgres Pro Standard
Cloud Solutions
Postgres Extensions
Resources
Blog
Documentation
Webinars
Videos
Presentations
Community
Events
Training Courses
Books
Demo Database
Mailing List Archives
About
Leadership team
Partners
Customers
In the News
Press Releases
Press Info
By continuing to browse this website, you agree to the use of cookies. Go to
Privacy Policy
.
I accept cookies