This question has been flagged
2 Replies
5447 Views

When trying to import a csv of updated product quantities and cost, Odoo process for about 30 seconds, then just says, "Odoo Server Error." 

This is what I'm trying to import (I'm ignoring all columns except "ID", "supplier_integration_ids/available_quantity", and "supplier_integration_ids/cost_value"):

id,supplier_integration_ids/id,supplier_integration_ids/product,supplier_integration_ids/nts_supplier_id,supplier_integration_ids/available_quantity,supplier_integration_ids/cost_value,default_c
tire.DRT396,__export__.nts_supplier_integration_10032,DRT396,Twin Valley,1,279,DRT396
tire.DRT316,__export__.nts_supplier_integration_10051,DRT316,Twin Valley,2,444,DRT316
tire.DRT362,__export__.nts_supplier_integration_10044,DRT362,Twin Valley,2,380,DRT362
tire.TRD278GY,__export__.nts_supplier_integration_10449,TRD278,Twin Valley,2,111,TRD278
tire.TRR335GY,__export__.nts_supplier_integration_10002,TRR335GY,Twin Valley,2,81,TRR335GY
tire.TRR230,__export__.nts_supplier_integration_10450,TRR230,Twin Valley,4,85,TRR230
tire.4LT317GY,__export__.nts_supplier_integration_10014,4LT317GY,Twin Valley,6,156,4LT317GY
tire.DRT351,__export__.nts_supplier_integration_10439,DRT351,Twin Valley,6,516,DRT351
tire.DRT395,__export__.nts_supplier_integration_10026,DRT395,Twin Valley,6,223,DRT395
tire.TRD395,__export__.nts_supplier_integration_10023,TRD395,Twin Valley,6,200,TRD395
tire.44R295,__export__.nts_supplier_integration_10361,44R295,Twin Valley,8,207,44R295
tire.DRT398,__export__.nts_supplier_integration_10015,DRT398,Twin Valley,10,159,DRT398
tire.TRD398,__export__.nts_supplier_integration_10017,TRD398,Twin Valley,10,161,TRD398
tire.DRT389,__export__.nts_supplier_integration_10440,DRT389,Twin Valley,20,316,DRT389

This is the server log:

Traceback (most recent call last):

