| body |
{"product": {"rating": null, "rating_count": null, "brand": "Nike", "name": "Golden State Warriors Essential City Edition Men's Nike NBA Max90 T-Shirt", "description": "Bold. Loud. Proud. This city edition Max90 t-shirt is one of them ones, driven by Warriors culture and attitude. It's a head-turner for sure and it comes with a relaxed fit with dropped shoulders and longer sleeves.", "data": {"dataFacets": []}, "gender": "Man", "categories": ["Graphic Tees > T-Shirt"], "product_images": [], "market_id": 96, "remote_code": "UeZdbaOf", "is_lost": 0, "variants": [{"remote_code": "f414f97f-5c4e-53fd-917d-2097e8c76171", "upc": "00198481791064", "additional_upc": "b330cd33-7499-4530-96e3-dee4cf4446d9", "remote_url": "https://www.nike.com/t/~/HV5500-120", "size": "S", "origin_color": "Natural/Corduroy Brown", "price": 45.97, "price_full": 55.0, "variant_images": ["https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/3a813dd4-016f-4b0b-b793-251763101e22/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.nike.com/a/images/t_default/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "description": "Color: Natural/Corduroy Brown; Size: S", "colors": ["Natural/Corduroy Brown"]}, {"remote_code": "b3f2c696-b3d5-51b4-9879-c65fc500d298", "upc": "00198481793471", "additional_upc": "b330cd33-7499-4530-96e3-dee4cf4446d9", "remote_url": "https://www.nike.com/t/~/HV5500-120", "size": "M", "origin_color": "Natural/Corduroy Brown", "price": 45.97, "price_full": 55.0, "variant_images": ["https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/3a813dd4-016f-4b0b-b793-251763101e22/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.nike.com/a/images/t_default/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "description": "Color: Natural/Corduroy Brown; Size: M", "colors": ["Natural/Corduroy Brown"]}, {"remote_code": "44c6b73b-13f5-5ec0-8e38-b8c6c004d0b3", "upc": "00198481857586", "additional_upc": "b330cd33-7499-4530-96e3-dee4cf4446d9", "remote_url": "https://www.nike.com/t/~/HV5500-120", "size": "L", "origin_color": "Natural/Corduroy Brown", "price": 45.97, "price_full": 55.0, "variant_images": ["https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/3a813dd4-016f-4b0b-b793-251763101e22/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.nike.com/a/images/t_default/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "description": "Color: Natural/Corduroy Brown; Size: L", "colors": ["Natural/Corduroy Brown"]}, {"remote_code": "c8e02f9e-3e1c-5e0c-bf5a-c43d22dd307d", "upc": "00198481816224", "additional_upc": "b330cd33-7499-4530-96e3-dee4cf4446d9", "remote_url": "https://www.nike.com/t/~/HV5500-120", "size": "XL", "origin_color": "Natural/Corduroy Brown", "price": 45.97, "price_full": 55.0, "variant_images": ["https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "https://static.nike.com/a/images/f_auto,q_auto:eco/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/3a813dd4-016f-4b0b-b793-251763101e22/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png"], "stock_count": 1, "data": ["transfer"], "image_url": "https://static.nike.com/a/images/t_default/u_9ddf04c7-2a9a-4d76-add1-d15af8f0263d,c_scale,fl_relative,w_1.0,h_1.0,fl_layer_apply/0868d784-f782-43bf-ac0f-c8421c860e2d/GSW+M+NK+ES+CE+BLG+SS+M90+TEE.png", "description": "Color: Natural/Corduroy Brown; Size: XL", "colors": ["Natural/Corduroy Brown"]}]}, "remote_url": "https://www.nike.com/t/UeZdbaOf", "parsing_type": "refresh", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'UeZdbaOf' - 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 768, 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 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_log.id AS product_log_id, product_log.market_id AS product_log_market_id, product_log.remote_code AS product_log_remote_code, product_log.remote_url AS product_log_remote_url, product_log.parsing_type AS product_log_parsing_type, product_log.parsing_code AS product_log_parsing_code, product_log.text AS product_log_text, product_log.logs AS product_log_logs, product_log.date_created AS product_log_date_created, product_log.date_modified AS product_log_date_modified
FROM product_log
WHERE product_log.market_id = %(market_id_1)s AND product_log.remote_code = %(remote_code_1)s
LIMIT %(param_1)s FOR UPDATE]
[parameters: {'market_id_1': 96, 'remote_code_1': 'UeZdbaOf', 'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)
|