Closed igor-chernikov closed 1 month ago
@igor-chernikov thanks for the report, can you please include the database information?
@kalxas, sure, excuse me for not mentioning that earlier. I'm using PostgreSQL 9.5 with PostGIS 2.2
It seems that you hit the index limit for the specific field. A workaround would be to drop that index completely. If you have full text search enabled, you will still be able to search your catalog through free text search.
@kalxas thanks for your response. I used exactly this workaround.
Description
Inserting record with long abstract causes the error:
ExceptionReport: 'Harvest (insert) failed: ERROR: index row size 2984 exceeds maximum 2712 for index "ix_records_abstract"\nHINT: Values larger than 1/3 of a buffer page cannot be indexed.\nConsider a function index of an MD5 hash of the value, or use full text indexing.\n.'
Sample record: http://geobretagne.fr/geonetwork/srv/eng/csw?service=CSW&version=2.0.2&request=GetRecordById&id=b5cb375d-7bb5-4b75-84f7-649e8f84e0dd
Environment
Steps to Reproduce
Sample code using owslib:
Additional Information