[mapguide-users] Strange SDF locking problem

[doggybs]

Hi All

Thanks for you comments, very helpful. I will experiment with the connection
pool settings to see if this helps.

Current yes SDF is set for connection pooling and pool size is set to 200.
There are 170 SDF files spread across two maps, one with 123, and the other
with 47.

I will let you know if adjusting the connection pooling helps.

Many Thanks


Kenneth Skovhede, GEOGRAF A/S wrote:
> 
> How many SDF files are there in total?
> 
> I had a problem with the OGR provider, as it is capable of pointing to a 
> folder of files.
> Very nice, because you can have one dataconnection and it just contains 
> all the tables/files.
> Unfortunately , Windows has a limit on 512 open files.
> A standard MapInfo table consists of 4 files, so a folder with 30 tables 
> takes 120 file handles.
> The connection pool is set to 200 as a default, so you can guess how 
> fast it breaks.
> 
> My experiments show that, depending on the compilation options of the 
> provider,
> the 512 limit is sometimes "pr provider" and sometimes "pr mapguide".
> 
> I would suggest trying to reduce the connection pool to 50 (SDF only has 
> one or two files open).
> 
> Also, you can try to run MapGuide interactively instead of as a service, 
> and you may see the errors
> in the console.
> 
> Regards, Kenneth Skovhede, GEOGRAF A/S
> 
> 
> 
> doggybs skrev:
>> Hi All
>>
>> I am having a very strange problem with Mapguide 2010, and I have no idea
>> what the problem could be or where to start looking for it.
>>
>> The problem only seems to happen in a multi user situation, but what
>> seems
>> to happen is that mapguide will randomly lockout a random selection of
>> SDF
>> files.
>>
>> The end result is quite catastrophic :
>>
>> - All users are no long able to view any of these SDF datasources
>> - tooltips on all layers stop working
>> - all labels on all layers stop appearing
>> - Testing of SDF connections using mapguide studio fails.
>>
>> There is also no indication in the error logs as to what the problem
>> might
>> be.
>>
>> The only way to get the effected layers and map working again is to
>> performance a service restart.
>>
>> I am using FDO version 3.4.0.4701
>>
>> I would be very grateful for any ideas you may have about this problem?
>>
>>
>>
>>   
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Strange-SDF-locking-problem-tp3405182p3408730.html
Sent from the MapGuide Users mailing list archive at Nabble.com.