Pause ArcPy script until feature class lock goes away

Question

My script needs to copy data into a feature class to an SDE geodatabase that might have a lock on it from another application. I shouldn't break the lock (that app has priority over a data update), but I also don't want the script to quit just because it tried at the wrong moment.

How can I set it to keep trying until there is no lock? I'm looking for something like a try/except, but more like try/keep-trying-every-15-seconds.

I considered making a separate function and adding a pause:

try:
    funcCopyData()
except:
    pause 10 seconds
    funcCopyData()

but wouldn't this still be limit me to only two attempts?

Answer 1

Ok, let me start this with I am no python expert, so there are probably much more efficient ways to accomplish this, but... the first thought that comes to me would be maybe something along the lines of the following (pseudo code below)

while success != True:
  funcCopyData()

def funcCopyData():
  try
    ...
    ...
    global var success = True
  except
    pause 10 sec

I don't know if that would work correctly or not as I don't know if the except would escape the while loop... but hopefully that at least gives you a thought.

Or you might look at the TestSchemaLock function and try something along the lines of

import arcpy, time
lockTest = arcpy.TestSchemaLock(featureClass)

while lockTest != True:
  time.sleep(10)
  lockTest = arcpy.TestSchemaLock(featureClass)

funcCopyData()

def funcCopyData():
  ...
  ...

I've never used the TestSchemaLock though, so I make no guarantees, but it sounds like it might meet what you are needing.

Hope it helps, edits/corrections welcome.