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

problem with segmentation fault error

From: pg2(at)onet(dot)eu
To: pgsql-bugs(at)postgresql(dot)org
Subject: problem with segmentation fault error
Date: 2010-01-27 21:27:01
Message-ID: Q15353263-46ebc2f731c26ae1f306ecebf2a2ada6@pmq2.m5r2.onet.test.onet.pl (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello,
I've got problem with PostgreSQL crash (today it was twice).

Usually, average load5 is about 16-20. Today I've run new application and load has increased dramatically.

First time before crash load was fast rising from 30 to 70 (log below)
2010-01-27 10:34:01 CET [3931]: [9-1] host=,user=,db= LOG:  server process (PID 24454) was terminated by signal 11: Segmentation fault
2010-01-27 10:34:01 CET [3931]: [10-1] host=,user=,db= LOG:  terminating any other active server processes
2010-01-27 10:34:01 CET [21906]: [1-1] host=X.X.X.X,user=pgmed,db=pgmed WARNING:  terminating connection because of crash of another server process
2010-01-27 10:34:01 CET [21906]: [2-1] host=X.X.X.X,user=pgmed,db=pgmed DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

Second time, load was about 70-80 and processor utilization was almost 100% from 1 hour (log below)
2010-01-27 18:46:06 CET [3931]: [16-1] host=,user=,db= LOG:  server process (PID 28357) was terminated by signal 11: Segmentation fault
2010-01-27 18:46:06 CET [3931]: [17-1] host=,user=,db= LOG:  terminating any other active server processes
2010-01-27 18:46:06 CET [26377]: [3-1] host=X.X.X.X,user=pgmed_app,db=pgmed WARNING:  terminating connection because of crash of another server process
2010-01-27 18:46:06 CET [26377]: [4-1] host=X.X.X.X,user=pgmed_app,db=pgmed DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.

I have 8.4.0 version.

Do you have any idea where problem could be? Is it hardware or rather PostgreSQL configuration problem?
I'll be grateful for any help.

Best regards
PG


Responses

pgsql-bugs by date

Next:From: Jim MlodgenskiDate: 2010-01-27 21:39:00
Subject: Re: Amazon EC2 CPU Utilization
Previous:From: Robert HaasDate: 2010-01-27 21:10:19
Subject: Re: BUG #5297: Add XATMI C API

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