Just got the article access. By the way this issue occurs in mysql even not a galera cluster types. even i make the same Mariadb as master / slave, the same issue occurs, so this is not the problem with galera cluster, is for sure.
... View more
@cjervis These are locks in Hive, we have a mysql backend for metastore and that keeps locking in above mentioned query. Whenever the row locks increase at mysql end we will face issues in hive in processing queries and backlog builds.
... View more
Below is the query causing row locks in Mariadb Galera Cluster 10.2.32 (3Node Cluster). select MT_COMMENT from AUX_TABLE where MT_KEY1='Cleaner' and MT_KEY2=0 for update > Hive is a framework, we couldn't get the flow to understand also can't alter the logic from app end. > Looking for solutions like any version that works in Mysql/Postgresql or any Metastore DBs that can scale for Hive Metastore without lockign issues. > Also looking for any work around solution from DB end for this Mysql Row Locking.
... View more
