Re: BUG #12808: BDR lock adding Postgis extension in one node

The error got when adding a PostGIS extension from PGAdmin in node 1. =
Extension was created and the depending table too but in node 2 got the =
error when adding the extension because the depending table was not =
created.=20

But, although the problem was originated for this, my main dude is how =
to fix the database then it=C2=B4s locked. What do I have to do? Because =
now, I cannot do any DDL or DML against it.


Ruth Patricia Melendo Ventura
Software Engineer
TELTRONIC, S.A.U.
T: +34 976 465656   Ext. 179
F: +34 976 465722=20
www.teltronic.es


-----Mensaje original-----
De: Andres Freund [mailto:andres@2ndquadrant.com]=20
Enviado el: viernes, 27 de febrero de 2015 15:24
Para: rmelendo@teltronic.es
CC: pgsql-bugs@postgresql.org
Asunto: Re: [BUGS] BUG #12808: BDR lock adding Postgis extension in one =
node

Hi,

On 2015-02-26 16:29:25 +0000, rmelendo@teltronic.es wrote:
> Using BDR with 2 nodes and trying to add a PostGIS extension in node=20
> 1, it adds the extension and automatically adds =
=E2=80=9Cspatial_ref_sys=E2=80=9D.
>=20
> In node2, it tries to add the extension and gets an error because=20
> table =E2=80=9Cspatial_ref_sys=E2=80=9D does not exists. The bbdd gets =
locked after that.

(this isn't the best forum for this, but I don't really know what to =
recommend besides -general)

What's the exact error message? Does it out because of the extension or =
because of inserts into that table?

Which version of bdr does this happen with? Because I seem to recall =
fixing a similar problem... If not, we'll look into the issue.

Greetings,

Andres Freund

--=20
 Andres Freund                       http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services