Jon Roberts created HAWQ-1244:
---------------------------------
Summary: unrecognized configuration parameter "ONETARY"
Key: HAWQ-1244
URL: https://issues.apache.org/jira/browse/HAWQ-1244
Project: Apache HAWQ
Issue Type: Bug
Components: Dispatcher
Reporter: Jon Roberts
Assignee: Ed Espino
Fatal error occurs when reading /usr/local/hawq/etc/_mgmt_config when the file
is large due to many temp directories, a highly parallelized query, random
distributed tables, and hawq_rm_nvseg_perquery_perseg_limit set higher (12 for
example).
Query 88 in TPC-DS fails with random distribution, 10 nodes in AWS, 7TB of
data, hawq_rm_memory_limit_perseg = 200gb, hawq_rm_stmt_vseg_memory = 16gb,
hawq_rm_nvseg_perquery_perseg_limit = 12.
Error raised:
psql:188.tpcds.88.sql:95: ERROR: Error dispatching to seg25
ip-172-21-13-189.ec2.internal:40000: connection pointer is NULL
DETAIL: Master unable to connect to seg25 ip-172-21-13-189.ec2.internal:40000:
FATAL: unrecognized configuration parameter "ONETARY"
Error from segment:
2016-12-14 13:47:34.760839
UTC,"gpadmin","gpadmin",p737499,th542214432,"172.21.13.196","40327",2016-12-14
13:47:34 UTC,0,con23798,,seg-10000,,,,,"FATAL","42704","unrecognized
configuration parameter ""ONETARY""",,,,,,,0,,"guc.c",10006,
Workaround is to use less vsegs or reduce the number of temp directories. This
is probably not related to the number of temp directories but the size of the
_mgmt_config file. The parameter it apparently is failing to parse is:
hawq_lc_monetary=en_US.utf8
The problem is likely in guc.c based on the segment error.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
