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

sym39 <marechal.sylvain2@xxxxxxxxx> · Tue, 09 Jun 2015 10:29:39 +0200



    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