Comments - Locking/deadlocking on temp tables?

7 years, 7 months ago Justin Swanhart Swanhart

If you are using Galera, then aborted transactions due to lock conflict are reported as deadlocks.

Temporary tables are not shared between connections and can not cause deadlocks.

 
7 years, 7 months ago Aaron Stanley

Thank you - Your reply says that temp tables won't cause deadlocks, which makes sense... but if all our physical tables are InnoDB/ExtraDB and SHOW ENGINE INNODB STATUS reports 0 deadlocks I am still confused why the mysql connector in our application would be reporting deadlocks. Regardless, again thank you for your reply!

 
7 years, 7 months ago Aaron Stanley

Problem solved! The problem is/was improper exception handling in the code talking to MariaDB. Who would've thought! ;) Thanks for your help and time.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.