Reading XML data returns "error: Huge input lookup"

Products

• VMware Tanzu Greenplum

Issue/Introduction

When reading XML data or casting text to XML can result in "error: Huge input lookup"

# select text_data::xml from table01 ;
ERROR:  invalid XML content  (seg2 slice1 10.10.0.1:6000 pid=5703)
DETAIL:  line 88068: internal error: Huge input lookup
sible for unapproved use of this group to manage access to systems not listed."/
                                                                               ^

Environment

Product Version: 6.22

Resolution

This is an issue with the limxml2 library provided with the Operating System (OS).
It is not provided with Greenplum.

Workaround
Change the GUC "xmloption" to "document". The default setting is "content".
This can be set for the session with:

set xmloption="document";

It can be set for all sessions with:

gpconfig -c xmloption -v document
gpstop -u