Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id A94D4200BFA for ; Wed, 28 Dec 2016 16:33:02 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id A7D38160B19; Wed, 28 Dec 2016 15:33:02 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 00A66160B2E for ; Wed, 28 Dec 2016 16:33:01 +0100 (CET) Received: (qmail 54703 invoked by uid 500); 28 Dec 2016 15:33:01 -0000 Mailing-List: contact dev-help@hawq.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hawq.incubator.apache.org Delivered-To: mailing list dev@hawq.incubator.apache.org Received: (qmail 54692 invoked by uid 99); 28 Dec 2016 15:33:01 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Dec 2016 15:33:01 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id BE7001A0624 for ; Wed, 28 Dec 2016 15:33:00 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -7.018 X-Spam-Level: X-Spam-Status: No, score=-7.018 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999, WEIRD_QUOTING=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id zXy8G3W_QSjf for ; Wed, 28 Dec 2016 15:33:00 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with SMTP id 507025FDFD for ; Wed, 28 Dec 2016 15:32:59 +0000 (UTC) Received: (qmail 54429 invoked by uid 99); 28 Dec 2016 15:32:58 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Dec 2016 15:32:58 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 6166F2C1F5A for ; Wed, 28 Dec 2016 15:32:58 +0000 (UTC) Date: Wed, 28 Dec 2016 15:32:58 +0000 (UTC) From: "Jon Roberts (JIRA)" To: dev@hawq.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HAWQ-1244) unrecognized configuration parameter "ONETARY" MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 28 Dec 2016 15:33:02 -0000 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)