[ https://issues.apache.org/jira/browse/HAWQ-813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Goden Yao reopened HAWQ-813: ---------------------------- reopen to update version > 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 > Fix For: 2.0.0.0-incubating > > > 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)