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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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