Comments - Locking/deadlocking on temp tables?
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.
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.
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!
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.