Symptoms

Tasks Update PowerDns server fail with error:

Operation with storage caused error: 'example.com.(123): Operation with storage caused error: 'Failed to execute command: ERROR: value too long for type character varying(255) ' '

Cause

The domain owner attempted to add TXT records longer than PowerDNS DB allowed to insert.

According to RFC4408 http://tools.ietf.org/html/rfc4408#section-3.1.3 a single text DNS record (either TXT or SPF RR types) can be composed of more than one string. It lets to put in one TXT record multiple strings with 255 letters each.

OA checks the lenght of record's content (the limit is 1023 symbols). Currently, it works for 1009 symbols for OA + BIND 9.9.4 and OA + PowerDNS 3.4.11.

As for older versions of PowerDNS, it's recomended to upsize the content column of records table The issue has been acknowleged as #POA-115002: "Unable to create TXT record with 1023 symbols.

Resolution

The length of 'content' field may be increased however it is not recommended because too long TXT records may not be working correctly. Refer to RFC 4408 for details.

Contact your Technical Account Manager or Pooled Technical Associate Team (pta@odin.com) in order to trace the current status of #POA-115002 "Unable to create TXT record with 1023 symbols" or request to apply internal workaround.

Internal content

Link on internal Article