[Bucardo-general] Bucardo 4.99.5 failing when adding additional sync
Zbyszek Żółkiewski
zbyszek at onefellow.com
Mon Feb 24 10:32:36 UTC 2014
Hello,
so no one have any idea what is going on?
__
Zbyszek Żółkiewski
On 20 Feb 2014, at 21:27, Zbyszek Żółkiewski <zbyszek at onefellow.com> 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
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
More information about the Bucardo-general
mailing list