Re: BUG #12808: BDR lock adding Postgis extension in one node - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #12808: BDR lock adding Postgis extension in one node
Date
Msg-id 20150227142428.GS24199@awork2.anarazel.de
Whole thread Raw
In response to BUG #12808: BDR lock adding Postgis extension in one node  (rmelendo@teltronic.es)
Responses Re: BUG #12808: BDR lock adding Postgis extension in one node  ("Ruth Melendo" <rmelendo@teltronic.es>)
List pgsql-bugs
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 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 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

pgsql-bugs by date:

Previous
From: william.welter@4linux.com.br
Date:
Subject: Re: BUG #12799: libpq - SSL pqsecure_read() doesn't clean openssl error queue before reading
Next
From: "Ruth Melendo"
Date:
Subject: Re: BUG #12808: BDR lock adding Postgis extension in one node