| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, "Dorochevsky, Michel" <michel(dot)dorochevsky(at)softcon(dot)de>, pgsql-bugs(at)postgresql(dot)org, Dave Page <dpage(at)postgresql(dot)org> |
| Subject: | Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect |
| Date: | 2007-04-24 04:37:20 |
| Message-ID: | 23704.1177389440@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers pgsql-patches |
I wrote:
> Now to start debugging.
It looks to me like the problem is that AtPrepare_Locks invokes
LockTagIsTemp, and that goes and reads various system catalogs, which
can result in new entries in the LOCALLOCK hash table, which might
result in a bucket split in same, which would result in some entries
possibly being scanned twice by the hash_seq_search scan.
Not sure about good fix, except that AtPrepare is probably a really
bad time to be doing fresh catalog searches.
Also, we have a generic issue that making fresh entries in a hashtable
might result in a concurrent hash_seq_search scan visiting existing
entries more than once; that's definitely not something any of the
existing callers are thinking about.
I'm too tired to think about fixes right now, but we've definitely
found a hotbed of actual and potential bugs.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marcin Waldowski | 2007-04-24 06:11:36 | Re: BUG #3242: FATAL: could not unlock semaphore: error code 298 |
| Previous Message | Tom Lane | 2007-04-24 02:42:38 | Re: BUG #3245: PANIC: failed to re-find shared loc k o b j ect |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-04-24 05:02:40 | Re: TODO idea - implicit constraints across child tables with a common column as primary key (but obviously not a shared index) |
| Previous Message | Greg Smith | 2007-04-24 04:16:38 | Re: Load distributed checkpoint V4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroki Kataoka | 2007-04-24 07:22:39 | Re: Dead Space Map version 3 (simplified) |
| Previous Message | Greg Smith | 2007-04-24 04:16:38 | Re: Load distributed checkpoint V4 |