På torsdag 18. februar 2016 kl. 09:26:59, skrev Sridhar N Bamandlapally <sridhar.bn1@gmail.com>:
If we want transactions in "begin-end" then its fine,
but in this case all these transactions are independent with autocommit off,
user choice to continue with commit or rollback
Look in you serverlogs, "something" is issuing a BEGIN. The transaction becomes invalid when an error occurs, you have to issue a COMMIT or ROLLBACK, and in this case both will ROLLBACK.