WebSVN RSS feed – SmartDukaanSun, 26 Apr 2026 05:58:04 +0530WebSVN 2.8.6-DEVenhttps://svn.smartdukaan.com/log.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-cron%2Fsrc%2Fmain%2Fjava%2Fcom%2Fsmartdukaan%2Fcron%2Fscheduled%2FTransactionRelatedTasks.java&max=40& Thu, 18 Dec 2025 19:12:51 +0530amit<div><strong>amit – 5 file(s) modified</strong><br/>Fix order billing vs cancellation race condition with pessimistic locking<br /> <br /> Problem:<br /> - Concurrent billing and cancellation of the same order caused data inconsistency<br /> - Money was refunded to wallet while order was also getting billed<br /> <br /> Solution:<br /> - Added pessimistic locking (SELECT FOR UPDATE) to prevent concurrent modifications<br /> - Added validation methods to check order state before billing/cancellation<br /> - Optimized billing method to reduce lock duration with pre-fetching<br /> <br /> Changes:<br /> - OrderRepository: Added selectByIdForUpdate, selectByOrderIdsForUpdate,<br /> selectByInvoiceNumbersForUpdate, selectAllByTransactionIdForUpdate,<br /> validateOrdersForBilling, validateOrderForRefund methods<br /> - OrderRepositoryImpl: Implemented locking methods with PESSIMISTIC_WRITE<br /> - TransactionServiceImpl: Updated billing methods with locking, fail-fast<br /> validation, pre-fetching to avoid N+1 queries<br /> - ScheduledTasks: Updated removePartialBillingForTransaction with locking<br /> - TransactionRelatedTasks: Updated reverseRTO with locking</div>~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java<br />~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/TransactionRelatedTasks.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepository.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/dao/repository/transaction/OrderRepositoryImpl.java<br />~ /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/transaction/TransactionServiceImpl.java<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-cron%2Fsrc%2Fmain%2Fjava%2Fcom%2Fsmartdukaan%2Fcron%2Fscheduled%2FTransactionRelatedTasks.java&rev=35424https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-cron%2Fsrc%2Fmain%2Fjava%2Fcom%2Fsmartdukaan%2Fcron%2Fscheduled%2FTransactionRelatedTasks.java&rev=35424 Wed, 10 Jan 2024 19:06:32 +0530amit.gupta<div><strong>amit.gupta – 2 file(s) modified</strong><br/>Added Script to auto refund reversal</div>~ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/ScheduledTasks.java<br />+ /trunk/profitmandi-cron/src/main/java/com/smartdukaan/cron/scheduled/TransactionRelatedTasks.java<br />https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-cron%2Fsrc%2Fmain%2Fjava%2Fcom%2Fsmartdukaan%2Fcron%2Fscheduled%2FTransactionRelatedTasks.java&rev=32817https://svn.smartdukaan.com/revision.php?repname=SmartDukaan&path=%2Ftrunk%2Fprofitmandi-cron%2Fsrc%2Fmain%2Fjava%2Fcom%2Fsmartdukaan%2Fcron%2Fscheduled%2FTransactionRelatedTasks.java&rev=32817