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

Re: [SQL] PostgreSQL server terminated by signal 11

From: "Daniel Caune" <daniel(dot)caune(at)ubisoft(dot)com>
To: "Jeff Frost" <jeff(at)frostconsultingllc(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [SQL] PostgreSQL server terminated by signal 11
Date: 2006-07-27 20:02:22
Message-ID: 1E293D3FF63A3740B10AD5AAD88535D202B64DBC@UBIMAIL1.ubisoft.org (view raw or flat)
Thread:
Lists: pgsql-admin
> -----Message d'origine-----
> De : jeff(at)glacier(dot)frostconsultingllc(dot)com
> [mailto:jeff(at)glacier(dot)frostconsultingllc(dot)com] De la part de Jeff Frost
> Envoyé : jeudi, juillet 27, 2006 15:36
> À : Daniel Caune
> Cc : pgsql-admin(at)postgresql(dot)org
> Objet : Re: [ADMIN] [SQL] PostgreSQL server terminated by signal 11
> 
> On Thu, 27 Jul 2006, Daniel Caune wrote:
> 
> > Actually ulimit is unlimited for user postgres and when the server was
> terminated the memory used was not that much compared to the machine
> capacity:
> >
> > Mem:   2075860k total,  1663520k used,   412340k free,     5620k buffers
> > Swap:   369452k total,        0k used,   369452k free,  1626176k cached
> >
> > I feel a bit lost, because it was running pretty well for the last
> couple months.  This table is a data stage table where some data are
> imported in from OLTP databases, this every day.  Indexes are dropped
> before inserting data and created when insertion has finished.  The
> structure didn't change since a while.
> 
> Daniel,
> 
> Was this 'free' output before or after the crash? 
>

Yes, it was before the crash.

> Also, have you combed through /var/log/messages for anything interesting
> that happened around the time of the crash?
>

Actually nothing from the last boot...

Jul 27 18:30:40 localhost kernel: FDC 0 is a post-1991 82077
Jul 27 18:30:40 localhost kernel: NET: Registered protocol family 10
Jul 27 18:30:40 localhost kernel: Disabled Privacy Extensions on device c031f0c0(lo)
Jul 27 18:30:40 localhost kernel: IPv6 over IPv4 tunneling driver
Jul 27 18:30:41 localhost lpd[2394]: restarted
Jul 27 18:50:40 localhost -- MARK --
Jul 27 19:10:41 localhost -- MARK --
Jul 27 19:30:41 localhost -- MARK --
Jul 27 19:50:41 localhost -- MARK --

It's easy for me to make the postgres server crashing and tailing the /var/log/messages.  Nothing is logged.

> Which postgresql version is this?
> 

PostgreSQL 8.1.4

I suspect a database corruption or something like this, but I don't know how/what to check and how to fix it if any.

--
Daniel

pgsql-admin by date

Next:From: Tom LaneDate: 2006-07-27 20:05:51
Subject: Re: PostgreSQL server terminated by signal 11
Previous:From: Jeff FrostDate: 2006-07-27 19:35:32
Subject: Re: [SQL] PostgreSQL server terminated by signal 11

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