Versioned edits may fail with invalid SeState handling
------------------------------------------------------
Key: GEOT-1863
URL: http://jira.codehaus.org/browse/GEOT-1863
Project: GeoTools
Issue Type: Bug
Components: data arcsde
Affects Versions: 2.5-M2, 2.4.4
Reporter: Gabriel Roldán
Assignee: Gabriel Roldán
Fix For: 2.4.5, 2.5-M3
A customer reported the following errors arise sometimes when editing a
versioned table.
With an ArcCatalog or ArcMap session open (not even editing the features, just
displaying), and I use Geoserver to do a WFS Transaction:
{{[SDE error -191][Error desc=STATE IS BEING MODIFIED.][Extended desc=]}}
{{org.geotools.arcsde.ArcSdeException: [SDE error -191][Error desc=STATE IS
BEING MODIFIED.]}}
{{org.geotools.arcsde.ArcSdeException: [SDE error -172][Error desc=A SPECIFIED
STATE IS NOT IN THE VERSION_STATES TABLE.][Extended desc=]}}
Full trace:
13 Jun 16:24:20 ERROR [arcsde.pool] - Command execution failed for Session 2 in
thread 24
org.geotools.arcsde.ArcSdeException: [SDE error -191][Error desc=STATE IS BEING
MODIFIED.][Extended desc=
]
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:89)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:76)
at org.geotools.arcsde.pool.Session.issue(Session.java:160)
at
org.geotools.arcsde.pool.SessionWrapper.issue(SessionWrapper.java:273)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler.setUpStream(TransactionDefaultVersionHandler.java:74)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter.createStream(ArcSdeFeatureWriter.java:179)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter.access$200(ArcSdeFeatureWriter.java:69)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter$4.execute(ArcSdeFeatureWriter.java:467)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter$4.execute(ArcSdeFeatureWriter.java:464)
at org.geotools.arcsde.pool.Session$2.call(Session.java:192)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeState.close(Unknown Source)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:84)
... 14 more
13 Jun 16:24:20 WARN [arcsde.data] - Error inserting
MutableFIDFeature:KGN_YSGB.KGNAT_SCHETSLAAG_VLAK<KGN_YSGB.KGNAT_SCHETSLAAG_VLAK
[EMAIL PROTECTED]>=[AttributeImpl:CODEBPN=4434, AttributeImpl:STATUS=Nieuw,
AttributeImpl:GEBRUIKERSNAAM=eijndenb, AttributeImpl:DATUMSCHETS=Fri Jun 13
02:00:00 CEST 2008, AttributeImpl:TOELICHTING=dfdfdf, AttributeImpl:LOG=null,
AttributeImpl:NAAM=mama4, GeometryAttributeImpl:SHAPE<SHAPE crs=PROJCS["RD_New",
GEOGCS["GCS_Amersfoort",
DATUM["D_Amersfoort",
SPHEROID["Bessel_1841", 6377397.155, 299.1528128]],
PRIMEM["Greenwich", 0.0],
UNIT["degree", 0.017453292519943295],
AXIS["Longitude", EAST],
AXIS["Latitude", NORTH]],
PROJECTION["Oblique_Stereographic"],
PARAMETER["central_meridian", 5.38763888888889],
PARAMETER["latitude_of_origin", 52.15616055555555],
PARAMETER["scale_factor", 0.9999079],
PARAMETER["false_easting", 155000.0],
PARAMETER["false_northing", 463000.0],
UNIT["m", 1.0],
AXIS["x", EAST],
AXIS["y", NORTH]]>=MULTIPOLYGON (((194650.52356020943 542068.0628272251,
228341.6230366492 544659.6858638744, 220566.75392670155 511832.4607329843,
190331.15183246072 508376.9633507853, 194650.52356020943 542068.0628272251))),
AttributeImpl:DISTRICTNAAM=Waterdistrict Maastricht-Maas]: [SDE error
-191][Error desc=STATE IS BEING MODIFIED.][Extended desc=
]
org.geotools.arcsde.ArcSdeException: [SDE error -191][Error desc=STATE IS BEING
MODIFIED.][Extended desc=
]
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:89)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:76)
at org.geotools.arcsde.pool.Session.issue(Session.java:160)
at
org.geotools.arcsde.pool.SessionWrapper.issue(SessionWrapper.java:273)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler.setUpStream(TransactionDefaultVersionHandler.java:74)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter.createStream(ArcSdeFeatureWriter.java:179)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter.access$200(ArcSdeFeatureWriter.java:69)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter$4.execute(ArcSdeFeatureWriter.java:467)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter$4.execute(ArcSdeFeatureWriter.java:464)
at org.geotools.arcsde.pool.Session$2.call(Session.java:192)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeState.close(Unknown Source)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:84)
... 14 more
13 Jun 16:24:20 ERROR [geoserver.wfs] - Transaction failed
org.geoserver.wfs.WFSTransactionException: Error performing insert
at
org.geoserver.wfs.InsertElementHandler.execute(InsertElementHandler.java:202)
at org.geoserver.wfs.Transaction.execute(Transaction.java:333)
at org.geoserver.wfs.Transaction.transaction(Transaction.java:108)
at
org.geoserver.wfs.DefaultWebFeatureService.transaction(DefaultWebFeatureService.java:157)
at sun.reflect.GeneratedMethodAccessor117.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.geoserver.ows.util.EMFLogger.invoke(EMFLogger.java:51)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy18.transaction(Unknown Source)
at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at
org.geoserver.security.OperationSecurityInterceptor.invoke(OperationSecurityInterceptor.java:41)
at org.geoserver.ows.Dispatcher.execute(Dispatcher.java:497)
at
org.geoserver.ows.Dispatcher.handleRequestInternal(Dispatcher.java:190)
at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:874)
at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:808)
at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:523)
at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:463)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at
org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at
org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107)
at
org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:178)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:229)
at
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274)
at
org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148)
at
org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.LoggingFilter.doFilter(LoggingFilter.java:73)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at
org.geoserver.filters.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:170)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at org.geoserver.filters.GZIPFilter.doFilter(GZIPFilter.java:47)
at
org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
at
org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
at
org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
at
org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at
org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:726)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at
org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
at
org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
at
org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at
org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)
at
org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:842)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:648)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)
at
org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)
at
org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:450)
Caused by: org.geotools.arcsde.ArcSdeException: [SDE error -191][Error
desc=STATE IS BEING MODIFIED.][Extended desc=
]
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:89)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:76)
at org.geotools.arcsde.pool.Session.issue(Session.java:160)
at
org.geotools.arcsde.pool.SessionWrapper.issue(SessionWrapper.java:273)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler.setUpStream(TransactionDefaultVersionHandler.java:74)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter.createStream(ArcSdeFeatureWriter.java:179)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter.access$200(ArcSdeFeatureWriter.java:69)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter$4.execute(ArcSdeFeatureWriter.java:467)
at
org.geotools.arcsde.data.ArcSdeFeatureWriter$4.execute(ArcSdeFeatureWriter.java:464)
at org.geotools.arcsde.pool.Session$2.call(Session.java:192)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.esri.sde.sdk.client.SeException:
at com.esri.sde.sdk.client.SeState.close(Unknown Source)
at
org.geotools.arcsde.data.versioning.TransactionDefaultVersionHandler$2.execute(TransactionDefaultVersionHandler.java:84)
... 14 more
13 Jun 16:24:20 INFO [geoserver.wfs] -
Request: transaction
handle = null
service = WFS
version = 1.0.0
baseUrl = http://145.50.148.45:8080/geoserver/
lockId = null
group = [wfs:[EMAIL PROTECTED] (feature:
[SimpleFeatureImpl:KGN_YSGB.KGNAT_SCHETSLAAG_VLAK<KGN_YSGB.KGNAT_SCHETSLAAG_VLAK
id=fid-69b32c41_11a80d55844_-7ff2>=[AttributeImpl:CODEBPN=4434,
AttributeImpl:STATUS=Nieuw, AttributeImpl:GEBRUIKERSNAAM=eijndenb,
AttributeImpl:DATUMSCHETS=Fri Jun 13 02:00:00 CEST 2008,
AttributeImpl:TOELICHTING=dfdfdf, AttributeImpl:LOG=null,
AttributeImpl:NAAM=mama4, GeometryAttributeImpl:SHAPE<SHAPE
crs=PROJCS["Amersfoort / RD New",
GEOGCS["Amersfoort",
DATUM["Amersfoort",
SPHEROID["Bessel 1841", 6377397.155, 299.1528128,
AUTHORITY["EPSG","7004"]],
TOWGS84[565.04, 49.91, 465.84, -0.40939438743923684,
-0.35970519561431136, 1.868491000350572, 0.8409828680306614],
AUTHORITY["EPSG","6289"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST],
AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4289"]],
PROJECTION["Oblique Stereographic", AUTHORITY["EPSG","9809"]],
PARAMETER["central_meridian", 5.387638888888891],
PARAMETER["latitude_of_origin", 52.15616055555556],
PARAMETER["scale_factor", 0.9999079],
PARAMETER["false_easting", 155000.0],
PARAMETER["false_northing", 463000.0],
UNIT["m", 1.0],
AXIS["Easting", EAST],
AXIS["Northing", NORTH],
AUTHORITY["EPSG","28992"]]>=MULTIPOLYGON (((194650.52356020943
542068.0628272251, 228341.6230366492 544659.6858638744, 220566.75392670155
511832.4607329843, 190331.15183246072 508376.9633507853, 194650.52356020943
542068.0628272251))), AttributeImpl:DISTRICTNAAM=Waterdistrict
Maastricht-Maas]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName:
null)]
insert = [EMAIL PROTECTED] (feature:
[SimpleFeatureImpl:KGN_YSGB.KGNAT_SCHETSLAAG_VLAK<KGN_YSGB.KGNAT_SCHETSLAAG_VLAK
id=fid-69b32c41_11a80d55844_-7ff2>=[AttributeImpl:CODEBPN=4434,
AttributeImpl:STATUS=Nieuw, AttributeImpl:GEBRUIKERSNAAM=eijndenb,
AttributeImpl:DATUMSCHETS=Fri Jun 13 02:00:00 CEST 2008,
AttributeImpl:TOELICHTING=dfdfdf, AttributeImpl:LOG=null,
AttributeImpl:NAAM=mama4, GeometryAttributeImpl:SHAPE<SHAPE
crs=PROJCS["Amersfoort / RD New",
GEOGCS["Amersfoort",
DATUM["Amersfoort",
SPHEROID["Bessel 1841", 6377397.155, 299.1528128,
AUTHORITY["EPSG","7004"]],
TOWGS84[565.04, 49.91, 465.84, -0.40939438743923684,
-0.35970519561431136, 1.868491000350572, 0.8409828680306614],
AUTHORITY["EPSG","6289"]],
PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
UNIT["degree", 0.017453292519943295],
AXIS["Geodetic longitude", EAST],
AXIS["Geodetic latitude", NORTH],
AUTHORITY["EPSG","4289"]],
PROJECTION["Oblique Stereographic", AUTHORITY["EPSG","9809"]],
PARAMETER["central_meridian", 5.387638888888891],
PARAMETER["latitude_of_origin", 52.15616055555556],
PARAMETER["scale_factor", 0.9999079],
PARAMETER["false_easting", 155000.0],
PARAMETER["false_northing", 463000.0],
UNIT["m", 1.0],
AXIS["Easting", EAST],
AXIS["Northing", NORTH],
AUTHORITY["EPSG","28992"]]>=MULTIPOLYGON (((194650.52356020943
542068.0628272251, 228341.6230366492 544659.6858638744, 220566.75392670155
511832.4607329843, 190331.15183246072 508376.9633507853, 194650.52356020943
542068.0628272251))), AttributeImpl:DISTRICTNAAM=Waterdistrict
Maastricht-Maas]], handle: null, idgen: <unset>, inputFormat: <unset>, srsName:
null)]
update = []
delete = []
native = []
releaseAction = ALL
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
