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 ,

We’d like to follow up on your support ticket. Has the issue been successfully addressed?

If a solution was provided, we’d truly appreciate it if you could share your experience or any relevant details, your input could be valuable to other community members.

 

Thanks again for being an active part of the Microsoft Fabric Community!

Antongig's avatar
Antongig
Frequent Visitor
1 year ago

Hey, I am trying to remove the table with rest api as you posted below. If that does not work I will open a support ticket, since microsoft support costs money it will be the last straw.

Thanks

  • 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.