This Session's transaction has been rolled back due to a previous exception during flush. To begin a new transaction with this Session, first issue Session.rollback(). Original exception was: (psycopg2.errors.ForeignKeyViolation) insert or update on table "mall_product_snapshots" violates foreign key constraint "mall_product_snapshots_product_code_fkey" DETAIL: Key (product_code)=(HH-2K33-193--2622) is not present in table "product". [SQL: INSERT INTO mall_product_snapshots (mall, item_code, product_code, name, path, raw_json, fetched_at, created_at, updated_at) VALUES (%(mall)s, %(item_code)s, %(product_code)s, %(name)s, %(path)s, %(raw_json)s::JSONB, %(fetched_at)s, %(created_at)s, %(updated_at)s) RETURNING mall_product_snapshots.id] [parameters: {'mall': 'rakuten', 'item_code': 'HH-2K33-193--2622', 'product_code': 'HH-2K33-193--2622', 'name': None, 'path': None, 'raw_json': '{"manageNumber": "2k33-193--2622", "itemNumber": "HH-2K33-193--2622", "itemType": "NORMAL", "title": "YKKAP\\u4ea4\\u63db\\u7528\\u90e8\\u54c1 \\u4e0 ... (16849 characters truncated) ... eatures": {"display": true, "categoryPageViewMode": "GALLERY"}}]}}], "created": "2020-05-16T16:46:05+09:00", "updated": "2025-10-06T14:37:05+09:00"}}', 'fetched_at': datetime.datetime(2026, 7, 23, 2, 58, 48, 262615), 'created_at': datetime.datetime(2026, 7, 23, 2, 58, 48, 262620), 'updated_at': datetime.datetime(2026, 7, 23, 2, 58, 48, 262622)}] (Background on this error at: https://sqlalche.me/e/20/gkpj) (Background on this error at: https://sqlalche.me/e/20/7s2a)