Hello, so no one have any idea what is going on?
__ Zbyszek Żółkiewski On 20 Feb 2014, at 21:27, Zbyszek Żółkiewski <[email protected]> wrote: > 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 > > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
