pycsw icon indicating copy to clipboard operation
pycsw copied to clipboard

Published 20 hours ago • verified publisher icon geopython

Database insert fails on large records

Open GaryHudmanAZGS opened this issue 9 years ago • 3 comments

I work on the NGDS CKAN system, the ckan-spatial has a background process that updates pyCSW. I have noticed quite a number of log errors for large dataset inserts: index row size 2896 exceeds maximum 2712 for index "ix_records_abstract" Has this been seen before? I am on postgres 9.1 and haven't tried any fixes yet. Its a database limit based on the index. this appears to be similar to the #279 parse error, except appears to be a repository.insert error. Thanks, Gary Hudman, AZGS @smrazgs

GaryHudmanAZGS avatar Jan 29 '16 18:01 GaryHudmanAZGS

I'm also seeing this on PyCSW 1.10. I'm looking to upgrade to 2.2.0 and see if the error persists. It affects several indexes, not just ix_records_abstract.

adborden avatar Mar 06 '19 15:03 adborden

This error persists in 2.4.0

adborden avatar Aug 20 '19 23:08 adborden

This error persists in geopython/pycsw:2.6.1

 index row size 3064 exceeds btree version 4 maximum 2704 for index "ix_records_links"

aijogja avatar Aug 10 '22 15:08 aijogja