After 2 hours of fighting with Atk/MySQl/PDO and almost all DB classes in atk I found Why my Database Was not Rolling Back. And found a silly mistake. Pasting here as Tip for others to look for such mistake if your database is not rolling back.
- Engine should be InnoDB (Done… it was ok)
and my mistake
2. IF your transaction contains any CREATE / ALTER … (DDL) queries mysql will not rollback your queries and in our ERP system a single model was using
And … oops… rollback not working …
So please check for any such mistake if your transactions are not working properly.