nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

lock files remains for local geodatabase in WPF App

MyronChew

After I used OpenAsync on a local geodatabase, it created these two lock files: .geodatabase-wal,.geodatabase-shm after I added some layers to the MapView. The lock files remain even I removed all its layers or perform GC.Collect. Is there a way to close the opened geodatabase without closing the application?

Find more posts tagged with

Accepted answers

All comments

SomeGISGuy

Did you also remove all references to the table, geodatabase and waited for pending finalizers?

MyronChew

Hi Nielsen

Thanks for your quick reply.

The following is my test project I pulled out from our
development. Unloading will not release the map lock files.

My xaml markup and code are as followed:

<Window

xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"

xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

xmlns:esri="http://schemas.esri.com/arcgis/runtime/2013" xmlns:Custom="http://infragistics.com/DockManager" x:Class="ArcGISRunTimeTest.MainWindow"

Title="MainWindow" Height="350" Width="525">

<Grid>

<esri:MapView x:Name="mapView" HorizontalAlignment="Stretch" VerticalAlignment="Stretch" MouseDown="MapView_MouseDown" MapViewTapped="MapView_MapViewTapped" MouseDoubleClick="MapView_MouseDoubleClick" KeyDown="MapView_KeyDown" Margin="0,63,0.4,0.4" ExtentChanged="mapView_ExtentChanged" MouseMove="mapView_MouseMove" PreviewMouseDoubleClick="mapView_PreviewMouseDoubleClick">

<esri:Map>

<esri:GraphicsLayer x:Name="graphicsLayer"
/>

</esri:Map>

</esri:MapView>

</Grid>

</Window>

private async void Load_Click(object sender, RoutedEventArgs e)

{

if
(!mapView.IsInitialized) return;

mapView.Map = new Map()

{

InitialViewpoint = new Viewpoint(new Envelope(-13054165, 3850112, -13027133, 3863559, SpatialReferences.WebMercator))

};

mapView.Map.SpatialReference = SpatialReferences.WebMercator;

Geodatabase gdb = await Geodatabase.OpenAsync(@C:\Temp\H2OTEST.IWDB\Map\map.geodatabase);

GeodatabaseFeatureTable gftable = gdb.FeatureTables.FirstOrDefault(m =>
m.Name.ToUpper() == "JUNCTION");

FeatureLayer myFeatureLayer = new Esri.ArcGISRuntime.Layers.FeatureLayer(gftable);

mapView.Map.Layers.Add(myFeatureLayer);

gftable
= gdb.FeatureTables.FirstOrDefault(m => m.Name.ToUpper() == "PIPE");

mapView.SetViewAsync(myFeatureLayer.FullExtent);

myFeatureLayer = new Esri.ArcGISRuntime.Layers.FeatureLayer(gftable);

mapView.Map.Layers.Add(myFeatureLayer);

}

private void Unload_Click(object sender, RoutedEventArgs e)

{

mapView.Map.Layers.Clear();

System.GC.Collect();

GC.WaitForPendingFinalizers();

}

ArtemHmara

Did you find out solution for this issue?

ReedHunter

I ran into this problem, and the WaitForPendingFinalizers clue helped me to solve this. I have a .Net app for downloading a geodatabase, acquiring and writing to the geodatabase some attributes from an external sql server database, syncing edits back if necessary to the feature service, and then zipping the offline geodatabase. The geodatabase openasync however would hold a lock on the .geodatabase file, preventing the zip from working. The solution was to structure my program this way ...

static void Main()

{

var gdbPath = "";

Task.Run(async () =>

{

//omitting code for downloading geodatabase asynchronously, and other operations on the file

}).Wait();

GC.Collect();

GC.WaitForPendingFinalizers();

//code to zip the geodatabase

}

Hope this helps anyone else who comes across this problem.

PhilScovis

I've had this problem too; This thread claims that it is a known bug.

In my case, I'm trying to re-create a .geodatabase from the server. I can remove the existing layer from the map view, but there's no way to dispose it.

My workaround was to use a new filename for the new file. I check for old files when the application starts, and try to delete them. This is not ideal, because the old file will remain in the filesystem until the application restarts.

AnttiKajanus1

You can use Geodatabase.Close Method to close the geodatabase so all the locks are released.

PhilScovis

That worked; thank you!

PhilScovis

Is there an equivalent for a .tpk file that is being held open by a Tiled Layer?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.