That's nice, crashed on my platform too (OS/X 10.5, GEOS trunk).
What's your platform?
On Thu, Apr 24, 2008 at 4:02 PM, Stefan Zweig <[EMAIL PROTECTED]> wrote:
>
> Hi paul,
>
> here we go, there is the new animal for your "zoo":
>
> select buffer(st_geomFromText('MULTIPOLYGON(((12.098789 50.905962,12.020813
50.947952,12.017285 50.967973,12.090563 50.976663,12.163175 50.959211,12.133071
50.932547,12.154221 50.884623,12.098789 50.905962),(12.1286244
50.8950136,12.1287442 50.8951404,12.1278504 50.8950303,12.1278598
50.8948964,12.1286244 50.8950136),(12.0922723 50.9546386,12.0926358
50.9541698,12.092428 50.955268,12.0922918 50.9551482,12.0922723
50.9546386),(12.1087437 50.8989343,12.1078831 50.8989326,12.107387
50.898063,12.1079471 50.8986231,12.1087437 50.8989343),(12.1228954
50.9164961,12.1233835 50.9177103,12.1224951 50.918326,12.1212225
50.9188562,12.1228954 50.9164961),(12.142612 50.884225,12.1490617
50.8856118,12.149222 50.885687,12.1437629 50.8846708,12.142612
50.884225),(12.090005 50.955723,12.0901606 50.9556077,12.0940001
50.9560483,12.0920097 50.9573598,12.090005 50.955723),(12.1515115
50.9369131,12.1504699 50.9391583,12.148134 50.93827,12.1503487
50.938083,12.1515115 50.9369131),(12.1360606 50.8892593,12.1344196
50.8892146,12.1357368 50.8858406,12.1399245 50.8865412,12.1360606
50.8892593),(12.087163 50.927347,12.0851166 50.9255544,12.084949
50.924396,12.08763 50.9271838,12.0894109 50.9306506,12.088262 50.932468,12.087163
50.927347),(12.0873679 50.9640895,12.0886015 50.9574848,12.069322
50.955508,12.094624 50.954051,12.1028119 50.9615,12.0873679
50.9640895)),((12.0832251 50.8628502,12.072535 50.8760369,12.0803652
50.8942363,12.0954397 50.8841184,12.0832251 50.8628502)),((12.089448
50.957301,12.089702 50.959116,12.0927875 50.9596698,12.0938183
50.9579664,12.089448 50.957301)),((12.0964798 50.9605757,12.0969206
50.9605509,12.0939251 50.9599157,12.0952655 50.960698,12.0964798
50.9605757)),((12.089702 50.959116,12.0901026 50.9596047,12.0926431
50.9598645,12.0907201 50.9594751,12.089702 50.959116)))'),0);
>
> the select crashes with
>
>
> 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"
>
> regards,
>
> stefan
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: PostGIS Users Discussion <[email protected]>
> > Gesendet: 22.04.08 17:05:32
> > An: "PostGIS Users Discussion" <[email protected]>
> > Betreff: Re: [postgis-users] error with buffer()
>
>
>
>
> > Send in your geometry! Some geometry/parameter combinations break
> > ST_Buffer() and we like to add those to our zoo of unusual and
> > interesting cases for future improvement.
> >
> > P
> >
> > In the meantime, try slightly simplifying your geometry first, or
> > doing your buffer in 2 or more steps of smaller tolerances, or
> > sacrificing a goat before starting the function call... :)
> >
> > On Tue, Apr 22, 2008 at 2:52 AM, Stefan Zweig <[EMAIL PROTECTED]> wrote:
> > >
> > >
> > > 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
> > >
> > _______________________________________________
> > postgis-users mailing list
> > [email protected]
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
> ______________________________________________________
> Bis 50 MB Dateianhänge? Kein Problem!
> http://freemail.web.de/club/landingpage.htm/?mc=025556
>
>
>
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
