| body |
{"product": {"rating": null, "rating_count": null, "brand": "FARM TO HOME", "name": "Farm To Home Organic Cotton Cover Wavy Channel Down Alternative Mattress Pad", "description": "Add an extra layer of comfort and support to your bed with this cozy mattress pad from Farm to Home. \nClick this BED & BATH GUIDE to find the perfect fit and more!\nPRODUCT FEATURES\n \nBreathable\n \nMedium\n \nStretch skirt\n \n220 thread count in wavy channel pattern\n \nFits most mattresses up to 20 inches deep\nSIZING\n \nTwin: 39\" x 75\", 9-oz. fill weight\n \nFull: 54\" x 75\", 10-oz. fill weight\n \nQueen: 60\" x 80\", 13-oz. fill weight\n \nKing: 78\" x 80\", 15-oz. fill weight\n \nCal King: 72\" x 84\", 19-oz. fill weight\nCONSTRUCTION & CARE\n \nCover material: organic cotton\n \nFill material: polyester\n \nMachine wash\n \nImported\n \nLaw Label\nSUSTAINABILITY FEATURES\n \nOrganic cotton\n \nGlobal Organic Textile Standard Certified", "data": {"dataFacets": []}, "gender": "unisex", "categories": ["Bedding > Mattress Protection > Mattress Pads"], "product_images": [], "market_id": 20, "remote_code": "6153538", "is_lost": 0, "variants": [{"remote_code": "66447340", "upc": "000788904044923", "email_meta": "6153538", "remote_url": "https://www.kohls.com/product/prd-6153538/~.jsp?skuId=66447340", "size": "TWIN", "origin_color": "White", "price": 35.74, "price_full": 64.99, "variant_images": ["https://media.kohlsimg.com/is/image/kohls/6153538", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT2?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT3?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT4?wid=600&hei=600"], "stock_count": 1, "data": ["transfer"], "image_url": "https://media.kohlsimg.com/is/image/kohls/6153538", "description": "Color: White; Size: TWIN", "colors": ["White"]}, {"remote_code": "73052029", "upc": "000788904044930", "email_meta": "6153538", "remote_url": "https://www.kohls.com/product/prd-6153538/~.jsp?skuId=73052029", "size": "TWIN XL", "origin_color": "White", "price": 38.49, "price_full": 69.99, "variant_images": ["https://media.kohlsimg.com/is/image/kohls/6153538", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT2?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT3?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT4?wid=600&hei=600"], "stock_count": 1, "data": ["transfer"], "image_url": "https://media.kohlsimg.com/is/image/kohls/6153538", "description": "Color: White; Size: TWIN XL", "colors": ["White"]}, {"remote_code": "45949845", "upc": "000788904044947", "email_meta": "6153538", "remote_url": "https://www.kohls.com/product/prd-6153538/~.jsp?skuId=45949845", "size": "FULL", "origin_color": "White", "price": 46.74, "price_full": 84.99, "variant_images": ["https://media.kohlsimg.com/is/image/kohls/6153538", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT2?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT3?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT4?wid=600&hei=600"], "stock_count": 1, "data": ["transfer"], "image_url": "https://media.kohlsimg.com/is/image/kohls/6153538", "description": "Color: White; Size: FULL", "colors": ["White"]}, {"remote_code": "46956917", "upc": "000788904044954", "email_meta": "6153538", "remote_url": "https://www.kohls.com/product/prd-6153538/~.jsp?skuId=46956917", "size": "QUEEN", "origin_color": "White", "price": 52.24, "price_full": 94.99, "variant_images": ["https://media.kohlsimg.com/is/image/kohls/6153538", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT2?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT3?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT4?wid=600&hei=600"], "stock_count": 1, "data": ["transfer"], "image_url": "https://media.kohlsimg.com/is/image/kohls/6153538", "description": "Color: White; Size: QUEEN", "colors": ["White"]}, {"remote_code": "44189874", "upc": "000788904044961", "email_meta": "6153538", "remote_url": "https://www.kohls.com/product/prd-6153538/~.jsp?skuId=44189874", "size": "KING", "origin_color": "White", "price": 65.99, "price_full": 119.99, "variant_images": ["https://media.kohlsimg.com/is/image/kohls/6153538", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT2?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT3?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT4?wid=600&hei=600"], "stock_count": 1, "data": ["transfer"], "image_url": "https://media.kohlsimg.com/is/image/kohls/6153538", "description": "Color: White; Size: KING", "colors": ["White"]}, {"remote_code": "47570282", "upc": "000788904044978", "email_meta": "6153538", "remote_url": "https://www.kohls.com/product/prd-6153538/~.jsp?skuId=47570282", "size": "CAL KING", "origin_color": "White", "price": 63.24, "price_full": 114.99, "variant_images": ["https://media.kohlsimg.com/is/image/kohls/6153538", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT2?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT3?wid=600&hei=600", "https://media.kohlsimg.com/is/image/kohls/6153538_ALT4?wid=600&hei=600"], "stock_count": 1, "data": ["transfer"], "image_url": "https://media.kohlsimg.com/is/image/kohls/6153538", "description": "Color: White; Size: CAL KING", "colors": ["White"]}]}, "remote_url": "https://www.kohls.com/product/prd-6153538/~.jsp", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '6153538' - parsed successfully. additional_error_text=''"} |
| 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 653, in log_product_upload
add_product_log(
File "/opt/working_folder/api/logging_router/api/product_logging.py", line 83, in add_product_log
.first()
^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2728, in first
return self.limit(1)._iter().first() # type: ignore
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/query.py", line 2827, in _iter
result: Union[ScalarResult[_T], Result[_T]] = self.session.execute(
^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2362, in execute
return self._execute_internal(
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 2226, in _execute_internal
) = compile_state_cls.orm_pre_session_exec(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 561, in orm_pre_session_exec
session._autoflush()
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 3061, in _autoflush
raise e.with_traceback(sys.exc_info()[2])
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/session.py", line 3050, in _autoflush
self.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)
|