Hi all,
We’ve been using ArcSDE extension for quite some time now with no problems on GeoServer’s side of things. However this week there was a problem with the SDE service/the server it sits on and we experienced some unusual problems.
When requesting WMS and WFS data from an ArcSDE data store, it just never responded, no time out or exception. I turned up the logging and the output at GeoServer startup is at the end of the message, it doesn’t seem to include anything particularly helpful that I can see. The logs hung at this point, there was no “try” 2 or 3.
GeoServer hung at this point and never loaded. More worryingly Tomcat also hung at this point, it was inaccessible (along with everything else Tomcat serves) and wouldn’t stop gracefully so had to kill the process.
The sysadmin for ArcSDE couldn’t find any reported problems on the SDE server, but it wasn’t working for Esri users either. Stop/starting the SDE service didn’t help but a reboot of the server appears to have fixed whatever the issue was. GeoServer can now connect as normal, no problems at present.
In the past we have had problems with SDE but we’ve always had exceptions reported, e.g.:
Unknown problem fetching connection from connection pool
Can’t create connection to IP.ADDRESS.WAS.HERE for Session #549
SDE error -121 Connection refused: connect
Error desc=NO INSTANCE RUNNING ON SERVER.
Extended desc=Connection refused: connect
Connection refused: connect
Version 2.5.5.1, running on Windows Server 2008 in Tomcat 7. Any thoughts anyone, seems odd to me that it wouldn’t just timeout at some point?
On a slightly related note, has anyone had any luck with a Direct Connect to SDE, we’ve never managed to get it working. I’ve been through the past threads on this forum but no-one seems to have managed it and was wondering if anyone has? Also can anyone confirm if you need to have the geometry stored as SDO rather than SDE?
Kind regards,
Rob
Log:
2015-07-09 10:31:29,778 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2015-07-09 10:31:29,778 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2015-07-09 10:31:29,778 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2015-07-09 10:31:29,778 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2015-07-09 10:31:29,793 INFO [org.geoserver] - Loaded store ‘ArcSDE’, enabled
2015-07-09 10:31:29,793 INFO [org.geoserver] - Loaded data store ‘ArcSDE’
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2015-07-09 10:31:29,793 TRACE [arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2015-07-09 10:31:29,793 DEBUG [arcsde.pool] - No database name specified
2015-07-09 10:31:29,793 DEBUG [arcsde.pool] - No database name specified
2015-07-09 10:31:29,793 DEBUG [arcsde.session] - populating ArcSDE connection pool
2015-07-09 10:31:29,809 DEBUG [arcsde.session] - Created ArcSDE connection pool for ArcSDEConnectionConfig[server=IP.ADDRESS.WAS.HERE, port=PORT_NUMBER_HERE, database=null, user=SDE_USERNAME_HERE, minConnections=2, maxConnections=4, timeout=500]
2015-07-09 10:31:29,809 INFO [arcsde.session] - Session auto-close threshold set to 500
2015-07-09 10:31:29,809 DEBUG [arcsde.session] - Creating connection for session #1(try 1 of 3)
EOF