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 Sun, 08 Nov 2015 08:21:30 GMT
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.
Mime
View raw message