[Geoserver-devel] [jira] Created: (GEOS-191) Multiple Inserts in Single Transaction Mangle Data

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://jira.codehaus.org/browse/GEOS-191

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: GEOS-191
    Summary: Multiple Inserts in Single Transaction Mangle Data
       Type: Bug

     Status: Open
   Priority: Major

Original Estimate: Unknown
Time Spent: Unknown
  Remaining: Unknown

    Project: GeoServer
Components:
             PostGIS
   Versions:
             1.2.0-rc2

   Assignee: Chris Holmes
   Reporter: John Stiening

    Created: Wed, 7 Jul 2004 1:23 PM
    Updated: Wed, 7 Jul 2004 1:23 PM
Environment: Tomcat, PostGIS, and Geoserver 1.2.0-rc2

Description:
Basically I am attempting to insert 30 features in a single transaction, and have noticed that while the transaction will claim that the features inserted properly, the data in the database is mangles. Increasing or decreasing the number of features(obs in my case) allows me to move the mangled spot around. The mangled spot includes only a portion of the data that is supposed to be in it. (e.g "CLIPPER SEA" becomes "SEA" in some iterations.) The weird thing is that it can chop out the middle of a data value as well, and not just one of the ends. I will post both db output and insert xml for you all to see.

Obervations

1) <DC:destination/> caused problems, while <DC:destination></DC:destination> did not.

2) Different lenghts of text in each data element appear to cause problems as well. My lat long coordinates had a few coordinates that were of slighly lower precision. When I added zeros for padding, the problem of mangled data mostly went away.

---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira