| body |
{"product": {"partial_update": 0, "variant_remote_code": null, "rating": 5.0, "rating_count": 1, "brand": "PanOxyl", "seller_name": "PanOxyl", "author": null, "name": "PanOxyl PM Balancing Repair Moisturizer with Niacinamide, Ceramides and Cica, Hydrating Face Moisturizer, Acne Prone Skin and Dry Skin, Non-Comedogenic Night Face Moisturizer, 3 oz", "description": "Hydrate and replenish with PanOxyl PM Balancing Repair Moisturizer. This lightweight, balancing gel cream moisturizer delivers instant and continuous hydration while helping control oil production, calming the look of redness, and minimizing the appearance of pores. Designed for daily use with PanOxyl AM Oil Control Moisturizer, these two formulas can help to restore balance and replenish skin. Persistent use of acne treatments can lead to excessive dryness. This moisturizer is designed to give the skin a much-needed break while delivering essential hydration, allowing the skin to replenish itself overnight. Formulated with seven different molecular weights of hyaluronic acid, this moisturizing treatment provides deeper hydration for immediate and lasting results. Nightly use will help skin to look smoother, healthier, and more supple. Niacinamide helps to prevent moisture loss and strengthen the skin\u2019s natural barrier. Ceramides further enhance the skin barrier, helping your skin to feel less dry and irritated. Cica, short for the plant Centenella asiatica, helps to soothe redness and irritation often associated with acne-prone skin. This gentle, dermatologist recommended moisturizer is specially designed for oily, sensitive, and acne-prone skin. Trusted by dermatologists, PanOxyl products use scientifically proven ingredients to banish breakouts without the prescription. PanOxyl products help your skin look its best so you can be your clearest, most confident you.", "data": {"dataFacets": []}, "categories": ["Beauty & Personal Care > Skin Care > Face > Creams & Moisturizers > Face Moisturizers"], "gender": "beauty_no_gender", "product_images": [], "market_id": 37, "remote_code": "B0DB8VJPW9", "is_lost": 0, "variants": [{"remote_code": "B0C1HKM67J", "additional_upc": "B0C1HKM67J", "remote_url": "https://www.amazon.com/dp/B0C1HKM67J?th=1&psc=1", "delivery_days": 5, "size": "3 Fl Oz (Pack of 1)", "origin_color": "NO_COLOR", "price": 10.48, "variant_images": ["https://m.media-amazon.com/images/I/71nqW2upKDL._SL1500_.jpg", "https://m.media-amazon.com/images/I/71CdkOaVYDL._SL1500_.jpg", "https://m.media-amazon.com/images/I/816O94d0TwL._SL1500_.jpg", "https://m.media-amazon.com/images/I/71yicyUnU1L._SL1500_.jpg", "https://m.media-amazon.com/images/I/91OiogLxbFL._SL1500_.jpg", "https://m.media-amazon.com/images/I/71qgIDaP46L._SL1500_.jpg", "https://m.media-amazon.com/images/I/71ZRBfaDmGL._SL1500_.jpg", "https://m.media-amazon.com/images/I/71YszQp3s5L._SL1500_.jpg", "https://m.media-amazon.com/images/I/71aZnaaGK+L._SL1500_.jpg"], "stock_count": 1, "data": ["transfer"], "image_url": "https://m.media-amazon.com/images/I/71nqW2upKDL._SL1500_._AC_SY300.jpg", "description": "Color: NO_COLOR; Size: 3 Fl Oz (Pack of 1)", "colors": ["NO_COLOR"], "upc": "303160295034", "weight": "", "combo_key": "3 Fl Oz (Pack of 1)NO_COLOR"}]}, "remote_url": "https://www.amazon.com/dp/B0DB8VJPW9?th=1&psc=1", "parsing_type": "refresh", "finalize": false, "parsing_code": 200, "parsing_text": "[200] Success: Item: 'B0DB8VJPW9' - 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 495, 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)
|