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.

But, although the problem was originated for this, my main dude is how to fix the database then it´s 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
www.teltronic.es

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

Hi,

On 2015-02-26 16:29:25 +0000, rmelendo(at)teltronic(dot)es wrote:
> Using BDR with 2 nodes and trying to add a PostGIS extension in node
> 1, it adds the extension and automatically adds “spatial_ref_sys”.
>
> In node2, it tries to add the extension and gets an error because
> table “spatial_ref_sys” 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

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