I'm trying to upgrade my Odoo11 (to 12) with Openupgrade. I get two errors in the logfile, which I'm not able to interpret and mitigate. It would be nice if somebody could help me or at least point into the right direction.
Thanks in advance for the help!
2022-10-30 12:02:21,795 14285 DEBUG Filmklappen OpenUpgrade: Deleting record for XML-ID mrp.sequence_mrp_prod
│2022-10-30 12:02:21,799 14285 DEBUG Filmklappen OpenUpgrade: Deleting record ir.sequence#37
│2022-10-30 12:02:21,823 14285 ERROR Filmklappen odoo.sql_db: bad query: DELETE FROM ir_sequence WHERE id IN (37)
│ERROR: null value in column "sequence_id" violates not-null constraint
│DETAIL: Failing row contains (6, Manufacturing, 0, 5, null, 16, 16, mrp_operation, null, f, 1, t, t, f, f, t, null, 1, 2018-10-24 17:58:06.305595, 1, 2018-10-24 17:58:06.305595, null).
│CONTEXT: SQL statement "UPDATE ONLY "public"."stock_picking_type" SET "sequence_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "sequence_id""
│
│2022-10-30 12:02:21,824 14285 INFO Filmklappen OpenUpgrade: Error deleting XML-ID mrp.sequence_mrp_prod: IntegrityError('null value in column "sequence_id" violates not-null constraint DETAIL: Failing row contains (6, Manufacturing, 0, 5, null, 16, 16, mrp_operation, null, f, 1, t, t, f, f, t, null, 1, 2018-10-24 17:58:06.305595, 1, 2018-10-24 17:58:06.305595, null).\nCONTEXT: SQL statement "UPDATE ONLY "public"."stock_picking_type" SET "sequence_id" = NULL WHERE $1 OPERATOR(pg_catalog.=) "sequence_id""\n',)
I tried to just delete the "Failing row", but I couldn't.
This is the second error:
│2022-10-30 12:19:25,430 15213 DEBUG Filmklappen OpenUpgrade: 0 rows affected after 0:00:00.000514 running UPDATE ir_model_data SET res_id = 12
│ WHERE model = 'res.users' AND res_id = 1
│ AND (module != 'base' OR name != 'user_root')
│2022-10-30 12:21:05,534 15213 DEBUG Filmklappen OpenUpgrade: 1 rows affected after 0:00:00.001877 running UPDATE "bus_presence"
│ SET "user_id" = 12
│ WHERE "user_id" in (1)
│2022-10-30 12:21:05,586 15213 DEBUG Filmklappen OpenUpgrade: 501 rows affected after 0:00:00.043498 running UPDATE "mrp_production"
│ SET "user_id" = 12
│ WHERE "user_id" in (1)
│2022-10-30 12:21:05,590 15213 DEBUG Filmklappen OpenUpgrade: 1 rows affected after 0:00:00.000752 running UPDATE "product_template"
│ SET "responsible_id" = 12
│ WHERE "responsible_id" in (1)
│2022-10-30 12:21:05,601 15213 DEBUG Filmklappen OpenUpgrade: 2 rows affected after 0:00:00.001254 running UPDATE "team_favorite_user_rel"
│ SET "user_id" = 12
│ WHERE "user_id" in (1)
│2022-10-30 12:21:05,605 15213 ERROR Filmklappen odoo.sql_db: bad query: UPDATE "digest_digest_res_users_rel"
│ SET "res_users_id" = 12
│ WHERE "res_users_id" in (1)
│ERROR: duplicate key value violates unique constraint "digest_digest_res_users_rel_digest_digest_id_res_users_id_key"
│DETAIL: Key (digest_digest_id, res_users_id)=(1, 12) already exists.
│
│2022-10-30 12:21:05,605 15213 ERROR Filmklappen OpenUpgrade: Error after 0:00:00.000786 running UPDATE "digest_digest_res_users_rel"
│ SET "res_users_id" = 12
│ WHERE "res_users_id" in (1)
│2022-10-30 12:21:05,607 15213 ERROR Filmklappen odoo.sql_db: bad query: UPDATE digest_digest_res_users_rel
│ SET "res_users_id" = 12
│ WHERE res_users_id = 1
│ERROR: duplicate key value violates unique constraint "digest_digest_res_users_rel_digest_digest_id_res_users_id_key"
│DETAIL: Key (digest_digest_id, res_users_id)=(1, 12) already exists.
│
│2022-10-30 12:21:05,607 15213 ERROR Filmklappen OpenUpgrade: Error after 0:00:00.000654 running UPDATE digest_digest_res_users_rel
│ SET "res_users_id" = 12
│ WHERE res_users_id = 1
