Chunling Wang created HAWQ-812: ---------------------------------- Summary: Activate standby master failed after create a new database Key: HAWQ-812 URL: https://issues.apache.org/jira/browse/HAWQ-812 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)