Odoo 10 and PostgreSQL 9.4 BDR
We are trying to set Odoo10 (One customized MLM Module) with PostgreSQL 9.4 BDR at Debian Linux
When we have done setup Odoo10 database with PostgreSQL 9.4 BDR and trying to start Odoo server. Its provide the error for Primary key is not set for many tables or Drop the particular table, which don't have Primary key.
error
File "/opt/odoo/odoo/addons/project/report/project_report.py", line 88, in init tools.drop_view_if_exists(self._cr, self._table) File "/opt/odoo/odoo/odoo/tools/sql.py", line 5, in drop_view_if_exists cr.execute("DROP view IF EXISTS %s CASCADE" % (viewname,)) File "/opt/odoo/odoo/odoo/sql_db.py", line 141, in wrapper return f(self, *args, **kwargs) File "/opt/odoo/odoo/odoo/sql_db.py", line 218, in execute res = self._obj.execute(query, params) ProgrammingError: "report_project_task_user" is not a view HINT: Use DROP TABLE to remove a table.
**When I am going to create node 1 ==> SELECT bdr.bdr_group_create( local_node_name := 'node1', node_external_dsn := user= dbname= password=);
at my first BDR machine, its provide **warning** like below.**
**warning** HINT: Drop the secondary unique constraint(s), change the table(s) to UNLOGGED if they don't need to be replicated, or exclude the table(s) from the active replication set(s). WARNING: Secondary unique constraint(s) exist on replicated table(s) DETAIL: Table public.mail_wizard_invite_res_partner_rel has secondary unique constraint mail_wizard_invite_res_partne_mail_wizard_invite_id_res_par_key. This may cause unhandled replication conflicts. HINT: Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY. WARNING: Table public.mail_wizard_invite_res_partner_rel has no PRIMARY KEY HINT: Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY. WARNING: Table public.mail_message_mail_channel_rel has no PRIMARY KEY HINT: Tables without a PRIMARY KEY cannot be UPDATEd or DELETEd from, only INSERTed into. Add a PRIMARY KEY. WARNING: Table public.project_tags_project_task_rel has no PRIMARY KEY
Please let me know if any one faced this kind of problem. Please provide the solution on this.
Thank in Advance