ocp SQL诊断功能为空

【产品名称】

【产品版本】

【问题描述】OCP诊断功能,SQL里都是空值,obstat2.log部分日志

x7f90c3e815b8, server_count=1, busy_conn_count_=0, ret=-1045)

5412 [2022-01-05 18:28:00.622177] INFO [LIB.MYSQLC] ob_server_connection_pool.cpp:165 [70892][Y0-0000000000000000] [lt=2] ms(server_=“1.1.1.1:1”, free_conn_cou nt_=1, busy_conn_count_=0, max_allowed_conn_count_=5, server_not_available_=false)

5413 [2022-01-05 18:28:00.622181] WARN [SERVER] acquire (obstat_connection_pool.cpp:55) [70892][Y0-0000000000000000] [lt=3] acquire connection failed(ret=-1045 )

5414 [2022-01-05 18:28:00.622188] WARN [COMMON.MYSQLP] read (ob_mysql_proxy.cpp:69) [70892][Y0-0000000000000000] [lt=2] acquire connection failed(ret=-1045, co nn=NULL)

5415 [2022-01-05 18:28:00.622194] WARN [SERVER] read (obstat_sql_proxy.cpp:162) [70892][Y0-0000000000000000] [lt=3] fail to read from mysql proxy(ret=-1045)

5416 [2022-01-05 18:28:00.622201] WARN [SERVER] init (ob_stat.cpp:174) [70892][Y0-0000000000000000] [lt=3] fail to read from monitor(ret=-1045, sql=SELECT 1)

5417 [2022-01-05 18:28:00.622210] WARN [SERVER] main (main2.cpp:209) [70892][Y0-0000000000000000] [lt=3] fail to init ob_stat(ret=-1045, opts={ocp_addr:“http:/ /-----------------”, cluster_name:“order_check”, ob_addr:null, ob_port:0})

5418 [2022-01-05 18:28:00.622240] INFO ob_timer.cpp:85 [70892][Y0-0000000000000000] [lt=3] ObTimer destroy

5419 [2022-01-05 18:28:00.622253] INFO ob_timer.cpp:330 [70902][Y0-0000000000000000] [lt=8] timer thread exit

5420 [2022-01-05 18:28:00.622293] INFO [SHARE] ob_reentrant_thread.cpp:200 [70903][Y0-0000000000000000] [lt=11] reentrant thread exited(thread=0x7f90c3ea2c78)

5421 [2022-01-05 18:28:00.622494] INFO [LIB] ob_work_queue.cpp:64 [70892][Y0-0000000000000000] [lt=3] work queue destroy

5422 [2022-01-05 18:28:00.622513] INFO [SHARE] ob_reentrant_thread.cpp:200 [70904][Y0-0000000000000000] [lt=6] reentrant thread exited(thread=0x7f90c3ea3038)

5423 [2022-01-05 18:28:00.622747] INFO [SHARE] ob_reentrant_thread.cpp:200 [70905][Y0-0000000000000000] [lt=5] reentrant thread exited(thread=0x7f90c3ea33f8)

5424 [2022-01-05 18:28:00.622988] INFO [SHARE] ob_reentrant_thread.cpp:200 [70910][Y0-0000000000000000] [lt=5] reentrant thread exited(thread=0x7f90c4025ff8)

5425 [2022-01-05 18:28:00.623196] INFO [SHARE] ob_reentrant_thread.cpp:200 [70915][Y0-0000000000000000] [lt=8] reentrant thread exited(thread=0x7f90c4127538)

5426 [2022-01-05 18:28:00.623387] INFO ob_timer.cpp:85 [70892][Y0-0000000000000000] [lt=7] ObTimer destroy

5427 [2022-01-05 18:28:00.623404] INFO ob_timer.cpp:330 [70911][Y0-0000000000000000] [lt=12] timer thread exit

5428 [2022-01-05 18:28:00.623492] INFO [SHARE] ob_reentrant_thread.cpp:200 [70912][Y0-0000000000000000] [lt=6] reentrant thread exited(thread=0x7f90c4026578)

5429 [2022-01-05 18:28:00.623694] INFO [LIB] ob_work_queue.cpp:64 [70892][Y0-0000000000000000] [lt=7] work queue destroy

5430 [2022-01-05 18:28:00.623711] INFO [SHARE] ob_reentrant_thread.cpp:200 [70913][Y0-0000000000000000] [lt=5] reentrant thread exited(thread=0x7f90c4026938)

monitordb 里面配置的是127.0.0.1

要配置实际的ip地址,sql相关的数据是直接写monitordb的,需要在observer上可以访问;

补救方法:

onitordb的可以改一下metadb里的内容,然后需要重启一下ocp;

select * from config_properties where

key
= 'ocp.monitordb.host';

update config_properties set value = '10.xxx' where

key
= 'ocp.monitordb.host';