Return-Path: X-Original-To: apmail-hawq-dev-archive@minotaur.apache.org Delivered-To: apmail-hawq-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7AFEE1004C for ; Tue, 8 Dec 2015 08:33:08 +0000 (UTC) Received: (qmail 26417 invoked by uid 500); 8 Dec 2015 08:33:08 -0000 Delivered-To: apmail-hawq-dev-archive@hawq.apache.org Received: (qmail 26372 invoked by uid 500); 8 Dec 2015 08:33:08 -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 26353 invoked by uid 99); 8 Dec 2015 08:33:08 -0000 Received: from Unknown (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Dec 2015 08:33:07 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 79417C6B2B for ; Tue, 8 Dec 2015 08:33:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.98 X-Spam-Level: ** X-Spam-Status: No, score=2.98 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=3, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, WEIRD_QUOTING=0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=pivotal-io.20150623.gappssmtp.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id DywmkoUTrPPL for ; Tue, 8 Dec 2015 08:33:06 +0000 (UTC) Received: from mail-oi0-f54.google.com (mail-oi0-f54.google.com [209.85.218.54]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id CF0E842ADE for ; Tue, 8 Dec 2015 08:33:05 +0000 (UTC) Received: by oixx65 with SMTP id x65so6350985oix.0 for ; Tue, 08 Dec 2015 00:28:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pivotal-io.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=f9/om+QJl2tHQvtWjE+APunZKCJ1Zav+JNM7UPQgR04=; b=oMrOwtfUJmYCSuYubCS78c3Rh8XEz2cb2rYDmjaDgFFR62ip3TV5ltb6kryTCq5nm4 ntw7RlPlizPnE30f1UMwp2Pf3JrLrnom8g29zfu02ZiLfmRRoAfPogN7E+bj+k1mUMrg kxrwGTILKCP86HtT0I6lsUIjW8hgRqWUIsnfTUM7nwIjhj/F9fOHvBxg8JmFJAOmne0W DqzAZofa1xEso157v6alMG7qMkQBZAUKBk49/Ked0WrmZWQlnE+r1yMS7TDeG+AIR/1/ gFzdMAWejS6GGmIB+Pb06RhiTauJ7k5tSpDtMzmNQElreFH7qj0wFAxRbnhKaulB/OmL 5B/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=f9/om+QJl2tHQvtWjE+APunZKCJ1Zav+JNM7UPQgR04=; b=AHCFmhl1CjLTrC0vwyWWp7qx2GWxtPyaV/vhw3YZQ6LJAzUjBs9FjJpliSV3JqmL3y RTC6ZmZGBufNlP6DECsG1w1/BDYIszTKQKhyx5B/morJ8+1bsxku1lUShTCiZyv3UqFM YzrSM46Emy+AGTU5h5udeHj5hO/Xhh2knQfeAblFh1hFULeHFmMlicYpzumAbkbJHVLv cxD/YrYpCaVcq5PU1wNo0OBZnjJY4RZ7eiajWHc4G170HRgXMFfcbDrglq6NjbSsFtFB d+PlFRdo6r/R2Uho6xIYkNWMojPIZQbpePw7Ao8plJfPT1DpMBR5PrJGmet2Su2xk4Gr p8ew== X-Gm-Message-State: ALoCoQke1OFHcRterz94rDIV5q8xsWUac8zyqF6zezkkRWkMK+IZEMC4RLEMpR8KKcHmifHRLA4fmTrZvVjiTkuUp1fSxnqMmjyTr8+GhoXhxqBvilqSiUo= MIME-Version: 1.0 X-Received: by 10.202.241.11 with SMTP id p11mr1415126oih.51.1449563285175; Tue, 08 Dec 2015 00:28:05 -0800 (PST) Received: by 10.202.228.84 with HTTP; Tue, 8 Dec 2015 00:28:05 -0800 (PST) In-Reply-To: References: Date: Tue, 8 Dec 2015 16:28:05 +0800 Message-ID: Subject: Re: Crashed while hawq init master From: Zhanwei Wang To: dev@hawq.incubator.apache.org Content-Type: multipart/alternative; boundary=94eb2c094892b15b0505265ec025 --94eb2c094892b15b0505265ec025 Content-Type: text/plain; charset=UTF-8 Hi Leon I have reproduce the issue. I will file a JIRA to for it. On Sat, Dec 5, 2015 at 10:15 AM, Leon Zhang wrote: > Hi, HAWQ dev: > > I recently rebuild the latest hawq on Centos7, it crashed while "hawq > init master". The stack dump looks like this: > > The files belonging to this database system will be owned by user > "xiaolin". > This user must also own the server process. > > The database cluster will be initialized with locale en_US.utf8. > > fixing permissions on existing directory > /mnt/xiaolin/hawq-data-directory/masterdd ... ok > creating subdirectories ... ok > selecting default max_connections ... 1280 > selecting default shared_buffers/max_fsm_pages ... 125MB/200000 > creating configuration files ... ok > creating template1 database in > /mnt/xiaolin/hawq-data-directory/masterdd/base/1 ... 2015-12-05 > 02:00:44.038224 > > GMT,,,p106570,th2038606336,,,,0,,,seg-10000,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9990, > ok > loading file-system persistent tables for template1 ... > 2015-12-05 02:00:50.473854 > > GMT,,,p106586,th2067827200,,,,0,,,seg-10000,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9990, > ok > initializing pg_authid ... 2015-12-05 02:00:51.873844 > > GMT,,,p106590,th-1267525120,,,,0,,,seg-10000,,,,,"WARNING","01000","""fsync"": > can not be set by the user and will be > ignored.",,,,,,,,"set_config_option","guc.c",9990, > 2015-12-05 10:00:52.434633 > > CST,,,p106590,th-1267525120,,,,0,,cmd1,seg-10000,,,x6,sx1,"FATAL","XX000","wrong > number of index expressions (index.c:1186)",,,,,,"CREATE TRIGGER > pg_sync_pg_database AFTER INSERT OR UPDATE OR DELETE ON pg_database FOR > EACH STATEMENT EXECUTE PROCEDURE flatfile_update_trigger(); > ",,"FormIndexDatum","index.c",1186,1 0x8c2b28 postgres errstart > (elog.c:473) > 2 0x8c489b postgres elog_finish (elog.c:1421) > 3 0x5735e5 postgres FormIndexDatum (index.c:1186) > 4 0x575030 postgres CatalogIndexInsert (discriminator 2) > 5 0x562f14 postgres caql_insert (caqlaccess.c:830) > 6 0x63fb38 postgres CreateTrigger (trigger.c:427) > 7 0x7ed0ec postgres ProcessUtility (utility.c:1578) > 8 0x7e8d6e postgres (pquery.c:1885) > 9 0x7ea54e postgres (pquery.c:1989) > 10 0x7ec2a5 postgres PortalRun (pquery.c:1510) > 11 0x7e41f1 postgres (postgres.c:1732) > 12 0x7e56b4 postgres PostgresMain (postgres.c:4697) > 13 0x4a2982 postgres main (main.c:204) > 14 0x7f1eb174faf5 libc.so.6 __libc_start_main (??:0) > 15 0x4a2a1d postgres (??:?) > > child process exited with exit code 1 > initdb: removing contents of data directory > "/mnt/xiaolin/hawq-data-directory/masterdd" > Master postgres initdb failed > 20151205:10:01:00:106236 hawq_init:dserver1:xiaolin-[INFO]:-Master postgres > initdb failed > 20151205:10:01:00:106236 hawq_init:dserver1:xiaolin-[ERROR]:-Master init > failed, exit > > > > > I have no idea why it crashed, any help will be appreciated. > > Thanks. > -- Best Regards ---------- Zhanwei Wang --94eb2c094892b15b0505265ec025--