Well after trying everything suggested and then some including manually deleting the cursor outside of a comprehension, using a context manager, moving it into separate functions, etc. etc. I finally got it to work the way I wanted it to. I eventually found out it was something to do with calling it from a while loop. I'm not 100% sure why, but if I got rid of that it worked as expected. So, what I got rid of the while loop entirely, and just have the function call itself after sleeping. From everything I've read it seems like this is an acceptable solution, and it actually works properly.
So instead of this.
def monitoring():
while True:
app.check_now("")
# Check every 30 minutes.
time.sleep(1800)
I'm using this.
def monitoring():
"""Checks for updates every 30 minutes."""
app.check_now("auto")
time.sleep(1800)
threading.Thread(target=monitoring, daemon=True).start()
Which calls the searchcursor via.
def get_mapped_permits(self):
"""Returns a list of building permits found in the BuildingPermits
feature class for the current year."""
with arcpy.da.SearchCursor(self.feature_class, "PERMIT_NUM") as search:
return [permit[0] for permit in search]
Thanks for all the help!
One last note on this in case it will help anyone in the future, I added another call to the function containing the SearchCursor() and started having the same problem again. Was able to fix it by changing the function to target an instance variable rather than return the value, then wrapping the function call in a daemon thread (terminology may be incorrect, noob, sry...) this produced the expected result.
def get_mapped_permits(self):
with arcpy.da.SearchCursor(self.feature_class, "PERMIT_NUM") as search:
self.mapped_permits = [permit[0] for permit in search]
# called from
self.mapped_permits.clear()
t = threading.Thread(target=self.get_mapped_permits, daemon=True)
t.start()
