| body |
{"product": {"rating": null, "rating_count": null, "brand": "H&M", "name": "Brazilian Bikini Bottoms", "description": "Fully lined bikini bottoms with a high waist. High-cut back.", "data": {"dataFacets": []}, "categories": ["Women > Swimwear & Beachwear > Bikini Sets > Bikini bottoms"], "gender": "Women", "product_images": [], "market_id": 82, "remote_code": "1297575", "is_lost": 0, "variants": [{"remote_code": "1297575001002", "upc": "1297575001002", "remote_url": "https://www2.hm.com/en_us/productpage.1297575001.html", "size": "XS", "origin_color": "White/red patterned", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/fa/c4/fac442e5e8f22effa3b28a8732305a3cede63423.jpg", "https://image.hm.com/assets/hm/1c/c2/1cc2dc47ea531e80d2a2ab7e47281069024e2bde.jpg", "https://image.hm.com/assets/hm/ef/87/ef87bca89745fd752e9674aaf7ae633d9338af62.jpg", "https://image.hm.com/assets/hm/83/21/8321b2be94cf5e3b061d4e5780face16213330d0.jpg", "https://image.hm.com/assets/hm/a2/20/a220be83a1127170b69de8180aa305bbfce62479.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/fa/c4/fac442e5e8f22effa3b28a8732305a3cede63423.jpg", "description": "Color: White/red patterned; Size: XS", "colors": ["White/red patterned"]}, {"remote_code": "1297575001003", "upc": "1297575001003", "remote_url": "https://www2.hm.com/en_us/productpage.1297575001.html", "size": "S", "origin_color": "White/red patterned", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/fa/c4/fac442e5e8f22effa3b28a8732305a3cede63423.jpg", "https://image.hm.com/assets/hm/1c/c2/1cc2dc47ea531e80d2a2ab7e47281069024e2bde.jpg", "https://image.hm.com/assets/hm/ef/87/ef87bca89745fd752e9674aaf7ae633d9338af62.jpg", "https://image.hm.com/assets/hm/83/21/8321b2be94cf5e3b061d4e5780face16213330d0.jpg", "https://image.hm.com/assets/hm/a2/20/a220be83a1127170b69de8180aa305bbfce62479.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/fa/c4/fac442e5e8f22effa3b28a8732305a3cede63423.jpg", "description": "Color: White/red patterned; Size: S", "colors": ["White/red patterned"]}, {"remote_code": "1297575002002", "upc": "1297575002002", "remote_url": "https://www2.hm.com/en_us/productpage.1297575002.html", "size": "XS", "origin_color": "White", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/80/f2/80f22eea52ce1669c21b99a3d5bf7f43d16362d0.jpg", "https://image.hm.com/assets/hm/ef/11/ef11435ca692ba5a28007e096967e1f1db641bb8.jpg", "https://image.hm.com/assets/hm/2d/4e/2d4ed736162eac569ac9032b194decb9d6275846.jpg", "https://image.hm.com/assets/hm/da/8d/da8d7a2d28f5715856dd3635af70722761c7add4.jpg", "https://image.hm.com/assets/hm/e2/13/e21381a25dbd5dd95116fdfe5c67de56ad95758f.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/80/f2/80f22eea52ce1669c21b99a3d5bf7f43d16362d0.jpg", "description": "Color: White; Size: XS", "colors": ["White"]}, {"remote_code": "1297575002003", "upc": "1297575002003", "remote_url": "https://www2.hm.com/en_us/productpage.1297575002.html", "size": "S", "origin_color": "White", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/80/f2/80f22eea52ce1669c21b99a3d5bf7f43d16362d0.jpg", "https://image.hm.com/assets/hm/ef/11/ef11435ca692ba5a28007e096967e1f1db641bb8.jpg", "https://image.hm.com/assets/hm/2d/4e/2d4ed736162eac569ac9032b194decb9d6275846.jpg", "https://image.hm.com/assets/hm/da/8d/da8d7a2d28f5715856dd3635af70722761c7add4.jpg", "https://image.hm.com/assets/hm/e2/13/e21381a25dbd5dd95116fdfe5c67de56ad95758f.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/80/f2/80f22eea52ce1669c21b99a3d5bf7f43d16362d0.jpg", "description": "Color: White; Size: S", "colors": ["White"]}, {"remote_code": "1297575003002", "upc": "1297575003002", "remote_url": "https://www2.hm.com/en_us/productpage.1297575003.html", "size": "XS", "origin_color": "Brown", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/aa/62/aa62bf4b157b6b0b710f657a9247db088deefc0e.jpg", "https://image.hm.com/assets/hm/1c/52/1c522eed78925d78a55c25a6ce7ead3d8543032f.jpg", "https://image.hm.com/assets/hm/08/bc/08bc40d13f9e5334403c2ecce934fa15b75554ea.jpg", "https://image.hm.com/assets/hm/c6/ad/c6ad8a7842beb53be2be90e6e2daeb5ff7dae875.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/aa/62/aa62bf4b157b6b0b710f657a9247db088deefc0e.jpg", "description": "Color: Brown; Size: XS", "colors": ["Brown"]}, {"remote_code": "1297575003003", "upc": "1297575003003", "remote_url": "https://www2.hm.com/en_us/productpage.1297575003.html", "size": "S", "origin_color": "Brown", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/aa/62/aa62bf4b157b6b0b710f657a9247db088deefc0e.jpg", "https://image.hm.com/assets/hm/1c/52/1c522eed78925d78a55c25a6ce7ead3d8543032f.jpg", "https://image.hm.com/assets/hm/08/bc/08bc40d13f9e5334403c2ecce934fa15b75554ea.jpg", "https://image.hm.com/assets/hm/c6/ad/c6ad8a7842beb53be2be90e6e2daeb5ff7dae875.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/aa/62/aa62bf4b157b6b0b710f657a9247db088deefc0e.jpg", "description": "Color: Brown; Size: S", "colors": ["Brown"]}, {"remote_code": "1297575004002", "upc": "1297575004002", "remote_url": "https://www2.hm.com/en_us/productpage.1297575004.html", "size": "XS", "origin_color": "Dark green", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/74/67/7467ee8a4a66353f657ed6a368ca130ca3e0a34d.jpg", "https://image.hm.com/assets/hm/7a/4c/7a4ce51319335a36c5feb5fb9dc64f42ff83c79f.jpg", "https://image.hm.com/assets/hm/1b/3a/1b3a394ba6e634a317f1748ce8a94669612a908b.jpg", "https://image.hm.com/assets/hm/dd/04/dd042ccdb68aa02a328f73620351599275e8035d.jpg", "https://image.hm.com/assets/hm/32/9d/329db2e0d9a655f3d3d81bcb391fa5a08a028ae1.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/74/67/7467ee8a4a66353f657ed6a368ca130ca3e0a34d.jpg", "description": "Color: Dark green; Size: XS", "colors": ["Dark green"]}, {"remote_code": "1297575004003", "upc": "1297575004003", "remote_url": "https://www2.hm.com/en_us/productpage.1297575004.html", "size": "S", "origin_color": "Dark green", "price": 19.99, "variant_images": ["https://image.hm.com/assets/hm/74/67/7467ee8a4a66353f657ed6a368ca130ca3e0a34d.jpg", "https://image.hm.com/assets/hm/7a/4c/7a4ce51319335a36c5feb5fb9dc64f42ff83c79f.jpg", "https://image.hm.com/assets/hm/1b/3a/1b3a394ba6e634a317f1748ce8a94669612a908b.jpg", "https://image.hm.com/assets/hm/dd/04/dd042ccdb68aa02a328f73620351599275e8035d.jpg", "https://image.hm.com/assets/hm/32/9d/329db2e0d9a655f3d3d81bcb391fa5a08a028ae1.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/74/67/7467ee8a4a66353f657ed6a368ca130ca3e0a34d.jpg", "description": "Color: Dark green; Size: S", "colors": ["Dark green"]}, {"remote_code": "1297575005002", "upc": "1297575005002", "remote_url": "https://www2.hm.com/en_us/productpage.1297575005.html", "size": "XS", "origin_color": "White/green patterned", "price": 7.49, "price_full": 19.99, "variant_images": ["https://image.hm.com/assets/hm/68/a9/68a9a40ad1a51b3b5893d50d6af64348c98fad77.jpg", "https://image.hm.com/assets/hm/47/4a/474a72100ad1080fea3a2b845e72a02a4b945667.jpg", "https://image.hm.com/assets/hm/81/81/8181c52378eccf6e8d028d218e58367d565ddc7b.jpg", "https://image.hm.com/assets/hm/66/9c/669c442a2f68ebef568e9296228d6123a3c041b4.jpg", "https://image.hm.com/assets/hm/0d/fa/0dfa124fb5e9aaef82914e09f1a6b467e1e22edc.jpg", "https://image.hm.com/assets/hm/cf/c0/cfc07b29bbf8765a0b76333ea6b94d2c14f7920e.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/68/a9/68a9a40ad1a51b3b5893d50d6af64348c98fad77.jpg", "description": "Color: White/green patterned; Size: XS", "colors": ["White/green patterned"]}, {"remote_code": "1297575005003", "upc": "1297575005003", "remote_url": "https://www2.hm.com/en_us/productpage.1297575005.html", "size": "S", "origin_color": "White/green patterned", "price": 7.49, "price_full": 19.99, "variant_images": ["https://image.hm.com/assets/hm/68/a9/68a9a40ad1a51b3b5893d50d6af64348c98fad77.jpg", "https://image.hm.com/assets/hm/47/4a/474a72100ad1080fea3a2b845e72a02a4b945667.jpg", "https://image.hm.com/assets/hm/81/81/8181c52378eccf6e8d028d218e58367d565ddc7b.jpg", "https://image.hm.com/assets/hm/66/9c/669c442a2f68ebef568e9296228d6123a3c041b4.jpg", "https://image.hm.com/assets/hm/0d/fa/0dfa124fb5e9aaef82914e09f1a6b467e1e22edc.jpg", "https://image.hm.com/assets/hm/cf/c0/cfc07b29bbf8765a0b76333ea6b94d2c14f7920e.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://image.hm.com/assets/hm/68/a9/68a9a40ad1a51b3b5893d50d6af64348c98fad77.jpg", "description": "Color: White/green patterned; Size: S", "colors": ["White/green patterned"]}]}, "remote_url": "https://www2.hm.com/en_us/productpage.1297575001.html", "parsing_type": "basket", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: '1297575' - 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 535, in log_product_upload
add_product_history(db, market_id, remote_code, json_data)
File "/opt/working_folder/api/logging_router/api/product_logging.py", line 319, in add_product_history
.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 2247, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/local/lib/python3.11/site-packages/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
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: SELECT product_history.id AS product_history_id, product_history.remote_code AS product_history_remote_code, product_history.market_id AS product_history_market_id, product_history.history AS product_history_history, product_history.date_created AS product_history_date_created, product_history.date_modified AS product_history_date_modified
FROM product_history
WHERE product_history.market_id = %(market_id_1)s AND product_history.remote_code = %(remote_code_1)s
LIMIT %(param_1)s FOR UPDATE]
[parameters: {'market_id_1': 82, 'remote_code_1': '1297575', 'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|