[mapguide-users] MySQL connection timing out

[Mark J.]

I'm having this same issue running MapGuide Server (Version 2.0.2.3011). It
looks as though this issue has been resolved (for future a future release
?). I'm new to this community so I don't know how this works, but there is a
service ticket for what looks like the same issue...

     http://trac.osgeo.org/mapguide/ticket/825

What does this mean for me? Do I have to wait for the next release or is
there a fix out there somewhere?

-Mark



George McLean wrote:
> 
> I left my development server last night thinking things were in pretty 
> good shape but this morning when querying a map no features stored in 
> MySQL and rendered using FDO were displayed.
> 
> I see in Mapguide's error log that starting at 4:12AM the connection was 
> lost to MySQL. Restarting theMySQL service did not fix the problem but 
> restarting MG did.
> 
> I have never seen this with MG 1.2 that I am aware of. I see there are 
> settings in MySQL that can extend the connection timeout but I am not 
> sure if this is the best solution.
> 
> Has anyone else seen this issue and found a solution?
> 
> I am not sure I completely understand what is happening here. Does MG 
> make a leave a connection open to MySQL? Why would I get a query attempt 
> every hour as shown in the log below? My first attempt to render a map 
> occurred at 08:51:21 as show below but the connection was apparently 
> broken by then?
> 
> Thanks again,
> 
> George McLean
> 

-- 
View this message in context: http://n2.nabble.com/MySQL-connection-timing-out-tp1816785p2353948.html
Sent from the MapGuide Users mailing list archive at Nabble.com.