[mapguide-users] MySQL connection timing out

[George McLean]

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

<2008-07-18T04:12:45>             Administrator
 Error: An exception occurred in FDO component.
        RDBMS: Lost connection to MySQL server during query
 StackTrace:
  - MgTimedEventHandler.handle_timeout line 123 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\TimedEventHandler.cpp
  - MgDataConnectionTimeoutEventHandler.HandleEvent line 89 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\DataConnectionTimeoutEventHandler.cpp
  - MgFdoConnectionManager.RemoveExpiredFdoConnections line 484 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\common\manager\FdoConnectionManager.cpp    
An exception occurred in FDO component.
RDBMS: Lost connection to MySQL server during query




<2008-07-18T05:12:49>             Administrator
 Error: An exception occurred in FDO component.
        RDBMS: MySQL server has gone away
 StackTrace:
  - MgTimedEventHandler.handle_timeout line 123 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\TimedEventHandler.cpp
  - MgDataConnectionTimeoutEventHandler.HandleEvent line 89 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\DataConnectionTimeoutEventHandler.cpp
  - MgFdoConnectionManager.RemoveExpiredFdoConnections line 484 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\common\manager\FdoConnectionManager.cpp    
An exception occurred in FDO component.
RDBMS: MySQL server has gone away


<2008-07-18T06:12:45>             Administrator
 Error: An exception occurred in FDO component.
        RDBMS: MySQL server has gone away
 StackTrace:
  - MgTimedEventHandler.handle_timeout line 123 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\TimedEventHandler.cpp
  - MgDataConnectionTimeoutEventHandler.HandleEvent line 89 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\DataConnectionTimeoutEventHandler.cpp
  - MgFdoConnectionManager.RemoveExpiredFdoConnections line 484 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\common\manager\FdoConnectionManager.cpp    
An exception occurred in FDO component.
RDBMS: MySQL server has gone away


<2008-07-18T07:12:45>             Administrator
 Error: An exception occurred in FDO component.
        RDBMS: MySQL server has gone away
 StackTrace:
  - MgTimedEventHandler.handle_timeout line 123 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\TimedEventHandler.cpp
  - MgDataConnectionTimeoutEventHandler.HandleEvent line 89 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\DataConnectionTimeoutEventHandler.cpp
  - MgFdoConnectionManager.RemoveExpiredFdoConnections line 484 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\common\manager\FdoConnectionManager.cpp    
An exception occurred in FDO component.
RDBMS: MySQL server has gone away



<2008-07-18T08:12:45>             Administrator
 Error: An exception occurred in FDO component.
        RDBMS: MySQL server has gone away
 StackTrace:
  - MgTimedEventHandler.handle_timeout line 123 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\TimedEventHandler.cpp
  - MgDataConnectionTimeoutEventHandler.HandleEvent line 89 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\core\DataConnectionTimeoutEventHandler.cpp
  - MgFdoConnectionManager.RemoveExpiredFdoConnections line 484 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\common\manager\FdoConnectionManager.cpp    
An exception occurred in FDO component.
RDBMS: MySQL server has gone away



<2008-07-18T08:51:21>         127.0.0.1    Administrator
 Error: Failed to stylize layer: Sectionalizer
        An exception occurred in FDO component.
        RDBMS: MySQL server has gone away
 StackTrace:
  - MgMappingUtil.StylizeLayers line 775 file 
d:\buildforgeprojects\mapguide_open_source_v2.0\build_27.16\mgdev\server\src\services\mapping\MappingUtil.cpp    
Failed to stylize layer: Sectionalizer
An exception occurred in FDO component.
RDBMS: MySQL server has gone away