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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #12808: BDR lock adding Postgis extension in one node
Дата
Msg-id 20150227142428.GS24199@awork2.anarazel.de
обсуждение исходный текст
Ответ на BUG #12808: BDR lock adding Postgis extension in one node  (rmelendo@teltronic.es)
Ответы Re: BUG #12808: BDR lock adding Postgis extension in one node
Список 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 по дате отправления:

Предыдущее
От: william.welter@4linux.com.br
Дата:
Сообщение: Re: BUG #12799: libpq - SSL pqsecure_read() doesn't clean openssl error queue before reading
Следующее
От: "Ruth Melendo"
Дата:
Сообщение: Re: BUG #12808: BDR lock adding Postgis extension in one node