OceanBase 加入小组

15个成员 14个话题 创建时间:2021-02-09

【故障处理】使用OCP安装OB集群时出现set sys password报错

发表于2021-03-23 2395次查看

【故障现象】

通过OCP安装ob集群时,可能会在set sys password部分报错,报错如下:

 

2021-03-23 01:48:25.301  INFO 53 --- [operation-task-16,a24821c88ca84023,1045a8c7a456] c.a.o.c.metadb.task.TaskInstanceEntity   : task 6096 run with context Context(parallelIdx=-1, stringMap={cluster_version=2.2.75, cluster_name=sandata01, startup_option_string=cpu_count=32,memory_limit=15G,system_memory=5G,cache_wash_threshold=1GB,net_thread_count=4,workers_per_cpu_quota=2,stack_size=512K,__min_full_resource_pool_memory=2147483648, ob_version=2.2.75, service_name=sandata01:2, ob_connect_address=192.168.2.71, task_operation=execute, zone3.idc=beijing_3, cluster_type=PRIMARY, ob_cluster_id=2, link_obproxy=false, zone1.idc=beijing_1, primary_zone=zone1;zone2;zone3, sql_port=2881, service_type=OB_CLUSTER, cluster_id=3, rpm_name=oceanbase-2.2.75-20210108170301.el7.x86_64.rpm, target_cluster_status=RUNNING, zone2.idc=beijing_2}, listMap={zone3.host_ids=[10], root_servers=[8, 9, 10], root_server_ips=[192.168.2.71, 192.168.2.72, 192.168.2.73], zone2.host_ids=[9], host_ids=[8, 9, 10], zone1.host_ids=[8], zone_names=[zone1, zone2, zone3]})

2021-03-23 01:48:25.308  INFO 53 --- [operation-task-16,a24821c88ca84023,1045a8c7a456] c.a.o.c.metadb.task.TaskInstanceEntity   : executor node ip:192.168.2.70

2021-03-23 01:48:25.343  INFO 53 --- [operation-task-16,a24821c88ca84023,1045a8c7a456] c.a.ocp.core.task.util.OcpAgentUtils     : [OcpAgentUtils.runCmd] svrIp=192.168.2.71, port=62888, user=admin, cmd=mysql -h127.1 -P2881 -uroot -e "alter user root identified by xxx "

2021-03-23 01:48:42.800 ERROR 53 --- [operation-task-16,a24821c88ca84023,1045a8c7a456] c.a.ocp.core.task.util.OcpAgentUtils     : call pos method failed, server IP: 192.168.2.71, port: 62888, args: admin mysql -h127.1 -P2881 -uroot -e "alter user root identified by xxx ", code: 1, result: ERROR 4016 (HY000) at line 1: Internal error

2021-03-23 01:48:42.821 ERROR 53 --- [operation-task-16,a24821c88ca84023,1045a8c7a456] c.a.o.core.task.manager.TaskManagerImpl  : got exception while execute task:

com.alipay.ocp.core.exception.UnexpectedException: [OCP UnexpectedException]: status=500 INTERNAL_SERVER_ERROR, errorCode=COMMON_RPC_EXECUTE_FAILED, args=192.168.2.71,62888,admin mysql -h127.1 -P2881 -uroot -e "alter user root identified by xxx ",1,ERROR 4016 (HY000) at line 1: Internal error
	at com.alipay.ocp.core.task.util.OcpAgentUtils.executePosMethod(OcpAgentUtils.java:265) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.core.task.util.OcpAgentUtils.callPosMethod(OcpAgentUtils.java:128) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.core.task.util.OcpAgentUtils.runCmd(OcpAgentUtils.java:50) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.service.compute.host.HostManager.executeRpcCommand(HostManager.java:82) ~[ocp-service-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.service.compute.host.HostManager.executeRpcCommand(HostManager.java:74) ~[ocp-service-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.service.task.business.cluster.SetSysPasswordTask.run(SetSysPasswordTask.java:39) ~[ocp-service-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.core.metadb.task.TaskInstanceEntity.run(TaskInstanceEntity.java:192) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.core.task.manager.TaskManagerImpl.lambda$null$1(TaskManagerImpl.java:186) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.core.task.manager.TaskManagerImpl.redirectOutputIfNotSysSchedule(TaskManagerImpl.java:241) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at com.alipay.ocp.core.task.manager.TaskManagerImpl.lambda$executeTask$2(TaskManagerImpl.java:159) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) ~[na:1.8.0_275]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_275]
	at c
om.alipay.ocp.core.thread.TraceDecorator.lambda$decorate$0(TraceDecorator.java:28) ~[ocp-core-2.5.1-20210220.jar!/:2.5.1-20210220]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_275]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_275]
	at java.lang.Thread.run(Thread.java:874) ~[na:1.8.0_275]


2021-03-23 01:48:42.834  INFO 53 --- [operation-task-16,a24821c88ca84023,1045a8c7a456] c.a.o.c.metadb.task.TaskInstanceEntity   : set state failed for task: 6096

【解决方法】

由于报错是

c.a.ocp.core.task.util.OcpAgentUtils     : call pos method failed, server IP: 192.168.2.71, port: 62888, args: admin mysql -h127.1 -P2881 -uroot -e "alter user root identified by xxx ", code: 1, result: ERROR 4016 (HY000) at line 1: Internal error

此时,可以选择再次重新执行此步骤来解决。

发表回复
你还没有登录,请先 登录或 注册!