Hello I am using bucardo to synchronise one database - and it works great. However today i wanted to add additional database for replication and it seems there is some bug, or me doing something wrong, please see my config:
bucardo list all
-- customcodes:
There are no entries in the 'customcode' table.
-- customnames:
No customnames have been added yet
-- customcols:
No customcols have been added yet
-- dbgroups:
Database group: mxsync Members: mx1:source mx2:target
Database group: rcubesync Members: rcubex1:source rcubex2:target
-- databases:
Database: mx1 Status: active Conn: psql -p -U mailreader -d mail
Database: mx2 Status: active Conn: psql -p -U mailreader -d mail -h
mx-2.somehost.com
Database: rcubex1 Status: active Conn: psql -p -U roundcube -d roundcubemail
Database: rcubex2 Status: active Conn: psql -p -U roundcube -d roundcubemail
-h mx-2.somehost.com
-- herds:
Herd: mxherd DB: mx1 Members: public.aliases, public.users
Used in syncs: mxsync
Herd: rcubeherd DB: rcubex1 Members: public.cache_index,
public.cache_messages, public.cache_thread, public.contact_ids,
public.contactgroupmembers, public.contactgroups, public.contactgroups_ids,
public.contacts, public.dictionary, public.identities, public.identity_ids,
public.search_ids, public.searches, public.session, public.system,
public.user_ids, public.users
Used in syncs: rcubesync
-- syncs:
Sync: mxsync Herd: mxherd [Active]
DB group mxsync: mx1 (source) mx2 (target)
Sync: rcubesync Herd: rcubeherd [Active]
DB group rcubesync: rcubex1 (source) rcubex2 (target)
-- tables:
44. Table: public.aliases DB: mx1 PK: alias|email (text|text)
Syncs: mxsync
46. Table: public.cache_index DB: rcubex1 PK: user_id|mailbox
(int4|varchar) Syncs: rcubesync
48. Table: public.cache_messages DB: rcubex1 PK: user_id|mailbox|uid
(int4|varchar|int4) Syncs: rcubesync
49. Table: public.cache_thread DB: rcubex1 PK: user_id|mailbox
(int4|varchar) Syncs: rcubesync
50. Table: public.contactgroupmembers DB: rcubex1 PK:
contactgroup_id|contact_id (int4|int4) Syncs: rcubesync
51. Table: public.contactgroups DB: rcubex1 PK: contactgroup_id (int4)
Syncs: rcubesync
52. Table: public.contacts DB: rcubex1 PK: contact_id (int4)
Syncs: rcubesync
53. Table: public.dictionary DB: rcubex1 PK: user_id|language
(int4|varchar) Syncs: rcubesync
54. Table: public.identities DB: rcubex1 PK: identity_id (int4)
Syncs: rcubesync
55. Table: public.searches DB: rcubex1 PK: search_id (int4)
Syncs: rcubesync
56. Table: public.session DB: rcubex1 PK: sess_id (varchar)
Syncs: rcubesync
57. Table: public.system DB: rcubex1 PK: name (varchar)
Syncs: rcubesync
58. Table: public.users DB: rcubex1 PK: user_id (int4)
45. Table: public.users DB: mx1 PK: email (text)
Syncs: mxsync,rcubesync
-- sequences:
Sequence: public.contactgroups_ids DB: rcubex1
Sequence: public.contact_ids DB: rcubex1
Sequence: public.identity_ids DB: rcubex1
Sequence: public.search_ids DB: rcubex1
Sequence: public.user_ids DB: rcubex1
from this config all seems fine (to me) and correct, until i have added
“rcubesync” all was working fine, but now when bucardo start i got following
error:
(25464) [Thu Feb 20 21:13:22 2014] MCP Activating sync "mxsync"
(25464) [Thu Feb 20 21:13:22 2014] MCP Running validate_sync on "mxsync"
(25464) [Thu Feb 20 21:13:22 2014] MCP Connecting to database "mx1" (source)
(25464) [Thu Feb 20 21:13:22 2014] MCP DB "mx1" Local epoch: 1392927202.36905
DB epoch: 1392927202.36907
(25464) [Thu Feb 20 21:13:22 2014] MCP DB "mx1" Local time: Thu Feb 20 21:13:22
2014 DB time: 2014-02-20 21:13:22.369068+01
(25464) [Thu Feb 20 21:13:22 2014] MCP DB "mx1" Local timezone: CET (+0100) DB
timezone: localtime
(25464) [Thu Feb 20 21:13:22 2014] MCP DB "mx1" Postgres version: 90111
(25464) [Thu Feb 20 21:13:22 2014] MCP DB "mx1" Database port: 5432
(25464) [Thu Feb 20 21:13:22 2014] MCP Connecting to database "mx2" (target)
(25464) [Thu Feb 20 21:13:23 2014] MCP DB "mx2" Local epoch: 1392927203.41941
DB epoch: 1392927203.45948
(25464) [Thu Feb 20 21:13:23 2014] MCP DB "mx2" Local time: Thu Feb 20 21:13:23
2014 DB time: 2014-02-20 21:13:23.459475+01
(25464) [Thu Feb 20 21:13:23 2014] MCP DB "mx2" Local timezone: CET (+0100) DB
timezone: localtime
(25464) [Thu Feb 20 21:13:23 2014] MCP DB "mx2" Postgres version: 90111
(25464) [Thu Feb 20 21:13:23 2014] MCP DB "mx2" Database port: 5432
(25464) [Thu Feb 20 21:13:25 2014] MCP Inspecting source table
"public.aliases" on database "mx1"
(25464) [Thu Feb 20 21:13:25 2014] MCP Inspecting target table
"public.aliases" on database "mx2"
(25464) [Thu Feb 20 21:13:25 2014] MCP Inspecting source table "public.users"
on database "mx1"
(25464) [Thu Feb 20 21:13:26 2014] MCP Inspecting target table
"public.users" on database "mx2"
(25464) [Thu Feb 20 21:13:26 2014] MCP Activating sync "rcubesync"
(25464) [Thu Feb 20 21:13:26 2014] MCP Running validate_sync on "rcubesync"
(25464) [Thu Feb 20 21:13:26 2014] MCP Connecting to database "rcubex1" (source)
(25464) [Thu Feb 20 21:13:26 2014] MCP DB "rcubex1" Local epoch:
1392927206.43815 DB epoch: 1392927206.43817
(25464) [Thu Feb 20 21:13:26 2014] MCP DB "rcubex1" Local time: Thu Feb 20
21:13:26 2014 DB time: 2014-02-20 21:13:26.438167+01
(25464) [Thu Feb 20 21:13:26 2014] MCP DB "rcubex1" Local timezone: CET (+0100)
DB timezone: localtime
(25464) [Thu Feb 20 21:13:26 2014] MCP DB "rcubex1" Postgres version: 90111
(25464) [Thu Feb 20 21:13:26 2014] MCP DB "rcubex1" Database port: 5432
(25464) [Thu Feb 20 21:13:26 2014] MCP Connecting to database "rcubex2" (target)
(25464) [Thu Feb 20 21:13:28 2014] MCP DB "rcubex2" Local epoch:
1392927207.81976 DB epoch: 1392927207.86042
(25464) [Thu Feb 20 21:13:28 2014] MCP DB "rcubex2" Local time: Thu Feb 20
21:13:27 2014 DB time: 2014-02-20 21:13:27.860423+01
(25464) [Thu Feb 20 21:13:28 2014] MCP DB "rcubex2" Local timezone: CET (+0100)
DB timezone: localtime
(25464) [Thu Feb 20 21:13:28 2014] MCP DB "rcubex2" Postgres version: 90111
(25464) [Thu Feb 20 21:13:28 2014] MCP DB "rcubex2" Database port: 5432
(25464) [Thu Feb 20 21:13:32 2014] MCP Inspecting source table
"public.cache_index" on database "rcubex1"
(25464) [Thu Feb 20 21:13:32 2014] MCP Inspecting target table
"public.cache_index" on database "mx2"
(25464) [Thu Feb 20 21:13:33 2014] MCP Warning: Killed (line 5896): DBD::Pg::st
execute failed: ERROR: relation "public.cache_index" does not exist at
/usr/share/perl5/Bucardo.pm line 5896.
(25464) [Thu Feb 20 21:13:34 2014] MCP End of cleanup_mcp. Sys time: Thu Feb 20
21:13:34 2014. Database time: 2014-02-20 21:13:34.602085+01
at the and you can see that somehow bucardo tries to check table
“public.cache_index” on database mx2 - which is not in correct herd! This seems
like bug.
Any help is greatly appreciated!
Thanks!
__
Zbyszek Żółkiewski
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
