search

smartloli / EFAK

A easy and high-performance monitoring system, for comprehensive monitoring and management of kafka cluster.
https://www.kafka-eagle.org/
Apache License 2.0
3.09k stars 778 forks source link

kafka ksql 查询超时！！！ #527

Open SilenceRainly opened 3 years ago

SilenceRainly commented 3 years ago

image

bayern01kahn commented 3 years ago

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

ke_console.out 日志内容 2021-07-24 10:21:15 INFO [KafkaSqlParser.http-nio-8048-exec-13] - KafkaSqlParser - SQL[select * from notificationEvent wherepartitionin (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

SilenceRainly commented 3 years ago

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

bayern01kahn commented 3 years ago

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

huanghuazhang commented 2 years ago

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

image
ChunMengLu commented 2 years ago

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