pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postmaster terminated without any error message
4+ messages / 3 participants
[nested] [flat]

* Postmaster terminated without any error message
@ 2004-10-08 19:22 roger <roger@tagalder.com>
  2004-10-10 19:29 ` Re: Postmaster terminated without any error message Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: roger @ 2004-10-08 19:22 UTC (permalink / raw)
  To: pgsql-admin

We have Postgresql 7.2 under Redhat 7.2. Postmaster can be started and we can use it without problem. However postmaster will terminate abnormally after 1 or 2 hours and leave no error messages. Next time we brought it up and it will stay for some time time and then shutdown by itself. The following are the log that we put into a file. Please advice what problem may cause this.

postmaster: PostmasterMain: initial environ dump:
-----------------------------------------
        PWD=/home/postgres
        HOSTNAME=tmspac.propagation.net
        LESSOPEN=|/usr/bin/lesspipe.sh %s
        SSH_CONNECTION=69.196.96.92 1202 66.221.32.226 22
        USER=postgres
        LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:
or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.b
at=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;3
1:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31
:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.ti
f=01;35:
        MACHTYPE=i386-redhat-linux-gnu
        MAIL=/var/spool/mail/tmspac
        INPUTRC=/etc/inputrc
        BASH_ENV=/home/tmspac/.bashrc
        LANG=en_US
        LOGNAME=postgres
        SHLVL=3
        SHELL=/bin/bash
        HOSTTYPE=i386
        OSTYPE=linux-gnu
        HISTSIZE=1000
        HOME=/home/postgres
        TERM=vt100
        PATH=/bin:/usr/bin:/usr/local/bin:/usr/local/mysql/bin:/usr/local/java/bin:/home/t
mspac/bin
        SSH_TTY=/dev/pts/0
        OLDPWD=/var/lib/pgsql/data
        _=/usr/bin/postmaster
-----------------------------------------
FindExec: searching PATH ...
ValidateBinary: can't stat "/bin/postgres"
FindExec: found "/usr/bin/postgres" using PATH
invoking IpcMemoryCreate(size=1417216)
FindExec: searching PATH ...
ValidateBinary: can't stat "/bin/postmaster"
FindExec: found "/usr/bin/postmaster" using PATH
2004-10-07 17:13:11 DEBUG:  database system was interrupted at 2004-10-07 15:45:42 CDT
2004-10-07 17:13:11 DEBUG:  checkpoint record is at 0/1B5F88
2004-10-07 17:13:11 DEBUG:  redo record is at 0/1B5F88; undo record is at 0/0; shutdown TR
UE
2004-10-07 17:13:11 DEBUG:  next transaction id: 257; next oid: 32940
2004-10-07 17:13:11 DEBUG:  database system was not properly shut down; automatic recovery
 in progress
2004-10-07 17:13:11 DEBUG:  ReadRecord: record with zero length at 0/1B5FC8
2004-10-07 17:13:11 DEBUG:  redo is not required
2004-10-07 17:13:13 DEBUG:  database system is ready
2004-10-07 17:13:13 DEBUG:  proc_exit(0)
2004-10-07 17:13:13 DEBUG:  shmem_exit(0)
2004-10-07 17:13:13 DEBUG:  exit(0)
2004-10-07 17:13:13 DEBUG:  reaping dead processes
2004-10-07 17:18:15 DEBUG:  proc_exit(0)
2004-10-07 17:18:15 DEBUG:  shmem_exit(0)
2004-10-07 17:18:15 DEBUG:  exit(0)

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postmaster terminated without any error message
  2004-10-08 19:22 Postmaster terminated without any error message roger <roger@tagalder.com>
@ 2004-10-10 19:29 ` Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-10 22:01   ` Re: Postmaster terminated without any error message roger <roger@tagalder.com>
  0 siblings, 1 reply; 4+ messages in thread

From: Tom Lane @ 2004-10-10 19:29 UTC (permalink / raw)
  To: roger <roger@tagalder.com>; +Cc: pgsql-admin

"roger" <roger@tagalder.com> writes:
> We have Postgresql 7.2 under Redhat 7.2. Postmaster can be started and we c=
> an use it without problem. However postmaster will terminate abnormally aft=
> er 1 or 2 hours and leave no error messages.

I suspect you are starting the postmaster under resource constraints
(check "ulimit" settings) or else the postmaster is getting hit by the
kernel's infamous "out-of-memory killer" (google for "OOM kill" for more
info).

In recent Linux kernels you can prevent OOM kills by adjusting the
kernel's memory allocation parameters, but RH 7.2 may be too old to give
you that control.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postmaster terminated without any error message
  2004-10-08 19:22 Postmaster terminated without any error message roger <roger@tagalder.com>
  2004-10-10 19:29 ` Re: Postmaster terminated without any error message Tom Lane <tgl@sss.pgh.pa.us>
@ 2004-10-10 22:01   ` roger <roger@tagalder.com>
  2004-10-11 13:36     ` Re: Postmaster terminated without any error message Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 1 reply; 4+ messages in thread

From: roger @ 2004-10-10 22:01 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

Thanks for your information. I couldn't find the "ulimit" setting in
postgresql.conf. Where can I find it? I use the default settings in pgsql.

Thanks.

Roger Lam
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "roger" <roger@tagalder.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Sunday, October 10, 2004 3:29 PM
Subject: Re: [ADMIN] Postmaster terminated without any error message


> "roger" <roger@tagalder.com> writes:
> > We have Postgresql 7.2 under Redhat 7.2. Postmaster can be started and
we c=
> > an use it without problem. However postmaster will terminate abnormally
aft=
> > er 1 or 2 hours and leave no error messages.
>
> I suspect you are starting the postmaster under resource constraints
> (check "ulimit" settings) or else the postmaster is getting hit by the
> kernel's infamous "out-of-memory killer" (google for "OOM kill" for more
> info).
>
> In recent Linux kernels you can prevent OOM kills by adjusting the
> kernel's memory allocation parameters, but RH 7.2 may be too old to give
> you that control.
>
> regards, tom lane




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Postmaster terminated without any error message
  2004-10-08 19:22 Postmaster terminated without any error message roger <roger@tagalder.com>
  2004-10-10 19:29 ` Re: Postmaster terminated without any error message Tom Lane <tgl@sss.pgh.pa.us>
  2004-10-10 22:01   ` Re: Postmaster terminated without any error message roger <roger@tagalder.com>
@ 2004-10-11 13:36     ` Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Gaetano Mendola @ 2004-10-11 13:36 UTC (permalink / raw)
  To: roger <roger@tagalder.com>

roger wrote:
 > Thanks for your information. I couldn't find the "ulimit" setting in
 > postgresql.conf. Where can I find it? I use the default settings in 
pgsql.
 >

Emh. ulimit is a OS command. Do an:   ulimit -a and let us know...



Regards
Gaetano Mendola




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2004-10-11 13:36 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-08 19:22 Postmaster terminated without any error message roger <roger@tagalder.com>
2004-10-10 19:29 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-10-10 22:01   ` roger <roger@tagalder.com>
2004-10-11 13:36     ` Gaetano Mendola <mendola@bigfoot.com>

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