Postgres Pro
Downloads
Home   >   mailing lists

Re: BDR: DDL lock problem with function inside a schema - Mailing list pgsql-general

From Craig Ringer
Subject Re: BDR: DDL lock problem with function inside a schema
Date
Msg-id CAMsr+YEogQsxZ=yVnwGvOoeyNVSHhAT3zKH53RYeoB2CgfDDJQ@mail.gmail.com
Whole thread Raw
In response to BDR: DDL lock problem with function inside a schema  (sym39 <marechal.sylvain2@gmail.com>)
Responses Re: BDR: DDL lock problem with function inside a schema  (sym39 <marechal.sylvain2@gmail.com>)
List pgsql-general
Tree view


Questions:
---------------
-Is it a known bug? If yes should I report it (and where)?

Please open a report on github for this - https://github.com/2ndQuadrant/bdr/issues
 
-How to recover such DDL lock problems operation without recreating the database? In other words, what is the proper way to cleanly restart both nodes?

Restarting both nodes should be sufficient, and I am surprised to see that is not the case here. This needs more investigation.
 
-Is it a well known method to properly detach and attach nodes?

I'm not sure I understand.

If you mean join and remove nodes, join with bdr.bdr_group_join, remove with bdr.bdr_part_by_node_names .


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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Momentary Delay
Next
From: sym39
Date:
Subject: Re: BDR: DDL lock problem with function inside a schema