row_id: 1778

Column Value
row_id 1778
time_created 2026-06-12 07:47:46.999170
endpoint https://usmall-catalog.shopfans.io/log/product_upload
params
body {"product": {"rating": 4.6, "rating_count": 562, "brand": "M&S US", "name": "4pk Cotton Rich Invisible Trainer Liners\u2122", "description": "These soft cotton rich invisible trainer liners offer comfort with practical silicone grippers that keep them in place during movement. The ankle height design ensures they remain discreetly hidden inside trainers. Featuring anti-bacterial and Freshfeet\u2122 technology for breathable, fresh footwear, while the added stretch provides a neat fit whether you're walking, running or relaxing.\nM&S Collection: Easy-to-wear wardrobe staples that combine classic and contemporary styles.\n\nDetails & care\nDetails\n\u2022 With silicone grippers to keep them in place,\n\u2022 Reinforced heel and toe\n\u2022 Added stretch\n\nComposition\n70% cotton, 26% polyamide and 4% elastane lycra\u00ae\n\nCare\n\u2022 Machine washable\n\u2022 Tumble dry", "data": {"dataFacets": []}, "categories": ["Home > Lingerie > Socks"], "gender": "Lingerie", "product_images": [], "market_id": 125, "remote_code": "P60167369", "is_lost": 0, "variants": [{"remote_code": "P60167369_3-5/Z0", "upc": "000000060205938001", "remote_url": "https://www.marksandspencer.com/us/4pk-cotton-rich-invisible-trainer-liners%E2%84%A2/p/P60167369.html?dwvar_P60167369_color=Z0&dwvar_P60167369_size=3-5&pid=P60167369", "size": "3-5", "origin_color": "WHITE", "price": 15.99, "variant_images": ["https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Z0_X_EC_0", "https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Z0_X_EC_6"], "stock_count": 1, "data": ["transfer"], "image_url": "https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Z0_X_EC_0", "description": "Color: WHITE; Size: 3-5", "colors": ["WHITE"], "combo_key": "3-5WHITE"}, {"remote_code": "P60167369_3-5/Y0", "upc": "000000060209348001", "remote_url": "https://www.marksandspencer.com/us/4pk-cotton-rich-invisible-trainer-liners%E2%84%A2/p/P60167369.html?dwvar_P60167369_color=Y0&dwvar_P60167369_size=3-5&pid=P60167369", "size": "3-5", "origin_color": "BLACK", "price": 15.99, "variant_images": ["https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Y0_X_EC_0", "https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Y0_X_EC_6"], "stock_count": 1, "data": ["transfer"], "image_url": "https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Y0_X_EC_0", "description": "Color: BLACK; Size: 3-5", "colors": ["BLACK"], "combo_key": "3-5BLACK"}, {"remote_code": "P60167369_6-8/Y0", "upc": "000000060209348002", "remote_url": "https://www.marksandspencer.com/us/4pk-cotton-rich-invisible-trainer-liners%E2%84%A2/p/P60167369.html?dwvar_P60167369_color=Y0&dwvar_P60167369_size=6-8&pid=P60167369", "size": "US 8.5-11 (UK 6-8)", "origin_color": "BLACK", "price": 15.99, "variant_images": ["https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Y0_X_EC_0", "https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Y0_X_EC_6"], "stock_count": 1, "data": ["transfer"], "image_url": "https://assets.digitalcontent.marksandspencer.app/image/upload/h_1024,q_100,f_auto,e_sharpen/SD_02_T60_8071_Y0_X_EC_0", "description": "Color: BLACK; Size: US 8.5-11 (UK 6-8)", "colors": ["BLACK"], "combo_key": "US 8.5-11 (UK 6-8)BLACK"}]}, "remote_url": "https://www.marksandspencer.com/us/4pk-cotton-rich-invisible-trainer-liners%E2%84%A2/p/P60167369.html", "parsing_type": "refresh", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'P60167369' - parsed successfully. additional_error_text=''"}
status_code 500
error_text File "/opt/working_folder/middlewares/catch_errors_middleware/catch_500_errors.py", line 15, in dispatch response = await call_next(request) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 84, in call_next raise app_exc File "/usr/local/lib/python3.11/site-packages/starlette/middleware/base.py", line 70, in coro await self.app(scope, receive_or_disconnect, send_no_error) File "/usr/local/lib/python3.11/site-packages/starlette/middleware/cors.py", line 83, in __call__ await self.app(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 79, in __call__ raise exc File "/usr/local/lib/python3.11/site-packages/starlette/middleware/exceptions.py", line 68, in __call__ await self.app(scope, receive, sender) File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 20, in __call__ raise e File "/usr/local/lib/python3.11/site-packages/fastapi/middleware/asyncexitstack.py", line 17, in __call__ await self.app(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 718, in __call__ await route.handle(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 276, in handle await self.app(scope, receive, send) File "/usr/local/lib/python3.11/site-packages/starlette/routing.py", line 66, in app response = await func(request) ^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 274, in app raw_response = await run_endpoint_function( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/fastapi/routing.py", line 193, in run_endpoint_function return await run_in_threadpool(dependant.call, **values) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/starlette/concurrency.py", line 41, in run_in_threadpool return await anyio.to_thread.run_sync(func, *args) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/anyio/to_thread.py", line 33, in run_sync return await get_asynclib().run_sync_in_worker_thread( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 877, in run_sync_in_worker_thread return await future ^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/anyio/_backends/_asyncio.py", line 807, in run result = context.run(func, *args) ^^^^^^^^^^^^^^^^^^^^^^^^ File "/opt/working_folder/api/logging_router/api/product_logging.py", line 308, in log_product_upload db.commit() File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2028, in commit trans.commit(_to_root=True) File "<string>", line 2, in commit File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go ret_value = fn(self, *arg, **kw) ^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1313, in commit self._prepare_impl() File "<string>", line 2, in _prepare_impl File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/state_changes.py", line 139, in _go ret_value = fn(self, *arg, **kw) ^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 1288, in _prepare_impl self.session.flush() File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 4352, in flush self._flush(objects) File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 4487, in _flush with util.safe_reraise(): File "/usr/local/lib/python3.11/site-packages/sqlalchemy/util/langhelpers.py", line 146, in __exit__ raise exc_value.with_traceback(exc_tb) File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 4448, in _flush flush_context.execute() File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py", line 466, in execute rec.execute(self) File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/unitofwork.py", line 642, in execute util.preloaded.orm_persistence.save_obj( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 93, in save_obj _emit_insert_statements( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/persistence.py", line 1233, in _emit_insert_statements result = connection.execute( ^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1418, in execute return meth( ^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection return connection._execute_clauseelement( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1640, in _execute_clauseelement ret = self._execute_context( ^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1846, in _execute_context return self._exec_single_context( ^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1986, in _exec_single_context self._handle_dbapi_exception( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 2355, in _handle_dbapi_exception raise sqlalchemy_exception.with_traceback(exc_info[2]) from e File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/base.py", line 1967, in _exec_single_context self.dialect.do_execute( File "/usr/local/lib/python3.11/site-packages/sqlalchemy/engine/default.py", line 941, in do_execute cursor.execute(statement, parameters)