最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

postgresql - Issue Importing product.product in Odoo 15 | Savepoint Error - Stack Overflow

programmeradmin0浏览0评论

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.
发布评论

评论列表(0)

  1. 暂无评论