Re: BDR: DDL lock problem with function inside a schema

Le 09/06/2015 02:29, Craig Ringer a écrit :
>
>
> 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
=> https://github.com/2ndQuadrant/bdr/issues/87
>
> -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 .

I was trying to find a way to recover the situation. I though that
detaching all nodes with bdr.bdr_part_by_node_names(), then reattaching
then with bdr.bdr_group_join() could help, but I did not succeed to do it.

In fact, this question is orthogonal / not related to the problem : I
just would like to detach /attach a node dynamically. Is it well
supported / planned to be supported ?

Thanks and Regards,
Sylvain