hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zhanwei Wang <zw...@pivotal.io>
Subject Re: Install failed when initdb (creating template0 instead template1)
Date Mon, 09 Nov 2015 01:46:44 GMT
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, None, 0 bytes)
View raw message