topic Re: arcpro 2.6 arcpy fgdb lock files not clearing in Python Questions

arcpro 2.6 arcpy fgdb lock files not clearing

KennethSmith1 — Mon, 03 Aug 2020 19:53:09 GMT

I recently upgraded to Arcpro 2.6 and am having issues with an ArcPy script that exported data to a file geodatabase and then zipped that fgdb.

res=arcpy.FeatureClassToFeatureClass_conversion(in_features=inFeature, out_path=I10_fgdb, out_name=FC)
del res

shutil.make_archive(fgdbPath, 'zip', ZipPath,fgdb)

This worked just fine in 2.5.X, however, after the upgrade, the lock file in the FGDB directory is not going away and that causes the zip to fail. How can I get ArcPy to clear the lockfile in a FGDB?

Thanks

Re: arcpro 2.6 arcpy fgdb lock files not clearing

DanPatterson — Mon, 03 Aug 2020 20:10:27 GMT

If this worked in 2.5, I would report to Technical Support.

Arcpy can't clear locks... it is well requested item

Re: arcpro 2.6 arcpy fgdb lock files not clearing

CooperLogan — Sat, 19 Sep 2020 00:13:04 GMT

Hi Kenneth Smith‌

It sounds like this issue has been reported as a bug with 2.6:

[ BUG-000133976: Unexpected behavior creating file geodatabases at 2.6 ]

Hope this helps!

Cooper

Re: arcpro 2.6 arcpy fgdb lock files not clearing

DonMorrison1 — Sat, 03 Oct 2020 18:44:28 GMT

Hi Cooper - do you know if there is a way to circumvent this problem? I have a number of critical scripts that are broken due this bug. I'm willing to go in and add some code if necessary. It looks to me like the only way to get rid of that lock file is to end the python script's process, but to do that in the middle of the script is really not feasible.

Re: arcpro 2.6 arcpy fgdb lock files not clearing

DanPatterson — Sat, 03 Oct 2020 19:52:43 GMT

BUG-000133976: Unexpected behavior occurs when creating file geodat..

no alternate solution provided

Re: arcpro 2.6 arcpy fgdb lock files not clearing

KennethSmith1 — Mon, 05 Oct 2020 14:02:01 GMT

My major issue was I was trying to zip the fgdb and it was causing it to break when using the shutil.make_archive. I coded around it in the following way by avoiding the lock files:

# shutil.make_archive(fgdbPath, 'zip', ZipPath,fgdb) -- this breaks with this bug

zf = zipfile.ZipFile(FGDBArchive, "w")
for dirname, subdirs, files in os.walk(fgdbPath):
   for filename in files:
      zfilename, zfileext = os.path.splitext(filename)
      if (zfileext != ".lock"):

zf.write(os.path.join(fgdbPath, filename), os.path.join(fgdb, filename), zipfile.ZIP_DEFLATED)
zf.close()

Re: arcpro 2.6 arcpy fgdb lock files not clearing

CooperLogan — Mon, 05 Oct 2020 15:41:13 GMT

Hi Don,

One workaround that allowed some users to circumvent the problem is to add the following line right before the script errors out:

arcpy.ClearWorkspaceCache_management()

I hope this helps!

Cooper

Don Morrison‌

Re: arcpro 2.6 arcpy fgdb lock files not clearing

MarcoBoeringa — Mon, 05 Oct 2020 20:37:37 GMT

Cooper Logan‌,

I am confused. This issue is about File Geodatabases being kept locked. The workaround you suggested shouldn't work according to this Help page, as arcpy.ClearWorkspaceCache_management() is only supposed to do anything for Enterprise Geodatabases, not File Geodatabases. The Help is quite adamant on that aspect:

"This tool only works with enterprise geodatabase workspaces."

Re: arcpro 2.6 arcpy fgdb lock files not clearing

MarcoBoeringa — Mon, 05 Oct 2020 20:44:14 GMT

I also wonder if this issue is actually being worked on? This is a quite hideous issue, causing significant problems for arcpy / Python development. I have reported a similar issue to the Dutch branch of ESRI based on a custom arcpy Python geoprocessing tool of mine that suddenly started failing going from Pro 2.4.3 to Pro 2.5, and the issue was also caused by left over *.lock files in a File Geodatabase folder, that weren't being cleaned up in Pro 2.5, while not an issue and being cleared properly in Pro 2.4.3.

It is registered as:

BUG-000131154 Fgdb locking behavior is different in ArcGIS Pro 2.5 to ArcGIS Pro 2.4.3 for copying styles

Re: arcpro 2.6 arcpy fgdb lock files not clearing

DonMorrison1 — Mon, 05 Oct 2020 21:54:36 GMT

Excellent idea. I was already using similar code to zip the file so it was an easy modification to filter out the .lock files. I was expecting have have problems deleting the file geodatabase after the zip but that seems to work OK even with the .lock file.

Re: arcpro 2.6 arcpy fgdb lock files not clearing

JustinKraemer — Thu, 02 Sep 2021 19:08:11 GMT

@MarcoBoeringa, I saw your reply, but decided to give it a try anyway, and found it worked! Mine is a file geodatabase. Just thought I should share

Re: arcpro 2.6 arcpy fgdb lock files not clearing

GavinMcGhie — Wed, 15 May 2024 20:43:13 GMT

I would add that I also used this solution to resolve a lock on an FGDB prior to trying to zip it with py.shutil and it resolved my issue as well even through it's an FGDB!