[Bucardo-general] Bucardo 4.99.5 failing when adding additional sync
Zbyszek Żółkiewski
zbyszek at onefellow.com
Thu Feb 20 20:27:46 UTC 2014
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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4891 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140220/c31fc4ce/attachment.p7s>
More information about the Bucardo-general
mailing list