hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yiming Liu" <liuyiming....@foxmail.com>
Subject 回复: Install failed when initdb (creating template0 instead template1)
Date Mon, 09 Nov 2015 03:13:30 GMT
My mistake. Thank you, I did follow the HAWQ tutorial: http://hawq.docs.pivotal.io/docs-hawq/topics/install-ambari.html,
installed by Ambari. I have no idea why the log shows "creating template0 database in /data/hawq/master/gpseg-1/base/1
...". But the initdb source code (at https://github.com/apache/incubator-hawq/blob/96779dd2ecd6a215da8789079116915caa99d408/src/bin/initdb/initdb.c
line 1547) has only the code "printf(_("creating template1 database in %s/base/1 ... "), pg_data);"




------------------ 原始邮件 ------------------
发件人: "Zhanwei Wang"<zwang@pivotal.io>; 
发送时间: 2015年11月9日(星期一) 上午9:46
收件人: "dev"<dev@hawq.incubator.apache.org>; 
主题: Re: Install failed when initdb (creating template0 instead template1)



Hi Yiming

The tutorial you mentioned is for Greenplum Database, not for HAWQ. You can
find HAWQ documents for 1.3 version in this link.

http://hawq.docs.pivotal.io/



On Sun, Nov 8, 2015 at 4:21 PM, Yiming Liu <liuyiming.vip@foxmail.com>
wrote:

> Hi HAWQ experts,
>
> I"m trying to deploy HAWQ to my cluster, following the tutorial:
> http://gpdb.docs.pivotal.io/4330/install_guide/install_guide.html
>
> My HAWQ version is 1.3.1.0. But the installation failed, the console shows
> "no gpadmin database" when I tried to connect psql. I have on master node,
> and three segments nodes. When I checked the log file gpinitsystem.log, I
> found there are some warnings when initdb.
> I tried to google the source code and found the initdb in HAWQ repo is
> just "creating template1 database", but my warning was "create template0
> database". There may be something wrong. Could you give me some help?
>
> Following are the detail logs:
>
> 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Start
> Function ARRAY_REORDER
> 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-End
> Function ARRAY_REORDER
> 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Start
> Function CREATE_QD_DB
> 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Building
> the Master instance database, please wait...
> 20151108:14:34:47:586892
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Initializing Master Postgres
> instance /data/hawq/master/gpseg-1
> 20151108:14:34:47:586892 gpinitsystem:easydmp69:gpadmin-[INFO]:-Commencing
> local /usr/local/hawq/./bin/initdb -E UNICODE -D /data/hawq/master/gpseg-1
> --locale=en_US.utf8        --max_connection
> s=250 --shared_buffers=128000kB --is_filerep_mirrored=no
> --backend_output=/data/hawq/master/gpseg-1.initdb --content_id=-1
> The files belonging to this database system will be owned by user
> "gpadmin".
> This user must also own the server process.
>
> The database cluster will be initialized with locale en_US.utf8.
>
> creating directory /data/hawq/master/gpseg-1 ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 250
> selecting default shared_buffers/max_fsm_pages ... 125MB/200000
> creating configuration files ... ok
> creating template0 database in /data/hawq/master/gpseg-1/base/1 ...
> 2015-11-08 06:34:48.283753
> GMT,,,p591743,th2143004704,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> loading file-system persistent tables for template0 (mirrored = false) ...
> 2015-11-08 06:34:53.276569
> GMT,,,p591746,th-949397472,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> initializing pg_authid ... 2015-11-08 06:34:54.387948
> GMT,,,p591749,th-1923487712,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> initializing dependencies ... 2015-11-08 06:34:55.414991
> GMT,,,p591751,th329537568,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> creating system views ... 2015-11-08 06:34:56.604558
> GMT,,,p591753,th128555040,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> loading system objects' descriptions ... 2015-11-08 06:34:57.714915
> GMT,,,p591755,th-134670304,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> creating conversions ... 2015-11-08 06:34:59.020746
> GMT,,,p591759,th1800534048,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> setting privileges on built-in objects ... 2015-11-08 06:35:07.921545
> GMT,,,p591762,th-1349728224,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> creating information schema ... 2015-11-08 06:35:08.803969
> GMT,,,p591765,th-1857652704,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> 2015-11-08 06:35:10.726271
> GMT,,,p591767,th-1193289696,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> creating HAWQ schema ... 2015-11-08 06:35:11.565366
> GMT,,,p591769,th159533088,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> vacuuming database template0 ... 2015-11-08 06:35:12.913042
> GMT,,,p591771,th43874336,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"": can
> not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
> updating content id ... 2015-11-08 06:35:19.245955
> GMT,,,p591775,th136087584,,,,0,,,seg-1,,,,,"WARNING","01000","""fsync"":
> can not be set by the user and will be
> ignored.",,,,,,,,"set_config_option","guc.c",9434,
> ok
>
> WARNING: enabling "trust" authentication for local connections
> You can change this by editing pg_hba.conf or using the -A option the
> next time you run initdb.
>
> Success. You can now start the database server using:
>
>     /usr/local/hawq/./bin/postgres -D /data/hawq/master/gpseg-1
> or
>     /usr/local/hawq/./bin/pg_ctl -D /data/hawq/master/gpseg-1 -l logfile
> start
>
>
> Thank you very much.
>
> Yiming Liu.




-- 
Best Regards
----------

Zhanwei Wang
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message