-
Notifications
You must be signed in to change notification settings - Fork 1
Description
Issue migrated from trac ticket # 738
component: node manager | priority: major
2022-05-25 18:18:24: hellen@zettadb.com created the issue
1.cluster info:
{"comps":"2","cpu_cores":"8","dbcfg":"1","ha_mode":"rbr","innodb_size":"1","max_connections":"6","max_storage_size":"20","nodes":"3","shards":"2"}2.testcase:
--let $pgport =select port from comp_nodes limit 0,1;
--set_cluster_id(3)
--kl_cluster_id(1)--pg_connect(testrbr1,computer.1, abc, abc)
drop table if exists bankData;
create table bankData(id int primary key, username varchar(10), money float);
insert into bankData(id,username,money) values(2022001, 'jim', 10000.0);
insert into bankData(id,username,money) values(2022002, 'anna', 20000.0);
start transaction;
update bankData set money # money+2000.5 where id2022002;
update bankData set money # money-80.7 where id2022001;
--exec ./kunlun-test/util/test_client node_mgr.1 " ps -aux |grep $pgport|grep -v grep |awk '{print $2}' | xargs kill"
--sleep 200
update bankData set money # money-100.5 where id2022002;
update bankData set money # money+1080.7 where id2022001;
commit;
select * from bankData;
drop table bankData;3.node mgr Non-stop output some error logs:
Wed May 25 18:17:05 2022 tid:0x2f5f46 [INFO] [/home/barney/zettadb/node_mgr/src/job.cc:295 job_control_computer]: start pgsql cmd : cd /home/kunlun/testmgr0.9.2/instance_binaries/computer/57031/kunlun-server-0.9.2/scripts; python2 start_pg.py --port=57031
Wed May 25 18:17:17 2022 tid:0x2f5f46 [ERROR] [/home/barney/zettadb/node_mgr/src/instance_info.cc:607 get_pgsql_alive]: pg select version failed:
Wed May 25 18:17:17 2022 tid:0x2f5f46 [ERROR] [/home/barney/zettadb/node_mgr/src/instance_info.cc:607 get_pgsql_alive]: pg select version failed:
Wed May 25 18:17:17 2022 tid:0x2f5f46 [ERROR] [/home/barney/zettadb/node_mgr/src/instance_info.cc:766 keepalive_instance]: computer_instance no alive, ip=192.168.0.129, port=57031