Forum Discussion

Antongig's avatar
Antongig
Frequent Visitor
1 year ago
Solved

Cannot Remove Invalid Table "_delta_log._commits" — SQL Sync Blocked

Hello, I'm experiencing a persistent issue in Microsoft Fabric Lakehouse.   Lakehouse: Silver_Lakehouse Issue: SQL Sync fails due to a phantom table _delta_log._commits. Error Message: Delta ta...
data warehouse
  • BhaveshPatel's avatar
    BhaveshPatel
    1 year ago

    Hi Antongig 

     

    Somewhere you deleted the transaction log file or data is corrupted due to _delta_log. For that, you need to delete the whole table ( single table ) and recreate the table using Python or scala commands which ever you think is relevant. 

     

    Also, Which database are you using as a source. I mean to say Azure SQL. SQL Server...etc. 

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi Antongig ,

Thank you for letting us know the update,please update once after trying it.

Regards,
Community Support Team.

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
1 year ago

Hi Antongig ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

Thank you.