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

[Michelle Sullivan]

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/