vzong
vzong
oceanbase log: [2022-11-08 15:26:08.812711] WARN [SERVER] process (obmp_query.cpp:291) [18886][2310][YB420A6DD311-0005E541469C5C50] [lt=6] [dc=0] fail execute sql(sql_id="", sql=select ID,USER,HOST,DB,COMMAND,TIME,STATE,left(INFO,10000) INFO,date_format(now(),'%Y-%m-%d %H:%i:%s') gettime from information_schema.PROCESSLIST where USER not in ('usvr_replication','system user') and DB not...
The IP address 10.25.248.131:2380 (VMS584328), which previously belonged to the tikv-oversea cluster, underwent a scale-in operation on 2024/04/08 at 10:19:26. The tiup cluster display command for tikv-oversea has shown that...
Subsequently, I attempted to find a way to cancel the reconnection of the removed pd node. I discovered that changing the pd leader did not work; only by reload the...
> ~/.obdiag/config.yml 中observer 的home_path应该是WorkingDirectory When i set home_path: /data/observer, running obdiag throw exception: '/data/observer/bin/observer: No such file or directory'.
安装目录和运行目录,不在同一个磁盘目录是一个常规需求,不应该绑定pid在ob_install_dir目录。能否home_path拆分成两个变量,install_dir、work_dir,默认这两个变量都是一样,但是允许用户指定。 官方文档: # observer的安装目录,例如observer的可执行程序为/root/observer/bin/observer # 则需要填写的home_path为/root/observer home_path: /root/observer pid源码: def get_observer_pid(ssh_client, ob_install_dir, stdio=None): """ get observer pid :return: """ try: cmd = "cat {ob_install_dir}/run/observer.pid".format(ob_install_dir=ob_install_dir) pids = ssh_client.exec_cmd(cmd) pid_list = pids.split()...
temporary solution: cp -r /home/poxxxx/.obdiag/* /root/.obdiag/
obproxy --version obproxy (OceanBase 4.3.2.0 26.el8) observer --version observer (OceanBase_CE 4.2.1.8) db is written in the connection string, , but there is still no database name. -Dcffdb $ mysql -hcff.db.xxxx.com...
observer log has no reason for failure, obproxy log has no database name, and the experience is very fragmented. observer log: [2025-11-26 06:55:11.521509] WDIAG [SERVER] load_privilege_info (obmp_connect.cpp:670) [1017343][T1002_MysqlQueu][T1002][Y0-000625AFAB5FD21B-0-0] [lt=9][errcode=-5039] User...