执行插入语句报错Statement is timeout

【产品名称】ob

【产品版本】3.1.1

【问题描述】执行语句偶尔会报错:Statement is timeout

replace into all SELECT a.*,b.* FROM info_realtime as a LEFT JOIN machine as b ON (a.IP = b.IP) where b.module is not NULL"

ERROR 4012 (25000) at line 1: Statement is timeout

如果执行时间大于ob_query_timeout 的话报这个错就是正常的,这种情况适当调大 ob_query_timeout 的值就可以。

1 个赞