Backend crash on TopoGeo_addLinestring

[strk]

I'm experiencing a backend crash on TopoGeo_addLinestring. The test dataset is currently composed by 11000 linestrings and I can't get to reduce further (could be memory handling related).

This is happening with current trunk (r14926) and with r14923.

I hadn't tried with 2.2 yet

[strk]

r14878 also affected, The dump of the offending table (~20MB compressed) is (temporarely) on ​http://strk.kbt.io/tmp/bug3568.sql.gz but running the query from that extract of the whole table does NOT reproduce the problem

[strk]

The query I'm using against the whole "ucs_rt" table, which can be found here: ​http://www502.regione.toscana.it/geoscopio/topologia_uso_suolo.7z

Is as follows:

DO $$                                                                           
declare                                                                         
  rec record;                                                                   
begin                                                                           
  for rec in select gid, (ST_Dump(ST_Boundary(geom))).* from ucs_rt             
      order by st_length(geom)                                                  
      offset 65000 limit 11000                                                  
  loop                                                                          
    begin                                                                       
      perform topology.TopoGeo_addLinestring('ucs_rt_topo', rec.geom);          
    exception when others then                                                  
      RAISE WARNING 'Error adding boundary line % of record with gid %: %',     
        rec.path, rec.gid, SQLERRM;                                             
      insert into ucs_rt_topo.problematic values ( rec.geom );                  
    end;                                                                        
  end loop;                                                                     
end;                                                                            
$$ language 'plpgsql';        

[strk]

Sorry, the dataset is the "ucs_rt.shp" inside this package: ​http://www502.regione.toscana.it/geoscopio/download/tematici/ucs_rt_2013/USO_E_COPERTURA_DEL_SUOLO_REGIONE_TOSCANA.7z

[robe]

strk I'm going to push this to 2.4, feel free to push back if you are going to have done in 2 weeks time.

[robe]

Milestone renamed

[Algunenano]

The test datasets are long gone, so I can't reproduce it. Feel free to reopen if it reappears.