[Bucardo-general] Sync Issues.

Periko Support pheriko.support at gmail.com
Fri Jan 20 18:43:48 UTC 2017


 Hi.

 We continue our learning curve with bucardo.

 Our masterslave sync stop working, reading the logs I found this:

(9378) [Tue Jan 17 12:41:11 2017] MCP    Inspecting target table
"public.fleet_vehicle_log_fuel" on database "slave"
(9378) [Tue Jan 17 12:41:11 2017] MCP   Inspecting source table
"public.fleet_vehicle_model_vendors" on database "master"
(9378) [Tue Jan 17 12:41:11 2017] MCP    Inspecting target table
"public.fleet_vehicle_model_vendors" on database "slave"
(9378) [Tue Jan 17 12:41:11 2017] MCP    Inspecting target table
"public.form_import_listas" on database "slave"
(9378) [Tue Jan 17 12:41:11 2017] MCP   Inspecting source table
"public.form_bom_analisys" on database "master"
(9378) [Tue Jan 17 12:41:11 2017] MCP    Inspecting target table
"public.form_bom_analisys" on database "slave"
(9378) [Tue Jan 17 12:41:11 2017] MCP Warning: Source database for
sync "masterslave" has column "avg" of table
"public.form_bom_analisys" at position 7 (7), but target database
"slave" has it in position 8 (8)
(9378) [Tue Jan 17 12:41:11 2017] MCP Warning: Source database for
sync "masterslave" has column "categ_id" of table
"public.form_bom_analisys" at position 10 (10), but target database
"slave" has it in position 9 (9)
(9378) [Tue Jan 17 12:41:11 2017] MCP Warning: Source database for
sync "masterslave" has column "product_id" of table
"public.form_bom_analisys" at position 8 (8), but target database
"slave" has it in position 10 (10)
(9378) [Tue Jan 17 12:41:11 2017] MCP Warning: Source database for
sync "masterslave" has column "supply_method" of table
"public.form_bom_analisys" at position 6 (6), but target database
"slave" has it in position 7 (7)
(9378) [Tue Jan 17 12:41:11 2017] MCP Warning: Source database for
sync "masterslave" has column "type_bom" of table
"public.form_bom_analisys" at position 9 (9), but target database
"slave" has it in position 6 (6)
(9378) [Tue Jan 17 12:41:11 2017] MCP Validation of sync masterslave FAILED
(9378) [Tue Jan 17 12:41:11 2017] MCP Active syncs: 0
(9378) [Tue Jan 17 12:41:11 2017] MCP Entering main loop

Exist a way to fix this or we have to manually fix the db?

Let me explain u our plan.

We want to have a master slave setup because we want to have a report
server for openerp(slave), but we are removing reports from the master
and add them to the slave because
we have a R/W database.

Don't know if this is causing this issue, but is the goal we are
trying to accomplish.

Thanks for your help!!!


More information about the Bucardo-general mailing list