Buenas a todos,
me paso de nuevo por el foro a ver si alguien ha tenido este problema o sabe como resolverlo.
Estoy actualizando mi bbdd de odoo de la v12 a la v13 con todo bien estructurado, digo esto porque he podido actualizar otras bbdd de odoo sin problema y en esta última me estoy encontrando problemas que no se resolver y lo único que se diferencia de las otras bbdd es que tiene el módulo de punto de venta, el cuál ya he incluido en los módulos a actualizar, como hago con el resto de módulos.
En resumen, que cuando lanzo la actualización con openupgrade, recibo un error en el log al intentar hacer un INSERT en la tabla product_template, indicándome que el name no puede ser NULL. He revisado esa tabla y tampoco existe ningún registro con la ID que me muestra el log (esto lo he hecho en el caso de que pudiese estar dando error por ya existir).
He revisado por el foro, github, y demás y no encuentro que le haya ocurrido a nadie algo parecido, así que entiendo que debe ser de algún problema de datos de mi bbdd pero no se como solucionarlo ni por donde empezar.
Os dejo el error al completo:
2025-11-06 12:42:26,895 13 INFO ddbb_odoo odoo.modules.loading: loading point_of_sale/views/report_userlabel.xml
2025-11-06 12:42:26,909 13 INFO ddbb_odoo odoo.modules.loading: loading point_of_sale/views/report_saledetails.xml
2025-11-06 12:42:26,927 13 INFO ddbb_odoo odoo.modules.loading: loading point_of_sale/views/point_of_sale_dashboard.xml
2025-11-06 12:42:26,972 13 INFO ddbb_odoo odoo.modules.migration: module point_of_sale: Running migration [13.0.1.0.1>] post-migration
2025-11-06 12:42:26,973 13 INFO ddbb_odoo OpenUpgrade: point_of_sale: post-migration script called with version 12.0.1.0.1
2025-11-06 12:42:26,974 13 DEBUG ddbb_odoo OpenUpgrade: 0 rows affected after 0:00:00.000652 running
UPDATE pos_config pc
SET default_cashbox_id = absc.id
FROM account_cashbox_line acl
JOIN account_bank_statement_cashbox absc ON acl.cashbox_id = absc.id
WHERE acl.openupgrade_legacy_13_0_default_pos_id = pc.id
2025-11-06 12:42:27,013 13 DEBUG ddbb_odoo OpenUpgrade: 2 rows affected after 0:00:00.039169 running
UPDATE pos_config pc
SET amount_authorized_diff = aj.openupgrade_legacy_13_0_amount_authorized_diff
FROM account_bank_statement abs
JOIN account_journal aj ON abs.journal_id = aj.id
JOIN pos_session ps ON abs.pos_session_id = ps.id
WHERE ps.config_id = pc.id AND pc.amount_authorized_diff IS NULL
AND aj.openupgrade_legacy_13_0_amount_authorized_diff IS NOT NULL
2025-11-06 12:42:27,258 13 DEBUG ddbb_odoo OpenUpgrade: 3348 rows affected after 0:00:00.244355 running
UPDATE pos_session ps
SET move_id = po.openupgrade_legacy_13_0_account_move
FROM pos_order po
WHERE po.session_id = ps.id AND po.openupgrade_legacy_13_0_account_move IS NOT NULL
AND ps.move_id IS NULL AND ps.state = 'closed'
2025-11-06 12:42:27,338 13 DEBUG ddbb_odoo OpenUpgrade: 2 rows affected after 0:00:00.079656 running
UPDATE pos_order po
SET account_move = am.id
FROM account_invoice ai
JOIN account_move am ON am.old_invoice_id = ai.id
WHERE po.openupgrade_legacy_13_0_invoice_id = ai.id
2025-11-06 12:42:27,338 13 DEBUG ddbb_odoo OpenUpgrade: 0 rows affected after 0:00:00.000369 running
UPDATE pos_config pc
SET barcode_nomenclature_id = rc.nomenclature_id
FROM res_company rc
WHERE pc.company_id = rc.id AND pc.barcode_nomenclature_id IS NULL
2025-11-06 12:42:27,339 13 DEBUG ddbb_odoo OpenUpgrade: 0 rows affected after 0:00:00.000188 running DELETE FROM pos_order_line WHERE order_id IS NULL
2025-11-06 12:42:27,339 13 DEBUG ddbb_odoo OpenUpgrade: Deleting record for XML-ID point_of_sale.pos_sale_journal
2025-11-06 12:42:27,340 13 DEBUG ddbb_odoo OpenUpgrade: Deleting record account.journal#9
2025-11-06 12:42:41,231 13 INFO ddbb_odoo OpenUpgrade: Error deleting XML-ID point_of_sale.pos_sale_journal: ForeignKeyViolation('update or delete on table "account_journal" violates foreign key constraint "account_move_journal_id_fkey" on table "account_move"\nDETAIL: Key (id)=(9) is still referenced from table "account_move".\n')
2025-11-06 12:42:41,232 13 DEBUG ddbb_odoo OpenUpgrade: Deleting record for XML-ID point_of_sale.seq_picking_type_posout
2025-11-06 12:42:41,234 13 DEBUG ddbb_odoo OpenUpgrade: Deleting record ir.sequence#29
2025-11-06 12:42:41,267 13 INFO ddbb_odoo odoo.models.unlink: User #1 deleted ir.model.data records with IDs: [14240]
2025-11-06 12:42:41,267 13 INFO ddbb_odoo odoo.models.unlink: User #1 deleted ir.sequence records with IDs: [29]
2025-11-06 12:42:41,267 13 INFO ddbb_odoo OpenUpgrade: point_of_sale: loading migrations/13.0.1.0.1/noupdate_changes.xml
2025-11-06 12:42:41,284 13 INFO ddbb_odoo odoo.models.unlink: User #1 deleted ir.model.data records with IDs: [14248]
2025-11-06 12:42:41,407 13 INFO ddbb_odoo odoo.models.unlink: User #1 deleted ir.model.data records with IDs: [14245]
2025-11-06 12:42:41,437 13 ERROR ddbb_odoo odoo.sql_db: bad query: INSERT INTO "product_template" ("id", "create_uid", "create_date", "write_uid", "write_date", "active", "available_in_pos", "categ_id", "list_price", "purchase_line_warn", "purchase_method", "purchase_ok", "sale_delay", "sale_ok", "sequence", "tracking", "type", "uom_id", "uom_po_id") VALUES (nextval('product_template_id_seq'), 1, (now() at time zone 'UTC'), 1, (now() at time zone 'UTC'), true, false, 1, '1.00', 'no-message', 'receive', true, 0.0, true, 1, 'none', 'consu', 1, 1) RETURNING id
ERROR: null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
2025-11-06 12:42:41,437 13 ERROR ddbb_odoo OpenUpgrade: point_of_sale: error in migration script /opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/post-migration.py: "null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
" while parsing /opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/noupdate_changes.xml:2, near
<odoo>
<!-- <record id="pos_config_main" model="pos.config">
<field name="picking_type_id"/>
</record>-->
<record id="product_product_consumable" model="product.product">
<field name="default_code">DISC</field>
<!-- <field name="image_1920" type="base64" file="point_of_sale/static/img/product_product_49-image.jpg"/>-->
<field name="list_price">0.00</field>
<field name="name">Discount</field>
<field name="standard_price">0.00</field>
<field name="purchase_ok">False</field>
<field name="weight">0.00</field>
</record>
<record id="product_product_tip" model="product.product">
<!-- <field name="taxes_id" eval="[(5,)]"/>-->
<field name="weight">0.01</field>
</record>
<record id="seq_pos_session" model="ir.sequence">
<field name="padding">5</field>
<field name="prefix">POS/</field>
</record>
</odoo>
2025-11-06 12:42:41,438 13 ERROR ddbb_odoo OpenUpgrade: "null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
" while parsing /opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/noupdate_changes.xml:2, near
<odoo>
<!-- <record id="pos_config_main" model="pos.config">
<field name="picking_type_id"/>
</record>-->
<record id="product_product_consumable" model="product.product">
<field name="default_code">DISC</field>
<!-- <field name="image_1920" type="base64" file="point_of_sale/static/img/product_product_49-image.jpg"/>-->
<field name="list_price">0.00</field>
<field name="name">Discount</field>
<field name="standard_price">0.00</field>
<field name="purchase_ok">False</field>
<field name="weight">0.00</field>
</record>
<record id="product_product_tip" model="product.product">
<!-- <field name="taxes_id" eval="[(5,)]"/>-->
<field name="weight">0.01</field>
</record>
<record id="seq_pos_session" model="ir.sequence">
<field name="padding">5</field>
<field name="prefix">POS/</field>
</record>
</odoo>
Traceback (most recent call last):
File "/opt/openupgrade/odoo/tools/convert.py", line 717, in parse
self._tag_root(de)
File "/opt/openupgrade/odoo/tools/convert.py", line 679, in _tag_root
f(rec)
File "/opt/openupgrade/odoo/tools/convert.py", line 582, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/openupgrade/odoo/models.py", line 4203, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/openupgrade/odoo/models.py", line 4104, in _load_records_create
return self.create(values)
File "<decorator-gen-125>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product.py", line 324, in create
products = super(ProductProduct, self.with_context(create_product_product=True)).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3820, in create
parents = self.env[model_name].create([
File "<decorator-gen-122>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product_template.py", line 380, in create
templates = super(ProductTemplate, self).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3828, in create
records = self._create(data_list)
File "/opt/openupgrade/odoo/models.py", line 3934, in _create
cr.execute(query, params)
File "/opt/openupgrade/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/openupgrade/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/local/lib/python3.8/site-packages/openupgradelib/openupgrade.py", line 2406, in wrapped_function
func(
File "/opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/post-migration.py", line 148, in migrate
openupgrade.load_data(env.cr, 'point_of_sale', 'migrations/13.0.1.0.1/noupdate_changes.xml')
File "/usr/local/lib/python3.8/site-packages/openupgradelib/openupgrade.py", line 389, in load_data
tools.convert_xml_import(env_or_cr, module_name, fp, idref, mode=mode)
File "/opt/openupgrade/odoo/tools/convert.py", line 808, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/openupgrade/odoo/tools/convert.py", line 720, in parse
pycompat.reraise(
File "/opt/openupgrade/odoo/tools/pycompat.py", line 13, in reraise
raise value.with_traceback(tb)
File "/opt/openupgrade/odoo/tools/convert.py", line 717, in parse
self._tag_root(de)
File "/opt/openupgrade/odoo/tools/convert.py", line 679, in _tag_root
f(rec)
File "/opt/openupgrade/odoo/tools/convert.py", line 582, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/openupgrade/odoo/models.py", line 4203, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/openupgrade/odoo/models.py", line 4104, in _load_records_create
return self.create(values)
File "<decorator-gen-125>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product.py", line 324, in create
products = super(ProductProduct, self.with_context(create_product_product=True)).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3820, in create
parents = self.env[model_name].create([
File "<decorator-gen-122>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product_template.py", line 380, in create
templates = super(ProductTemplate, self).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3828, in create
records = self._create(data_list)
File "/opt/openupgrade/odoo/models.py", line 3934, in _create
cr.execute(query, params)
File "/opt/openupgrade/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/openupgrade/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
" while parsing /opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/noupdate_changes.xml:2, near
<odoo>
<!-- <record id="pos_config_main" model="pos.config">
<field name="picking_type_id"/>
</record>-->
<record id="product_product_consumable" model="product.product">
<field name="default_code">DISC</field>
<!-- <field name="image_1920" type="base64" file="point_of_sale/static/img/product_product_49-image.jpg"/>-->
<field name="list_price">0.00</field>
<field name="name">Discount</field>
<field name="standard_price">0.00</field>
<field name="purchase_ok">False</field>
<field name="weight">0.00</field>
</record>
<record id="product_product_tip" model="product.product">
<!-- <field name="taxes_id" eval="[(5,)]"/>-->
<field name="weight">0.01</field>
</record>
<record id="seq_pos_session" model="ir.sequence">
<field name="padding">5</field>
<field name="prefix">POS/</field>
</record>
</odoo>
2025-11-06 12:42:41,441 13 ERROR ddbb_odoo odoo.modules.loading: Error executing post migration script for module point_of_sale
`-> l10n_es_pos
`-> pos_cash_rounding
`-> pos_epson_printer
`-> pos_order_mgmt
: "null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
" while parsing /opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/noupdate_changes.xml:2, near
<odoo>
<!-- <record id="pos_config_main" model="pos.config">
<field name="picking_type_id"/>
</record>-->
<record id="product_product_consumable" model="product.product">
<field name="default_code">DISC</field>
<!-- <field name="image_1920" type="base64" file="point_of_sale/static/img/product_product_49-image.jpg"/>-->
<field name="list_price">0.00</field>
<field name="name">Discount</field>
<field name="standard_price">0.00</field>
<field name="purchase_ok">False</field>
<field name="weight">0.00</field>
</record>
<record id="product_product_tip" model="product.product">
<!-- <field name="taxes_id" eval="[(5,)]"/>-->
<field name="weight">0.01</field>
</record>
<record id="seq_pos_session" model="ir.sequence">
<field name="padding">5</field>
<field name="prefix">POS/</field>
</record>
</odoo>
2025-11-06 12:42:41,448 13 ERROR ddbb_odoo odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/opt/openupgrade/odoo/tools/convert.py", line 717, in parse
self._tag_root(de)
File "/opt/openupgrade/odoo/tools/convert.py", line 679, in _tag_root
f(rec)
File "/opt/openupgrade/odoo/tools/convert.py", line 582, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/openupgrade/odoo/models.py", line 4203, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/openupgrade/odoo/models.py", line 4104, in _load_records_create
return self.create(values)
File "<decorator-gen-125>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product.py", line 324, in create
products = super(ProductProduct, self.with_context(create_product_product=True)).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3820, in create
parents = self.env[model_name].create([
File "<decorator-gen-122>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product_template.py", line 380, in create
templates = super(ProductTemplate, self).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3828, in create
records = self._create(data_list)
File "/opt/openupgrade/odoo/models.py", line 3934, in _create
cr.execute(query, params)
File "/opt/openupgrade/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/openupgrade/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/openupgrade/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/openupgrade/odoo/modules/loading.py", line 487, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "/opt/openupgrade/odoo/modules/loading.py", line 365, in load_marked_modules
loaded, processed = load_module_graph(
File "/opt/openupgrade/odoo/modules/loading.py", line 256, in load_module_graph
migrations.migrate_module(package, 'post')
File "/opt/openupgrade/odoo/modules/migration.py", line 191, in migrate_module
migrate(self.cr, installed_version)
File "/usr/local/lib/python3.8/site-packages/openupgradelib/openupgrade.py", line 2406, in wrapped_function
func(
File "/opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/post-migration.py", line 148, in migrate
openupgrade.load_data(env.cr, 'point_of_sale', 'migrations/13.0.1.0.1/noupdate_changes.xml')
File "/usr/local/lib/python3.8/site-packages/openupgradelib/openupgrade.py", line 389, in load_data
tools.convert_xml_import(env_or_cr, module_name, fp, idref, mode=mode)
File "/opt/openupgrade/odoo/tools/convert.py", line 808, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/openupgrade/odoo/tools/convert.py", line 720, in parse
pycompat.reraise(
File "/opt/openupgrade/odoo/tools/pycompat.py", line 13, in reraise
raise value.with_traceback(tb)
File "/opt/openupgrade/odoo/tools/convert.py", line 717, in parse
self._tag_root(de)
File "/opt/openupgrade/odoo/tools/convert.py", line 679, in _tag_root
f(rec)
File "/opt/openupgrade/odoo/tools/convert.py", line 582, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/openupgrade/odoo/models.py", line 4203, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/openupgrade/odoo/models.py", line 4104, in _load_records_create
return self.create(values)
File "<decorator-gen-125>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product.py", line 324, in create
products = super(ProductProduct, self.with_context(create_product_product=True)).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3820, in create
parents = self.env[model_name].create([
File "<decorator-gen-122>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product_template.py", line 380, in create
templates = super(ProductTemplate, self).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3828, in create
records = self._create(data_list)
File "/opt/openupgrade/odoo/models.py", line 3934, in _create
cr.execute(query, params)
File "/opt/openupgrade/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/openupgrade/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
" while parsing /opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/noupdate_changes.xml:2, near
<odoo>
<!-- <record id="pos_config_main" model="pos.config">
<field name="picking_type_id"/>
</record>-->
<record id="product_product_consumable" model="product.product">
<field name="default_code">DISC</field>
<!-- <field name="image_1920" type="base64" file="point_of_sale/static/img/product_product_49-image.jpg"/>-->
<field name="list_price">0.00</field>
<field name="name">Discount</field>
<field name="standard_price">0.00</field>
<field name="purchase_ok">False</field>
<field name="weight">0.00</field>
</record>
<record id="product_product_tip" model="product.product">
<!-- <field name="taxes_id" eval="[(5,)]"/>-->
<field name="weight">0.01</field>
</record>
<record id="seq_pos_session" model="ir.sequence">
<field name="padding">5</field>
<field name="prefix">POS/</field>
</record>
</odoo>
2025-11-06 12:42:41,450 13 CRITICAL ddbb_odoo odoo.service.server: Failed to initialize database `ddbb_odoo`.
Traceback (most recent call last):
File "/opt/openupgrade/odoo/tools/convert.py", line 717, in parse
self._tag_root(de)
File "/opt/openupgrade/odoo/tools/convert.py", line 679, in _tag_root
f(rec)
File "/opt/openupgrade/odoo/tools/convert.py", line 582, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/openupgrade/odoo/models.py", line 4203, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/openupgrade/odoo/models.py", line 4104, in _load_records_create
return self.create(values)
File "<decorator-gen-125>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product.py", line 324, in create
products = super(ProductProduct, self.with_context(create_product_product=True)).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3820, in create
parents = self.env[model_name].create([
File "<decorator-gen-122>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product_template.py", line 380, in create
templates = super(ProductTemplate, self).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3828, in create
records = self._create(data_list)
File "/opt/openupgrade/odoo/models.py", line 3934, in _create
cr.execute(query, params)
File "/opt/openupgrade/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/openupgrade/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/opt/openupgrade/odoo/service/server.py", line 1194, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "/opt/openupgrade/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry._db, force_demo, status, update_module)
File "/opt/openupgrade/odoo/modules/loading.py", line 487, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "/opt/openupgrade/odoo/modules/loading.py", line 365, in load_marked_modules
loaded, processed = load_module_graph(
File "/opt/openupgrade/odoo/modules/loading.py", line 256, in load_module_graph
migrations.migrate_module(package, 'post')
File "/opt/openupgrade/odoo/modules/migration.py", line 191, in migrate_module
migrate(self.cr, installed_version)
File "/usr/local/lib/python3.8/site-packages/openupgradelib/openupgrade.py", line 2406, in wrapped_function
func(
File "/opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/post-migration.py", line 148, in migrate
openupgrade.load_data(env.cr, 'point_of_sale', 'migrations/13.0.1.0.1/noupdate_changes.xml')
File "/usr/local/lib/python3.8/site-packages/openupgradelib/openupgrade.py", line 389, in load_data
tools.convert_xml_import(env_or_cr, module_name, fp, idref, mode=mode)
File "/opt/openupgrade/odoo/tools/convert.py", line 808, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/openupgrade/odoo/tools/convert.py", line 720, in parse
pycompat.reraise(
File "/opt/openupgrade/odoo/tools/pycompat.py", line 13, in reraise
raise value.with_traceback(tb)
File "/opt/openupgrade/odoo/tools/convert.py", line 717, in parse
self._tag_root(de)
File "/opt/openupgrade/odoo/tools/convert.py", line 679, in _tag_root
f(rec)
File "/opt/openupgrade/odoo/tools/convert.py", line 582, in _tag_record
record = model._load_records([data], self.mode == 'update')
File "/opt/openupgrade/odoo/models.py", line 4203, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
File "/opt/openupgrade/odoo/models.py", line 4104, in _load_records_create
return self.create(values)
File "<decorator-gen-125>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product.py", line 324, in create
products = super(ProductProduct, self.with_context(create_product_product=True)).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3820, in create
parents = self.env[model_name].create([
File "<decorator-gen-122>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/product/models/product_template.py", line 380, in create
templates = super(ProductTemplate, self).create(vals_list)
File "<decorator-gen-111>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/addons/mail/models/mail_thread.py", line 269, in create
threads = super(MailThread, self).create(vals_list)
File "<decorator-gen-3>", line 2, in create
File "/opt/openupgrade/odoo/api.py", line 339, in _model_create_multi
return create(self, arg)
File "/opt/openupgrade/odoo/models.py", line 3828, in create
records = self._create(data_list)
File "/opt/openupgrade/odoo/models.py", line 3934, in _create
cr.execute(query, params)
File "/opt/openupgrade/odoo/sql_db.py", line 173, in wrapper
return f(self, *args, **kwargs)
File "/opt/openupgrade/odoo/sql_db.py", line 250, in execute
res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "name" of relation "product_template" violates not-null constraint
DETAIL: Failing row contains (72413, null, 1, null, null, null, consu, null, 1, 1.00, null, t, t, 1, 1, null, t, null, null, null, 1, 2025-11-06 12:42:21.997882, 1, 2025-11-06 12:42:21.997882, null, null, null, null, null, null, 0, none, null, null, null, f, null, null, receive, no-message, null, null, null, null, null, null).
" while parsing /opt/openupgrade/addons/point_of_sale/migrations/13.0.1.0.1/noupdate_changes.xml:2, near
<odoo>
<!-- <record id="pos_config_main" model="pos.config">
<field name="picking_type_id"/>
</record>-->
<record id="product_product_consumable" model="product.product">
<field name="default_code">DISC</field>
<!-- <field name="image_1920" type="base64" file="point_of_sale/static/img/product_product_49-image.jpg"/>-->
<field name="list_price">0.00</field>
<field name="name">Discount</field>
<field name="standard_price">0.00</field>
<field name="purchase_ok">False</field>
<field name="weight">0.00</field>
</record>
<record id="product_product_tip" model="product.product">
<!-- <field name="taxes_id" eval="[(5,)]"/>-->
<field name="weight">0.01</field>
</record>
<record id="seq_pos_session" model="ir.sequence">
<field name="padding">5</field>
<field name="prefix">POS/</field>
</record>
</odoo>
2025-11-06 12:42:41,450 13 INFO ddbb_odoo odoo.service.server: Initiating shutdown
2025-11-06 12:42:41,450 13 INFO ddbb_odoo odoo.service.server: Hit CTRL-C again or send a second signal to force the shutdown.
2025-11-06 12:42:41,452 13 INFO ddbb_odoo odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 1 connections
Gracias de antemano!