首批通过分布式安全可靠测评,为关键业务系统打造
OCP 日志告警 easy_reqeust hold by upper-layer for too much time 的原因及解决方法
更新时间:2026-06-04 01:56
问题现象
OCP 频繁日志告警 WARN 级别,关键日志信息如下。
observer.log.20241012081352:[2024-10-12 08:00:15.932202] WARN easy_connection_dump_request (easy_connection.c:2176) [1648][0][Y0-0000000000000000] [lt=10] [dc=0] easy_reqeust hold by upper-layer for too much time. req(0xfff9969a9000), timeout_warn_count(0), protocol(RPC), pcode(1311), time(9.018056), packet_id(122970403965497), trace_id(xxxxx-xxxxx), trace_point(5), bt().
observer.log.20241012081352:[2024-10-12 08:00:18.713953] WARN easy_connection_dump_request (easy_connection.c:2181) [1672][0][Y0-0000000000000000] [lt=9] [dc=0] easy_reqeust hold by upper-layer for too much time. req(0xfff93bbc2a70), timeout_warn_count(0), protocol(SQL), time(11.830069), session_id(3221882368), trace_point(11), bt().
observer.log.20241012081352:[2024-10-12 08:00:19.265648] WARN easy_connection_dump_request (easy_connection.c:2176) [1648][0][Y0-0000000000000000] [lt=10] [dc=0] easy_reqeust hold by upper-layer for too much time. req(0xfff9969a9000), timeout_warn_count(1), protocol(RPC), pcode(1311), time(12.351500), packet_id(122970403965497), trace_id(xxxxx-xxxxx), trace_point(5), bt().
observer.log.20241012081352:[2024-10-12 08:00:22.599026] WARN easy_connection_dump_request (easy_connection.c:2176) [1648][0][Y0-0000000000000000] [lt=12] [dc=0] easy_reqeust hold by upper-layer for too much time. req(0xfff9969a9000), timeout_warn_count(2), protocol(RPC), pcode(1311), time(15.684881), packet_id(122970403965497), trace_id(xxxxx-xxxxx), trace_point(5), bt().
observer.log.20241012081352:[2024-10-12 08:00:25.932720] WARN easy_connection_dump_request (easy_connection.c:2176) [1648][0][Y0-0000000000000000] [lt=11] [dc=0] easy_reqeust hold by upper-layer for too much time. req(0xfff9969a9000), timeout_warn_count(3), protocol(RPC), pcode(1311), time(19.018574), packet_id(122970403965497), trace_id(xxxxx-xxxxx), trace_point(5), bt().
observer.log.20241012081352:[2024-10-12 08:00:25.932735] WARN easy_connection_dump_request (easy_connection.c:2176) [1648][0][Y0-0000000000000000] [lt=12] [dc=0] easy_reqeust hold by upper-layer for too much time. req(0xfff9969e7f80), timeout_warn_count(0), protocol(RPC), pcode(1311), time(10.070809), packet_id(122972608072249), trace_id(xxxxx-xxxxx), trace_point(5), bt().
observer.log.20241012081352:[2024-10-12 08:00:29.265364] WARN easy_connection_dump_request (easy_connection.c:2176) [1648][0][Y0-0000000000000000] [lt=11] [dc=0] easy_reqeust hold by upper-layer for too much time. req(0xfff9969a9000), timeout_warn_count(4), protocol(RPC), pcode(1311), time(22.351220), packet_id(122970403965497), trace_id(xxxxx-xxxxx), trace_point(5), bt().
问题原因
此告警日志产生的原因是 SQL 执行的慢,RPC 或 SQL 执行超过 9s 会打印 WARN 级别的 easy 日志,是预期内的。可通过 WARN 日志中的告警 trace_id,在 gv$sql_audit 视图中捞取 SQL,看下 SQL 执行慢是否是预期内的,非预期内的进行专门的优化
问题的风险及影响
无影响。
影响租户
影响 OceanBase 数据库中的 SYS 租户和 Oracle 租户以及 MySQL 租户。
适用版本
OceanBase 数据库 V2.x、V3.x 版本。
解决方法
SQL 执行慢预期内告警。