[pycsw-devel] SOS Harvesting Error

dan at inlet.geol.sc.edu dan at inlet.geol.sc.edu
Mon Oct 27 07:56:24 PDT 2014


I am attempting to populate a test pycsw server with the offerings from
NDBC's SOS server. I am getting an exception of:
<ows:Exception exceptionCode="NoApplicableCode" locator="source">
    <ows:ExceptionText>Harvest (insert) failed: ERROR: index row size 3956
exceeds maximum 2712 for index "ix_records_operateson"
HINT:  Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text
indexing.
.</ows:ExceptionText>
  </ows:Exception>
</ows:ExceptionReport>

I am not sure what this is telling me. The xml file I am using to direct
the pycsw-admin is:
<?xml version="1.0" encoding="UTF-8"?>
<Harvest xmlns="http://www.opengis.net/cat/csw/2.0.2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.opengis.net/cat/csw/2.0.2
http://schemas.opengis.net/csw/2.0.2/CSW-publication.xsd" service="CSW"
version="2.0.2">
  <Source>http://sdf.ndbc.noaa.gov/sos/server.php</Source>
  <ResourceType>http://www.opengis.net/sos/1.0</ResourceType>
</Harvest>

Any pointers would be great.

Dan



More information about the pycsw-devel mailing list