租户会话管理-查看会话数据显示异常

66

打开谷歌浏览器的开发者模式->network->看看访问的哪个API接口

看着问题会话超过100个 但是显示的会话数量不对是么？

学到了。

http://192.168.170.205:2886/api/v1/tenant/ys/sessions?page=1&size=20&active_only=false 这个请求url，返回的数据，

http://192.168.170.205:2886/api/v1/tenant/ys/sessions?page=1&size=10&active_only=false这个请求返回的数据

能找一下日志文件么？看看查询的信息 是哪个语句发出来的

你这样试一下 看看真是返回的数据什么样的
– 应返回真实总数，例如 total_elements: 120, total_pages: 12
curl “http://192.168.170.205:2886/api/v1/tenant/ys/sessions?page=1&size=10&active_only=false”

– 第 2 页应返回不同的会话 ID
curl “http://192.168.170.205:2886/api/v1/tenant/ys/sessions?page=2&size=10&active_only=false”

扩容的问题 可以在提个帖子么？方便跟踪 把操作还有接口信息也发一下

直接请求报错
{“successful”:false,“timestamp”:“2026-07-24T14:11:38.30577954+08:00”,“duration”:0,“status”:400,“traceId”:“7f5151dc35d73c5d”,“error”:{“errCode”:“Request.Header.NotFound”,“message”:“X-OCS-Agent-Header or X-OCS-Header not found in http request header”}}

日志书刷新太快了，找不到关键信息

不是observer日志 是Dashboard的日志信息
应该在安装的家目录下 你找一下看看
/home/admin/oceanbase/log_obshell/obshell.log

已经单独提了问题，租户资源扩容报错

2026-07-24T14:19:13.309 INFO [33219] [0efa744cb0a7c0a7] [common/middleware.go:266] API request: [GET /api/v1/tenant/ys/sessions?page=1&size=20&active_only=false, client=172.16.11.51, traceId=0efa744cb0a7c0a7, body={}]
2026-07-24T14:19:13.309 INFO [33219] [0efa744cb0a7c0a7] [common/middleware.go:730] verfiy request: /api/v1/tenant/ys/sessions?page=1&size=20&active_only=false
2026-07-24T14:19:13.328 INFO [33219] [0efa744cb0a7c0a7] [api/tenant_utils.go:175] Current agent is maintainer
2026-07-24T14:19:13.347 INFO [33219] [0efa744cb0a7c0a7] [common/middleware.go:359] API response OK: [GET /api/v1/tenant/ys/sessions?page=1&size=20&active_only=false, client=172.16.11.51, traceId=0efa744cb0a7c0a7, duration=40, status=200, data=&{Page:{TotalElements:20 TotalPages:1 Size:20 Number:1} Contents:[{Id:3221652669 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:54852 Command:Sleep Time:461.611733 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221650005 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_xxl_job_db Tenant:ys Host:192.168.168.136:38514 Command:Sleep Time:499.732574 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221650577 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_xxl_job_db Tenant:ys Host:192.168.168.136:50012 Command:Sleep Time:491.259054 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221652812 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:54854 Command:Sleep Time:459.59673 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221659965 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:58658 Command:Sleep Time:356.159114 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221652941 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:45418 Command:Sleep Time:457.251672 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221657940 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:41256 Command:Sleep Time:385.068286 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221655019 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:59894 Command:Sleep Time:426.649863 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221656834 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:56412 Command:Sleep Time:401.825795 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221652145 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:38370 Command:Sleep Time:468.330514 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221658116 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:41258 Command:Sleep Time:382.613101 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221653114 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:45434 Command:Sleep Time:454.56897 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221649788 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_xxl_job_db Tenant:ys Host:192.168.168.136:38508 Command:Sleep Time:502.6465 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221658197 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:41260 Command:Sleep Time:381.434405 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221653301 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:45444 Command:Sleep Time:451.983227 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221652508 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:54840 Command:Sleep Time:463.307729 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221649068 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_xxl_job_db Tenant:ys Host:192.168.168.136:59418 Command:Sleep Time:4.359311 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221649524 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_xxl_job_db Tenant:ys Host:192.168.168.136:38500 Command:Sleep Time:506.117832 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221660969 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_base_db Tenant:ys Host:192.168.168.136:37748 Command:Sleep Time:342.175539 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0} {Id:3221649220 SvrIp:192.168.170.205 SvrPort:2882 SqlPort:2881 User:yuansu Db:ys_xxl_job_db Tenant:ys Host:192.168.168.136:59434 Command:Sleep Time:4.362727 State:SLEEP Info: ProxySessId:0 ProxyIp: Action: Module: ClientInfo: Level:1 SamplePercentage:10 RecordPolicy:SAMPLE_AND_SLOW_QUERY SqlId: TotalCpuTime:0 MemoryUsage:0}]}]
2026-07-24T14:19:16.301 INFO [33219] [F000000000000000] [coordinator/coordinator.go:157] renewal maintainer
2026-07-24T14:19:16.311 INFO [33219] [F000000000000000] [coordinator/coordinator.go:122] coordinator wait: 4s
2026-07-24T14:19:16.861 INFO [33219] [8d52300a804e3b51] [common/middleware.go:266] API request: [GET /api/v1/task/dag/agent/unfinish, client=172.16.11.51, traceId=8d52300a804e3b51, body={}]
2026-07-24T14:19:16.861 INFO [33219] [8d52300a804e3b51] [common/middleware.go:730] verfiy request: /api/v1/task/dag/agent/unfinish
2026-07-24T14:19:16.861 INFO [33219] [8d52300a804e3b51] [common/middleware.go:359] API response OK: [GET /api/v1/task/dag/agent/unfinish, client=172.16.11.51, traceId=8d52300a804e3b51, duration=3, status=200, data={Contents:[]}]
2026-07-24T14:19:20.312 INFO [33219] [F000000000000000] [coordinator/coordinator.go:157] renewal maintainer
2026-07-24T14:19:20.323 INFO [33219] [F000000000000000] [coordinator/coordinator.go:122] coordinator wait: 4s
2026-07-24T14:19:24.323 INFO [33219] [F000000000000000] [coordinator/coordinator.go:157] renewal maintainer
2026-07-24T14:19:24.332 INFO [33219] [F000000000000000] [coordinator/coordinator.go:122] coordinator wait: 4s
2026-07-24T14:19:28.334 INFO [33219] [F000000000000000] [coordinator/coordinator.go:157] renewal maintainer
2026-07-24T14:19:28.345 INFO [33219] [F000000000000000] [coordinator/coordinator.go:122] coordinator wait: 4s
2026-07-24T14:19:32.345 INFO [33219] [F000000000000000] [coordinator/coordinator.go:157] renewal maintainer
2026-07-24T14:19:32.357 INFO [33219] [F000000000000000] [coordinator/coordinator.go:122] coordinator wait: 4s

好的 感谢你的反馈 我们也内部测试一下看看 看着是不符合预期

感谢分享。

66

6666

文中对168的分析很到位，补充一点：结合ys和192可以获得更好的效果。

标准安装也会出现这问题吗

666

还有这情况，没遇到过，换个浏览器试试