https://community.databricks.com/t5/data-governance/the-issue-with-sql-endpoint-external-hive-metastore/m-p/16100#M573 <P>Generally, this should not be a case. Please raise a support request to databricks</P> Mon, 19 Dec 2022 04:26:09 GMT Ajay-Pandey 2022-12-19T04:26:09Z https://community.databricks.com/t5/data-governance/the-issue-with-sql-endpoint-external-hive-metastore/m-p/16099#M572 <P>Hi</P><P></P><P>We have faced an issue recently (everything worked well 1 week before)</P><P></P><P>We are using exnernal hive metastore:</P><PRE><CODE>"spark.hadoop.datanucleus.connectionPool.maxPoolSize" : "10" &nbsp; "spark.sql.hive.metastore.jars" : "/dbfs/ivyjars/*" &nbsp; "spark.sql.hive.metastore.version" : "3.1.0"</CODE></PRE><P>and now it looks like all access for the metastore from sql-endpoints are stuck (I am observing a lot of queued session from query history like "show databases", "show table" and so on )</P><P></P><P>the version of sql-warehouse:</P><PRE><CODE>Channel Current (v 2022.40)</CODE></PRE><P>We are using rds for hive metastore and I'm observing a lot of idle sessions such as:</P><P></P><PRE><CODE>idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,SET application_name = 'PostgreSQL JDBC Driver' idle,,,COMMIT</CODE></PRE><P></P><P>What is the issue?</P><P></P><P>P.S.</P><P></P><P>The restarting of the SQL -warehouse helps sometimes, but the problem still exists</P><P></P> Sun, 18 Dec 2022 07:44:31 GMT https://community.databricks.com/t5/data-governance/the-issue-with-sql-endpoint-external-hive-metastore/m-p/16099#M572 vpismarev 2022-12-18T07:44:31Z https://community.databricks.com/t5/data-governance/the-issue-with-sql-endpoint-external-hive-metastore/m-p/16100#M573 <P>Generally, this should not be a case. Please raise a support request to databricks</P> Mon, 19 Dec 2022 04:26:09 GMT https://community.databricks.com/t5/data-governance/the-issue-with-sql-endpoint-external-hive-metastore/m-p/16100#M573 Ajay-Pandey 2022-12-19T04:26:09Z