行锁持有者视图查询不出来

OceanBase 技术问题
#1

image
image840×214 4.34 KB

1 个赞
#3

请按如下步骤提供下日志
1.开启 Trace 功能
SET ob_enable_show_trace=ON;
2.执行问题SQL
3.获取SQL trace_id
SELECT last_trace_id() FROM DUAL;
4.登录对应 OBServer 节点，进入到日志文件所在目录
cd /home/admin/oceanbase/log
5.获取trace_id对应的日志
grep xxxxxxx observer.log --填写第3步获取的trace_id

1 个赞
#4

[2024-07-15 11:32:05.659788] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=35] [dc=31] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627780, partition_id:9, part_cnt:0})
[2024-07-15 11:32:05.659903] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=15] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627990, partition_id:4, part_cnt:0})
[2024-07-15 11:32:05.660066] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=10] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627997, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.660229] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627887, partition_id:14, part_cnt:0})
[2024-07-15 11:32:05.660556] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627967, partition_id:8, part_cnt:0})
[2024-07-15 11:32:05.660716] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1101710651031720, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.661044] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1100611139403965, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.661207] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1100611139453777, partition_id:40, part_cnt:0})
[2024-07-15 11:32:05.661367] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627910, partition_id:1, part_cnt:0})
[2024-07-15 11:32:05.661531] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627890, partition_id:13, part_cnt:0})
[2024-07-15 11:32:05.661694] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627957, partition_id:4, part_cnt:0})
[2024-07-15 11:32:05.662183] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627985, partition_id:6, part_cnt:0})
[2024-07-15 11:32:05.662512] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=10] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1102810162659497, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.662673] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627929, partition_id:1, part_cnt:0})
[2024-07-15 11:32:05.662833] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1102810162659596, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.662997] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627927, partition_id:1, part_cnt:0})
[2024-07-15 11:32:05.663159] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627987, partition_id:8, part_cnt:0})
[2024-07-15 11:32:05.663326] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1101710651031749, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.663484] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1101710651031734, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.663813] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627921, partition_id:11, part_cnt:0})
[2024-07-15 11:32:05.663974] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627922, partition_id:10, part_cnt:0})
[2024-07-15 11:32:05.664299] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511628045, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.664467] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627989, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.664624] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627887, partition_id:13, part_cnt:0})
[2024-07-15 11:32:05.664954] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1101710651031717, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.665114] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627915, partition_id:13, part_cnt:0})
[2024-07-15 11:32:05.665441] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627971, partition_id:6, part_cnt:0})
[2024-07-15 11:32:05.665608] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627968, partition_id:6, part_cnt:0})
[2024-07-15 11:32:05.665767] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627968, partition_id:9, part_cnt:0})
[2024-07-15 11:32:05.665928] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627918, partition_id:9, part_cnt:0})
[2024-07-15 11:32:05.666093] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1102810162659533, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.666256] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1100611139453777, partition_id:17, part_cnt:0})
[2024-07-15 11:32:05.666417] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627987, partition_id:13, part_cnt:0})
[2024-07-15 11:32:05.666582] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627968, partition_id:3, part_cnt:0})
[2024-07-15 11:32:05.666741] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627980, partition_id:6, part_cnt:0})
[2024-07-15 11:32:05.666906] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627891, partition_id:1, part_cnt:0})
[2024-07-15 11:32:05.667067] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627922, partition_id:11, part_cnt:0})
[2024-07-15 11:32:05.667231] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627970, partition_id:8, part_cnt:0})
[2024-07-15 11:32:05.667399] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511628009, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.667557] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511628011, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.667724] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627935, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.667885] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1102810162659443, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.668044] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627989, partition_id:7, part_cnt:0})
[2024-07-15 11:32:05.668378] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627890, partition_id:6, part_cnt:0})
[2024-07-15 11:32:05.668534] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627964, partition_id:10, part_cnt:0})
[2024-07-15 11:32:05.668696] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=10] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627990, partition_id:12, part_cnt:0})
[2024-07-15 11:32:05.668863] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=11] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511628083, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.669022] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1100611139403989, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.669187] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1102810162659520, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.669348] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=11] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627887, partition_id:8, part_cnt:0})
[2024-07-15 11:32:05.669509] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1100611139453777, partition_id:100, part_cnt:0})
[2024-07-15 11:32:05.669678] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=10] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627993, partition_id:13, part_cnt:0})
[2024-07-15 11:32:05.669840] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=9] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627929, partition_id:11, part_cnt:0})
[2024-07-15 11:32:05.670002] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=16] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511628097, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.670163] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627913, partition_id:6, part_cnt:0})
[2024-07-15 11:32:05.670324] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1102810162659448, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.670488] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=6] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627965, partition_id:15, part_cnt:0})
[2024-07-15 11:32:05.670652] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1100611139404072, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.670812] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627780, partition_id:13, part_cnt:0})
[2024-07-15 11:32:05.670981] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=7] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627933, partition_id:11, part_cnt:0})
[2024-07-15 11:32:05.671141] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=6] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1102810162659518, partition_id:0, part_cnt:0})
[2024-07-15 11:32:05.671304] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627880, partition_id:7, part_cnt:0})
[2024-07-15 11:32:05.671470] INFO [STORAGE.TRANS] ob_trans_service.cpp:6846 [11614][2180][YB420A7D0AA3-00061C79C89DF715] [lt=8] [dc=0] ObTransLockStatIterator set ready succ(ret=0, ret=“OB_SUCCESS”, partition={tid:1099511627897, partition_id:2, part_cnt:0})
[2024-07-15 11:32:05.734941] WARN [SQL.DTL] process_base (ob_dtl_channel_loop.cpp:238) [11612][2176][YB420A7D0AA3-00061C79C89DF715] [lt=11] [dc=0] message loop is interrupted(code={code:-4023, info:{msg:“tid:15652,from:“10.125.10.164:2882”,TASK ABORT QC”}}, ret=-4023)
[2024-07-15 11:32:05.819314] WARN [SQL.DTL] process_base (ob_dtl_channel_loop.cpp:238) [11612][2176][YB420A7D0AA3-00061C79C89DF715] [lt=22] [dc=0] message loop is interrupted(code={code:-4023, info:{msg:“tid:15652,from:“10.125.10.164:2882”,TASK ABORT QC”}}, ret=-4023)
[2024-07-15 11:32:05.839385] WARN [SQL.ENG] get_next_row (ob_operator.cpp:599) [11612][2176][YB420A7D0AA3-00061C79C89DF715] [lt=14] [dc=0] inner get next row failed(ret=-4023, type=77, op=“PHY_PX_FIFO_COORD”)
[2024-07-15 11:32:05.839550] WARN [SERVER] do_process (obmp_query.cpp:674) [11612][2176][YB420A7D0AA3-00061C79C89DF715] [lt=14] [dc=0] execute query fail(ret=-4023, timeout_timestamp=1721014335641053)

1 个赞
#6

我联系对这块熟悉的同学分析下

#7

初步怀疑集群有问题 你先用obdiag巡检集群 obdiag check --cases=build_before 巡检完 把报告贴出来
这个是obdiag巡检工具的官方文档说明
https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000818904

#8

image
image940×166 4.16 KB

1 个赞
#9

image
image1210×481 11.9 KB

1 个赞
#10

好的 这边找老师分析一下 看看具体的原因 你这个版本太低了 建议升级到4.2.1.x版本如果是测试用 建议直接用4.2.1.x的版本或着其他高版本

1 个赞
#11

生产有3.1.4版本的大概几百个租户

1 个赞
#12

这个问题 是必现么？

1 个赞