topic Re: Can I have multiple open arcpy.da.InsertCursor at the same time? in Python Questions

Can I have multiple open arcpy.da.InsertCursor at the same time?

TimDine — Wed, 03 Oct 2012 17:42:09 GMT

Is this possible or do you have to delete one cursor before opening another?

I create the first cursor, make a row, and insert it. I make the second cursor, make a row, attempt to insert it, and I get the error "workspace already in transaction mode".

While creating cursors in the new form is much faster (I measured 10X) it should still be faster to have all of the cursors I`m going to use created once rather than 50000 times. I`m loading features in a random order from randomly ordered XML files.

Re: Can I have multiple open arcpy.da.InsertCursor at the same time?

curtvprice — Wed, 03 Oct 2012 18:48:53 GMT

Is this possible or do you have to delete one cursor before opening another?

The arcpy.da.SearchCursor" rel="nofollow" target="_blank">http://resources.arcgis.com/en/help/main/10.1/index.html#/UpdateCursor/018w00000014000000/]arcpy.da.SearchCursor doc says right up front:

Opening simultaneous insert and/or update operations on the same workspace using different cursors requires the start of an edit session.

Re: Can I have multiple open arcpy.da.InsertCursor at the same time?

ClayPerry — Wed, 03 Oct 2012 19:03:47 GMT

I think if you are adding features from various sources into a single feature class, you only need one insert cursor running to handle the record insertion. The source files would require individual search cursors to pull the information to be added by the insert cursor. You would probably want some sort of loop to run through the input files that does the following: creates a search cursor, grabs some info, adds the gathered information via the insert cursor to your new feature class, and closes the search cursor. But like a previous post said, apparently you can't open multiple insert/update cursors without and edit session being open.

Re: Can I have multiple open arcpy.da.InsertCursor at the same time?

TimDine — Sat, 11 Dec 2021 16:27:30 GMT

So I did miss that note, I see it right at the top of the arcpy.da.insertcursor documentation as well now. In the mean time I managed to get an error about the feature class not being editable outside an edit session which got me onto an edit session for an unrelated reason. I now have a far simplified chunk of code that gives me the same error. "workspace already in transaction mode".

import arcpy

edit = arcpy.da.Editor(r'C:/Projects/GISPROD_ElectricDistribution_Extract.gdb')

edit.startEditing(False,False)

theIC = arcpy.da.InsertCursor(r'C:/Projects/GISPROD_ElectricDistribution_Extract.gdb/electric/servicepoint',['PHASEDESIGNATION', 'WORKORDERID', 'SUBTYPECD', 'PLACEMENTCONFIDENCE', 'SHAPE@'])
theIC.insertRow(['7', '280773', '1', '90', arcpy.Point(292840.72313, 4818098.69548)])

edit.stopEditing(False)

Thoughts? There is a geometric network buried in there, but there are not objects that are not straight arcgis object classes that I am aware of.

Re: Can I have multiple open arcpy.da.InsertCursor at the same time?

TimDine — Thu, 04 Oct 2012 16:58:14 GMT

I believe it's data related. I think I've got it sorted.

Marking the original answer as correct.

Re: Can I have multiple open arcpy.da.InsertCursor at the same time?

DouglasHall — Sat, 11 Dec 2021 16:27:33 GMT

Just FYI, I can't create and delete 3 insert cursors squentially without getting the following error. (Sequentially meaning that I'm creating and deleting the cursor before creating the next one).

RuntimeError: workspace already in transaction mode

Upon creating the third cursor and attempting to insertRow(), I get the error.

It doesn't matter if I'm in the editing session or not.

I can comment out any one of the 3 cursor insert blocks and the other 2 will work.

Using a with clause or cursor = ..., doesn't matter

with arcpy.da.InsertCursor('Points_Geom', ["PointID", 'SHAPE@XY']) as cursor:
    cursor.insertRow((123458, (4364181.91, 263840.13)))

cursor = arcpy.da.InsertCursor('Points_Geom', ["PointID", 'SHAPE@XY'])
cursor.insertRow((123458, (4364181.91, 263840.13)))
del cursor

Re: Can I have multiple open arcpy.da.InsertCursor at the same time?

PaulSchneider — Thu, 12 Dec 2013 13:27:31 GMT

Try this link as another possible solution to this error.