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
