da.editor throwing error

Question

Getting an error when I run this. Cant see why. Any ideas?

with arcpy.da.Editor(r"D:\GIS-DATA\bay-arcgis-pro@sde@sde.sde"):
    with arcpy.da.UpdateCursor(production_parcels,'OID@') as cursor:
                    for row in cursor:
                        if row[0] in delete_OIDs:
                            cursor.deleteRow()                       
    with arcpy.da.UpdateCursor(staging_parcels,'OID@') as cursor:
                    for row in cursor:
                        if row[0] not in append_OIDs:
                            cursor.deleteRow()               
    arcpy.Append_management(staging_parcels,production_parcels,'NO_TEST')

Traceback (most recent call last):
** IDLE Internal Exception: 
  File "D:\Python27\ArcGISx6410.1\lib\idlelibun.py", line 93, in main
    seq, request = rpc.request_queue.get(block=True, timeout=0.05)
  File "D:\Python27\ArcGISx6410.1\lib\Queue.py", line 177, in get
    self.not_empty.wait(remaining)
  File "D:\Python27\ArcGISx6410.1\lib	hreading.py", line 262, in wait
    delay = min(delay * 2, remaining, .05)
RuntimeError: start edit session

ChrisMathers · Answer

Had time to poke at this some more and from a run of exactly the code above run on a 10.2 install got an error that I was trying to edit a closed state. Never a dull moment.

EDIT: Worked at 10.2 after a compress cleared most of the states from the state lineage in the database. Ill try on the 10.1 install where this will run as a scheduled task and update.

EDIT-2: Looks like it was a database state hang up. Works fine now and is faster than making a selection and then deleting the selection.

ChrisMathers · Answer

My problem is that I have to delete based on a list of OIDs and in one list there will be around 4000 and the other will be around 117100. The SQL statement that the select tool takes cant be that long so I have to do it in cycles. That is a work around but isn't doesn't resolve the underlying issue here.

curtvprice · Answer

I have no expertise with ArcSDE, but are you sure you may not get better performance anyway by doing a selection on a layer and using the Delete Rows tool - which would do the row deletes at the arc objects level? You can create a sql expression like this:

delete_list = ",".join([str(k) for k in delete_OIDs])
where = "OBJECTID IN ({})".format(delete_list)