https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58252#M31068 <P>We have a table where the underlying data has been dropped, and seemingly something else must have gone wrong as well, and we want to just get rid of the whole table and schema, but running "DROP TABLE schema.table" is throwing the following error:</P><PRE><SPAN>org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:org.datanucleus.exceptions.NucleusDataStoreException: Update of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@955c52" using statement "UPDATE SDS SET CD_ID=? WHERE SD_ID=?" failed : java.sql.SQLTransientConnectionException: (conn=64550) Lock wait timeout exceeded; try restarting transaction</SPAN></PRE><P>I have used the script mentioned&nbsp;<A href="https://community.databricks.com/t5/data-engineering/unable-to-drop-a-table/m-p/19564#M13130" target="_self">in this conversation</A>, but that leads to a similar error:</P><PRE><SPAN>HiveException: MetaException(message:org.datanucleus.exceptions.NucleusDataStoreException: Update of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@5396216a" using statement "UPDATE SDS SET CD_ID=? WHERE SD_ID=?" failed : java.sql.SQLTransientConnectionException: (conn=64632) Lock wait timeout exceeded; try restarting transaction</SPAN></PRE><P>Any search for this error only brings up MySQL topics. Is there anything I can do to force-drop the table?&nbsp;</P> Tue, 23 Jan 2024 09:40:52 GMT MarthinusBosma1 2024-01-23T09:40:52Z https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58252#M31068 <P>We have a table where the underlying data has been dropped, and seemingly something else must have gone wrong as well, and we want to just get rid of the whole table and schema, but running "DROP TABLE schema.table" is throwing the following error:</P><PRE><SPAN>org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:org.datanucleus.exceptions.NucleusDataStoreException: Update of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@955c52" using statement "UPDATE SDS SET CD_ID=? WHERE SD_ID=?" failed : java.sql.SQLTransientConnectionException: (conn=64550) Lock wait timeout exceeded; try restarting transaction</SPAN></PRE><P>I have used the script mentioned&nbsp;<A href="https://community.databricks.com/t5/data-engineering/unable-to-drop-a-table/m-p/19564#M13130" target="_self">in this conversation</A>, but that leads to a similar error:</P><PRE><SPAN>HiveException: MetaException(message:org.datanucleus.exceptions.NucleusDataStoreException: Update of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@5396216a" using statement "UPDATE SDS SET CD_ID=? WHERE SD_ID=?" failed : java.sql.SQLTransientConnectionException: (conn=64632) Lock wait timeout exceeded; try restarting transaction</SPAN></PRE><P>Any search for this error only brings up MySQL topics. Is there anything I can do to force-drop the table?&nbsp;</P> Tue, 23 Jan 2024 09:40:52 GMT https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58252#M31068 MarthinusBosma1 2024-01-23T09:40:52Z https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58265#M31074 <P>The table needs to be dropped from the backend. If you can raise a ticket, support team can do it for you.&nbsp;</P> Tue, 23 Jan 2024 11:19:50 GMT https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58265#M31074 Lakshay 2024-01-23T11:19:50Z https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58268#M31076 <P>This is running on a private Azure Databricks subscription. So I'm not sure who "support" is in that case?</P> Tue, 23 Jan 2024 13:09:02 GMT https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58268#M31076 MarthinusBosma1 2024-01-23T13:09:02Z https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58271#M31077 <P>I think it should be Microsoft but probably you can check within your organization.</P> Tue, 23 Jan 2024 13:31:48 GMT https://community.databricks.com/t5/data-engineering/unable-to-drop-table-quot-lock-wait-timeout-exceeded-quot/m-p/58271#M31077 Lakshay 2024-01-23T13:31:48Z