Subversion Repositories SmartDukaan

Last modification

• Rev 36927 2026-06-25 14:21:37
• Author: amit

• Log message:

  HDFC push-credits: stop lost/uncaptured credits and cut burst contention
  
  - Capture every payment in hdfc_payment before VA validation; never 500 a
  missing/unmatched VA. Acknowledge as success so HDFC stops retrying, leaving
  the row uncredited for reconciliation (dedupe against add_wallet_request).
  - On a row-lock conflict (lock-wait/deadlock), roll back fully and let HDFC retry
  instead of mis-acking as 'duplicate', which silently lost valid-partner credits.
  - Resolve VA/retailer (cached, read-only) before the INSERT to shorten the
  hdfc_payment index-lock window.
  - Scope READ-COMMITTED to the push-credits transaction only (no app-wide change)
  to drop gap-lock contention on concurrent hdfc_payment inserts.
  - Lower innodb_lock_wait_timeout to 10s per HikariCP connection so blocked
  transactions fail fast instead of starving the pool.