SmartDukaan – /trunk/PyProj/src/shop2020/utils/ContentUploadUtil.py

Rev 35608 – Fix DB connection pooling to reduce service restarts - ...

amit — Wed, 28 Jan 2026 17:15:30 +0530

amit – 8 file(s) modified
Fix DB connection pooling to reduce service restarts

- Add pool_timeout=30 to fail fast instead of hanging indefinitely
- Add pool_pre_ping=True to detect stale MySQL connections before use
- Reduce pool_recycle from 7200s to 3600s for fresher connections
- Disable SQL echo logging (echo=False) to reduce memory/CPU usage
- Fix MongoDB connection with thread-safe initialization and proper pooling

Modified services: helper, user, inventory, order, payment, logistics, catalog

~ /trunk/PyProj/src/shop2020/helpers/impl/DataService.py
~ /trunk/PyProj/src/shop2020/logistics/service/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/inventory/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/order/impl/DataService.py
~ /trunk/PyProj/src/shop2020/model/v1/user/impl/Dataservice.py
~ /trunk/PyProj/src/shop2020/payments/impl/DataService.py
~ /trunk/PyProj/src/shop2020/utils/ContentUploadUtil.py

Rev 19933 –

kshitij.sood — Tue, 07 Jun 2016 17:42:09 +0530

kshitij.sood – 1 file(s) modified

~ /trunk/PyProj/src/shop2020/utils/ContentUploadUtil.py

Rev 19686 – Entity upload service

kshitij.sood — Wed, 04 May 2016 13:51:32 +0530

kshitij.sood – 16 file(s) modified
Entity upload service

~ /trunk/PyProj/src/shop2020/content/main/handler/ContentHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/CatalogServiceHandler.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataAcessors.py
~ /trunk/PyProj/src/shop2020/model/v1/catalog/impl/DataService.py
~ /trunk/PyProj/src/shop2020/thriftpy/content/ContentService.py
~ /trunk/PyProj/src/shop2020/thriftpy/content/ttypes.py
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/catalog/CatalogService.py
~ /trunk/PyProj/src/shop2020/thriftpy/model/v1/catalog/ttypes.py
+ /trunk/PyProj/src/shop2020/utils/ContentUploadUtil.py
+ /trunk/ThriftConfig/src/main/java/in/shop2020/content/BulkContentUpload.java
+ /trunk/ThriftConfig/src/main/java/in/shop2020/content/BulkContentUploadResult.java
~ /trunk/ThriftConfig/src/main/java/in/shop2020/content/ContentService.java
+ /trunk/ThriftConfig/src/main/java/in/shop2020/model/v1/catalog/BulkUploadCatalog.java
~ /trunk/ThriftConfig/src/main/java/in/shop2020/model/v1/catalog/CatalogService.java
~ /trunk/ThriftGen/thriftsrc/CatalogService/CatalogService.thrift
~ /trunk/ThriftGen/thriftsrc/ContentService/ContentService.thrift