| From: | "Eric B(dot) Ridge" <ebr(at)tcdi(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org, Mike Weber <j_weber(at)tcdi(dot)com> |
| Subject: | Re: Postgres "locked up" |
| Date: | 2009-12-10 23:35:16 |
| Message-ID: | AD850662-B7DC-4FD1-8900-5D6B4D6ABFCE@tcdi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Dec 10, 2009, at 6:28 PM, Tom Lane wrote:
> It looks like somehow the SInvalLock got stuck --- that would account
> for both the stack traces you show.
What's a SInvalLock? I looked at the code/comments for ReceiveSharedInvalidMessages(), but it didn't make much sense out of context.
> I'm not sure though why a "reload" would appear to free things up.
Yeah, that's the most bizarre part. Damn near all the backends issued various commands, then froze again. "reload" seemed the quickest way, under pressure, to send all the backends some kind of signal. I didn't actually expect it to do anything, tho.
> Have you tried restarting the whole database rather than halfway
> measures like "reload"?
That's what we ended up doing, after turning off stats collection and autovacuum. I don't know that those are related or not, but making some change seemed necessary. :( Everything has been fine since.
eric
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2009-12-10 23:42:32 | Re: Restore time differences between full database dumps and separate schema/data dumps |
| Previous Message | Tom Lane | 2009-12-10 23:28:56 | Re: Postgres "locked up" |