[mapguide-users] Mapguide 4.0 FDO PostgreSQL connection issues

[Ari Hyvönen]

We have been using version MApguide 3.1.2 with PostgreSQL 11 server with
multiple databases for a few years and I have been testing version 4.0 and
faced issue with included FDO driver.

When site is idle for a while and database connections are closed from
connection pool looks like they are not really removed from pool. When new
request is made to site and database connection opened again Mapguide
server gets this error (with correct featuresource and class names). Also
when disabling connection pooling same error is shown and database
connection fails on all requests. Restarting server or saving database
featuresource fixes issue.

Error: An exception occurred in FDO component.
        Error occurred in Feature Source
(Library://XXX/Data/yyy.FeatureSource): Class 'public:yyy' not found
 (Cause: , Root Cause: Class 'public:yyy' not found )

When replacing FDO driver with version 4.1 from Mapguide 3.1.2 issue is
solved so this is either bug in FDO driver version 4.2 or incompatibility
with Mapguide 4.0 and FDO 4.2.

Otherwise everything seem to be running smoothly. I'm waiting for next
release and hope that it will include PHP 8.2 or PHP 8.3 as 8.1 is closing
in on end of security support.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapguide-users/attachments/20250527/69ae9893/attachment.htm>