[postgis-devel] Troubles with GeosIntersect & Postgis

[Andrea Peri]

Hi, I'm try to use Postgis 2.0 windows version r9106 (8 feb).

But I'm having many troubles in some my queries.
I will have this trouble s also with the previous version (1 feb.)

I will have many log error like this:

2012-02-16 09:16:30 CET STATEMENT:  create table work.arco3d as select a.*
from gb.arco3d as a, work.ww_ingombro as b where (( a.geometry &&
b.geometry ) AND (ST_Intersects(a.geometry,b.geometry)=true));
2012-02-16 09:17:09 CET ERROR:  GEOSIntersects: St9bad_alloc

After I see this errors.
I drop the DB and try to recreate it reloading all the datas, but the error
there is again.

I guess is changed something on the && operator ?

The "arco3d" is a table of Lines 3D.

I'm not sure this is the explanation because the errors there are on every
query not only on query using 3D geometries.
But the first where thereis the error is the 3D query I show .

2012-02-16 09:16:30 CET STATEMENT:  create table work.arco3d as select a.*
from gb.arco3d as a, work.ww_ingombro as b where (( a.geometry &&
b.geometry ) AND (ST_Intersects(a.geometry,b.geometry)=true));
2012-02-16 09:17:09 CET ERROR:  GEOSIntersects: St9bad_alloc

After this every query give error.
And after some queries of my batch, postgres give a never seen before
message.
Something like a crash of memory.

As show from this log.

----
...
2012-02-16 09:20:16 CET ERROR:  GEOSIntersects: St9bad_alloc
2012-02-16 09:20:16 CET STATEMENT:  create table work.elementostradale as
select a.* from gb.elementostradale as a, work.ww_ingombro as b where ((
a.geometry && b.geometry ) AND (ST_Intersects(a.geometry,b.geometry)=true));
2012-02-16 09:20:44 CET ERROR:  GEOSIntersects: St9bad_alloc
2012-02-16 09:20:44 CET STATEMENT:  create table work.geometrialinearess as
select a.* from gb.geometrialinearess as a, work.ww_ingombro as b where ((
a.geometry && b.geometry ) AND (ST_Intersects(a.geometry,b.geometry)=true));
TopMemoryContext: 112256 total in 15 blocks; 8280 free (22 chunks); 103976
used
  TopTransactionContext: 24576 total in 2 blocks; 12184 free (1 chunks);
12392 used
    Combo CIDs: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
  PostGIS Prepared Geometry Backend MemoryContext Hash: 253952 total in 5
blocks; 121568 free (16 chunks); 132384 used
  Attopt cache: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
  Type information cache: 24576 total in 2 blocks; 14072 free (6 chunks);
10504 used
  TableSpace cache: 8192 total in 1 blocks; 5640 free (0 chunks); 2552 used
  Operator lookup cache: 24576 total in 2 blocks; 14072 free (6 chunks);
10504 used
  MessageContext: 73728 total in 4 blocks; 46720 free (8 chunks); 27008 used
  CFuncHash: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
  Operator class cache: 8192 total in 1 blocks; 4872 free (0 chunks); 3320
used
  smgr relation table: 57344 total in 3 blocks; 18008 free (8 chunks);
39336 used
  TransactionAbortContext: 32768 total in 1 blocks; 32752 free (0 chunks);
16 used
  Portal hash: 8192 total in 1 blocks; 3912 free (0 chunks); 4280 used
  PortalMemory: 8192 total in 1 blocks; 8040 free (0 chunks); 152 used
    PortalHeapMemory: 1024 total in 1 blocks; 936 free (0 chunks); 88 used
      ExecutorState: 1048640 total in 8 blocks; 4896 free (11 chunks);
1043744 used
        GiST temporary context: 8192 total in 1 blocks; 8176 free (0
chunks); 16 used
        GiST queue context: 8192 total in 1 blocks; 7416 free (122 chunks);
776 used
        ExprContext: 864720 total in 4 blocks; 24544 free (11 chunks);
840176 used
        ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
        ExprContext: 0 total in 0 blocks; 0 free (0 chunks); 0 used
        ExprContext: 444648 total in 3 blocks; 24048 free (7 chunks);
420600 used
  Relcache by OID: 24576 total in 2 blocks; 10912 free (3 chunks); 13664
used
  CacheMemoryContext: 2249792 total in 23 blocks; 721056 free (9 chunks);
1528736 used
    pg_toast_729128_index: 1024 total in 1 blocks; 336 free (0 chunks); 688
used
    idx_giunzionestradale_org: 1024 total in 1 blocks; 368 free (0 chunks);
656 used

...

-----



-- 
-----------------
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-----------------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20120216/67b248c8/attachment.html>