ERPOnline Community Support Forums

Where Odoo enthusiast and the ERPOnline team offer free help and support to Odoo users
  1. SNS Odoo
  2. Developers
  3. Wednesday, 27 December 2017
  4.  Subscribe via email
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


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

General Discussions
  1. 4 posts
  2. 0 subcategories
Agents & Resellers
  1. 0 posts
  2. 0 subcategories
Developers
  1. 34 posts
  2. 0 subcategories
Usage & Implementation
  1. 39 posts
  2. 0 subcategories
Pre-sales Questions
  1. 1 post
  2. 0 subcategories
ERPOnline is a cloud-based solution that hosts the most popular Enterprise Resources Planning solution - Odoo. With ERPOnline, Odoo deployment has never been easier. Consumers are offered with a great possibility to deploy Odoo in one click and run it fast, securely with neither hardware investment nor software installation on individual computers nor any IT effort.

The company

T.V.T Marine Automation Co., Ltd
#40 An Lac 2, So Dau ward, Hong Bang distr., Hai Phong city
Vietnam
Sales This email address is being protected from spambots. You need JavaScript enabled to view it.
Billing This email address is being protected from spambots. You need JavaScript enabled to view it.
Support This email address is being protected from spambots. You need JavaScript enabled to view it.
Back to top