Here is my error:

2023-10-23 12:39:34,701 555 ERROR odoo-production odoo.sql_db: bad query: ALTER TABLE "stock_picking_backorder_rel" ADD FOREIGN KEY ("stock_backorder_confirmation_id") REFERENCES "stock_backorder_confirmation"("id") ON DELETE cascade

ERROR: insert or update on table "stock_picking_backorder_rel" violates foreign key constraint "stock_picking_backorder_rel_stock_backorder_confirmation_i_fkey"

DETAIL:  Key (stock_backorder_confirmation_id)=(3640) is not present in table "stock_backorder_confirmation".

looks like something is missing there .

anyone came across something similar in the past?

Any solutions?

Thanks