Chunling Wang created HAWQ-813:
----------------------------------
Summary: Activate standby master failed after create a new database
Key: HAWQ-813
URL: https://issues.apache.org/jira/browse/HAWQ-813
Project: Apache HAWQ
Issue Type: Bug
Components: Backup & restore
Reporter: Chunling Wang
Assignee: Lei Chang
Activate standby master failed after create a new database. However, it will
success if we do not create a new database even we create a new table and
insert data.
1. Create a new database 'gptest'
{code}
[gpadmin@test1 ~]$ psql -l
List of databases
Name | Owner | Encoding | Access privileges
-----------+---------+----------+-------------------
postgres | gpadmin | UTF8 |
template0 | gpadmin | UTF8 |
template1 | gpadmin | UTF8 |
(3 rows)
[gpadmin@test1 ~]$ createdb gptest
[gpadmin@test1 ~]$ psql -l
List of databases
Name | Owner | Encoding | Access privileges
-----------+---------+----------+-------------------
gptest | gpadmin | UTF8 |
postgres | gpadmin | UTF8 |
template0 | gpadmin | UTF8 |
template1 | gpadmin | UTF8 |
(4 rows)
{code}
2. Stop HAWQ master
{code}
[gpadmin@test1 ~]$ hawq stop master -a
20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Prepare to do 'hawq
stop'
20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-You can find log in:
20160613:20:13:44:068559
hawq_stop:test1:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_stop_20160613.log
20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-GPHOME is set to:
20160613:20:13:44:068559
hawq_stop:test1:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
20160613:20:13:44:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq with args:
['stop', 'master']
20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-There are 0
connections to the database
20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Commencing Master
instance shutdown with mode='smart'
20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Master host=test1
20160613:20:13:45:068559 hawq_stop:test1:gpadmin-[INFO]:-Stop hawq master
20160613:20:13:46:068559 hawq_stop:test1:gpadmin-[INFO]:-Master stopped
successfully
{code}
3. Activate standby master
{code}
[gpadmin@test1 ~]$ ssh test5 'source
/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/./greenplum_path.sh;
hawq activate standby -a'
20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Prepare to do
'hawq activate'
20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-You can find log
in:
20160613:20:14:14:126841
hawq_activate:test5:gpadmin-[INFO]:-/home/gpadmin/hawqAdminLogs/hawq_activate_20160613.log
20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-GPHOME is set to:
20160613:20:14:14:126841
hawq_activate:test5:gpadmin-[INFO]:-/data/pulse-agent-data/HAWQ-main-FeatureTest-opt-mutilnodeparallel-wcl/product/hawq/.
20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Activate hawq with
args: ['activate', 'standby']
20160613:20:14:14:126841 hawq_activate:test5:gpadmin-[INFO]:-Starting to
activate standby master 'test5'
20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-HAWQ master is not
running, skip
20160613:20:14:15:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping all the
running segments
20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-
20160613:20:14:21:126841 hawq_activate:test5:gpadmin-[INFO]:-Stopping running
standby
20160613:20:14:23:126841 hawq_activate:test5:gpadmin-[INFO]:-Update master host
name in hawq-site.xml
20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-GUC
hawq_master_address_host already exist in hawq-site.xml
Update it with value: test5
20160613:20:14:31:126841 hawq_activate:test5:gpadmin-[INFO]:-Remove current
standby from hawq-site.xml
20160613:20:14:39:126841 hawq_activate:test5:gpadmin-[INFO]:-Start master in
master only mode
{code}
It hangs and can not start master.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
