EFAK icon indicating copy to clipboard operation
EFAK copied to clipboard

kafka ksql 查询超时!!!

Open SilenceRainly opened this issue 3 years ago • 5 comments

image

SilenceRainly avatar Jul 23 '21 08:07 SilenceRainly

请问解决了吗? 遇到相同的问题

ke_console.out 日志内容 2021-07-24 10:21:15 INFO [KafkaSqlParser.http-nio-8048-exec-13] - KafkaSqlParser - SQL[select * from notificationEvent where partition in (0,1,2) limit 10] org.apache.kafka.common.errors.TimeoutException: Failed to get offsets by times in 30000ms 2021-07-24 10:21:45 ERROR [KafkaSqlParser.http-nio-8048-exec-13] - Execute sql to query kafka topic has error,msg is Failed to get offsets by times in 30000ms

bayern01kahn avatar Jul 24 '21 10:07 bayern01kahn

没有解决了 我没找到问题在哪里

SilenceRainly avatar Jul 24 '21 11:07 SilenceRainly

@smartloli 请问大概什么问题引起的 能不能给个排查方向 感谢

bayern01kahn avatar Jul 25 '21 09:07 bayern01kahn

v2.1.0版本,KafkaSqlParser里的execute,注释掉 calcite部分。这部份没什么用,正常kafka查数是ms级。 image

huanghuazhang avatar Apr 07 '22 02:04 huanghuazhang

同遇到这个问题,发现如果 partition in (0,1,2) 里面的分区如果实际上不存在就会超时,这块是不是可以优化下。

ChunMengLu avatar May 07 '22 03:05 ChunMengLu