| body |
{"product": {"brand": "Polo Ralph Lauren", "name": "Oversize Fit Linen Shirt", "description": "<ul>\n<li>Oversize Fit: a fuller silhouette with ample room in the chest and waist. Intended to hit below the hip.</li>\n<li>Size medium has a 28\" front body length, a 29.5\" body length and a 33\" sleeve length. Back body length and sleeve length are taken from the center back of the neck. Sleeve length changes 0.75\" between sizes.</li>\n<li>Spread collar. Buttoned placket. Shell buttons.</li>\n<li>Long sleeves with buttoned barrel cuffs. Dropped shoulders.</li>\n<li>Box-pleated back yoke. Locker loop. Shirttail hem.</li>\n<li>Signature embroidered Pony at the right cuff.</li>\n<li>100% linen.</li>\n<li>Machine washable or dry clean. Imported.</li>\n<li>Model is 5'10\" (178 cm) and wears a size small.</li>\n</ul>", "data": {"dataFacets": []}, "categories": ["Women > Clothing > Shirts Blouses"], "gender": "Women", "product_images": [], "market_id": 101, "remote_code": "100041558", "is_lost": 0, "variants": [{"remote_code": "0080245673", "upc": "0080245673", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245673.html", "size": "L", "origin_color": "Antique Cream", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "description": "Color: Antique Cream; Size: L", "colors": ["Antique Cream"], "combo_key": "LAntique Cream"}, {"remote_code": "0080245541", "upc": "0080245541", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245541.html", "size": "XL", "origin_color": "Blue", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate5?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "description": "Color: Blue; Size: XL", "colors": ["Blue"], "combo_key": "XLBlue"}, {"remote_code": "0080245533", "upc": "0080245533", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245533.html", "size": "L", "origin_color": "Blue", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate5?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "description": "Color: Blue; Size: L", "colors": ["Blue"], "combo_key": "LBlue"}, {"remote_code": "0080245665", "upc": "0080245665", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245665.html", "size": "M", "origin_color": "Antique Cream", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "description": "Color: Antique Cream; Size: M", "colors": ["Antique Cream"], "combo_key": "MAntique Cream"}, {"remote_code": "0080245681", "upc": "0080245681", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245681.html", "size": "XL", "origin_color": "Antique Cream", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "description": "Color: Antique Cream; Size: XL", "colors": ["Antique Cream"], "combo_key": "XLAntique Cream"}, {"remote_code": "0080245525", "upc": "0080245525", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245525.html", "size": "M", "origin_color": "Blue", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate5?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "description": "Color: Blue; Size: M", "colors": ["Blue"], "combo_key": "MBlue"}, {"remote_code": "0080245509", "upc": "0080245509", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245509.html", "size": "XS", "origin_color": "Blue", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate5?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "description": "Color: Blue; Size: XS", "colors": ["Blue"], "combo_key": "XSBlue"}, {"remote_code": "0080245566", "upc": "0080245566", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245566.html", "size": "XXS", "origin_color": "Blue", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate5?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "description": "Color: Blue; Size: XXS", "colors": ["Blue"], "combo_key": "XXSBlue"}, {"remote_code": "0080245517", "upc": "0080245517", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245517.html", "size": "S", "origin_color": "Blue", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate5?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221500_alternate10?$rl_4x5_pdp$", "description": "Color: Blue; Size: S", "colors": ["Blue"], "combo_key": "SBlue"}, {"remote_code": "0080245657", "upc": "0080245657", "remote_url": "https://www.ralphlauren.com/women-clothing-shirts-blouses/oversize-fit-linen-shirt/0080245657.html", "size": "S", "origin_color": "Antique Cream", "price": 168.0, "variant_images": ["https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate1?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate3?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate4?$rl_4x5_pdp$", "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_lifestyle?$rl_4x5_pdp$"], "stock_count": 1, "data": ["transfer"], "image_url": "https://dtcralphlauren.scene7.com/is/image/PoloGSI/s7-AI211968221505_alternate10?$rl_4x5_pdp$", "description": "Color: Antique Cream; Size: S", "colors": ["Antique Cream"], "combo_key": "SAntique Cream"}]}, "remote_url": "https://www.ralphlauren.com/products/product/100041558.html", "parsing_type": "refresh", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '100041558' - parsed successfully. additional_error_text=''"} |
| error_text |
Traceback (most recent call last):
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)
psycopg2.errors.SqlclientUnableToEstablishSqlconnection: could not establish connection for write forwarding
DETAIL: fe_sendauth: no password supplied
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/opt/working_folder/middlewares/catch_errors_middleware/catch_500_errors.py", line 35, 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 761, in log_product_upload
upsert_product_hash(
File "/opt/working_folder/api/logging_router/api/product_logging.py", line 368, in upsert_product_hash
db.execute(stmt)
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 2256, in _execute_internal
result = conn.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)
sqlalchemy.exc.OperationalError: (psycopg2.errors.SqlclientUnableToEstablishSqlconnection) could not establish connection for write forwarding
DETAIL: fe_sendauth: no password supplied
[SQL: INSERT INTO product_hash (market_id, remote_code, product_hash) VALUES (%(market_id)s, %(remote_code)s, %(product_hash)s) ON CONFLICT (market_id, remote_code) DO UPDATE SET product_hash = excluded.product_hash RETURNING product_hash.id]
[parameters: {'market_id': 101, 'remote_code': '100041558', 'product_hash': 'a55e5cecb8193776d1071fafb4570890d8d8bc6e660a9a1251de069e1cadb108'}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|