Mapserver/Fastcgi losing connection to SDE when SDE is shutdown/restarted

[SLIPGIS]

Mapserver connecting to a Oracle/SDE database with Fastcgi, when SDE is shutdown/restarted every morning the connection pool appears become corrupt and Mapserver cannot connect.

The SDE data is refreshed each night into an inactive database then in the morning SDE is shutdown and the inactive database is swapped with the active one, SDE is then restarted. At this point Mapserver cannot re-establish a connection to SDE.

[hobu]

The handle to SDE that fastcgi is storing is now bunk when you shutdown the server. You have to restart MapServer so it can create a fresh handle (and a good connection).

I don't see a good way to trap this error either. Once the handle is bad, no further calls to it seem to work, so it is difficult to relight the connection.

[hobu]

Thinking about this more, it might be possible to know we're bunk and relight the connection.

1) Put a test here that checks the viability of the pool's connection handle ​http://trac.osgeo.org/mapserver/browser/trunk/mapserver/mapsde.c#L1047

2) If bad, release the old pool handle and create a new one. (Some of the SDE free functions might need to connect to the db though).

[sdlime]

Howard, can I reassign to you?

Steve

[hobu]

I suppose, but I'm not going to be able to do anything about it for a while...

[bartvde]

I've attached a patch against 5.0.2, is anybody able to verify?

[hobu]

I think SE_connection_test_server is only ArcSDE 9.2+

[bartvde]

Howard, it is also available in 9.1, see:

​http://edndoc.esri.com/arcsde/9.1/capi_functions/dbase_connects/se_connection_test_server.htm

[bartvde]

And even 9.0 has it :-) see:

​http://edndoc.esri.com/arcsde/9.0/capi_functions/dbase_connects/se_connection_test_server.htm

[hobu]

ok. Don't know about 8.x, but this is worth it regardless. Added in r7750