You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hawq.apache.org by Yiming Liu <li...@foxmail.com> on 2015/11/08 09:21:30 UTC
Install failed when initdb (creating template0 instead template1)
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.
Re: Install failed when initdb (creating template0 instead template1)
Posted by Yiming Liu <li...@foxmail.com>.
Thanks, Lei.
I could list the files created on HDFS during installation. Does it still mean the HDFS configuration is wrong?
[gpadmin@easydmp69 gpAdminLogs]$ hadoop fs -ls hdfs://easydmp106.xipu:8020/hawq_data
Found 3 items
drwx------ - gpadmin gpadmin 0 2015-11-11 01:03 hdfs://easydmp106.xipu:8020/hawq_data/gpseg0
drwx------ - gpadmin gpadmin 0 2015-11-11 01:03 hdfs://easydmp106.xipu:8020/hawq_data/gpseg1
drwx------ - gpadmin gpadmin 0 2015-11-11 01:03 hdfs://easydmp106.xipu:8020/hawq_data/gpseg2
------------------ Original ------------------
From: "Lei Chang";<ch...@gmail.com>;
Date: Wed, Nov 11, 2015 11:39 AM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
Looking at the log, "Failed to create dfs filespace". It seems you hdfs
does not work.
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
create dfs filespace; review gpinitsystem output to
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
why this step failed and reinitialize cluster after resolving
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
Not all initialization tasks have completed so the cluster
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not
be used. 20151110:22:25:45:184226
Thanks
Lei
On Wed, Nov 11, 2015 at 1:20 AM, Yiming Liu <li...@foxmail.com>
wrote:
> Now, I could run 'gpstart' to start the server from the command line,
> instead of Ambari.
>
>
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Process
> results...
> 20151111:01:10:42:274689
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Successful
> segment starts = 3
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Failed
> segment starts = 0
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Skipped
> segment starts (segments are marked down in configuration) = 0
> 20151111:01:10:42:274689
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Successfully
> started 3 of 3 segment instances
> 20151111:01:10:42:274689
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master
> instance easydmp69.xipu directory /data/hawq/master/gpseg-1/
> 20151111:01:10:45:274689 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl
> reports Master easydmp69.xipu instance active
> 20151111:01:10:45:274689 gpstart:easydmp69:gpadmin-[INFO]:-Database
> successfully started
>
>
>
> The server seems running.
>
>
> [gpadmin@easydmp69 ~]$ ps -eaf| grep postgres
> gpadmin 274826 1 1 01:10 ? 00:00:00
> /usr/local/hawq-1.3.1.0/bin/postgres -D /data/hawq/segments/gpseg0 -p 40000
> -b 2 -z 3 --silent-mode=true -i -M mirrorless -C 0
> gpadmin 274827 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> logger process
> gpadmin 274832 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> stats collector process
> gpadmin 274833 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> writer process
> gpadmin 274834 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> checkpoint process
> gpadmin 274835 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> sweeper process
> gpadmin 274845 1 1 01:10 ? 00:00:00
> /usr/local/hawq-1.3.1.0/bin/postgres -D /data/hawq/master/gpseg-1 -p 5432
> -b 1 -z 3 --silent-mode=true -i -M master -C -1 -x 0 -E
> gpadmin 274846 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> master logger process
> gpadmin 274849 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> stats collector process
> gpadmin 274850 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> writer process
> gpadmin 274851 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> checkpoint process
> gpadmin 274852 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> seqserver process
> gpadmin 274853 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> WAL Send Server process
> gpadmin 274854 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> ftsprobe process
> gpadmin 274855 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> sweeper process
>
>
>
> But when I try to login by 'psql', and create database, it will say
> "template1' not exist.
> [gpadmin@easydmp69 ~]$ psql
> psql: FATAL: database "gpadmin" does not exist
>
> [gpadmin@easydmp69 ~]$ psql template1
> psql: FATAL: database "template1" does not exist
> [gpadmin@easydmp69 ~]$ psql template0
> psql (8.2.15)
> Type "help" for help.
>
> template0=# create database hello;
> ERROR: template database "template1" does not exist
>
>
>
>
>
> ------------------ Original ------------------
> From: "Yiming Liu";<li...@foxmail.com>;
> Date: Tue, Nov 10, 2015 10:34 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Reformat the log in pure txt
>
>
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Process
> results...
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful
> segment starts = 3
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed
> segment starts = 0
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped
> segment starts (segments are marked down in configuration) = 0
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully
> started 3 of 3 segment instances
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master
> instance easydmp69.xipu directory /data/hawq/master/gpseg-1
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl
> reports Master easydmp69.xipu instance active
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[WARNING]:-error
> 'ERROR: failed to acquire resources on segment 1
> ' in 'SET CLIENT_MIN_MESSAGES='ERROR''
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of
> database with gpstate utility
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed
> restart of Greenplum instance in production mode
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to
> create filespace on hdfs
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create
> filespace dfs_system
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create
> tablespace dfs_default
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update
> template0 tablespace
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
> create dfs filespace; review gpinitsystem output to
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
> why this step failed and reinitialize cluster after resolving
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
> Not all initialization tasks have completed so the cluster
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should
> not be used.
> 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop
> the cluster
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop
> with args: -a -i -d /data/hawq/master/gpseg-1
> 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Gathering
> information and validating the environment...
> 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining
> Greenplum Master catalog information
> 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining
> Segment details from master...
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum
> Version: 'postgres (HAWQ) 4.2.0 build 1'
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-There are 0
> connections to the database
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> Master instance shutdown with mode='immediate'
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master
> host=easydmp69.xipu
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> Master instance shutdown with mode=immediate
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master segment
> instance directory=/data/hawq/master/gpseg-1
> 20151110:22:25:39:198856 gpstop:easydmp69:gpadmin-[INFO]:-No standby
> master host configured
> 20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> parallel segment instance shutdown, please wait...
> .....
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments
> stopped successfully = 3
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments with
> errors during stop = 0
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully
> shutdown 3 of 3 segment instances
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Database
> successfully shutdown with no errors reported
> 20151110:22:25:45:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum
> instance
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
> create dfs filespace; review gpinitsystem output to
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
> why this step failed and reinitialize cluster after resolving
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
> Not all initialization tasks have completed so the cluster
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should
> not be used.
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs
> filespace failed; Script Exiting!
>
>
>
>
>
> ------------------ Original ------------------
> From: "Yiming Liu";<li...@foxmail.com>;
> Date: Tue, Nov 10, 2015 10:30 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> The gpinitsystem.log has the following log, and no postgres process could
> be found by ps -eaf20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-Process results...
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful
> segment starts = 3
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed
> segment starts = 0
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped
> segment starts (segments are marked down in configuration) = 0
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully
> started 3 of 3 segment instances 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master
> instance easydmp69.xipu directory /data/hawq/master/gpseg-1
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl
> reports Master easydmp69.xipu instance active 20151110:22:25:34:197931
> gpstart:easydmp69:gpadmin-[WARNING]:-error 'ERROR: failed to acquire
> resources on segment 1 ' in 'SET CLIENT_MIN_MESSAGES='ERROR''
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of
> database with gpstate utility 20151110:22:25:34:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed restart of Greenplum
> instance in production mode 20151110:22:25:34:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to create filespace on hdfs
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create
> filespace dfs_system 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Create tablespace dfs_default
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update
> template0 tablespace 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace;
> review gpinitsystem output to 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and
> reinitialize cluster after resolving 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization
> tasks have completed so the cluster 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used.
> 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop
> the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop
> with args: -a -i -d /data/hawq/master/gpseg-1 20151110:22:25:35:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Gathering information and validating the
> environment... 20151110:22:25:36:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Greenplum Master catalog
> information 20151110:22:25:36:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Segment details from master...
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum
> Version: 'postgres (HAWQ) 4.2.0 build 1' 20151110:22:25:37:198856
> gpstop:easydmp69:gpadmin-[INFO]:-There are 0 connections to the database
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master
> instance shutdown with mode='immediate' 20151110:22:25:37:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Master host=easydmp69.xipu
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master
> instance shutdown with mode=immediate 20151110:22:25:37:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Master segment instance
> directory=/data/hawq/master/gpseg-1 20151110:22:25:39:198856
> gpstop:easydmp69:gpadmin-[INFO]:-No standby master host configured
> 20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> parallel segment instance shutdown, please wait... .....
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments
> stopped successfully = 3 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:- Segments with errors during stop = 0
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully
> shutdown 3 of 3 segment instances 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Database successfully shutdown with no
> errors reported 20151110:22:25:45:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum
> instance 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
> create dfs filespace; review gpinitsystem output to
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
> why this step failed and reinitialize cluster after resolving
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
> Not all initialization tasks have completed so the cluster
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not
> be used. 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs
> filespace failed; Script Exiting!
>
>
>
>
> ------------------ Original ------------------
> From: "Lei Chang";<ch...@gmail.com>;
> Date: Mon, Nov 9, 2015 05:48 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Can you show the logs in your home directory ~/gpAdminLogs and run "ps -eaf
> | grep postgres" on your master and segment nodes?
>
> Thanks
> Lei
>
>
>
>
> On Mon, Nov 9, 2015 at 4:32 PM, Yiming Liu <li...@foxmail.com>
> wrote:
>
> > it will say "database postgres does not exist"
> >
> >
> >
> >
> > ------------------ Original ------------------
> > From: "Lei Chang";<ch...@gmail.com>;
> > Date: Mon, Nov 9, 2015 04:27 PM
> > To: "dev"<de...@hawq.incubator.apache.org>;
> >
> > Subject: Re: Install failed when initdb (creating template0 instead
> > template1)
> >
> >
> >
> > Looks your database has been created.
> >
> > Can you try "psql -d postgres"?
> >
> > Cheers
> > Lei
> >
> >
> >
> >
> > On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
> > wrote:
> >
> > > 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"<zw...@pivotal.io>;
> > > 发送时间: 2015年11月9日(星期一) 上午9:46
> > > 收件人: "dev"<de...@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 <li...@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
> > >
> >
>
Re: Install failed when initdb (creating template0 instead template1)
Posted by Lei Chang <ch...@gmail.com>.
Looking at the log, "Failed to create dfs filespace". It seems you hdfs
does not work.
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
create dfs filespace; review gpinitsystem output to
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
why this step failed and reinitialize cluster after resolving
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
Not all initialization tasks have completed so the cluster
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not
be used. 20151110:22:25:45:184226
Thanks
Lei
On Wed, Nov 11, 2015 at 1:20 AM, Yiming Liu <li...@foxmail.com>
wrote:
> Now, I could run 'gpstart' to start the server from the command line,
> instead of Ambari.
>
>
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Process
> results...
> 20151111:01:10:42:274689
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Successful
> segment starts = 3
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Failed
> segment starts = 0
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Skipped
> segment starts (segments are marked down in configuration) = 0
> 20151111:01:10:42:274689
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Successfully
> started 3 of 3 segment instances
> 20151111:01:10:42:274689
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master
> instance easydmp69.xipu directory /data/hawq/master/gpseg-1/
> 20151111:01:10:45:274689 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl
> reports Master easydmp69.xipu instance active
> 20151111:01:10:45:274689 gpstart:easydmp69:gpadmin-[INFO]:-Database
> successfully started
>
>
>
> The server seems running.
>
>
> [gpadmin@easydmp69 ~]$ ps -eaf| grep postgres
> gpadmin 274826 1 1 01:10 ? 00:00:00
> /usr/local/hawq-1.3.1.0/bin/postgres -D /data/hawq/segments/gpseg0 -p 40000
> -b 2 -z 3 --silent-mode=true -i -M mirrorless -C 0
> gpadmin 274827 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> logger process
> gpadmin 274832 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> stats collector process
> gpadmin 274833 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> writer process
> gpadmin 274834 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> checkpoint process
> gpadmin 274835 274826 0 01:10 ? 00:00:00 postgres: port 40000,
> sweeper process
> gpadmin 274845 1 1 01:10 ? 00:00:00
> /usr/local/hawq-1.3.1.0/bin/postgres -D /data/hawq/master/gpseg-1 -p 5432
> -b 1 -z 3 --silent-mode=true -i -M master -C -1 -x 0 -E
> gpadmin 274846 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> master logger process
> gpadmin 274849 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> stats collector process
> gpadmin 274850 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> writer process
> gpadmin 274851 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> checkpoint process
> gpadmin 274852 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> seqserver process
> gpadmin 274853 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> WAL Send Server process
> gpadmin 274854 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> ftsprobe process
> gpadmin 274855 274845 0 01:10 ? 00:00:00 postgres: port 5432,
> sweeper process
>
>
>
> But when I try to login by 'psql', and create database, it will say
> "template1' not exist.
> [gpadmin@easydmp69 ~]$ psql
> psql: FATAL: database "gpadmin" does not exist
>
> [gpadmin@easydmp69 ~]$ psql template1
> psql: FATAL: database "template1" does not exist
> [gpadmin@easydmp69 ~]$ psql template0
> psql (8.2.15)
> Type "help" for help.
>
> template0=# create database hello;
> ERROR: template database "template1" does not exist
>
>
>
>
>
> ------------------ Original ------------------
> From: "Yiming Liu";<li...@foxmail.com>;
> Date: Tue, Nov 10, 2015 10:34 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Reformat the log in pure txt
>
>
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Process
> results...
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful
> segment starts = 3
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed
> segment starts = 0
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped
> segment starts (segments are marked down in configuration) = 0
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully
> started 3 of 3 segment instances
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master
> instance easydmp69.xipu directory /data/hawq/master/gpseg-1
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl
> reports Master easydmp69.xipu instance active
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[WARNING]:-error
> 'ERROR: failed to acquire resources on segment 1
> ' in 'SET CLIENT_MIN_MESSAGES='ERROR''
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of
> database with gpstate utility
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed
> restart of Greenplum instance in production mode
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to
> create filespace on hdfs
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create
> filespace dfs_system
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create
> tablespace dfs_default
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update
> template0 tablespace
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
> create dfs filespace; review gpinitsystem output to
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
> why this step failed and reinitialize cluster after resolving
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
> Not all initialization tasks have completed so the cluster
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should
> not be used.
> 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop
> the cluster
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop
> with args: -a -i -d /data/hawq/master/gpseg-1
> 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Gathering
> information and validating the environment...
> 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining
> Greenplum Master catalog information
> 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining
> Segment details from master...
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum
> Version: 'postgres (HAWQ) 4.2.0 build 1'
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-There are 0
> connections to the database
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> Master instance shutdown with mode='immediate'
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master
> host=easydmp69.xipu
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> Master instance shutdown with mode=immediate
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master segment
> instance directory=/data/hawq/master/gpseg-1
> 20151110:22:25:39:198856 gpstop:easydmp69:gpadmin-[INFO]:-No standby
> master host configured
> 20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> parallel segment instance shutdown, please wait...
> .....
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments
> stopped successfully = 3
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments with
> errors during stop = 0
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully
> shutdown 3 of 3 segment instances
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Database
> successfully shutdown with no errors reported
> 20151110:22:25:45:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum
> instance
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
> create dfs filespace; review gpinitsystem output to
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
> why this step failed and reinitialize cluster after resolving
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
> Not all initialization tasks have completed so the cluster
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should
> not be used.
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs
> filespace failed; Script Exiting!
>
>
>
>
>
> ------------------ Original ------------------
> From: "Yiming Liu";<li...@foxmail.com>;
> Date: Tue, Nov 10, 2015 10:30 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> The gpinitsystem.log has the following log, and no postgres process could
> be found by ps -eaf20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-Process results...
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful
> segment starts = 3
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed
> segment starts = 0
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped
> segment starts (segments are marked down in configuration) = 0
> 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully
> started 3 of 3 segment instances 20151110:22:25:31:197931
> gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master
> instance easydmp69.xipu directory /data/hawq/master/gpseg-1
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl
> reports Master easydmp69.xipu instance active 20151110:22:25:34:197931
> gpstart:easydmp69:gpadmin-[WARNING]:-error 'ERROR: failed to acquire
> resources on segment 1 ' in 'SET CLIENT_MIN_MESSAGES='ERROR''
> 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of
> database with gpstate utility 20151110:22:25:34:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed restart of Greenplum
> instance in production mode 20151110:22:25:34:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to create filespace on hdfs
> 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create
> filespace dfs_system 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Create tablespace dfs_default
> 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update
> template0 tablespace 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace;
> review gpinitsystem output to 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and
> reinitialize cluster after resolving 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization
> tasks have completed so the cluster 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used.
> 20151110:22:25:35:184226
> gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop
> the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop
> with args: -a -i -d /data/hawq/master/gpseg-1 20151110:22:25:35:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Gathering information and validating the
> environment... 20151110:22:25:36:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Greenplum Master catalog
> information 20151110:22:25:36:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Segment details from master...
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum
> Version: 'postgres (HAWQ) 4.2.0 build 1' 20151110:22:25:37:198856
> gpstop:easydmp69:gpadmin-[INFO]:-There are 0 connections to the database
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master
> instance shutdown with mode='immediate' 20151110:22:25:37:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Master host=easydmp69.xipu
> 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master
> instance shutdown with mode=immediate 20151110:22:25:37:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Master segment instance
> directory=/data/hawq/master/gpseg-1 20151110:22:25:39:198856
> gpstop:easydmp69:gpadmin-[INFO]:-No standby master host configured
> 20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing
> parallel segment instance shutdown, please wait... .....
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments
> stopped successfully = 3 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:- Segments with errors during stop = 0
> 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
> 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully
> shutdown 3 of 3 segment instances 20151110:22:25:45:198856
> gpstop:easydmp69:gpadmin-[INFO]:-Database successfully shutdown with no
> errors reported 20151110:22:25:45:184226
> gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum
> instance 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to
> create dfs filespace; review gpinitsystem output to
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine
> why this step failed and reinitialize cluster after resolving
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues.
> Not all initialization tasks have completed so the cluster
> 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not
> be used. 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
> 20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs
> filespace failed; Script Exiting!
>
>
>
>
> ------------------ Original ------------------
> From: "Lei Chang";<ch...@gmail.com>;
> Date: Mon, Nov 9, 2015 05:48 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Can you show the logs in your home directory ~/gpAdminLogs and run "ps -eaf
> | grep postgres" on your master and segment nodes?
>
> Thanks
> Lei
>
>
>
>
> On Mon, Nov 9, 2015 at 4:32 PM, Yiming Liu <li...@foxmail.com>
> wrote:
>
> > it will say "database postgres does not exist"
> >
> >
> >
> >
> > ------------------ Original ------------------
> > From: "Lei Chang";<ch...@gmail.com>;
> > Date: Mon, Nov 9, 2015 04:27 PM
> > To: "dev"<de...@hawq.incubator.apache.org>;
> >
> > Subject: Re: Install failed when initdb (creating template0 instead
> > template1)
> >
> >
> >
> > Looks your database has been created.
> >
> > Can you try "psql -d postgres"?
> >
> > Cheers
> > Lei
> >
> >
> >
> >
> > On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
> > wrote:
> >
> > > 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"<zw...@pivotal.io>;
> > > 发送时间: 2015年11月9日(星期一) 上午9:46
> > > 收件人: "dev"<de...@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 <li...@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
> > >
> >
>
Re: Install failed when initdb (creating template0 instead template1)
Posted by Yiming Liu <li...@foxmail.com>.
Now, I could run 'gpstart' to start the server from the command line, instead of Ambari.
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Process results...
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Successful segment starts = 3
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Failed segment starts = 0
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151111:01:10:42:274689 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master instance easydmp69.xipu directory /data/hawq/master/gpseg-1/
20151111:01:10:45:274689 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl reports Master easydmp69.xipu instance active
20151111:01:10:45:274689 gpstart:easydmp69:gpadmin-[INFO]:-Database successfully started
The server seems running.
[gpadmin@easydmp69 ~]$ ps -eaf| grep postgres
gpadmin 274826 1 1 01:10 ? 00:00:00 /usr/local/hawq-1.3.1.0/bin/postgres -D /data/hawq/segments/gpseg0 -p 40000 -b 2 -z 3 --silent-mode=true -i -M mirrorless -C 0
gpadmin 274827 274826 0 01:10 ? 00:00:00 postgres: port 40000, logger process
gpadmin 274832 274826 0 01:10 ? 00:00:00 postgres: port 40000, stats collector process
gpadmin 274833 274826 0 01:10 ? 00:00:00 postgres: port 40000, writer process
gpadmin 274834 274826 0 01:10 ? 00:00:00 postgres: port 40000, checkpoint process
gpadmin 274835 274826 0 01:10 ? 00:00:00 postgres: port 40000, sweeper process
gpadmin 274845 1 1 01:10 ? 00:00:00 /usr/local/hawq-1.3.1.0/bin/postgres -D /data/hawq/master/gpseg-1 -p 5432 -b 1 -z 3 --silent-mode=true -i -M master -C -1 -x 0 -E
gpadmin 274846 274845 0 01:10 ? 00:00:00 postgres: port 5432, master logger process
gpadmin 274849 274845 0 01:10 ? 00:00:00 postgres: port 5432, stats collector process
gpadmin 274850 274845 0 01:10 ? 00:00:00 postgres: port 5432, writer process
gpadmin 274851 274845 0 01:10 ? 00:00:00 postgres: port 5432, checkpoint process
gpadmin 274852 274845 0 01:10 ? 00:00:00 postgres: port 5432, seqserver process
gpadmin 274853 274845 0 01:10 ? 00:00:00 postgres: port 5432, WAL Send Server process
gpadmin 274854 274845 0 01:10 ? 00:00:00 postgres: port 5432, ftsprobe process
gpadmin 274855 274845 0 01:10 ? 00:00:00 postgres: port 5432, sweeper process
But when I try to login by 'psql', and create database, it will say "template1' not exist.
[gpadmin@easydmp69 ~]$ psql
psql: FATAL: database "gpadmin" does not exist
[gpadmin@easydmp69 ~]$ psql template1
psql: FATAL: database "template1" does not exist
[gpadmin@easydmp69 ~]$ psql template0
psql (8.2.15)
Type "help" for help.
template0=# create database hello;
ERROR: template database "template1" does not exist
------------------ Original ------------------
From: "Yiming Liu";<li...@foxmail.com>;
Date: Tue, Nov 10, 2015 10:34 PM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
Reformat the log in pure txt
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Process results...
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful segment starts = 3
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed segment starts = 0
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master instance easydmp69.xipu directory /data/hawq/master/gpseg-1
20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl reports Master easydmp69.xipu instance active
20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[WARNING]:-error 'ERROR: failed to acquire resources on segment 1
' in 'SET CLIENT_MIN_MESSAGES='ERROR''
20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of database with gpstate utility
20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to create filespace on hdfs
20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create filespace dfs_system
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create tablespace dfs_default
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update template0 tablespace
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used.
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop the cluster
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop with args: -a -i -d /data/hawq/master/gpseg-1
20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Gathering information and validating the environment...
20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Segment details from master...
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum Version: 'postgres (HAWQ) 4.2.0 build 1'
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-There are 0 connections to the database
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master host=easydmp69.xipu
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master segment instance directory=/data/hawq/master/gpseg-1
20151110:22:25:39:198856 gpstop:easydmp69:gpadmin-[INFO]:-No standby master host configured
20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
.....
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments stopped successfully = 3
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments with errors during stop = 0
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully shutdown 3 of 3 segment instances
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum instance
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used.
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs filespace failed; Script Exiting!
------------------ Original ------------------
From: "Yiming Liu";<li...@foxmail.com>;
Date: Tue, Nov 10, 2015 10:30 PM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
The gpinitsystem.log has the following log, and no postgres process could be found by ps -eaf20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Process results... 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful segment starts = 3 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed segment starts = 0 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master instance easydmp69.xipu directory /data/hawq/master/gpseg-1 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl reports Master easydmp69.xipu instance active 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[WARNING]:-error 'ERROR: failed to acquire resources on segment 1 ' in 'SET CLIENT_MIN_MESSAGES='ERROR'' 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of database with gpstate utility 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to create filespace on hdfs 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create filespace dfs_system 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create tablespace dfs_default 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update template0 tablespace 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used. 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop with args: -a -i -d /data/hawq/master/gpseg-1 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Gathering information and validating the environment... 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Segment details from master... 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum Version: 'postgres (HAWQ) 4.2.0 build 1' 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-There are 0 connections to the database 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate' 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master host=easydmp69.xipu 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master segment instance directory=/data/hawq/master/gpseg-1 20151110:22:25:39:198856 gpstop:easydmp69:gpadmin-[INFO]:-No standby master host configured 20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait... ..... 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments stopped successfully = 3 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments with errors during stop = 0 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully shutdown 3 of 3 segment instances 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum instance 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used. 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs filespace failed; Script Exiting!
------------------ Original ------------------
From: "Lei Chang";<ch...@gmail.com>;
Date: Mon, Nov 9, 2015 05:48 PM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
Can you show the logs in your home directory ~/gpAdminLogs and run "ps -eaf
| grep postgres" on your master and segment nodes?
Thanks
Lei
On Mon, Nov 9, 2015 at 4:32 PM, Yiming Liu <li...@foxmail.com>
wrote:
> it will say "database postgres does not exist"
>
>
>
>
> ------------------ Original ------------------
> From: "Lei Chang";<ch...@gmail.com>;
> Date: Mon, Nov 9, 2015 04:27 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Looks your database has been created.
>
> Can you try "psql -d postgres"?
>
> Cheers
> Lei
>
>
>
>
> On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
> wrote:
>
> > 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"<zw...@pivotal.io>;
> > 发送时间: 2015年11月9日(星期一) 上午9:46
> > 收件人: "dev"<de...@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 <li...@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
> >
>
Re: Install failed when initdb (creating template0 instead template1)
Posted by Yiming Liu <li...@foxmail.com>.
Reformat the log in pure txt
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Process results...
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful segment starts = 3
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed segment starts = 0
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master instance easydmp69.xipu directory /data/hawq/master/gpseg-1
20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl reports Master easydmp69.xipu instance active
20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[WARNING]:-error 'ERROR: failed to acquire resources on segment 1
' in 'SET CLIENT_MIN_MESSAGES='ERROR''
20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of database with gpstate utility
20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode
20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to create filespace on hdfs
20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create filespace dfs_system
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create tablespace dfs_default
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update template0 tablespace
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used.
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop the cluster
20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop with args: -a -i -d /data/hawq/master/gpseg-1
20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Gathering information and validating the environment...
20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Segment details from master...
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum Version: 'postgres (HAWQ) 4.2.0 build 1'
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-There are 0 connections to the database
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate'
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master host=easydmp69.xipu
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate
20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master segment instance directory=/data/hawq/master/gpseg-1
20151110:22:25:39:198856 gpstop:easydmp69:gpadmin-[INFO]:-No standby master host configured
20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait...
.....
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments stopped successfully = 3
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments with errors during stop = 0
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-----------------------------------------------------
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully shutdown 3 of 3 segment instances
20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Database successfully shutdown with no errors reported
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum instance
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used.
20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:
20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs filespace failed; Script Exiting!
------------------ Original ------------------
From: "Yiming Liu";<li...@foxmail.com>;
Date: Tue, Nov 10, 2015 10:30 PM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
The gpinitsystem.log has the following log, and no postgres process could be found by ps -eaf20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Process results... 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful segment starts = 3 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed segment starts = 0 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master instance easydmp69.xipu directory /data/hawq/master/gpseg-1 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl reports Master easydmp69.xipu instance active 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[WARNING]:-error 'ERROR: failed to acquire resources on segment 1 ' in 'SET CLIENT_MIN_MESSAGES='ERROR'' 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of database with gpstate utility 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to create filespace on hdfs 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create filespace dfs_system 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create tablespace dfs_default 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update template0 tablespace 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used. 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop with args: -a -i -d /data/hawq/master/gpseg-1 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Gathering information and validating the environment... 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Segment details from master... 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum Version: 'postgres (HAWQ) 4.2.0 build 1' 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-There are 0 connections to the database 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate' 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master host=easydmp69.xipu 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master segment instance directory=/data/hawq/master/gpseg-1 20151110:22:25:39:198856 gpstop:easydmp69:gpadmin-[INFO]:-No standby master host configured 20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait... ..... 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments stopped successfully = 3 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments with errors during stop = 0 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully shutdown 3 of 3 segment instances 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum instance 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used. 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs filespace failed; Script Exiting!
------------------ Original ------------------
From: "Lei Chang";<ch...@gmail.com>;
Date: Mon, Nov 9, 2015 05:48 PM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
Can you show the logs in your home directory ~/gpAdminLogs and run "ps -eaf
| grep postgres" on your master and segment nodes?
Thanks
Lei
On Mon, Nov 9, 2015 at 4:32 PM, Yiming Liu <li...@foxmail.com>
wrote:
> it will say "database postgres does not exist"
>
>
>
>
> ------------------ Original ------------------
> From: "Lei Chang";<ch...@gmail.com>;
> Date: Mon, Nov 9, 2015 04:27 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Looks your database has been created.
>
> Can you try "psql -d postgres"?
>
> Cheers
> Lei
>
>
>
>
> On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
> wrote:
>
> > 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"<zw...@pivotal.io>;
> > 发送时间: 2015年11月9日(星期一) 上午9:46
> > 收件人: "dev"<de...@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 <li...@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
> >
>
Re: Install failed when initdb (creating template0 instead template1)
Posted by Yiming Liu <li...@foxmail.com>.
The gpinitsystem.log has the following log, and no postgres process could be found by ps -eaf20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Process results... 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Successful segment starts = 3 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Failed segment starts = 0 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- Skipped segment starts (segments are marked down in configuration) = 0 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Successfully started 3 of 3 segment instances 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:31:197931 gpstart:easydmp69:gpadmin-[INFO]:-Starting Master instance easydmp69.xipu directory /data/hawq/master/gpseg-1 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Command pg_ctl reports Master easydmp69.xipu instance active 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[WARNING]:-error 'ERROR: failed to acquire resources on segment 1 ' in 'SET CLIENT_MIN_MESSAGES='ERROR'' 20151110:22:25:34:197931 gpstart:easydmp69:gpadmin-[INFO]:-Check status of database with gpstate utility 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Completed restart of Greenplum instance in production mode 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Prepare to create filespace on hdfs 20151110:22:25:34:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create filespace dfs_system 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Create tablespace dfs_default 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Update template0 tablespace 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used. 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-gpinitsystem will now try to stop the cluster 20151110:22:25:35:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Starting gpstop with args: -a -i -d /data/hawq/master/gpseg-1 20151110:22:25:35:198856 gpstop:easydmp69:gpadmin-[INFO]:-Gathering information and validating the environment... 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20151110:22:25:36:198856 gpstop:easydmp69:gpadmin-[INFO]:-Obtaining Segment details from master... 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Greenplum Version: 'postgres (HAWQ) 4.2.0 build 1' 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-There are 0 connections to the database 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode='immediate' 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master host=easydmp69.xipu 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing Master instance shutdown with mode=immediate 20151110:22:25:37:198856 gpstop:easydmp69:gpadmin-[INFO]:-Master segment instance directory=/data/hawq/master/gpseg-1 20151110:22:25:39:198856 gpstop:easydmp69:gpadmin-[INFO]:-No standby master host configured 20151110:22:25:40:198856 gpstop:easydmp69:gpadmin-[INFO]:-Commencing parallel segment instance shutdown, please wait... ..... 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments stopped successfully = 3 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:- Segments with errors during stop = 0 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:----------------------------------------------------- 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Successfully shutdown 3 of 3 segment instances 20151110:22:25:45:198856 gpstop:easydmp69:gpadmin-[INFO]:-Database successfully shutdown with no errors reported 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[INFO]:-Successfully shutdown the Greenplum instance 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:-Failed to create dfs filespace; review gpinitsystem output to 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- determine why this step failed and reinitialize cluster after resolving 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- issues. Not all initialization tasks have completed so the cluster 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]:- should not be used. 20151110:22:25:45:184226 gpinitsystem:easydmp69:gpadmin-[WARN]: 20151110:22:25:45:gpinitsystem:easydmp69:gpadmin-[FATAL]: create dfs filespace failed; Script Exiting!
------------------ Original ------------------
From: "Lei Chang";<ch...@gmail.com>;
Date: Mon, Nov 9, 2015 05:48 PM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
Can you show the logs in your home directory ~/gpAdminLogs and run "ps -eaf
| grep postgres" on your master and segment nodes?
Thanks
Lei
On Mon, Nov 9, 2015 at 4:32 PM, Yiming Liu <li...@foxmail.com>
wrote:
> it will say "database postgres does not exist"
>
>
>
>
> ------------------ Original ------------------
> From: "Lei Chang";<ch...@gmail.com>;
> Date: Mon, Nov 9, 2015 04:27 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Looks your database has been created.
>
> Can you try "psql -d postgres"?
>
> Cheers
> Lei
>
>
>
>
> On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
> wrote:
>
> > 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"<zw...@pivotal.io>;
> > 发送时间: 2015年11月9日(星期一) 上午9:46
> > 收件人: "dev"<de...@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 <li...@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
> >
>
Re: Install failed when initdb (creating template0 instead template1)
Posted by Lei Chang <ch...@gmail.com>.
Can you show the logs in your home directory ~/gpAdminLogs and run "ps -eaf
| grep postgres" on your master and segment nodes?
Thanks
Lei
On Mon, Nov 9, 2015 at 4:32 PM, Yiming Liu <li...@foxmail.com>
wrote:
> it will say "database postgres does not exist"
>
>
>
>
> ------------------ Original ------------------
> From: "Lei Chang";<ch...@gmail.com>;
> Date: Mon, Nov 9, 2015 04:27 PM
> To: "dev"<de...@hawq.incubator.apache.org>;
>
> Subject: Re: Install failed when initdb (creating template0 instead
> template1)
>
>
>
> Looks your database has been created.
>
> Can you try "psql -d postgres"?
>
> Cheers
> Lei
>
>
>
>
> On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
> wrote:
>
> > 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"<zw...@pivotal.io>;
> > 发送时间: 2015年11月9日(星期一) 上午9:46
> > 收件人: "dev"<de...@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 <li...@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
> >
>
Re: Install failed when initdb (creating template0 instead template1)
Posted by Yiming Liu <li...@foxmail.com>.
it will say "database postgres does not exist"
------------------ Original ------------------
From: "Lei Chang";<ch...@gmail.com>;
Date: Mon, Nov 9, 2015 04:27 PM
To: "dev"<de...@hawq.incubator.apache.org>;
Subject: Re: Install failed when initdb (creating template0 instead template1)
Looks your database has been created.
Can you try "psql -d postgres"?
Cheers
Lei
On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
wrote:
> 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"<zw...@pivotal.io>;
> 发送时间: 2015年11月9日(星期一) 上午9:46
> 收件人: "dev"<de...@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 <li...@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
>
Re: Install failed when initdb (creating template0 instead template1)
Posted by Lei Chang <ch...@gmail.com>.
Looks your database has been created.
Can you try "psql -d postgres"?
Cheers
Lei
On Mon, Nov 9, 2015 at 11:13 AM, Yiming Liu <li...@foxmail.com>
wrote:
> 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"<zw...@pivotal.io>;
> 发送时间: 2015年11月9日(星期一) 上午9:46
> 收件人: "dev"<de...@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 <li...@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
>
回复： Install failed when initdb (creating template0 instead template1)
Posted by Yiming Liu <li...@foxmail.com>.
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"<zw...@pivotal.io>;
发送时间: 2015年11月9日(星期一) 上午9:46
收件人: "dev"<de...@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 <li...@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
Re: Install failed when initdb (creating template0 instead template1)
Posted by Zhanwei Wang <zw...@pivotal.io>.
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 <li...@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