Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

why cant import a big data .csv

By
Marco Gipp
on 8/27/15, 9:16 AM 484 views

I have a Product .csv with ca. 400.000 Products...

and the import doesnt stop.....i get a error in the odoo-server.log:

I start with:

2015-08-27 12:07:27,022 5030 INFO odoo openerp.addons.base_import.models: importing 409658 rows...


After 1 or 2 ours i get this errors:

--------------------------------------------------------------------------------------------------------------------------------------------------------------

2015-08-27 12:23:46,178 5030 ERROR odoo openerp.sql_db: bad query: INSERT INTO "product_product" ("id", "product_tmpl_id", "active", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('product_product_id_seq'), 214571, true, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

TransactionRollbackError: could not serialize access due to concurrent update

NTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"..

----------------------------------------------------------------------------------------------------------------------------------------------------------------

0
Marco Gipp
On 8/27/15, 9:50 AM

What exactly do you mean ?

am logged in and see the waiting screen....after a wihle i see... hit F5 But

in the linux console i see that the postgre Server work...cpu 60-80%.

(sry 4 my bad english, iam from germany ^^)

see the begining from the log:

2015-08-27 12:07:27,022 5030 INFO odoo openerp.addons.base_import.models: importing 409658 rows...

2015-08-27 12:07:39,789 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:07:39] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:08:29,991 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:08:29] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:09:20,276 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:09:20] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:10:10,453 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:10:10] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:11:00,607 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:11:00] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:11:48,913 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:11:48] "POST /calendar/notify HTTP/1.1" 200 -

2015-08-27 12:11:50,747 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:11:50] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:12:40,859 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:12:40] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:13:30,953 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:13:30] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:14:21,090 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:14:21] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:15:11,174 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:15:11] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:16:01,256 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:16:01] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:16:48,877 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:16:48] "POST /calendar/notify HTTP/1.1" 200 -

2015-08-27 12:16:51,377 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:16:51] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:17:41,478 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:17:41] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:18:31,555 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:18:31] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:19:21,682 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:19:21] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:20:11,795 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:20:11] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:21:01,886 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:21:01] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:21:48,883 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:21:48] "POST /calendar/notify HTTP/1.1" 200 -

2015-08-27 12:21:51,976 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:21:51] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:22:42,078 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:22:42] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:22:51,412 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:22:51] "POST /web/webclient/version_info HTTP/1.1" 200 -

2015-08-27 12:22:51,672 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:22:51] "POST /web/webclient/version_info HTTP/1.1" 200 -

2015-08-27 12:22:51,846 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:22:51] "POST /web/session/get_session_info HTTP/1.1" 200 -

2015-08-27 12:22:52,098 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:22:52] "POST /web/webclient/version_info HTTP/1.1" 200 -

2015-08-27 12:22:52,285 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:22:52] "POST /web/webclient/version_info HTTP/1.1" 200 -

2015-08-27 12:22:52,475 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:22:52] "POST /web/session/get_session_info HTTP/1.1" 200 -

2015-08-27 12:22:52,725 5030 INFO None werkzeug: 176.4.70.175 - - [27/Aug/2015 12:22:52] "POST /web/database/get_list HTTP/1.1" 200 -

2015-08-27 12:23:32,215 5030 INFO odoo werkzeug: 93.220.12.187 - - [27/Aug/2015 12:23:32] "POST /longpolling/poll HTTP/1.1" 200 -

2015-08-27 12:23:45,272 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:23:45] "POST /web/webclient/version_info HTTP/1.1" 200 -

2015-08-27 12:23:45,444 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:23:45] "POST /web/webclient/version_info HTTP/1.1" 200 -

2015-08-27 12:23:45,695 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:23:45] "POST /web/session/get_session_info HTTP/1.1" 200 -

2015-08-27 12:23:46,116 5030 INFO odoo openerp.service.common: successful login from 'webmaster@domain.de' using database 'odoo'

