Opened 9 years ago

Closed 9 years ago

#825 closed defect (fixed)

Pooled RDBMS connection fails if RDBMS drops connection

Reported by: brucedechant Owned by: brucedechant
Priority: medium Milestone: 2.1
Component: Feature Service Version: 2.0.2
Severity: major Keywords:
Cc: External ID: 1147707.01

Description

Create a connection to any RDBMS: I used MySQL for example by previewing a Map to MySQL data. After seeing the data in the map, stop the RDBMS server, pause the VM or disconnect it in some way (ex: pulling network cable). Attempt to pan or zoom in the map and nothing happens. There may be an FDO timeout waiting to occur. Restart the RDBMS and refresh the map. An FDO error is generated indicating the connection to the RDBMS is invalid. For MySQL the error was as follows after pausing the VM:

<2008-10-28T16:31:35> wilsond

Error: Failed to stylize layer: calmysql5 montana ab30

An exception occurred in FDO component. RDBMS: MySQL server has gone away

StackTrace?:

An exception occurred in FDO component. RDBMS: MySQL server has gone away

It appears that once the RDBMS has dropped the connection the server fails to drop the connection from the pool as it should realize the connection is invalid.

The above also happens for Oracle and SQL Server.

Change History (4)

comment:1 Changed 9 years ago by brucedechant

Owner: set to brucedechant
Status: newassigned

comment:2 Changed 9 years ago by brucedechant

Summary: Add 64bit supportPooled RDBMS connection fails if RDBMS drops connection linked

comment:3 Changed 9 years ago by brucedechant

Summary: Pooled RDBMS connection fails if RDBMS drops connection linkedPooled RDBMS connection fails if RDBMS drops connection

comment:4 Changed 9 years ago by brucedechant

Resolution: fixed
Status: assignedclosed
Note: See TracTickets for help on using tickets.