[mapguide-users] Strange SDF locking problem

[Kenneth Skovhede, GEOGRAF A/S]

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?
>
>
>
>