[Bucardo-general] Seem to have found a bug...

[Michelle Sullivan]

Further testing - this problem does not occur if the second table with
the same name is added through 'bucardo add all tables'

Michelle

Michelle Sullivan wrote:
> Consider the following setup script...
>
> bucardo add database sorbs_corkscrew dbhost=corkscrew.sorbs.net
> dbuser=**** dbpass=**** dbname=sorbs dbtype=postgres dbgroup=sorbs_at1
> .
> .
> .
> bucardo add dbgroup sorbsmasters sorbs_corkscrew:source
> sorbs_helix:source sorbs_gemini:source sorbs_galaxi:source
> bucardo add dbgroup sorbsslaves sorbs_corkscrew:source
> sorbs_helix:source sorbs_gemini:source sorbs_galaxi:source
> .
> .
> .
> .
> .
>
> bucardo add database dns_corkscrew dbhost=corkscrew.sorbs.net
> dbuser=**** dbpass=**** dbname=dns dbtype=postgres dbgroup=dns_at1:source
> .
> .
> .
> .
> bucardo add dbgroup dnsmasters dns_corkscrew:source dns_helix:source
> dns_gemini:source dns_galaxi:source
> bucardo add dbgroup dnsslaves dns_corkscrew:source dns_helix:source
> dns_gemini:source dns_galaxi:source
> .
> .
> .
> .
> .
> .
> .
>
> for a in . . . . . public.domains . . . . .. . . public.wnetassignments
> do
>   bucardo add table $a relgroup=sorbs2 db=sorbs_corkscrew
> done
>
> .
> .
> .
> .
>
> .
> .
> .
> .
>
> for a in public.billing . . . public.domains . . . public.slaves
> do
>   echo "*** bucardo add table $a relgroup=dns db=dns_corkscrew
> makedelta=dnsslaves"
>   bucardo add table $a relgroup=dns db=dns_corkscrew makedelta=dnsslaves
> done
>
> And we get:
>
> The following tables are now part of the relgroup "dns":
>   public.delagation
> *** bucardo add table public.domains relgroup=dns db=dns_corkscrew
> makedelta=dnsslaves
> DBD::Pg::st execute failed: ERROR:  error from Perl function
> "herdcheck": Cannot have relations from different databases in the same
> relgroup (3) at line 17. at /usr/bin/bucardo line 3031.
> *** bucardo add table public.masters relgroup=dns db=dns_corkscrew
> makedelta=dnsslaves
> Added the following tables:
>   public.masters
> The following tables are now part of the relgroup "dns":
>   public.masters
>
> Seems herdcheck is not distinguishing 2 tables with the same name from 2
> different databases on the same host.
>
> Michelle
>
>   


-- 
Michelle Sullivan
http://www.mhix.org/