I have the ff. sample queries in this sequence:
- START TRANSACTION
Query #2 is timing out but I noticed that query #3 is not rolled back.
I am also trying to manually rollback by verifying (querying the table) if the updates went through before I commit. But when I do that, I get an explicit:
General error: 2006 MySQL server has gone away error.
ON, isn't query #3 supposed to be rolled back?
Since I can't even manually roll back, what options do I have?
Note: This is on mariadb-10.4.17