Hello guys, You have to run a vacuum command on the database/table. Without that, a bug will come up, which is not fixed yet.
For more information see ticket: http://jira.codehaus.org/browse/GEOS-4342 Zsolt Sandor wrote: > > Ok guys, i run into another problem, as i described above. I don't know > whether i should fill a bug report, or bring this topic to development > list, but i see the following things. > > i would like to send a position update using WFS/transaction api 1.0. > > I can trace down the error to JDBCDataStore.class > > ReferencedEnvelope getBounds(SimpleFeatureType featureType, Query query, > Connection cx) ... > > It tries to get the bounds from an optimized table: > > dialect.getOptimizedBounds(databaseSchema, featureType, cx); > > but since it does not exists, the code executes a simple sql query. > > String sql = selectBoundsSQL(featureType, query); > LOGGER.log(Level.FINE, "Retriving bounding box: {0}", sql); > > st = cx.createStatement(); > rs = st.executeQuery(sql); > > now, this executeQuery dies with the following exception: > > org.postgresql.util.PSQLException: ERROR: current transaction is aborted, > commands ignored until end of transaction block > > and so it exits from this method. > > Any idea why it happens, did i found a bug, or made something wrong? > > This error can be reproduced also with the latests Geoserver from Trunk. > -- View this message in context: http://old.nabble.com/WFS-Transaction-problem-tp30804990p31030426.html Sent from the GeoServer - User mailing list archive at Nabble.com. ------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
