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
------------------------------------------------------------------------------
Don't Limit Your Business. Reach for the Cloud.
GigeNET's Cloud Solutions provide you with the tools and support that
you need to offload your IT needs and focus on growing your business.
Configured For All Businesses. Start Your Cloud Today.
https://www.gigenetcloud.com/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
