Subversion Repositories SmartDukaan

Last modification

• Rev 36327 2026-04-21 13:35:46
• Author: amit

• Log message:

  Fix currentinventorysnapshot/currentreservationsnapshot deadlock and optimize getFirstBillingDate
  
  - SaholicInventoryServiceImpl: enforce reservation-snapshot → inventory-snapshot
  lock order in addReservationCount and reduceReservationCount via explicit
  session.flush(); eliminates the hadb1 deadlock recorded 2026-04-20 19:43:24
  between these two methods' opposite-order writes.
  - SaholicInventorySnapshot: add @DynamicUpdate so UPDATEs only rewrite the
  changed column instead of all three — cuts redo/binlog write amplification
  and makes deadlock dumps pinpoint the actual business path.
  - TransactionRepositoryImpl.getFirstBillingDate: replace filesort-over-all-billed-
  orders with MIN(billingTimestamp) via new Order.selectFirstBillingByRetailer
  named query (Select tables optimized away). Preserves 2017-01-01 cutoff and
  null-for-unbilled-partner semantics.
  - Add @Cacheable on redisOneDayCacheManager keyed by fofoId (unless null) so the
  8 call sites stop piling up identical SELECTs on the order table — this was
  the query pinning Hikari slots at 150-460s each in recent processlist dumps.