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.
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963