【 使用环境 】测试环境
oceanbase数据库4.2.1.7
【问题描述】清晰明确描述问题
部署的一个服务里面报错了
[ERROR] 2025/03/11 08:37:18 scheduler.go:55: Error 4009 (58030): IO error
[ERROR] 2025/03/11 08:37:11 query.go:534: Error 4009 (58030): IO error
排查是因为执行这个sql时报错的
select v.id,
v.ts,
a.ip,
a.host_ip,
a.ipv6,
a.host_ipv6,
a.agent_uuid,
v.app_name,
v.version,
v.app_type,
v.pid_file_path,
v.cfg_port,
v.install_path,
v.listener_port,
v.exe_path,
v.parent_process_name,
v.running_process_user,
cast(crc32(concat_ws(
‘@’,
a.ip,
a.host_ip,
a.ipv6,
a.host_ipv6,
app_name,
version,
app_type,
pid_file_path,
cfg_port,
install_path,
listener_port,
exe_path,
parent_process_name,
running_process_user)) as char) as hash
from (select ts,
agent_uuid,
agent_ip as ip,
agent_localhost_ip as host_ip,
agent_business_ipv6 as ipv6,
agent_localhost_ipv6 as host_ipv6
from hhit_agent
where is_delete = 0
and online_status = 1
and monitor_status = 1) a
inner join hhit_asset_agent_app_service v on v.ts = a.ts and v.host_uuid = a.agent_uuid
left join hhit_asset_agent_data_hash h on h.data_id = v.id and h.data_type = ‘app_service’ and h.ts = v.ts
where (h.data_hash is null or
h.data_hash != crc32(concat_ws(
‘@’,
a.ip,
a.host_ip,
a.ipv6,
a.host_ipv6,
app_name,
version,
app_type,
pid_file_path,
cfg_port,
install_path,
listener_port,
exe_path,
parent_process_name,
running_process_user))) ORDER BY v.id, v.ts LIMIT ‘20’ OFFSET ‘0’;
observer.log (20.7 MB)
