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

Re: seg fault crashed the postmaster

From: Gordon Shannon <gordo169(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: seg fault crashed the postmaster
Date: 2011-01-01 01:55:58
Message-ID: AANLkTiktGQzo6DynsOqoK_N66U-vVDaFgtKmx1se5DDx@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Unfortunately it's now impossible to say how many were updated, as they get
deleted by another process later. I may be able to restore part of a dump
from 2 days ago on another machine, and get some counts from that, assuming
I have the disk space.  I'll work on that.

I do not believe there could have been more than 2 concurrent updates
because the app is limited to 2 threads, but I will verify that with the
developer.

-gordon

On Fri, Dec 31, 2010 at 3:43 PM, Tom Lane-2 [via PostgreSQL] <
ml-node+3323971-508486184-56124(at)n5(dot)nabble(dot)com<ml-node%2B3323971-508486184-56124(at)n5(dot)nabble(dot)com>
> wrote:

>
>
> No luck here either.  A couple further questions --- do you think it's
> likely that you could have been over 10000 matches, ie, the LIMIT
> actually kicked in?  Also, could there have been more than two
> concurrent updates acting on the same rows?
>
>

-- 
View this message in context: http://postgresql.1045698.n5.nabble.com/seg-fault-crashed-the-postmaster-tp3323117p3324015.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

pgsql-general by date

Next:From: Dick KniepDate: 2011-01-01 08:16:30
Subject: Shit happens
Previous:From: Tom LaneDate: 2010-12-31 22:42:33
Subject: Re: seg fault crashed the postmaster

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