[Geoserver-users] Unable to get my SDE datastore available again

Hi,

After I managed to get a working SDE datastore, I tried to access my SDE
layers through GeoServer.

All worked fine until I tried to display my largest dataset (more than
6,000,000 entries, the whole roads of France).

The SDE connection failed because of the default value of the timeout
(apparently, 1000 ms is not enough to access the data with SDE).

But since this error, I am unable to have my SDE layers back in GeoServer :
I get the following message (even if I restart my Tomcat Container):

2008-02-15 09:18:13,259 ERROR [geoserver.global] - FeatureTypeInfo
TestSde:::EE.EE_CDT_CL_GEO ignored - as DataStore TestSde is
broken:java.lang.NoSuchFieldError: NONE

If I try to had a new SDE layer, I got the same message and the following
stack:

java.lang.NoSuchFieldError: NONE
  at
org.geotools.data.arcsde.ArcSDEAdapter.createAttributeTypes(ArcSDEAdapter.ja
va:418)
  at
org.geotools.data.arcsde.ArcSDEAdapter.fetchSchema(ArcSDEAdapter.java:287)
  at
org.geotools.data.arcsde.ArcSDEDataStore.getSchema(ArcSDEDataStore.java:202)
  at
org.vfny.geoserver.action.data.DataFeatureTypesNewAction.execute(DataFeature
TypesNewAction.java:84)
  at
org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:101)
  at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces
sor.java:431)
  at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
  at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
  at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:269)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterE
ncodingFilter.java:108)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:264)
  at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecur
ityInterceptor.java:107)
  at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSec
urityInterceptor.java:72)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslatio
nFilter.java:110)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(Ano
nymousProcessingFilter.java:125)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(Remember
MeProcessingFilter.java:142)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(S
ecurityContextHolderAwareRequestFilter.java:81)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFil
ter.java:217)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:106)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpS
essionContextIntegrationFilter.java:229)
  at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterCh
ainProxy.java:274)
  at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
  at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:215)
  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:188)
  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:213)
  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja
va:174)
  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127
)
  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117
)
  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java
:108)
  at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
  at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:
834)
  at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(H
ttp11AprProtocol.java:640)
  at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
  at java.lang.Thread.run(Thread.java:619)

What should I do to get my SDE datastore back ? Create a new one ?
Restarting my computer ?

Moreover after the initial exception due to the SDE pool timeout, I got an
unexpected error for the JVM (I attached the dump file to the mail).
Apparently it is the imageio which is the problem : could it be linked to
the fact I deployed the native JAI ?

Alexandre

hs_err_pid1772.log (12.5 KB)

Alexandre Gacon ha scritto:

Hi,

After I managed to get a working SDE datastore, I tried to access my SDE
layers through GeoServer.

...

What should I do to get my SDE datastore back ? Create a new one ?
Restarting my computer ?

For that I have no idea, I'm cc'ing the developers that have some
experience with SDE, hope they can provide some info.

Moreover after the initial exception due to the SDE pool timeout, I got an
unexpected error for the JVM (I attached the dump file to the mail).
Apparently it is the imageio which is the problem : could it be linked to
the fact I deployed the native JAI ?

Hum, I see both APR and imageio in the stack trace, but imageio wise,
it's the pure java part that's taking part in it:

j org.apache.tomcat.jni.Socket.sendbb(JII)I+0
j org.apache.coyote.http11.InternalAprOutputBuffer.flushBuffer()V+22
j org.apache.coyote.http11.InternalAprOutputBuffer.flush()V+19
j org.apache.coyote.http11.Http11AprProcessor.action(Lorg/apache/coyote/ActionCode;Ljava/lang/Object;)V+104
j org.apache.coyote.Response.action(Lorg/apache/coyote/ActionCode;Ljava/lang/Object;)V+31
j org.apache.catalina.connector.OutputBuffer.doFlush(Z)V+95
j org.apache.catalina.connector.OutputBuffer.flush()V+2
j org.apache.catalina.connector.CoyoteOutputStream.flush()V+4
j org.vfny.geoserver.util.PartialBufferedOutputStream2.flush()V+27
j org.geoserver.ows.DispatcherOutputStream.flush()V+4
j javax.imageio.stream.MemoryCacheImageOutputStream.flushBefore(J)V+47
j javax.imageio.stream.MemoryCacheImageOutputStream.close()V+15
j javax.imageio.stream.ImageInputStreamImpl.finalize()V+8

A quick google serch shows the following:
http://issues.apache.org/bugzilla/show_bug.cgi?id=40070
soo... maybe you can try to upgrade your APR install, or poke the
tomcat developers there, and eventually uninstall APR for the time
being.

Cheers
Andrea