does not rollback and i don't know what i have to do , i do all sug solution with no result

Hi Ahmed!
Thanks for reaching out!

Could you please support your question with the entire code you’ve executed? This can help us assist you better. Thank you.

Looking forward to your answer.
Best,
Tsvetelin

you got to execute:
SET autocommit=0;

Thank you Ahmed, you really saved me a lot of frustration. Too bad this was not covered when the explained to turn off the checkbox

SET autocommit=0;  was absolutely necessary.