A peeve of mine is trying to purchase something online from an e-commerce site which specifically states In Stock, and then waiting for weeks only to discover I’ve been back-ordered. It’s doubly bad when I’m trying to buy myself a christmas present. Yup, myself.
I haven’t tried the method listed in the below link yet, but I’m setting it aside in case I need it in the future.
http://stackoverflow.com/questions/11278494/mysql-atomic-operations-and-table-locking