From: Tom Lane on 8 Jun 2010 15:35 I wrote: > I realized this while thinking about Jeff Amiel's report here: > http://archives.postgresql.org/pgsql-general/2010-06/msg00351.php > I can't prove that this is what's causing his crashes, but it could > produce the symptom he's reporting. Actually, no it can't: the case I'm envisioning should lead to throwing this error: elog(ERROR, "failed to delete rightmost child %u of block %u in index \"%s\"", target, parent, RelationGetRelationName(rel)); a bit further up. That's annoying enough, but it's not a PANIC. A search of the archives produces no evidence that anyone has ever reported the "failed to delete rightmost child" error from the field. So while I still think this is a bug that needs to be fixed, it may be lower priority than I thought initially. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Bruce Momjian on 2 Jul 2010 19:20 Tom Lane wrote: > I wrote: > > I realized this while thinking about Jeff Amiel's report here: > > http://archives.postgresql.org/pgsql-general/2010-06/msg00351.php > > I can't prove that this is what's causing his crashes, but it could > > produce the symptom he's reporting. > > Actually, no it can't: the case I'm envisioning should lead to throwing > this error: > > elog(ERROR, "failed to delete rightmost child %u of block %u in index \"%s\"", > target, parent, RelationGetRelationName(rel)); > > a bit further up. That's annoying enough, but it's not a PANIC. > > A search of the archives produces no evidence that anyone has ever > reported the "failed to delete rightmost child" error from the field. > So while I still think this is a bug that needs to be fixed, it may > be lower priority than I thought initially. Is this a TODO? -- Bruce Momjian <bruce(a)momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + None of us is going to be here forever. + -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Tom Lane on 2 Jul 2010 22:02 Bruce Momjian <bruce(a)momjian.us> writes: > Tom Lane wrote: >> A search of the archives produces no evidence that anyone has ever >> reported the "failed to delete rightmost child" error from the field. >> So while I still think this is a bug that needs to be fixed, it may >> be lower priority than I thought initially. > Is this a TODO? Possibly. I was planning to go back and study that code a bit more --- I have a feeling that there might be some kind of rare concurrency bug involved in btree page deletion. But I've been up to my rear in other alligators for the past several weeks. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
From: Alvaro Herrera on 3 Jul 2010 22:15 Excerpts from Tom Lane's message of vie jul 02 22:02:59 -0400 2010: > Possibly. I was planning to go back and study that code a bit more --- > I have a feeling that there might be some kind of rare concurrency bug > involved in btree page deletion. But I've been up to my rear in > other alligators for the past several weeks. Judging from the evidence I've seen, I'm fairly sure that there *is* a concurrency bug somewhere in that code. -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
|
Pages: 1 Prev: hstore ==> and deprecate => Next: How about closing some Open Items? |