I'm having trouble removing a schema lock from a feature class in a file geodatabase after running arcpy.MakeFeatureLayer(). The typical arcpy.Delete(layer) isn't working. I only experience this issue when running this with Pro's (1.4.1) version of python. It works fine with ArcGIS Desktop. Any ideas? Here's a script that demonstrates the issue: import arcpy arcpy . management . CreateFileGDB ( r "C:\temp" , "test.gdb" , "CURRENT" ) arcpy . management . CreateFeatureclass ( r "C:\temp\test.gdb" , "Test" , "POLYGON" , None , None , "ENABLED" , "PROJCS [ 'WGS_1984_Web_Mercator_Auxiliary_Sphere' , GEOGCS [ 'GCS_WGS_1984' , DATUM [ 'D_WGS_1984' , SPHEROID [ 'WGS_1984' , 6378137.0 , 298.257223563 ] ] , PRIMEM [ 'Greenwich' , 0.0 ] , UNIT [ 'Degree' , 0.0174532925199433 ] ] , PROJECTION [ 'Mercator_Auxiliary_Sphere' ] , PARAMETER [ 'False_Easting' , 0.0 ] , PARAMETER [ 'False_Northing' , 0.0 ] , PARAMETER [ 'Central_Meridian' , 0.0 ] , PARAMETER [ 'Standard_Parallel_1' , 0.0 ] , PARAMETER [ 'Auxiliary_Sphere_Type' , 0.0 ] , UNIT [ 'Meter' , 1.0 ] ] ; - 20037700 - 30241100 10000 ; #;#;0.001;#;#;IsHighPrecision", None, 0, 0, 0) arcpy . env . workspace = "c:\\temp\\test.gdb" layer = arcpy . MakeFeatureLayer_management ( 'Test' , 'NewTest' ) arcpy . Delete_management ( 'NewTest' , 'Layer' ) del layer arcpy . env . workspace = "" #: lock still exists arcpy . Delete_management ( "C:\\temp\\test.gdb" ) """ This throws an exception: arcgisscripting.ExecuteError: ERROR 000601: Cannot delete C:\Temp\test.gdb. May be locked by another application. """

