Running Vacuum on Lakehouse table throws error

[govindarajan_d]

Hi All,

I have been trying to run vacuum on multiple tables using both Adhoc maintenance option as well as Spark and I am getting the following error:

These tables are updated by Dataflow Gen 2 on a daily basis. The dataflow was running fine without issues for past 1 month.

[optimizer]

I got the same problem

[VincentMeyers]

I got exactly the same problem for all my tables in my lakehouse, coming from dataflows

[AndyDDC]

Hi @govindarajan_d has the VACUUM command ever worked on these tables?

[govindarajan_d]

Hi @AndyDDC ,

This is the first time I am running VACUUM on these tables. 

For few other tables that have been updated by Spark, VACUUM works fine. Two tables that are updated by Dataflow Gen 2 throws the error. 

[AndyDDC]

@govindarajan_d I've tested using a Dataflow Gen2 to load into a Delta table and then ran the VACUUM command and it worked successfully.  What version of Spark are you using in the workspace that the lakehouse is in?

[govindarajan_d]

Hi @AndyDDC. 3.4 version of Spark. And yes, it works for many other tables, but not these 2 tables

[v-gchenna-msft]

Hi @govindarajan_d ,

Apologies for the issue you have been facing.

This might require a deeper investigation from our engineering team and they can guide you better for the issue with those two specified tables.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support
Please provide the ticket number here as we can keep an eye on it.

[govindarajan_d]

Support request number: 2312220040004539

[v-gchenna-msft]

Thanks for sharing the request number.

Hope you got some insights over your query. Please continue using Fabric Community for your further queries.

[v-gchenna-msft]

Hi @govindarajan_d ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet . Did you got a chance to look into @AndyDDC  reply?
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

[v-gchenna-msft]

Hi @govindarajan_d ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .