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.
