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

From: Andres Freund <andres(at)2ndquadrant(dot)com>
To: rmelendo(at)teltronic(dot)es
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #12808: BDR lock adding Postgis extension in one node
Date: 2015-02-27 14:24:28
Message-ID: 20150227142428.GS24199@awork2.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ruth Melendo 2015-02-27 14:30:20 Re: BUG #12808: BDR lock adding Postgis extension in one node
Previous Message Daniele Posenato 2015-02-27 12:27:11 Re: BUG #12785: server process (PID 2872) was terminated by exception 0xC0000005