Subversion Repositories SmartDukaan
(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/dao/ – Rev 36927
Rev 35832 | Compare with Previous | Directory listing | View Log | RSS feed
Last modification
- Rev 36927 – 26 d 3 h
- 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.
