US 12,111,822 B2
Database race condition prevention
Peter Wang, Seattle, WA (US); Alexander Thiemann, San Francisco, CA (US); Adam Eagle, San Francisco, CA (US); Hongshan Zhou, San Francisco, CA (US); and Ji Huang, Bothell, WA (US)
Assigned to Stripe, Inc., South San Francisco, CA (US)
Filed by Stripe, Inc., South San Francisco, CA (US)
Filed on Sep. 29, 2021, as Appl. No. 17/489,062.
Prior Publication US 2023/0114105 A1, Apr. 13, 2023
Int. Cl. G06F 16/00 (2019.01); G06F 16/23 (2019.01); G06Q 10/087 (2023.01)
CPC G06F 16/2379 (2019.01) [G06F 16/2343 (2019.01); G06Q 10/087 (2013.01)] 20 Claims
OG exemplary drawing
 
1. A method for preventing race conditions in a database by at least one hardware processor, comprising:
setting an orderable entry and an in-stock entry for a product in the database;
receiving an online transaction for the product;
responsive to determining a lock of the database is in progress, suspending the online transaction;
updating a quantity of the orderable entry while the lock of the database is in progress;
removing the lock; and
responsive to determining that the lock is removed:
responsive to determining that the quantity of the orderable entry is greater than zero:
decrementing the quantity of the orderable entry by an amount indicated in the online transaction, and
determining whether the quantity of the in-stock entry is greater than zero; and
responsive to determining that the quantity of the orderable entry is greater than zero and that the quantity of the in-stock entry is greater than zero, decrementing the quantity of the in-stock entry by the amount indicated in the online transaction.