[gdal-dev] RuntimeError no COPY in progress

[Even Rouault]

Le jeudi 02 octobre 2014 18:26:37, Ari Jolma a écrit :
> A strange bug somewhere between OGR and PostgreSQL(?)
> 
> I've created a layer with a geometry and id fields. The layer gets
> created ok. After inserting 500 features I get the error:
> 
> RuntimeError no COPY in progress
> 
> PostgreSQL  logs this:
> 
> 2014-10-02 19:23:03 EEST ERROR:  COPY from stdin failed: COPY terminated
> by new PQexec
> 2014-10-02 19:23:03 EEST CONTEXT:  COPY rannat, line 501
> 2014-10-02 19:23:03 EEST STATEMENT:  COPY "rannat" ("wkb_geometry",
> "id") FROM STDIN;
> 2014-10-02 19:23:03 EEST ERROR:  current transaction is aborted,
> commands ignored until end of transaction block
> 2014-10-02 19:23:03 EEST STATEMENT:  FETCH 500 in OGRPGLayerReader0x258c8f0
> 2014-10-02 19:23:03 EEST ERROR:  current transaction is aborted,
> commands ignored until end of transaction block
> 2014-10-02 19:23:03 EEST STATEMENT:  CLOSE OGRPGLayerReader0x258c8f0
> 
> "rannat" is the new table.
> 
> Any ideas? Am I inserting features too fast??

Ari,

Too fast ? lol, no I don't think so. There must be something odd that happens, 
wrong escaping, whatever that makes the COPY to fail. Could you provide some 
way to reproduce this ?

Even

> 
> Ari
> 
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev

-- 
Spatialys - Geospatial professional services
http://www.spatialys.com