SQL because it is being used by another process

[dorathoto]

I have a console program that will perform a Sync when it receives a signalR, but it says that the database is already open.

Yes, I use EntityFramework in my console project..

Dotmim.Sync.SyncException: '[InternalApplyChangesAsync]..[InternalApplyCleanErrorsAsync]..The process cannot access the file 'C:\Users....\dbo_Agendamentos_0000_SQLLocalTotem_ERRORS_rjc0yplu_f2y.json' because it is being used by another process.'

What should I do? Would just closing the connection first work?
use the SqlSyncChangeTrackingProvider()

[Mimetis]

That's strange.
Are you able to produce a small example that can reproduce the bug ?

Seems you have a problem on accessing a file on disk, and not really the database

That's weird coz this file (indeed generated by DMS) is only used by DMS, internally...

[abri-damien]

I'm getting the exact same error and its happening here on line 866

[Mimetis]

Maybe your antivirus, I don't know, honestly

[abri-damien]

I don't have one. Its only specific to a single database. We have around 40 databases with identical schema and only one of them is getting this error.

[abri-damien]

If I comment out that File.Delete the error goes away, but I get a completely different one

[Mimetis]

no idea, honestly

[Mimetis]

When you have the error, try to find which program is locking the file
You can use SysInternals Process Explorer for example:

• https://www.thewindowsclub.com/how-to-tell-which-process-is-locking-a-file
• https://thegeekpage.com/how-to-find-out-which-process-is-locking-a-file-or-folder-in-windows-10/
• Using powershell : https://superuser.com/questions/117902/find-out-which-process-is-locking-a-file-or-folder-in-windows

[abri-damien]

It seems to only happen after errors have occurred. The first error I am getting is the JsonReaderException. The file is indeed incomplete:

Animal_Movements_0000_ERRORS_mrrcnzkz_bxf.json

The process using the file is my app so somewhere its not being closed properly (I'm not touching these files myself).

I am using the ASP.NET Core Web Proxy along with SQL Server Change Tracking. I'll see if I can give you a reproducible sample. I can't post the copies of the databases here publicly but I may be able to send them to you privately.