From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Assert failure when validating foreign keys |
Date: | 2019-03-24 10:54:53 |
Message-ID: | CAKJS1f_SHKcPYMsi39An5aUjhAcEMZb6Cx1Sj1QWEWSiKJkBVQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
This results in an Assert failure on master and an elog ERROR prior to
c2fe139c201:
create role test_role with login;
create table ref(a int primary key);
grant references on ref to test_role;
set role test_role;
create table t1(a int, b int);
insert into t1 values(1,1);
alter table t1 add constraint t1_b_key foreign key (b) references ref(a);
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
Fails in heapam_tuple_satisfies_snapshot() at
Assert(BufferIsValid(bslot->buffer));
c2fe139c201~1:
ERROR: expected buffer tuple
The test case is just a variation of the case in [1], but a different
bug, so reporting it on a different thread.
I've not looked into the cause or when it started happening.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2019-03-24 11:04:12 | Re: chained transactions |
Previous Message | Julien Rouhaud | 2019-03-24 10:52:52 | Avoid full GIN index scan when possible |