2015-08-27 12:23:46,137 5030 INFO odoo werkzeug: 176.4.70.175 - - [27/Aug/2015 12:23:46] "POST /web/session/authenticate HTTP/1.1" 200 -

2015-08-27 12:23:46,178 5030 ERROR odoo openerp.sql_db: bad query: INSERT INTO "product_product" ("id", "product_tmpl_id", "active", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('product_product_id_seq'), 214571, true, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

TransactionRollbackError: could not serialize access due to concurrent update

CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"

2015-08-27 12:23:46,240 5030 ERROR odoo openerp.sql_db: bad query: INSERT INTO "product_template" ("id", "track_all", "list_price", "track_production", "mes_type", "uom_id", "expense_pdt", "uos_coeff", "sale_ok", "purchase_ok", "track_outgoing", "company_id", "income_pdt", "uom_po_id", "type", "track_incoming", "to_weight", "active", "website_sequence", "rental", "sale_delay", "name", "produce_delay", "available_in_pos", "categ_id", "website_published", "website_size_x", "website_size_y", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('product_template_id_seq'), false, '1.00', false, 'fixed', 1, false, '1.000', true, true, false, 1, false, 1, 'consu', false, false, true, 3056, false, 7.0, 'SONY ERICSSON RAY', 1.0, true, 1, false, 1, 1, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

TransactionRollbackError: could not serialize access due to concurrent update

CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"

2015-08-27 12:23:46,298 5030 ERROR odoo openerp.sql_db: bad query: INSERT INTO "product_template" ("id", "track_all", "list_price", "track_production", "mes_type", "uom_id", "expense_pdt", "uos_coeff", "sale_ok", "purchase_ok", "track_outgoing", "company_id", "income_pdt", "uom_po_id", "type", "track_incoming", "to_weight", "active", "website_sequence", "rental", "sale_delay", "name", "produce_delay", "available_in_pos", "categ_id", "website_published", "website_size_x", "website_size_y", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('product_template_id_seq'), false, '1.00', false, 'fixed', 1, false, '1.000', true, true, false, 1, false, 1, 'consu', false, false, true, 3056, false, 7.0, 'MOTOROLA DEFY', 1.0, true, 1, false, 1, 1, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

TransactionRollbackError: could not serialize access due to concurrent update

CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"

2015-08-27 12:23:46,354 5030 ERROR odoo openerp.sql_db: bad query: INSERT INTO "product_template" ("id", "track_all", "list_price", "track_production", "mes_type", "uom_id", "expense_pdt", "uos_coeff", "sale_ok", "purchase_ok", "track_outgoing", "company_id", "income_pdt", "uom_po_id", "type", "track_incoming", "to_weight", "active", "website_sequence", "rental", "sale_delay", "name", "produce_delay", "available_in_pos", "categ_id", "website_published", "website_size_x", "website_size_y", "create_uid", "write_uid", "create_date", "write_date") VALUES(nextval('product_template_id_seq'), false, '1.00', false, 'fixed', 1, false, '1.000', true, true, false, 1, false, 1, 'consu', false, false, true, 3056, false, 7.0, 'MOTOROLA PRO PLUS', 1.0, true, 1, false, 1, 1, 1, 1, (now() at time zone 'UTC'), (now() at time zone 'UTC')) RETURNING id

Traceback (most recent call last):

File "/opt/odoo/odoo-server/openerp/sql_db.py", line 234, in execute

res = self._obj.execute(query, params)

TransactionRollbackError: could not serialize access due to concurrent update

CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR KEY SHARE OF x"


0
Dr Obx
On 8/27/15, 9:43 AM

Is your machine only logged in while you doing it ?

0
Dr Obx
On 8/27/15, 9:43 AM

Is your machine only logged in while you doing it ?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 8/27/15, 9:16 AM
Seen: 484 times
Last updated: 8/27/15, 9:50 AM