I have an application where I run an explicit
COMMIT query on a MySQL standalone server
The query works as expected in the vast majority of cases, but sometimes the query seems successful but at the same time seems not to commit the transaction to the DB.
So I was digging into the possibility that a
COMMIT query could fail. I found this similar question: https://stackoverflow.com/questions/3960189/can-a-commit-statement-in-sql-ever-fail-how
but on the official MySQL doc never mentions that a
COMMIT can fail.
I want to understand in which conditions a commit query can fail and how to reproduce it, possibly supported by official doc pages.