Display Computer Names in Python

MattDeveney

Hello, I am running ArcGIS 10.1 using file geodatabases.  In order to update information across geodatabases I run a model that copies the information to each, unless the data is in use, causing a schema lock.  If I were to convert my model into a python script, is there any way to have it display the users computer name that is causing the schema lock?

FreddieGibson

I don't believe there is an out-of-the-box way to do this if you're not using an enterprise geodatabase. If you wanted to get an idea of what machine may have created the lock I'd think that you can use pure python to list out the *.lock files that appear in the geodatabase. From this file you should be able to parse out the machine accessing the content within the geodatabase. For example, I tried this out on my machine and I can see that there are lock files with the following names.

_gdb.UZUMAKI.10792.10812.SR.lock

In the above case UZUMAKI is the hostname for my machine that is accessing the data. If needed you could use the following class to check if you're able to get an exclusive lock on the data.

TestSchemaLock

http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-functions/testschemalock.htm