Hi All, I'm still having this challenge. To summarize the code below: * From a point feature class I'm making a point feature layer (if the point feature layer already exists I specify to delete and overwrite it)--see line 7 in code sample * Do stuff with the point feature layer (lines 9-55) * Once done doing stuff with the point feature layer, I specify to try and delete it (line 59). But I cannot delete it because it has a schema lock on it. More info: * The issue does not affect when I run in a desktop environment. It only comes up once I publish the tool using the code to my agency's Portal hosted on ArcServer * This creates problems because there are various points in my script where the same process is re-run on the same feature class, so the feature layers for * The problem is intermittent (but happens more than half the time I run the tool), and I can't pin down the exact conditions that trigger it. * I've tried the following with no success:* Putting feature layer in "in-memory" * Making copy of source feature class in scratch GDB * adding a time.clock() suffix to the feature class name so that every time it is created it has a unique name. What I want to know: Is there anything I can do to "release" the feature layer so that it can be deleted? I hope this is the right thread to post this on. Any help much appreciated. def intersection_density ( fc_project , fc_intersxns , project_type ) : arcpy . AddMessage ( "Calculating intersection density..." ) fl_project = 'fl_project' #weirdly, the project line feature class has no problems # the intersections fl is what's problematic. Trying to create in temp memory workspace fl_intersxns = os . path . join ( 'memory' , 'fl_intersxns' ) extest = arcpy . Exists ( fl_intersxns ) arcpy . AddMessage ( "Does intersection fl exist? {}" . format ( extest ) ) try : if arcpy . Exists ( fl_project ) : arcpy . Delete_management ( fl_project ) arcpy . MakeFeatureLayer_management ( fc_project , fl_project ) # the first time through, it seems fine and creates the intersections feature layer without problems if arcpy . Exists ( fl_intersxns ) : arcpy . Delete_management ( fl_intersxns ) arcpy . MakeFeatureLayer_management ( fc_intersxns , fl_intersxns ) if project_type == params . ptype_area_agg : fc_buff = fc_project else : params . intersxn_dens_buff fc_buff = r "memory\temp_buff_qmi" arcpy . Buffer_analysis ( fl_project , fc_buff , params . intersxn_dens_buff ) fl_buff = "fl_buff" if arcpy . Exists ( fl_buff ) : arcpy . Delete_management ( fl_buff ) arcpy . MakeFeatureLayer_management ( fc_buff , fl_buff ) buff_acres = get_poly_area ( fl_buff ) arcpy . SelectLayerByLocation_management ( fl_intersxns , "INTERSECT" , fl_buff , 0 , "NEW_SELECTION" ) intsxn_34 = 0 col_link_cnt = "LINKS" with arcpy . da . SearchCursor ( fl_intersxns , [ col_link_cnt ] ) as cur : for row in cur : if row [ 0 ] > 2 : intsxn_34 += 1 intersxns_per_acre = intsxn_34 / buff_acres if buff_acres > 0 else 0 arcpy . AddMessage ( "Successfully calculated intersections per acre." ) return { "Intersxn_34_per_acre" : intersxns_per_acre } except : msg = "{}, {}" . format ( arcpy . GetMessages ( 2 ) , trace ( ) ) arcpy . AddWarning ( msg ) finally : if arcpy . Exists ( fl_intersxns ) : try : #HERE IS WHERE IT THROWS ERROR 000464: cannot delete because of schema lock. Why is it still locked? arcpy . Delete_management ( fl_intersxns ) except : msg = "trying arcpy.Delete_management: {}, {}" . format ( arcpy . GetMessages ( 2 ) , trace ( ) ) arcpy . AddWarning ( msg ) n = gc . collect ( )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trouble Removing Schema Lock After arcpy.MakeFeatureLayer (Pro Only)

ScottDavis

I'm having trouble removing a schema lock from a feature class in a file geodatabase after running arcpy.MakeFeatureLayer(). The typical arcpy.Delete(layer) isn't working.

I only experience this issue when running this with Pro's (1.4.1) version of python. It works fine with ArcGIS Desktop. Any ideas?

Demo

Here's a script that demonstrates the issue:

<SPAN class="keyword token">import</SPAN> arcpy
arcpy<SPAN class="punctuation token">.</SPAN>management<SPAN class="punctuation token">.</SPAN>CreateFileGDB<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\temp"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"test.gdb"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CURRENT"</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>management<SPAN class="punctuation token">.</SPAN>CreateFeatureclass<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">"C:\temp\test.gdb"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Test"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POLYGON"</SPAN><SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ENABLED"</SPAN><SPAN class="punctuation token">,</SPAN> "PROJCS<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'WGS_1984_Web_Mercator_Auxiliary_Sphere'</SPAN><SPAN class="punctuation token">,</SPAN>GEOGCS<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GCS_WGS_1984'</SPAN><SPAN class="punctuation token">,</SPAN>DATUM<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'D_WGS_1984'</SPAN><SPAN class="punctuation token">,</SPAN>SPHEROID<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'WGS_1984'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">6378137.0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">298.257223563</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PRIMEM<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Greenwich'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>UNIT<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Degree'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0174532925199433</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PROJECTION<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Mercator_Auxiliary_Sphere'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'False_Easting'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'False_Northing'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Central_Meridian'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Standard_Parallel_1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Auxiliary_Sphere_Type'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>UNIT<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Meter'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">20037700</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">30241100</SPAN> <SPAN class="number token">10000</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="comment token">#;#;0.001;#;#;IsHighPrecision", None, 0, 0, 0)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"c:\\temp\\test.gdb"</SPAN>
layer <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Test'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NewTest'</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'NewTest'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Layer'</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> layer
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN>
<SPAN class="comment token">#: lock still exists</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"C:\\temp\\test.gdb"</SPAN><SPAN class="punctuation token">)</SPAN> 

