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. 

Antongig's avatar
Antongig
Frequent Visitor
7 months ago

Apparently, Microsoft fixed the problem by enabling me to see the _delta_log table and to delete it. It took 2 minutes to resolve this issure. After all it was a bug in fabric.

Thank you for your help

v-menakakota's avatar
v-menakakota
Icon for Community Support rankCommunity Support
7 months ago

Hi Antongig ,

Thank you for the update.