File "/opt/odoo/odoo_10/odoo/addons/base/ir/ir_attachment.py", line 100, in _file_read
r = open(full_path,'rb').read().encode('base64')
IOError: [Errno 2] No such file or directory: u'/var/lib/odoo/.local/share/Odoo/filestore/05_2019/1b/1bdd2f86352db984b4bbd34c8e1e43071019aced'
2019-06-19 17:58:24,880 6587 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:24,880 6587 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:24,880 6587 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:24,880 6587 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:24,924 6587 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:27,448 6590 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:27,485 6590 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:27,485 6590 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:27,485 6590 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:27,508 6590 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:27,979 8085 INFO 05_2019 odoo.addons.base.ir.ir_attachment: _read_file reading /var/lib/odoo/.local/share/Odoo/filestore/05_2019/96/96cc6c89a2539bb3e3b08bbbc08c9cb0180984a9
Traceback (most recent call last):
File "/opt/odoo/odoo_10/odoo/addons/base/ir/ir_attachment.py", line 100, in _file_read
r = open(full_path,'rb').read().encode('base64')
IOError: [Errno 2] No such file or directory: u'/var/lib/odoo/.local/share/Odoo/filestore/05_2019/96/96cc6c89a2539bb3e3b08bbbc08c9cb0180984a9'
2019-06-19 17:58:30,006 6593 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:30,006 6593 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:30,006 6593 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:30,006 6593 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:30,029 6593 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:32,713 6596 INFO ? odoo: Odoo version 10.0
2019-06-19 17:58:32,713 6596 INFO ? odoo: Using configuration file at /etc/odoo/odoo.conf
2019-06-19 17:58:32,731 6596 INFO ? odoo: addons paths: ['/var/lib/odoo/.local/share/Odoo/addons/10.0', u'/opt/odoo/custom/addons/modules_for_theme', u'/opt/odoo/nts-internal', u'/opt/odoo/enterprise/addons', u'/opt/odoo/odoo_10/addons', u'/opt/odoo/odoo_10/odoo/addons', '/usr/lib/python2.7/dist-packages/odoo/addons']
2019-06-19 17:58:32,731 6596 INFO ? odoo: database: nts@default:default
2019-06-19 17:58:32,792 6596 INFO ? odoo.service.server: HTTP service (werkzeug) running on 127.0.0.1:8069
2019-06-19 17:58:33,888 8087 INFO 05_2019 odoo.addons.nts_kmtire.models.nts_kmtire: 2081 - 15120
2019-06-19 17:58:34,194 8085 INFO 05_2019 odoo.sql_db: bad query: RELEASE SAVEPOINT model_load_save
2019-06-19 17:58:34,195 8085 INFO 05_2019 odoo.sql_db: bad query: ROLLBACK TO SAVEPOINT model_load_save
2019-06-19 17:58:34,195 8085 ERROR 05_2019 odoo.http: Exception during JSON request handling.
Traceback (most recent call last):
File "/opt/odoo/odoo_10/odoo/http.py", line 642, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "/opt/odoo/nts-internal/newrelic/__init__.py", line 63, in _handle_exception
return wrapped(*args, **kwargs)
File "/opt/odoo/odoo_10/odoo/http.py", line 684, in dispatch
result = self._call_function(**self.params)
File "/opt/odoo/odoo_10/odoo/http.py", line 334, in _call_function
return checked_call(self.db, *args, **kwargs)
File "/opt/odoo/odoo_10/odoo/service/model.py", line 101, in wrapper
return f(dbname, *args, **kwargs)
File "/opt/odoo/odoo_10/odoo/http.py", line 327, in checked_call
result = self.endpoint(*a, **kw)
File "/opt/odoo/odoo_10/odoo/http.py", line 942, in __call__
return self.method(*args, **kw)
File "/opt/odoo/odoo_10/odoo/http.py", line 507, in response_wrap
response = f(*args, **kw)
File "/opt/odoo/odoo_10/addons/web/controllers/main.py", line 892, in call_kw
return self._call_kw(model, method, args, kwargs)
File "/opt/odoo/odoo_10/addons/web/controllers/main.py", line 884, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "/opt/odoo/odoo_10/odoo/api.py", line 689, in call_kw
return call_kw_multi(method, model, args, kwargs)
File "/opt/odoo/odoo_10/odoo/api.py", line 680, in call_kw_multi
result = method(recs, *args, **kwargs)
File "/opt/odoo/enterprise/addons/account_bank_statement_import_csv/wizard/account_bank_statement_import_csv.py", line 159, in do
return super(AccountBankStmtImportCSV, self).do(fields, options, dryrun=dryrun)
File "/opt/odoo/odoo_10/addons/base_import/models/base_import.py", line 690, in do
import_result = model.load(import_fields, data)
File "/opt/odoo/odoo_10/odoo/models.py", line 894, in load
cr.execute('ROLLBACK TO SAVEPOINT model_load_save')
File "/opt/odoo/odoo_10/odoo/sql_db.py", line 154, in wrapper
return f(self, *args, **kwargs)
File "/opt/odoo/odoo_10/odoo/sql_db.py", line 231, in execute
res = self._obj.execute(query, params)
File "/usr/local/lib/python2.7/dist-packages/newrelic-2.78.0.57/newrelic/hooks/database_dbapi2.py", line 22, in execute
*args, **kwargs)
InternalError: no such savepoint

Avatar
Discard

Are you using New Relic for monitoring ? One of the New Relic scripts seems to be triggering the error.

Looking here may provide a clue:

"/usr/local/lib/python2.7/dist-packages/newrelic-2.78.0.57/newrelic/hooks/database_dbapi2.py", line 22

Yeah, that's right, I'm using new relic