hi list,
there seems to be an error within the buffer(geometry, precision) function. i just tried to the following statement: UPDATE _g2870 SET the_geom_3_b = buffer(the_geom_3, 0) WHERE isValid(the_geom_3) = false; and it resulted into a broken connection to the postmaster. postgis seems to have problems with the buffer function and invalid geometries. the server.log says the following: bufferOriginalPrecision failed (TopologyException: unable to assign hole to a shell), trying with reduced precision recomputing with precision scale factor = 1e+12 Scaler: offsetX,Y: 0,0 scaleFactor: 1e+12 ReScaler: offsetX,Y: 0,0 scaleFactor: 1e+12 recomputing with precision scale factor = 1e+11 Scaler: offsetX,Y: 0,0 scaleFactor: 1e+11 ReScaler: offsetX,Y: 0,0 scaleFactor: 1e+11 recomputing with precision scale factor = 1e+10 Scaler: offsetX,Y: 0,0 scaleFactor: 1e+10 ReScaler: offsetX,Y: 0,0 scaleFactor: 1e+10 recomputing with precision scale factor = 1e+09 Scaler: offsetX,Y: 0,0 scaleFactor: 1e+09 ReScaler: offsetX,Y: 0,0 scaleFactor: 1e+09 recomputing with precision scale factor = 1e+08 Scaler: offsetX,Y: 0,0 scaleFactor: 1e+08 ReScaler: offsetX,Y: 0,0 scaleFactor: 1e+08 recomputing with precision scale factor = 1e+07 Scaler: offsetX,Y: 0,0 scaleFactor: 1e+07 ReScaler: offsetX,Y: 0,0 scaleFactor: 1e+07 recomputing with precision scale factor = 1e+06 Scaler: offsetX,Y: 0,0 scaleFactor: 1e+06 ReScaler: offsetX,Y: 0,0 scaleFactor: 1e+06 recomputing with precision scale factor = 100000 Scaler: offsetX,Y: 0,0 scaleFactor: 100000 ReScaler: offsetX,Y: 0,0 scaleFactor: 100000 recomputing with precision scale factor = 10000 Scaler: offsetX,Y: 0,0 scaleFactor: 10000 ReScaler: offsetX,Y: 0,0 scaleFactor: 10000 recomputing with precision scale factor = 1000 Scaler: offsetX,Y: 0,0 scaleFactor: 1000 pdata 10.100.6.140(1782) UPDATE: ../../source/headers/geos/noding/SegmentString.h:175: void geos::noding::SegmentString::testInvariant() const: Zusicherung »pts->size() > 1« nicht erfÃŒllt. LOG: server process (PID 7510) was terminated by signal 6 LOG: terminating any other active server processes WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. WARNING: terminating connection because of crash of another server process DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. HINT: In a moment you should be able to reconnect to the database and repeat your command. LOG: all server processes terminated; reinitializing LOG: database system was interrupted at 2008-04-22 11:18:52 CEST LOG: checkpoint record is at 0/9A4F7BC8 LOG: redo record is at 0/9A4F7BC8; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 0/51508; next OID: 322761 LOG: next MultiXactId: 1; next MultiXactOffset: 0 LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 0/9A4F7C18 LOG: unexpected pageaddr 0/9161E000 in log file 0, segment 154, offset 6414336 LOG: redo done at 0/9A61D790 LOG: database system is ready my postgis_version is: select postgis_full_version() "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS" any ideas? regards, stefan _______________________________________________________________________ Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 30 Tage kostenlos testen. http://www.pc-sicherheit.web.de/startseite/?mc=022220 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