<SPAN class="string token">"""
This throws an exception: 
arcgisscripting.ExecuteError: ERROR 000601: Cannot delete C:\Temp\test.gdb.&nbsp; 
May be locked by another application.
"""</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

All comments

HanZheng

My situation is that my python notebook script in my ArcGIS Pro project needs to read a *.shp as input and drop bunch of files in my default geodatabase. After the script finishes, there is always a lock to that input shapefile unless I closed the ArcGIS project. Ideally, I'd like to have that lock release after Python script finishes running.

I am looking for a solution (maybe a line of python script in the end) that the scheme lock of that input shapefile can be released after script completes execution without me closing ArcGIS Pro project.

DarrenConly

Hi All,

I'm still having this challenge. To summarize the code below:

From a point feature class I'm making a point feature layer (if the point feature layer already exists I specify to delete and overwrite it)--see line 7 in code sample
Do stuff with the point feature layer (lines 9-55)
Once done doing stuff with the point feature layer, I specify to try and delete it (line 59). But I cannot delete it because it has a schema lock on it.

More info:

The issue does not affect when I run in a desktop environment. It only comes up once I publish the tool using the code to my agency's Portal hosted on ArcServer
This creates problems because there are various points in my script where the same process is re-run on the same feature class, so the feature layers for
The problem is intermittent (but happens more than half the time I run the tool), and I can't pin down the exact conditions that trigger it.
I've tried the following with no success:
- Putting feature layer in "in-memory"
- Making copy of source feature class in scratch GDB
- adding a time.clock() suffix to the feature class name so that every time it is created it has a unique name.

What I want to know:

Is there anything I can do to "release" the feature layer so that it can be deleted?

I hope this is the right thread to post this on. Any help much appreciated.

<SPAN class="keyword token">def</SPAN> <SPAN class="token function">intersection_density</SPAN><SPAN class="punctuation token">(</SPAN>fc_project<SPAN class="punctuation token">,</SPAN> fc_intersxns<SPAN class="punctuation token">,</SPAN> project_type<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Calculating intersection density..."</SPAN><SPAN class="punctuation token">)</SPAN>
    
    fl_project <SPAN class="operator token">=</SPAN> <SPAN class="string token">'fl_project'</SPAN> <SPAN class="comment token">#weirdly, the project line feature class has no problems</SPAN>

    <SPAN class="comment token"># the intersections fl is what's problematic. Trying to create in temp memory workspace</SPAN>
    fl_intersxns <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'memory'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'fl_intersxns'</SPAN><SPAN class="punctuation token">)</SPAN>

    extest <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>fl_intersxns<SPAN class="punctuation token">)</SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Does intersection fl exist? {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>extest<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

    <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
        
        <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>fl_project<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>fl_project<SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc_project<SPAN class="punctuation token">,</SPAN> fl_project<SPAN class="punctuation token">)</SPAN>
        
        <SPAN class="comment token"># the first time through, it seems fine and creates the intersections feature layer without problems</SPAN>
        <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>fl_intersxns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>fl_intersxns<SPAN class="punctuation token">)</SPAN>    
        arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc_intersxns<SPAN class="punctuation token">,</SPAN> fl_intersxns<SPAN class="punctuation token">)</SPAN>


        <SPAN class="keyword token">if</SPAN> project_type <SPAN class="operator token">==</SPAN> params<SPAN class="punctuation token">.</SPAN>ptype_area_agg<SPAN class="punctuation token">:</SPAN>
            fc_buff <SPAN class="operator token">=</SPAN> fc_project
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            params<SPAN class="punctuation token">.</SPAN>intersxn_dens_buff
            fc_buff <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"memory\temp_buff_qmi"</SPAN>
            arcpy<SPAN class="punctuation token">.</SPAN>Buffer_analysis<SPAN class="punctuation token">(</SPAN>fl_project<SPAN class="punctuation token">,</SPAN> fc_buff<SPAN class="punctuation token">,</SPAN> params<SPAN class="punctuation token">.</SPAN>intersxn_dens_buff<SPAN class="punctuation token">)</SPAN>

        fl_buff <SPAN class="operator token">=</SPAN> <SPAN class="string token">"fl_buff"</SPAN>
    
        <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>fl_buff<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>fl_buff<SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc_buff<SPAN class="punctuation token">,</SPAN> fl_buff<SPAN class="punctuation token">)</SPAN>

        buff_acres <SPAN class="operator token">=</SPAN> get_poly_area<SPAN class="punctuation token">(</SPAN>fl_buff<SPAN class="punctuation token">)</SPAN>

        arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management<SPAN class="punctuation token">(</SPAN>fl_intersxns<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"INTERSECT"</SPAN><SPAN class="punctuation token">,</SPAN> fl_buff<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">)</SPAN>

        intsxn_34 <SPAN class="operator token">=</SPAN> <SPAN class="number token">0</SPAN>
        col_link_cnt <SPAN class="operator token">=</SPAN> <SPAN class="string token">"LINKS"</SPAN>

        <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fl_intersxns<SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN>col_link_cnt<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
                <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">></SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">:</SPAN>
                    intsxn_34 <SPAN class="operator token">+=</SPAN> <SPAN class="number token">1</SPAN>

        intersxns_per_acre <SPAN class="operator token">=</SPAN> intsxn_34 <SPAN class="operator token">/</SPAN> buff_acres <SPAN class="keyword token">if</SPAN> buff_acres <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN> <SPAN class="keyword token">else</SPAN> <SPAN class="number token">0</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddMessage<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Successfully calculated intersections per acre."</SPAN><SPAN class="punctuation token">)</SPAN>

        <SPAN class="keyword token">return</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="string token">"Intersxn_34_per_acre"</SPAN><SPAN class="punctuation token">:</SPAN> intersxns_per_acre<SPAN class="punctuation token">}</SPAN>
        

    <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
        msg <SPAN class="operator token">=</SPAN> <SPAN class="string token">"{}, {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> trace<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>AddWarning<SPAN class="punctuation token">(</SPAN>msg<SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">finally</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Exists<SPAN class="punctuation token">(</SPAN>fl_intersxns<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> 
            <SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
                <SPAN class="comment token">#HERE IS WHERE IT THROWS ERROR 000464: cannot delete because of schema lock. Why is it still locked?</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>Delete_management<SPAN class="punctuation token">(</SPAN>fl_intersxns<SPAN class="punctuation token">)</SPAN>
            <SPAN class="keyword token">except</SPAN><SPAN class="punctuation token">:</SPAN>
                msg <SPAN class="operator token">=</SPAN> <SPAN class="string token">"trying arcpy.Delete_management: {}, {}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>GetMessages<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">,</SPAN> trace<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>AddWarning<SPAN class="punctuation token">(</SPAN>msg<SPAN class="punctuation token">)</SPAN>

        n <SPAN class="operator token">=</SPAN> gc<SPAN class="punctuation token">.</SPAN>collect<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RobertHolliday

Working with tech support BUG-000129022 was logged. In my case, updating FC attributes in a scratch FGDB with update cursors caused locks which prevented deletion of the scratch FGDB. Substituting calculate field for the update cursors is a viable option in this case as the FC in question only contains a few thousand features.

Specifically: arcgisscripting.ExecuteError: ERROR 000601: Cannot delete C:\TEMP\ESRI_Case_geodatabase_locks\proc.gdb. May be locked by another application.
Failed to execute (Delete).

In theory creating the cursors using the following construct should release locks after the cursor executes.

with arcpy.da.UpdateCursor(fc, [columns], where clause) as cursor:

for row in cursor:

do some calculation

cursor.updateRow(row)

ThomasL

Thank you Tomasz TARCHALSKI‌ for documenting this bug.

I am running version ArcGIS Pro 2.4.3 and have the same issue, but on a ShapeFile.

My workaround is to duplicate the data set to avoid this, not very ideal.

Any update to his Shaun Walbridge‌ ?

TomaszTARCHALSKI1

Hi, at version ArcGIS Pro 2.4.2, I have very, if not the same, behavior: I cannot delete layer, because of ERROR 000464: Cannot get exclusive schema lock.

Workflow of Script:

my script is accessing one feature class in fgdb stored on NAS --> meaning read only files
next it create layers (in local fgdb ), do some intersection within my zone (AOI) and export to local feature class
when trying to delete the layer, the scripts fails due to the above error.

Here are my observation:

Executing script standalone and using python 3x and based on fgdb stored on NAS (read only files) --> it fails
Executing script in Pyton 2.7 --> it works!
Executing script through toolbox in ArcGIS Pro --> it works!
Executing script standalone and using python 3.x and based on fgdb stored locally (so no attributes of read only) --> it works!

I am attaching zip file with script, and 2 fgdb:

one fgdb which is created normally (access read/write)
the second fgdb where after creation, I've changed read/write rights within windows explorer and properties of folder.

As said above if executing script with "read only" fgdb by:

"c:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3" test.py - it fails
"C:\Python27\ArcGISx6410.6\python.exe" test.py -it works

As said above if executing script with "read/write" fgdb by:

"c:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3" test.py - it works
"C:\Python27\ArcGISx6410.6\python.exe" test.py -it work

link to dropox with zip file of script and data

What is the problem? Anyone ?

Thank you, Tomasz

screenshot of script

ShaunWalbridge

Francisco,

In the case you describe I think the error is accurate, since there are two separate processes trying to access the workspace simultaneously. You could do something like create a temporary workspace for each process, and then write to the shared workspace only at the end to avoid having this overlap, or if your data is small enough, use in memory workspaces in each process till the final write step.

Cheers,

Shaun

FranciscoCosta1

Shaun Walbridge‌ Scott Davis Using Jupyter with ArcGIS Pro open, seems also is occurring , i.e. :

ArcGIS Pro v2.4.1 is open: arcpy.env.workspace = 'D:\\some_projects\\cogubem\\scratch.gdb'

No locks in here.

Jupyter Nb is open: arcpy.env.workspace = 'C:\\%users%\\AppData\\Local\\Temp\\scratch.gdb'

ExecuteError: ERROR 000464: Cannot get exclusive schema lock. Either being edited or in use by another application or service. Failed to execute (Delete).

And Jupyter Nb is running a cloned conda environment of arcpy accordingly.

Found way of sorting it although is for case here so i would like to know if in your case this also works.

ShaunWalbridge

Scott Davis‌ Adam Thomas This issue has been resolved in Pro 2.3. Thanks for bringing it up, and if you see something similar once you have Pro 2.3, let me know.

Cheers,

Shaun

CC Kory Kramer‌

AdamThomas3

One possible solution is to use the scratch workspace instead of creating your own temp workspace. The lock will still be created in the scratch workspace (it only exists while the python process is running, just like before), but the scratch workspace isn't intended to be deleted, so you won't need to do any cleanup afterwards. Arcpy will always have access to create the same scratch workspace for each process that is created. In my case the scratch workspace is created in C:\Users\{user}\AppData\Local\Temp\scratch.gdb.

Here is the sample script from above, modified to use the scratch workspace instead:

<SPAN class="keyword token">import</SPAN> arcpy
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>scratchGDB
arcpy<SPAN class="punctuation token">.</SPAN>management<SPAN class="punctuation token">.</SPAN>CreateFeatureclass<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"Test"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POLYGON"</SPAN><SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> None<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"ENABLED"</SPAN><SPAN class="punctuation token">,</SPAN> "PROJCS<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'WGS_1984_Web_Mercator_Auxiliary_Sphere'</SPAN><SPAN class="punctuation token">,</SPAN>GEOGCS<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'GCS_WGS_1984'</SPAN><SPAN class="punctuation token">,</SPAN>DATUM<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'D_WGS_1984'</SPAN><SPAN class="punctuation token">,</SPAN>SPHEROID<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'WGS_1984'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">6378137.0</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">298.257223563</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PRIMEM<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Greenwich'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>UNIT<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Degree'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0174532925199433</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PROJECTION<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Mercator_Auxiliary_Sphere'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'False_Easting'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'False_Northing'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Central_Meridian'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Standard_Parallel_1'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>PARAMETER<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Auxiliary_Sphere_Type'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">0.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>UNIT<SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Meter'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">1.0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">20037700</SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">30241100</SPAN> <SPAN class="number token">10000</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="comment token">#;#;0.001;#;#;IsHighPrecision", None, 0, 0, 0)</SPAN>
layer <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Test'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'NewTest'</SPAN><SPAN class="punctuation token">)</SPAN>‍‍‍‍

<SPAN class="comment token"># No cleanup required here.</SPAN>
<SPAN class="comment token"># The scratch workspace is recreated every time it is used.</SPAN>
<SPAN class="comment token"># Pretend it never existed!‍‍‍‍‍</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

AdamThomas3

This is logged as BUG-000086232 here: https://support.esri.com/en/bugs/nimbus/QlVHLTAwMDA4NjIzMg==, but there is currently no plan to resolve it.

AdamThomas3

Scott Davis - I am experiencing the exact issue you describe, but I am using ArcMap Desktop 10.5.1 using Python 2.7.

Here's my workflow in a single script:

1. Create temporary gdb and feature class (on C:\temp for speed)

2. Create feature layer from feature class (in-memory) to perform some analysis

3. Output results to desired destination

4. Delete temporary gdb (fail)

Robert LeClair‌ - The lock will remain for asynchronous processes until the python process has ended (and raised an error in this case), so adding time.sleep() during the process has no impact. I can delete the gdb in a separate process once the first process has ended.

Shaun Walbridge‌ - 1. The lock gets added to the source data and has no impact on the feature layer, so using in-memory for the feature layer does not help. 2. Not sure how you can make a feature layer from a feature class that has been deleted. 3. This appears to be the only solution for now.

ShaunWalbridge

Hello Adrian and Robert,

We've looked at this issue and it looks like a bug. It's a regression from 10.x where this behavior isn't observed. There are a few workarounds for this issue for anyone coming to this issue later:

1. Use an in-memory workspace for the temporary results you want to store

2. Delete the feature class created just prior to the layer creation

3. Run the MakeFeatureLayer step in a subprocess, so that it's process terminates prior to you trying to do further work in the GDB.

Cheers, Shaun

Robert LeClair

Hi Scott - first I have to mention I'm not a Python guru but have a suggestion or two to investigate based upon my research. First, you may want to run the "Analyze Tools for Pro" GP tool either in ArcMap or Pro. The GP tool will test your Python script to see if it will run in Python 3.5.2 (Pro's version of Python) and write a text file out to troubleshoot. Second, I haven't seen a bug mentioning the error codes but there was a suggestion to put a time.sleep() into your code for asynchronous processes. Refresh the folder. Does the LOCK remain? Pls advise.

AdrianWelsh

Hi Scott,

I looked around and did not see any solutions to this. I wonder if this is a bug and potentially fixed in ArcGIS Pro 2.0. I am tagging rleclair-esristaff‌ to see if he has any insight.

Also, it might help to form your discussion into a question in order to get more responses and more visibility.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.