I'm facing an issue while importing products via an Excel file in Odoo 15. The problem only occurs with the product.product model, and the error logs show messages related to missing savepoints and transaction rollbacks. Here is the relevant error output:
odoo.addons.base_import.models.base_import: importing 1 rows...
2025-02-03 14:22:19,864 26276 ERROR import_error odoo.sql_db: bad query: RELEASE SAVEPOINT "46ec9370e23a11efa851612a4112352d416"
ERROR: no existe el �savepoint� �46ed155125d41b8112d416�
2025-02-03 14:22:19,865 26276 ERROR import_error odoo.sql_db: bad query: SELECT value FROM ir_translation
WHERE lang='es_ES' AND type in ('code') AND src='Unknown database error: ''%s''' AND md5(src)=md5('Unknown database error: ''%s''')
ERROR: transacci�n abortada, las �rdenes ser�n ignoradas hasta el fin de bloque de transacci�n
2025-02-03 14:22:19,865 26276 ERROR import_error odoo.sql_db: bad query: ROLLBACK TO SAVEPOINT model_load
ERROR: no existe el �savepoint� �model_load�
2025-02-03 14:22:19,865 26276 ERROR import_error odoo.http: Exception during JSON request handling.
Traceback (most recent call last):
File "C:\Program Files\Odoo 15\server\odoo\addons\base\models\ir_http.py", line 242, in _dispatch
result = request.dispatch()
File "C:\Program Files\Odoo 15\server\odoo\", line 702, in dispatchhttp.py
result = self._call_function(**self.params)
File "C:\Program Files\Odoo 15\server\odoo\http.py", line 368, in _call_function
return checked_call(self.db, *args, **kwargs)
File "C:\Program Files\Odoo 15\server\odoo\service\model.py", line 94, in wrapper
return f(dbname, *args, **kwargs)
File "C:\Program Files\Odoo 15\server\odoo\http.py", line 357, in checked_call
result = self.endpoint(*a, **kw)
File "C:\Program Files\Odoo 15\server\odoo\http.py", line 925, in __call__
return self.method(*args, **kw)
File "C:\Program Files\Odoo 15\server\odoo\http.py", line 546, in response_wrap
response = f(*args, **kw)
File "C:\Program Files\Odoo 15\server\odoo\addons\web\controllers\main.py", line 1324, in call_kw
return self._call_kw(model, method, args, kwargs)
File "C:\Program Files\Odoo 15\server\odoo\addons\web\controllers\main.py", line 1316, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "C:\Program Files\Odoo 15\server\odoo\api.py", line 471, in call_kw
result = _call_kw_multi(method, model, args, kwargs)
File "C:\Program Files\Odoo 15\server\odoo\api.py", line 456, in _call_kw_multi
result = method(recs, *args, **kwargs)
File "C:\Program Files\Odoo 15\server\odoo\addons\base_import\models\base_import.py", line 1387, in execute_import
import_result = model.load(import_fields, merged_data)
File "C:\Program Files\Odoo 15\server\odoo\", line 1218, in loadmodels.py
cr.execute('ROLLBACK TO SAVEPOINT model_load')
File "<decorator-gen-5>", line 2, in execute
File "C:\Program Files\Odoo 15\server\odoo\sql_db.py", line 90, in check
return f(self, *args, **kwargs)
File "C:\Program Files\Odoo 15\server\odoo\sql_db.py", line 311, in execute
res = self._obj.execute(query, params)
Exception
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "C:\Program Files\Odoo 15\server\odoo\", line 658, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "C:\Program Files\Odoo 15\server.py", line 301, in _handle_exception
raise exception.with_traceback(None) from new_cause
psycopg2.errors.InvalidSavepointSpecification: no existe el �savepoint� �model_load�
What I’ve tried so far:
- Checked my custom code: The only modifications to product.product involve updating WooCommerce prices and reassigning duplicate products.
- Tested importing a single product manually: Creating a product via the UI works fine.
- Restarted PostgreSQL and Odoo: The issue persists.
- Checked database locks: No active transactions blocking imports.